/// <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);
}
