/// <summary> /// 新增字段 /// </summary> /// <returns></returns> public ActionResult AddFields() { try { UserEntity uInfo = ViewData["Account"] as UserEntity; FieldsEntity entityAdd = new FieldsEntity(); entityAdd.TabId = int.Parse(Request["TabId"]); entityAdd.FieldName = Request["FieldName"].Trim(); entityAdd.FieldViewName = Request["FieldViewName"].Trim(); entityAdd.FieldDataTypeId = int.Parse(Request["FieldDataTypeId"]); entityAdd.IsActive = bool.Parse(Request["IsActive"]); entityAdd.IsSearch = bool.Parse(Request["IsSearch"]); entityAdd.CreateBy = uInfo.AccountName; entityAdd.CreateTime = DateTime.Now; entityAdd.UpdateBy = uInfo.AccountName; entityAdd.UpdateTime = DateTime.Now; entityAdd.Sort = int.Parse(Request["Sort"]); bool ExistsFieldName = new FieldsBLL().ExistsFieldName(entityAdd.FieldName, entityAdd.TabId); bool ExistsFieldViewName = new FieldsBLL().ExistsFieldViewName(entityAdd.FieldViewName, entityAdd.TabId); if (ExistsFieldName) { return(Content("{\"msg\":\"添加失败,字段名已存在!\",\"success\":false}")); } else if (ExistsFieldViewName) { return(Content("{\"msg\":\"添加失败,字段显示名已存在!\",\"success\":false}")); } else { int entityId = new FieldsBLL().Add(entityAdd); if (entityId > 0) { //新增数据库表字段 获取表信息 TableEntity tabEntity = new TableBLL().GetModel(entityAdd.TabId); DataTypeEntity dataTypeEntity = new DataTypeBLL().GetModel(entityAdd.FieldDataTypeId); string dbTabName = "tb_" + tabEntity.TabName; if (Comm.AddTabField(dbTabName, entityAdd.FieldName, dataTypeEntity.DataType)) { return(Content("{\"msg\":\"添加成功!\",\"success\":true}")); } else { return(Content("{\"msg\":\"添加失败!\",\"success\":false}")); } } else { return(Content("{\"msg\":\"添加失败!\",\"success\":false}")); } } } catch (Exception ex) { return(Content("{\"msg\":\"添加失败," + ex.Message + "\",\"success\":false}")); } }
/// <summary> /// 编辑字段 /// </summary> /// <returns></returns> public ActionResult EditFields() { try { UserEntity uInfo = ViewData["Account"] as UserEntity; int id = Convert.ToInt32(Request["id"]); string originalName = Request["originalName"]; string originalViewName = Request["originalViewName"]; FieldsEntity entityEdit = new FieldsBLL().GetModel(id); entityEdit.FieldName = Request["FieldName"].Trim(); entityEdit.FieldViewName = Request["FieldViewName"].Trim(); entityEdit.FieldDataTypeId = int.Parse(Request["FieldDataTypeId"]); entityEdit.IsActive = bool.Parse(Request["IsActive"]); entityEdit.IsSearch = bool.Parse(Request["IsSearch"]); entityEdit.Sort = int.Parse(Request["Sort"]); entityEdit.UpdateBy = uInfo.AccountName; entityEdit.UpdateTime = DateTime.Now; bool ExistsFieldViewName = new FieldsBLL().ExistsFieldViewName(entityEdit.FieldViewName, entityEdit.TabId); if (entityEdit.FieldViewName != originalViewName && ExistsFieldViewName) { return(Content("{\"msg\":\"修改失败,字段显示名已存在!\",\"success\":false}")); } else { int result = new FieldsBLL().Update(entityEdit); if (result > 0) { //新增数据库表字段 获取表信息 TableEntity tabEntity = new TableBLL().GetModel(entityEdit.TabId); DataTypeEntity dataTypeEntity = new DataTypeBLL().GetModel(entityEdit.FieldDataTypeId); string dbTabName = "tb_" + tabEntity.TabName; if (Comm.UpdateTabField(dbTabName, entityEdit.FieldName, dataTypeEntity.DataType)) { return(Content("{\"msg\":\"修改成功!\",\"success\":true}")); } else { return(Content("{\"msg\":\"修改失败!\",\"success\":false}")); } } else { return(Content("{\"msg\":\"修改失败!\",\"success\":false}")); } } } catch (Exception ex) { return(Content("{\"msg\":\"修改失败," + ex.Message + "\",\"success\":false}")); } }
public ActionResult GetAllDataTypeInfo() { string strWhere = "1=1"; string sort = Request["sort"] == null ? "id" : Request["sort"]; string order = Request["order"] == null ? "asc" : Request["order"]; if (!string.IsNullOrEmpty(Request["DataTypeName"]) && !SqlInjection.GetString(Request["DataTypeName"])) { strWhere += " and DataTypeName like '%" + Request["DataTypeName"] + "%'"; } //首先获取前台传递过来的参数 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 DataTypeBLL().GetPager("tbDataType", "Id,DataType,DataTypeName,Sort,CreateTime,CreateBy,UpdateTime,UpdateBy", sort + " " + order, pagesize, pageindex, strWhere, out totalCount); return(Content("{\"total\": " + totalCount.ToString() + ",\"rows\":" + strJson + "}")); }
/// <summary> /// 编辑 /// </summary> /// <returns></returns> public ActionResult EditDataType() { try { UserEntity uInfo = ViewData["Account"] as UserEntity; int id = Convert.ToInt32(Request["id"]); string originalName = Request["originalName"]; DataTypeEntity typeEdit = new DataTypeBLL().GetModel(id); typeEdit.DataType = Request["DataType"]; typeEdit.DataTypeName = Request["DataTypeName"]; typeEdit.Sort = int.Parse(Request["Sort"] == null ? "0" : Request["Sort"]); typeEdit.UpdateBy = uInfo.AccountName; typeEdit.UpdateTime = DateTime.Now; bool exists = new DataTypeBLL().Exists(typeEdit.DataTypeName); if (typeEdit.DataTypeName != originalName && exists) { return(Content("{\"msg\":\"修改失败,类型名称已存在!\",\"success\":false}")); } else { int result = new DataTypeBLL().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}")); } }
/// <summary> /// 新增 /// </summary> /// <returns></returns> public ActionResult AddDataType() { try { UserEntity uInfo = ViewData["Account"] as UserEntity; DataTypeEntity typeAdd = new DataTypeEntity(); typeAdd.DataType = Request["DataType"]; typeAdd.DataTypeName = Request["DataTypeName"]; typeAdd.Sort = 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 DataTypeBLL().Exists(typeAdd.DataTypeName); if (exists) { return(Content("{\"msg\":\"添加失败,类型名称已存在!\",\"success\":false}")); } else { int typeId = new DataTypeBLL().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 GetAllDataTypeDrop() { string roleJson = new DataTypeBLL().GetAllDataTypeInfo("1=1"); return(Content(roleJson)); }