public int InsertOrgRole(SysOrganizeEntity model, List<SysOrganizeroleEntity> listModel) { bool resulte = SqlHelper.ExecuteTranSql((con, tran) => { int r = 0; try { StringBuilder strsql = new StringBuilder(); strsql.Append("insert into sys_organize(orgcode,orgname,parentcode,orgseq,isdel,remark,createby,createdate) "); strsql.Append(" values(@orgcode,@orgname,@parentcode,@orgseq,@isdel,@remark,@createby,@createdate)"); r = SqlHelper.ExecuteCon(strsql.ToString(), model, tran, null, CommandType.Text, con); if (listModel != null && listModel.Count > 0) { StringBuilder strsqlfun = new StringBuilder(); strsqlfun.Append("insert into sys_organizerole(orgcode,rolecode) "); strsqlfun.Append(" values(@orgcode,@rolecode)"); r = SqlHelper.ExecuteCon(strsqlfun.ToString(), listModel, tran, null, CommandType.Text, con); } } catch (Exception ex) { Log4NetHelper.GetLogger(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType).Debug(ex.Message); r = 0; } return r; }); return resulte ? 1 : 0; }
public int Insert(SysOrganizeEntity model) { StringBuilder strsql = new StringBuilder(); strsql.Append("insert into sys_organize(orgcode,orgname,parentcode,orgseq,isdel,remark,createby,createdate) "); strsql.Append(" values(@orgcode,@orgname,@parentcode,@orgseq,@isdel,@remark,@createby,@createdate)"); return SqlHelper.Execute(strsql.ToString(), model); }
public int UpdateOrgRole(SysOrganizeEntity model, List<SysOrganizeroleEntity> listModel) { bool resulte = SqlHelper.ExecuteTranSql((con, tran) => { int r = 0; try { StringBuilder strsql = new StringBuilder(); strsql.Append("update sys_organize set "); strsql.Append("orgcode=@orgcode,orgname=@orgname,parentcode=@parentcode,orgseq=@orgseq,isdel=@isdel,remark=@remark,createby=@createby,createdate=@createdate"); strsql.Append(" where id=@id "); r = SqlHelper.ExecuteCon(strsql.ToString(), model, tran, null, CommandType.Text, con); string sqlfun = "delete from sys_organizerole where orgcode=@Orgcode"; r = SqlHelper.ExecuteCon(sqlfun.ToString(), new { Orgcode = model.Orgcode }, tran, null, CommandType.Text, con); StringBuilder strsqlfun = new StringBuilder(); if (listModel != null && listModel.Count > 0) { strsqlfun.Append("insert into sys_organizerole(orgcode,rolecode) "); strsqlfun.Append(" values(@orgcode,@rolecode)"); r = SqlHelper.ExecuteCon(strsqlfun.ToString(), listModel, tran, null, CommandType.Text, con); } r = 1;//标识成功 } catch (Exception ex) { Log4NetHelper.GetLogger(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType).Debug(ex.Message); r = 0; } return r; }); return resulte ? 1 : 0; }
public int Update(SysOrganizeEntity model) { StringBuilder strsql = new StringBuilder(); strsql.Append("update sys_organize set "); strsql.Append("orgcode=@orgcode,orgname=@orgname,parentcode=@parentcode,orgseq=@orgseq,isdel=@isdel,remark=@remark,createby=@createby,createdate=@createdate"); strsql.Append(" where id=@id "); return SqlHelper.Execute(strsql.ToString(), model); }
public ActionResult CreateOrg() { SysPower(SysMenuConstant.MENU_ORGANIZE_MANAGE, SysMenuConstant.FUN_ADD, UserInfo.UserCode); var model = new SysOrganizeEntity(); #region 增加是自动获取代码和序列号 string strwhere = string.Empty; Hashtable hs = ISysOrgService.GetMaxPartOrg(RequestHelper.FilterParam(Request.QueryString["code"])); string parentCode = ""; int menseq = 0; if (hs.Count > 0) { parentCode = hs["OrgCode"].ToString(); menseq = Convert.ToInt32(hs["OrgSeq"]); } string code = RequestHelper.GetQueryValueOrNull <string>("code"); string currcode = ""; if (parentCode == "") { if (string.IsNullOrEmpty(code))//表示顶级菜单 { currcode = "201"; } else { currcode = Request.QueryString["code"].ToString() + "001"; } menseq = 1; } else { if (string.IsNullOrEmpty(code))//表示顶级菜单 { currcode = Convert.ToString(Convert.ToInt32(parentCode) + 1); menseq = 1; } else { currcode = code + Convert.ToString(Convert.ToInt32(parentCode.Substring(parentCode.Length - 3)) + 1).PadLeft(3, '0'); menseq++; } } model.Orgcode = currcode; model.Orgseq = menseq; model.Parentcode = code; #endregion return(View("EidtOrg", model)); }
public ActionResult SaveOrgRole(SysOrganizeEntity model) { var orgname = StringHelper.GetStrLength(model.Orgname); bool power = true; if (orgname == 0 || orgname > 20) { return(new CustomerJsonResult(new ResponseResult { code = ResponseHelper.ORPARAMCODE, msg = "名称不合法" })); } if (string.IsNullOrWhiteSpace(model.Orgcode)) { return(new CustomerJsonResult(new ResponseResult { code = ResponseHelper.ORPARAMCODE, msg = "代码不能为空" })); } model.Createby = UserInfo.UserCode; model.Createdate = DateTime.Now; List <SysOrganizeroleEntity> list = new List <SysOrganizeroleEntity>(); //处理角色 功能 var listrolecode = RequestHelper.GetStringListNoNull("rolecode"); foreach (var item in listrolecode) { list.Add(new SysOrganizeroleEntity { Orgcode = model.Orgcode, Rolecode = item }); } int result = 0; if (model.Id > 0) { power = SysPower(SysMenuConstant.MENU_ORGANIZE_MANAGE, SysMenuConstant.FUN_UPDATE, UserInfo.UserCode, false); if (!power) { return(new CustomerJsonResult(new ResponseResult { code = ResponseHelper.FAILCODE, msg = "权限不足" })); } result = ISysOrgService.UpdateOrgRole(model, list); } else { power = SysPower(SysMenuConstant.MENU_ORGANIZE_MANAGE, SysMenuConstant.FUN_ADD, UserInfo.UserCode, false); if (!power) { return(new CustomerJsonResult(new ResponseResult { code = ResponseHelper.FAILCODE, msg = "权限不足" })); } result = ISysOrgService.InsertOrgRole(model, list); } if (result > 0) { return(new CustomerJsonResult(new ResponseResult { code = ResponseHelper.ESUCCESSCODE, msg = "保存成功" })); } else { return(new CustomerJsonResult(new ResponseResult { code = ResponseHelper.FAILCODE, msg = "保存失败" })); } }