public ActionResult SurveyEdit(int id = 0) { Survey_Survey survey = new Survey_Survey(); ViewBag.id = id; if (id > 0) { survey = surveyBL.Get(id); if (survey.OpenGroupFlag == 1)//群组 { int total = 0; string strWhere = " GroupId in (select id from dbo.F_SplitIDs('" + survey.OpenGroup + "')) "; ViewBag.Groups = sys_GroupBL.GetAllList(out total, 1, int.MaxValue, strWhere); } if (survey.OpenDepartFlag == 1)//组织结构 { string strWhere = " DepartmentId in (select id from dbo.F_SplitIDs('" + survey.OpenDepart + "')) "; ViewBag.Departs = deptBL.GetAllList(strWhere); } } else { string star; string end; var TrainGradeTime = trainBL.IsUpdateTrain(out star, out end, AllSystemConfigs.Where(p => p.ConfigType == 11).FirstOrDefault(), DateTime.Now.Date); ViewBag.start = star == "" ? "" : Convert.ToDateTime(star).ToString("yyyy-MM-dd"); ViewBag.end = end == "" ? "" : Convert.ToDateTime(end).ToString("yyyy-MM-dd"); } return(View(survey)); }
/// <summary> /// 插入调查 /// </summary> /// <param name="model"></param> public void InsertSurvey_Survey(Survey_Survey model) { using (IDbConnection conn = OpenConnection()) { var sql = string.Format(@"INSERT INTO dbo.Survey_Survey ( Name, PaperID, Memo, OpenGroupFlag, OpenGroup, OpenDepartFlag, OpenDepart, PublishFlag, LastUpdateTime, UserID, StartTime, EndTime, IsDelete ) VALUES ( @name, @paperid, @memo, @opengroupflag, @opengroup, @opendepartflag, @opendepart, @publishflag, getdate(), @userid, @starttime, @endtime, 0 );SELECT @@IDENTITY AS ID" ); var param = new { name = model.Name, paperid = model.PaperID, memo = model.Memo, opengroupflag = model.OpenGroupFlag, opengroup = model.OpenGroup, opendepartflag = model.OpenDepartFlag, opendepart = model.OpenDepart, publishflag = model.PublishFlag, userid = model.UserID, starttime = model.StartTime, endtime = model.EndTime, }; dynamic list = conn.Query <dynamic>(sql, param).FirstOrDefault(); model.Id = decimal.ToInt32(list.ID); } }
/// <summary> /// 添加调查 /// </summary> /// <param name="model"></param> public JsonResult InsertSurvey_Survey(Survey_Survey model) { try { string star; string end; var TrainGradeTime = trainBL.IsUpdateTrain(out star, out end, AllSystemConfigs.Where(p => p.ConfigType == 11).FirstOrDefault(), DateTime.Now.Date); model.StartTime = model.StartTime == Convert.ToDateTime("0001/1/1 0:00:00") ? Convert.ToDateTime(star) : model.StartTime; model.EndTime = model.EndTime == Convert.ToDateTime("0001/1/1 0:00:00") ? Convert.ToDateTime(end) : model.EndTime; model.PublishFlag = 0; model.OpenGroup = model.OpenGroup == null ? "" : model.OpenGroup; model.OpenDepart = model.OpenDepart == null ? "" : model.OpenDepart; model.Memo = string.IsNullOrEmpty(model.Memo) ? "" : model.Memo.Trim(); if (model.chbOpenFlag == 1) { model.OpenGroupFlag = 1; } else if (model.chbOpenFlag == 2) { model.OpenDepartFlag = 1; } else { model.OpenGroupFlag = 1; model.OpenDepartFlag = 1; } model.UserID = CurrentUser.UserId; if (model.Id > 0) { surveyBL.UpdateSurvey_Survey(model); } else { surveyBL.InsertSurvey_Survey(model); } return(Json(new { result = 1, Content = "添加成功" })); } catch { return(Json(new { result = 0, Content = "添加失败" })); } }
/// <summary> /// 更新 /// </summary> /// <param name="model"></param> public void UpdateSurvey_Survey(Survey_Survey model) { using (IDbConnection conn = OpenConnection()) { var sql = string.Format(@" UPDATE dbo.Survey_Survey SET Name = @name, PaperID = @paperid, Memo = @memo, OpenGroupFlag = @opengroupflag, OpenGroup = @opengroup, OpenDepartFlag = @opendepartflag, OpenDepart = @opendepart, PublishFlag = @publishflag, LastUpdateTime = getdate(), UserID = @userid, StartTime = @starttime, EndTime = @endtime, IsDelete = 0 WHERE Id = @id"); var param = new { Id = model.Id, isdelete = model.IsDelete, name = model.Name, paperid = model.PaperID, memo = model.Memo, opengroupflag = model.OpenGroupFlag, opengroup = model.OpenGroup, opendepartflag = model.OpenDepartFlag, opendepart = model.OpenDepart, publishflag = model.PublishFlag, userid = model.UserID, starttime = model.StartTime, endtime = model.EndTime, }; conn.Execute(sql, param); } }
/// <summary> /// 更新 /// </summary> /// <param name="model"></param> public void UpdateSurvey_Survey(Survey_Survey model) { surveyDB.UpdateSurvey_Survey(model); }
/// <summary> /// 插入调查 /// </summary> /// <param name="model"></param> public void InsertSurvey_Survey(Survey_Survey model) { surveyDB.InsertSurvey_Survey(model); }