public ActionResult DeleteProjectType(int Id)
{
var result = new ProjectTypeBLL().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.ActionDeleteProjectType, $"{Id}");
return(Json(response, JsonRequestBehavior.AllowGet));
}
public ActionResult GetProjectTypeList()
{
try
{
var queryParams = new NameValueCollection();
if (!ParamHelper.CheckParaQ(ref queryParams))
{
return(Json(new ResponseEntity <int>(RegularFunction.RegularSqlRegexText), JsonRequestBehavior.AllowGet));
}
var query = new ProjectTypeQuery(queryParams);
var sqlCondition = new StringBuilder();
sqlCondition.Append("ISNULL(IsDelete,0)!=1");
if (!string.IsNullOrEmpty(query.Name))
{
sqlCondition.Append($" and Name like '%{query.Name}%'");
}
PageRequest preq = new PageRequest
{
TableName = " [ProjectType] ",
Where = sqlCondition.ToString(),
Order = " Id DESC ",
IsSelect = true,
IsReturnRecord = true,
PageSize = query.PageSize,
PageIndex = query.PageIndex,
FieldStr = "*"
};
var result = new ProjectTypeBLL().GetDataByPage(preq);
var response = new ResponseEntity <object>(true, string.Empty,
new DataGridResultEntity <ProjectType>
{
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 GetProjectTypeById(int Id)
{
var result = new ProjectTypeBLL().GetDataById(Id);
if (result != null)
{
var response = new ResponseEntity <ProjectType>(true, ConstantDefine.TipQuerySuccess, result);
return(Json(response, JsonRequestBehavior.AllowGet));
}
else
{
var response = new ResponseEntity <ProjectType>(ConstantDefine.TipQueryFail);
return(Json(response, JsonRequestBehavior.AllowGet));
}
}
public ActionResult GetDepartmentAndProjectType()
{
var result = new ProjectTypeBLL().GetDepartmentAndProjectType();
if (result != null)
{
var response = new ResponseEntity <object>(true, ConstantDefine.TipQuerySuccess, result);
return(Json(response, JsonRequestBehavior.AllowGet));
}
else
{
var response = new ResponseEntity <object>(ConstantDefine.TipQueryFail);
return(Json(response, JsonRequestBehavior.AllowGet));
}
}
public ActionResult GetAllProjectType(string name)
{
var result = new ProjectTypeBLL().GetDataAll();
if (!string.IsNullOrEmpty(name))
{
result = result.Where(x => !string.IsNullOrEmpty(x.Name) && x.Name.IndexOf(name, StringComparison.InvariantCultureIgnoreCase) > -1).ToList();
}
if (result != null)
{
var response = new ResponseEntity <List <ProjectType> >(true, ConstantDefine.TipQuerySuccess, result);
return(Json(response, JsonRequestBehavior.AllowGet));
}
else
{
var response = new ResponseEntity <List <ProjectType> >(ConstantDefine.TipQueryFail);
return(Json(response, JsonRequestBehavior.AllowGet));
}
}
public ActionResult SaveProjectType(ProjectType entity)
{
ResponseEntity <int> response;
if (entity.Id == 0)
{
var list = new ProjectTypeBLL().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 ProjectTypeBLL().InsertProjectType(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.ActionSaveProjectType, $"{result.Data}");
}
else
{
entity.UpdateBy = "";
entity.UpdateTime = DateTime.Now;
var result = new ProjectTypeBLL().UpdateProjectType(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.ActionUpdateProjectType, $"{entity.Id}");
}
return(Json(response, JsonRequestBehavior.AllowGet));
}
