/// <summary> /// 删除未提交问卷 /// </summary> /// <param name="vguid">问卷Vguid</param> /// <returns></returns> public bool DeletedQuestion(string vguid) { using (SqlSugarClient _dbMsSql = SugarDao_MsSql.GetInstance()) { bool result = false; Guid questionVguid = Guid.Parse(vguid); try { _dbMsSql.BeginTran(); Business_Questionnaire exerciseModel = _dbMsSql.Queryable <Business_Questionnaire>().Where(i => i.Vguid == questionVguid).SingleOrDefault(); string logData = JsonHelper.ModelToJson(exerciseModel); result = _dbMsSql.Delete <Business_Questionnaire>(i => i.Vguid == questionVguid); //删除问卷主表 if (result) { List <Business_QuestionnaireDetail> exercisesDetail = _dbMsSql.Queryable <Business_QuestionnaireDetail>().Where(i => i.QuestionnaireVguid == questionVguid).ToList(); if (exercisesDetail.Count != 0) { result = _dbMsSql.Delete <Business_QuestionnaireDetail>(i => i.QuestionnaireVguid == questionVguid); //删除问卷附表 } } _ll.SaveLog(2, 52, Common.CurrentUser.GetCurrentUser().LoginName, exerciseModel.QuestionnaireName, logData); _dbMsSql.CommitTran(); } catch (Exception exp) { _dbMsSql.RollbackTran(); Common.LogHelper.LogHelper.WriteLog(exp.ToString()); _ll.SaveLog(5, 52, Common.CurrentUser.GetCurrentUser().LoginName, "", exp.ToString()); } return(result); } }
/// <summary> /// 审核提交问卷 /// </summary> /// <param name="vguid"></param> /// <returns></returns> public bool CheckedQuestion(string vguid) { using (SqlSugarClient _dbMsSql = SugarDao_MsSql.GetInstance()) { bool result = false; Guid Vguid = Guid.Parse(vguid); try { _dbMsSql.BeginTran(); result = _dbMsSql.Update <Business_Questionnaire>(new { Status = 2 }, i => i.Vguid == Vguid); Business_Questionnaire questionInfo = _dbMsSql.Queryable <Business_Questionnaire>().Where(i => i.Vguid == Vguid).SingleOrDefault(); string exerciseJson = JsonHelper.ModelToJson(questionInfo); //存入操作日志表 _ll.SaveLog(9, 52, CurrentUser.GetCurrentUser().LoginName, questionInfo.QuestionnaireName, exerciseJson); _dbMsSql.CommitTran(); } catch (Exception ex) { _dbMsSql.RollbackTran(); Common.LogHelper.LogHelper.WriteLog(ex.ToString()); _ll.SaveLog(5, 52, CurrentUser.GetCurrentUser().LoginName, "", ex.ToString()); } return(result); } }
/// <summary> /// 问卷详情界面(新增/编辑) /// </summary> /// <returns></returns> public ActionResult QuestionDetail() { //绑定问卷类型 var questionType = new List <CS_Master_2>(); questionType = _el.GetQuestionType(); ViewData["QuestionType"] = questionType; bool isEdit = Boolean.Parse(Request.QueryString["isEdit"]); string vguid = Request.QueryString["Vguid"]; Business_Questionnaire questionMain = new Business_Questionnaire(); if (isEdit)//编辑 { questionMain = _el.GetQuestionByVguid(vguid); } else//新增 { questionMain.Vguid = Guid.NewGuid(); } Sys_Role_Module roleModuleModel = _al.GetRoleModulePermission(Common.CurrentUser.GetCurrentUser().Role, Common.Tools.ModuleVguid.QuestionModule); ViewBag.CurrentModulePermission = roleModuleModel; ViewBag.isEdit = isEdit; ViewBag.questionMainModel = questionMain; return(View()); }
/// <summary> /// 保存问卷信息(主信息、详细信息) /// </summary> /// <param name="questionMainModel"></param> /// <returns></returns> public JsonResult SaveQuestionMain(Business_Questionnaire questionMainModel, bool isEdit, string questionData) { var models = new ActionResultModel <String>(); models.isSuccess = false; models.isSuccess = _el.SaveQuestionMain(questionMainModel, isEdit, questionData); models.respnseInfo = models.isSuccess == true ? "1" : "0"; return(Json(models, JsonRequestBehavior.AllowGet)); }
/// <summary> /// 保存问卷信息(主信息、详细信息) /// </summary> /// <param name="questionMainModel"></param> /// <param name="isEdit"></param> /// <returns></returns> public bool SaveQuestionMain(Business_Questionnaire questionMainModel, bool isEdit, List <Business_QuestionnaireDetail> questionDetailList) { using (SqlSugarClient _dbMsSql = SugarDao.SugarDao_MsSql.GetInstance()) { bool result = false; try { _dbMsSql.BeginTran(); if (isEdit) { //定义匿名类型model var model = new { QuestionnaireName = questionMainModel.QuestionnaireName, Description = questionMainModel.Description, Remarks = questionMainModel.Remarks, EffectiveDate = questionMainModel.EffectiveDate, Status = questionMainModel.Status, ChangeUser = questionMainModel.ChangeUser, ChangeDate = questionMainModel.ChangeDate }; result = _dbMsSql.Update <Business_Questionnaire>(model, i => i.Vguid == questionMainModel.Vguid); //存入操作日志表 string logData = JsonHelper.ModelToJson(questionMainModel); _ll.SaveLog(4, 54, CurrentUser.GetCurrentUser().LoginName, questionMainModel.QuestionnaireName + " " + "主信息", logData); } else { result = _dbMsSql.Insert(questionMainModel, false) != DBNull.Value; //存入操作日志表 string logData = JsonHelper.ModelToJson(questionMainModel); _ll.SaveLog(1, 53, CurrentUser.GetCurrentUser().LoginName, questionMainModel.QuestionnaireName + " " + "主信息", logData); } _dbMsSql.Delete <Business_QuestionnaireDetail>(i => i.QuestionnaireVguid == questionMainModel.Vguid); foreach (var item in questionDetailList) { _dbMsSql.Insert(item, false); //存入操作日志表 string logData = JsonHelper.ModelToJson(item); _ll.SaveLog(4, 55, CurrentUser.GetCurrentUser().LoginName, questionMainModel.QuestionnaireName + " " + "问卷详细信息", logData); } _dbMsSql.CommitTran(); } catch (Exception ex) { _dbMsSql.RollbackTran(); Common.LogHelper.LogHelper.WriteLog(ex.Message + "/n" + ex + "/n" + ex.StackTrace); } return(result); } }
/// <summary> /// 通过Vguid获取问卷信息(编辑) /// </summary> /// <param name="Vguid"></param> /// <returns></returns> public Business_Questionnaire GetQuestionByVguid(string Vguid) { using (SqlSugarClient _dbMsSql = SugarDao.SugarDao_MsSql.GetInstance()) { Guid vguid = Guid.Parse(Vguid); Business_Questionnaire questionInfoModel = _dbMsSql.Queryable <Business_Questionnaire>().Where(i => i.Vguid == vguid).SingleOrDefault(); //存入操作日志表 string logData = JsonHelper.ModelToJson <Business_Questionnaire>(questionInfoModel); _ll.SaveLog(3, 55, Common.CurrentUser.GetCurrentUser().LoginName, questionInfoModel.QuestionnaireName, logData); return(questionInfoModel); } }
public ActionResult CheckedDetail() { //绑定问卷类型 var questionType = new List <CS_Master_2>(); questionType = _cl.GetQuestionType(); ViewData["QuestionType"] = questionType; string vguid = Request.QueryString["Vguid"]; ViewData["Type"] = Request.QueryString["Type"]; Business_Questionnaire questionMain = new Business_Questionnaire(); questionMain = _cl.GetQuestionByVguid(vguid); Sys_Role_Module roleModuleModel = _al.GetRoleModulePermission(Common.CurrentUser.GetCurrentUser().Role, Common.Tools.ModuleVguid.CheckedQuestionModule); ViewBag.CurrentModulePermission = roleModuleModel; ViewBag.questionMainModel = questionMain; return(View()); }
/// <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); }