public ActionResult GetFormLibraryList()
{
try
{
var queryParams = new NameValueCollection();
if (!ParamHelper.CheckParaQ(ref queryParams))
{
return(Json(new ResponseEntity <int>(RegularFunction.RegularSqlRegexText), JsonRequestBehavior.AllowGet));
}
var query = new FormLibraryQuery(queryParams);
var sqlCondition = new StringBuilder();
sqlCondition.Append("ISNULL(IsDelete,0)!=1");
if (!string.IsNullOrEmpty(query.DepartId))
{
sqlCondition.Append($" and DepartId = {query.DepartId}");
}
if (!string.IsNullOrEmpty(query.ProjectType))
{
sqlCondition.Append($" and ProjectType = {query.ProjectType}");
}
if (!string.IsNullOrEmpty(query.Name))
{
sqlCondition.Append($" and Name like '%{query.Name}%'");
}
PageRequest preq = new PageRequest
{
TableName = " [View_FormLibrary] ",
Where = sqlCondition.ToString(),
Order = " Id DESC ",
IsSelect = true,
IsReturnRecord = true,
PageSize = query.PageSize,
PageIndex = query.PageIndex,
FieldStr = "*"
};
var result = new FormLibraryBLL().GetView_FormLibraryByPage(preq);
var response = new ResponseEntity <object>(true, string.Empty,
new DataGridResultEntity <View_FormLibrary>
{
TotalRecords = preq.Out_AllRecordCount,
DisplayRecords = preq.Out_PageCount,
ResultData = result
});
return(Json(response, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
return(Json(new ResponseEntity <object>(-999, string.Empty, ""), JsonRequestBehavior.AllowGet));
}
}
public ActionResult DeleteFormLibrary(int Id)
{
var result = new FormLibraryBLL().DeleteDataById(Id);
var response = new ResponseEntity <int>(result.Success, result.Message, result.Data);
new LogBLL().LogEvent(CurrenUserInfo.LoginName, GDS.Entity.Constant.ConstantDefine.ModuleBaseData,
GDS.Entity.Constant.ConstantDefine.TypeDelete, GDS.Entity.Constant.ConstantDefine.ActionDeleteFormLibrary, $"{Id}");
return(Json(response, JsonRequestBehavior.AllowGet));
}
public ActionResult GetFormLibraryById(int Id)
{
var result = new FormLibraryBLL().GetDataById(Id);
if (result != null)
{
var response = new ResponseEntity <FormLibrary>(true, ConstantDefine.TipQuerySuccess, result);
return(Json(response, JsonRequestBehavior.AllowGet));
}
else
{
var response = new ResponseEntity <FormLibrary>(ConstantDefine.TipQueryFail);
return(Json(response, JsonRequestBehavior.AllowGet));
}
}
public ActionResult SaveFormLibrary(FormLibrary entity)
{
ResponseEntity <int> response;
if (entity.Id == 0)
{
var list = new FormLibraryBLL().GetDataByName(entity.Name);
if (list != null && list.Count > 0)
{
return(Json(new ResponseEntity <object>(-999, "±íµ¥ÒÑ´æÔÚ", ""), JsonRequestBehavior.AllowGet));
}
entity.IsDelete = 0;
entity.CreateBy = "";
entity.CreateTime = DateTime.Now;
entity.UpdateBy = "";
entity.UpdateTime = DateTime.Now;
var result = new FormLibraryBLL().InsertFormLibrary(entity);
response = new ResponseEntity <int>(result.Success, result.Message, result.Data);
new LogBLL().LogEvent(CurrenUserInfo.LoginName, GDS.Entity.Constant.ConstantDefine.ModuleBaseData,
GDS.Entity.Constant.ConstantDefine.TypeAdd, GDS.Entity.Constant.ConstantDefine.ActionSaveFormLibrary, $"{result.Data}");
}
else
{
entity.UpdateBy = "";
entity.UpdateTime = DateTime.Now;
var result = new FormLibraryBLL().UpdateFormLibrary(entity);
response = new ResponseEntity <int>(result.Success, result.Message, result.Data);
new LogBLL().LogEvent(CurrenUserInfo.LoginName, GDS.Entity.Constant.ConstantDefine.ModuleBaseData,
GDS.Entity.Constant.ConstantDefine.TypeUpdate, GDS.Entity.Constant.ConstantDefine.ActionUpdateFormLibrary, $"{entity.Id}");
}
return(Json(response, JsonRequestBehavior.AllowGet));
}
