using?System;
using?System.Collections.Generic;
using?System.Linq;
using?System.Text;
using?Interface;
using?Entities;

namespace?baseQueryParam
{
????public?class?AnswerRepository:IAnswerRepository
????{
????????QuestionnaireSurveyEntiti?context;

????????#region?構(gòu)造函數(shù)
????????///?

????????///?構(gòu)造函數(shù)
????????///?

????????public?AnswerRepository（）
????????{
????????????context?=?new?QuestionnaireSurveyEntiti（）;
????????}
????????#endregion

????????///?

????????///?添加答案
????????///?

????????///?答案實體對象
????????///?操作狀態(tài)
????????public?void?Add（Answer?answer?out?OperateStatus?status）
????????{
????????????//try
????????????//{
????????????????context.AddToAnswer（answer）;

????????????????context.SaveChanges（）;

????????????????status?=?new?OperateStatus
????????????????{
????????????????????Message?=?“添加成功！“
????????????????????ResultSign?=?ResultSign.Success
????????????????};
????????????//}
????????????//catch?（Exception?ex）
????????????//{
????????????//????status?=?new?OperateStatus
????????????//????{
????????????//????????Message?=?string.Format（“選項添加失敗！異常信息：{0}“ex.Message）
????????????//????????ResultSign?=?ResultSign.Fail
????????????//????};
????????????//????throw?ex;
????????????//}

????????}

????????///?

????????///?答案查詢
????????///?

????????///?答案查詢參數(shù)
????????///?總記錄數(shù)
????????public?IList?Query（AnswerQueryParam?queryParam?out?int?totalCount）
????????{
????????????var?query?=?context.Answer.OrderBy（p?=>?p.UserID）.AsQueryable（）;

????????????if?（queryParam?==?null）
????????????{
????????????????totalCount?=?query.Count（）;

????????????????return?query.ToList（）;
????????????}
????????????if?（queryParam.UserID!=Guid.Empty）
????????????{
????????????????query?=?query.Where（p?=>?p.UserID==?queryParam.UserID）;
????????????}
????????????if?（queryParam.OptionID!=?null）
????????????{
????????????????query?=?query.Where（p?=>?p.OptionID?==?queryParam.OptionID）;
????????????}

????????????if?（queryParam.Answer!=null?）
????????????{
????????????????query?=?query.Where（p?=>?p.Answer1?==?queryParam.Answer）;
????????????}

????????????totalCount?=?query.Count（）;

????????????return?query.Skip（queryParam.StartIndex）.Take（queryParam.PageSize）.ToList（）;
????????}
????}
}

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2013-02-19?21:18??問卷調(diào)查小系統(tǒng)\
?????目錄???????????0??2013-02-19?21:17??問卷調(diào)查小系統(tǒng)\QuestionnaireSurvey\
?????目錄???????????0??2013-02-19?21:17??問卷調(diào)查小系統(tǒng)\QuestionnaireSurvey\baseQueryParam\
?????文件????????2590??2012-10-10?18:03??問卷調(diào)查小系統(tǒng)\QuestionnaireSurvey\baseQueryParam\AnswerRepository.cs
?????目錄???????????0??2013-02-19?21:17??問卷調(diào)查小系統(tǒng)\QuestionnaireSurvey\baseQueryParam\bin\
?????目錄???????????0??2013-02-19?21:17??問卷調(diào)查小系統(tǒng)\QuestionnaireSurvey\baseQueryParam\bin\Debug\
?????文件???????14848??2013-01-30?16:35??問卷調(diào)查小系統(tǒng)\QuestionnaireSurvey\baseQueryParam\bin\Debug\baseQueryParam.dll
?????文件???????26112??2013-01-30?16:35??問卷調(diào)查小系統(tǒng)\QuestionnaireSurvey\baseQueryParam\bin\Debug\baseQueryParam.pdb
?????文件???????35840??2013-01-30?16:35??問卷調(diào)查小系統(tǒng)\QuestionnaireSurvey\baseQueryParam\bin\Debug\Entities.dll
?????文件???????46592??2013-01-30?16:35??問卷調(diào)查小系統(tǒng)\QuestionnaireSurvey\baseQueryParam\bin\Debug\Entities.pdb
?????文件????????5120??2013-01-30?16:35??問卷調(diào)查小系統(tǒng)\QuestionnaireSurvey\baseQueryParam\bin\Debug\Interface.dll
?????文件????????7680??2013-01-30?16:35??問卷調(diào)查小系統(tǒng)\QuestionnaireSurvey\baseQueryParam\bin\Debug\Interface.pdb
?????目錄???????????0??2012-04-26?22:56??問卷調(diào)查小系統(tǒng)\QuestionnaireSurvey\baseQueryParam\bin\Release\
?????文件????????2959??2012-05-09?18:02??問卷調(diào)查小系統(tǒng)\QuestionnaireSurvey\baseQueryParam\Implement.csproj
?????目錄???????????0??2013-02-19?21:17??問卷調(diào)查小系統(tǒng)\QuestionnaireSurvey\baseQueryParam\obj\
?????目錄???????????0??2013-02-19?21:17??問卷調(diào)查小系統(tǒng)\QuestionnaireSurvey\baseQueryParam\obj\Debug\
?????文件???????14848??2013-01-30?16:35??問卷調(diào)查小系統(tǒng)\QuestionnaireSurvey\baseQueryParam\obj\Debug\baseQueryParam.dll
?????文件???????26112??2013-01-30?16:35??問卷調(diào)查小系統(tǒng)\QuestionnaireSurvey\baseQueryParam\obj\Debug\baseQueryParam.pdb
?????文件????????6078??2013-01-30?16:35??問卷調(diào)查小系統(tǒng)\QuestionnaireSurvey\baseQueryParam\obj\Debug\DesignTimeResolveAssemblyReferencesInput.cache
?????文件????????7059??2013-01-30?16:35??問卷調(diào)查小系統(tǒng)\QuestionnaireSurvey\baseQueryParam\obj\Debug\Implement.csproj.FileListAbsolute.txt
?????文件????????6999??2013-01-30?16:35??問卷調(diào)查小系統(tǒng)\QuestionnaireSurvey\baseQueryParam\obj\Debug\ResolveAssemblyReference.cache
?????目錄???????????0??2012-04-26?13:16??問卷調(diào)查小系統(tǒng)\QuestionnaireSurvey\baseQueryParam\obj\Debug\TempPE\
?????文件????????5609??2012-05-06?19:06??問卷調(diào)查小系統(tǒng)\QuestionnaireSurvey\baseQueryParam\OptionRepository.cs
?????目錄???????????0??2013-02-19?21:17??問卷調(diào)查小系統(tǒng)\QuestionnaireSurvey\baseQueryParam\Properties\
?????文件????????1360??2012-04-26?13:16??問卷調(diào)查小系統(tǒng)\QuestionnaireSurvey\baseQueryParam\Properties\AssemblyInfo.cs
?????文件????????5685??2012-05-06?22:03??問卷調(diào)查小系統(tǒng)\QuestionnaireSurvey\baseQueryParam\QuestionRepository.cs
?????文件????????5648??2013-01-30?10:53??問卷調(diào)查小系統(tǒng)\QuestionnaireSurvey\baseQueryParam\QuestRepository.cs
?????目錄???????????0??2013-02-19?21:17??問卷調(diào)查小系統(tǒng)\QuestionnaireSurvey\business\
?????目錄???????????0??2013-02-19?21:17??問卷調(diào)查小系統(tǒng)\QuestionnaireSurvey\business\bin\
?????目錄???????????0??2013-02-19?21:17??問卷調(diào)查小系統(tǒng)\QuestionnaireSurvey\business\bin\Debug\
?????文件????????4608??2013-01-30?16:35??問卷調(diào)查小系統(tǒng)\QuestionnaireSurvey\business\bin\Debug\business.dll
............此處省略1024個文件信息