/// <summary>
/// 通过问卷Vguid获取问卷详细信息
/// </summary>
/// <param name="questionDetailVguid"></param>
/// <returns></returns>
public Business_QuestionnaireDetail GetQuestionDetailModel(string questionDetailVguid)
{
using (SqlSugarClient _dbMsSql = SugarDao_MsSql.GetInstance())
{
Guid vguid = Guid.Parse(questionDetailVguid);
Business_QuestionnaireDetail questionModel = _dbMsSql.Queryable <Business_QuestionnaireDetail>().Where(i => i.Vguid == vguid).SingleOrDefault();
return(questionModel);
}
}
/// <summary>
/// 通过问卷Vguid获取问卷详细信息
/// </summary>
/// <param name="questionDetailVguid"></param>
/// <returns></returns>
public Business_QuestionnaireDetail GetQuestionDetailModel(string questionDetailVguid)
{
using (SqlSugarClient dbMsSql = SugarDao_MsSql.GetInstance())
{
Guid vguid = Guid.Parse(questionDetailVguid);
Business_QuestionnaireDetail questionModel = dbMsSql.Queryable <Business_QuestionnaireDetail>().Where(i => i.Vguid == vguid).SingleOrDefault();
//存入操作日志表
string logData = JsonHelper.ModelToJson(questionModel);
_ll.SaveLog(3, 34, "", questionModel.QuestionnaireDetailName, logData);
return(questionModel);
}
}
/// <summary>
/// 保存问卷信息(主信息、详细信息)
/// </summary>
/// <param name="questionMainModel"></param>
/// <param name="isEdit"></param>
/// <returns></returns>
public bool SaveQuestionMain(Business_Questionnaire questionMainModel, bool isEdit, string questionData)
{
bool result = false;
var questionModel = new Business_Questionnaire(); //问卷主信息
var questionList = JsonHelper.JsonToModel <List <Business_QuestionnaireDetail> >(questionData); //待保存的问卷详细信息
var questionDetailList = new List <Business_QuestionnaireDetail>();
if (isEdit)
{
questionModel = GetQuestionByVguid(questionMainModel.Vguid.ToString());
questionModel.QuestionnaireName = questionMainModel.QuestionnaireName;
questionModel.Description = questionMainModel.Description;
questionModel.Remarks = questionMainModel.Remarks;
questionModel.EffectiveDate = questionMainModel.EffectiveDate;
questionModel.Status = "1";
questionModel.ChangeUser = Common.CurrentUser.GetCurrentUser().LoginName;
questionModel.ChangeDate = DateTime.Now;
//循环遍历问卷详情
foreach (var item in questionList)
{
Business_QuestionnaireDetail questionDetail = new Business_QuestionnaireDetail();
questionDetail.QuestionnaireDetailType = item.QuestionnaireDetailType;
questionDetail.QuestionnaireDetailName = item.QuestionnaireDetailName;
questionDetail.QuestionOption = item.QuestionOption;
questionDetail.QuestionTitleID = item.QuestionTitleID;
questionDetail.Answer = item.Answer;
questionDetail.Vguid = Guid.NewGuid();
questionDetail.QuestionnaireVguid = questionMainModel.Vguid;//问卷主信息Vguid
questionDetail.CreatedUser = Common.CurrentUser.GetCurrentUser().LoginName;
questionDetail.CreatedDate = DateTime.Now;
questionDetail.ChangeDate = DateTime.Now;
questionDetailList.Add(questionDetail);
}
result = _es.SaveQuestionMain(questionModel, isEdit, questionDetailList);
}
else
{
questionModel.QuestionnaireName = questionMainModel.QuestionnaireName;
questionModel.Description = questionMainModel.Description;
questionModel.Remarks = questionMainModel.Remarks;
questionModel.EffectiveDate = questionMainModel.EffectiveDate;
questionModel.Status = "1";
questionModel.CreatedDate = DateTime.Now;
questionModel.CreatedUser = Common.CurrentUser.GetCurrentUser().LoginName;
questionModel.ChangeDate = DateTime.Now;
questionModel.Vguid = questionMainModel.Vguid;
foreach (var item in questionList)
{
Business_QuestionnaireDetail questionDetail = new Business_QuestionnaireDetail();
questionDetail.QuestionnaireDetailType = item.QuestionnaireDetailType;
questionDetail.QuestionnaireDetailName = item.QuestionnaireDetailName;
questionDetail.QuestionOption = item.QuestionOption;
questionDetail.QuestionTitleID = item.QuestionTitleID;
questionDetail.Answer = item.Answer;
questionDetail.Vguid = Guid.NewGuid();
questionDetail.QuestionnaireVguid = questionMainModel.Vguid;//问卷主信息Vguid
questionDetail.CreatedUser = Common.CurrentUser.GetCurrentUser().LoginName;
questionDetail.CreatedDate = DateTime.Now;
questionDetail.ChangeDate = DateTime.Now;
questionDetailList.Add(questionDetail);
}
result = _es.SaveQuestionMain(questionModel, isEdit, questionDetailList);
}
return(result);
}
