/// <summary>
/// 新增
/// </summary>
/// <returns></returns>
public ActionResult AddRequestionType()
{
try
{
UserModel uInfo = ViewData["Account"] as UserModel;
RequestionTypeModel typeAdd = new RequestionTypeModel();
typeAdd.ftypename = Request["TypeName"];
typeAdd.fsort = int.Parse(Request["Sort"] == null ? "0" : Request["Sort"]);
typeAdd.CreateBy = uInfo.AccountName;
typeAdd.CreateTime = DateTime.Now;
typeAdd.UpdateBy = uInfo.AccountName;
typeAdd.UpdateTime = DateTime.Now;
bool exists = new RequestionTypeBLL().Exists(typeAdd.ftypename);
if (exists)
{
return(Content("{\"msg\":\"添加失败,类型名称已存在！\",\"success\":false}"));
}
else
{
int typeId = new RequestionTypeBLL().Add(typeAdd);
if (typeId > 0)
{
return(Content("{\"msg\":\"添加成功！\",\"success\":true}"));
}
else
{
return(Content("{\"msg\":\"添加失败！\",\"success\":false}"));
}
}
}
catch (Exception ex)
{
return(Content("{\"msg\":\"添加失败," + ex.Message + "\",\"success\":false}"));
}
}
public ActionResult GetAllRequestionTypeInfo()
{
string strWhere = "1=1";
string sort = Request["sort"] == null ? "id" : Request["sort"];
string order = Request["order"] == null ? "asc" : Request["order"];
if (!string.IsNullOrEmpty(Request["FTypeName"]) && !SqlInjection.GetString(Request["FTypeName"]))
{
strWhere += " and ftypename like '%" + Request["FTypeName"] + "%'";
}
//首先获取前台传递过来的参数
int pageindex = Request["page"] == null ? 1 : Convert.ToInt32(Request["page"]);
int pagesize = Request["rows"] == null ? 10 : Convert.ToInt32(Request["rows"]);
int totalCount = 0; //输出参数
string strJson = new RequestionTypeBLL().GetPager("tbRequestionType", "[id],[ftypename],fsort,CreateTime,CreateBy,UpdateTime,UpdateBy", sort + " " + order, pagesize, pageindex, strWhere, out totalCount);
return(Content("{\"total\": " + totalCount.ToString() + ",\"rows\":" + strJson + "}"));
}
/// <summary>
/// 编辑
/// </summary>
/// <returns></returns>
public ActionResult EditRequestionType()
{
try
{
UserModel uInfo = ViewData["Account"] as UserModel;
int id = Convert.ToInt32(Request["id"]);
string originalName = Request["originalName"];
RequestionTypeModel typeEdit = new RequestionTypeBLL().GetModel(id);
typeEdit.ftypename = Request["TypeName"];
typeEdit.fsort = int.Parse(Request["Sort"] == null ? "0" : Request["Sort"]);
typeEdit.UpdateBy = uInfo.AccountName;
typeEdit.UpdateTime = DateTime.Now;
bool exists = new RequestionTypeBLL().Exists(typeEdit.ftypename);
if (typeEdit.ftypename != originalName && exists)
{
return(Content("{\"msg\":\"修改失败,类型名称已存在！\",\"success\":false}"));
}
else
{
int result = new RequestionTypeBLL().Update(typeEdit);
if (result > 0)
{
return(Content("{\"msg\":\"修改成功！\",\"success\":true}"));
}
else
{
return(Content("{\"msg\":\"修改失败！\",\"success\":false}"));
}
}
}
catch (Exception ex)
{
return(Content("{\"msg\":\"修改失败," + ex.Message + "\",\"success\":false}"));
}
}
public ActionResult GetAllRequestionTypeDrop()
{
string roleJson = new RequestionTypeBLL().GetAllRequestionTypeInfo("1=1");
return(Content(roleJson));
}
