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