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