public int Delete(string id) { var model = GetById(Convert.ToInt32(id)); bool resulte = SqlHelper.ExecuteTranSql((con, tran) => { int r = 0; try { string sql = "delete from sys_role where id=@Id"; r = SqlHelper.ExecuteCon(sql.ToString(), new { Id = id }, tran, null, CommandType.Text, con); string sqlfun = "delete from sys_rolemenu where rolecode=@Rolecode"; r = SqlHelper.ExecuteCon(sqlfun.ToString(), new { Rolecode = model.Rolecode }, 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 UpdateRoleMenu(SysRoleEntity model, List <SysRoleMenuEntity> listModel) { bool resulte = SqlHelper.ExecuteTranSql((con, tran) => { int r = 0; try { StringBuilder strsql = new StringBuilder(); strsql.Append("update sys_role set "); strsql.Append("rolecode=@rolecode,rolename=@rolename,roleseq=@roleseq,remark=@remark,createby=@createby,createdate=@createdate"); strsql.Append(" where id=@id "); r = SqlHelper.ExecuteCon(strsql.ToString(), model, tran, null, CommandType.Text, con); if (listModel != null && listModel.Count > 0) { string sqlrolemenu = "delete from sys_rolemenu where rolecode=@Rolecode"; r = SqlHelper.ExecuteCon(sqlrolemenu.ToString(), new { Rolecode = model.Rolecode }, tran, null, CommandType.Text, con); StringBuilder strsqlfun = new StringBuilder(); strsqlfun.Append("insert into sys_rolemenu(menucode,rolecode,funcode) "); strsqlfun.Append(" values(@menucode,@rolecode,@funcode)"); 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 UpdateMenuFun(SysMenuEntity model, List <SysMenuFunctionEntity> listModel) { bool resulte = SqlHelper.ExecuteTranSql((con, tran) => { int r = 0; try { StringBuilder strsql = new StringBuilder(); strsql.Append("update sys_menu set "); strsql.Append("menucode=@menucode,parentcode=@parentcode,menuname=@menuname,menuurl=@menuurl,menuicon=@menuicon,menuseq=@menuseq,isvisible=@isvisible,isenable=@isenable,menulevel=@menulevel,createby=@createby,createdate=@createdate,remark=@remark"); strsql.Append(" where id=@id "); r = SqlHelper.ExecuteCon(strsql.ToString(), model, tran, null, CommandType.Text, con); if (listModel != null && listModel.Count > 0) { string sqlfun = "delete from sys_menufunction where menucode=@Menucode"; r = SqlHelper.ExecuteCon(sqlfun.ToString(), new { Menucode = model.Menucode }, tran, null, CommandType.Text, con); StringBuilder strsqlfun = new StringBuilder(); strsqlfun.Append("insert into sys_menufunction(menucode,funcode) "); strsqlfun.Append(" values(@menucode,@funcode)"); 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 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 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 UpdateUser(SysUserEntity model, SysUserinfoEntity userinfoModel, List <SysUserReumeEntity> userreumeList, List <SysOrganizeuserEntity> orguserList, List <SysUserroleEntity> userroleList) { bool resulte = SqlHelper.ExecuteTranSql((con, tran) => { int r = 0; try { StringBuilder strsql = new StringBuilder(); strsql.Append("update sys_user set "); strsql.Append("usercode=@usercode,username=@username,userpwd=@userpwd,jobcode=@jobcode,rolenames=@rolenames,positions=@positions,orgnames=@orgnames,configjson=@configjson,isenable=@isenable,createby=@createby,createdate=@createdate,jobcodeName=@jobcodeName,positionsName=@positionsName"); strsql.Append(" where id=@id "); r = SqlHelper.ExecuteCon(strsql.ToString(), model, tran, null, CommandType.Text, con); StringBuilder sqluserinfo = new StringBuilder(); sqluserinfo.Append("update sys_userinfo set "); sqluserinfo.Append("realname=@realname,sex=@sex,birthdate=@birthdate,nation=@nation,political=@political,maritalstatus=@maritalstatus,presentaddress=@presentaddress,placeorigin=@placeorigin,education=@education,university=@university,specialty=@specialty,hobby=@hobby,perspecialty=@perspecialty,comprehensive=@comprehensive,telephone=@telephone,email=@email,photo=@photo,selfevaluation=@selfevaluation,createby=@createby,createdate=@createdate"); sqluserinfo.Append(" where usercode=@usercode "); r = SqlHelper.ExecuteCon(sqluserinfo.ToString(), userinfoModel, tran, null, CommandType.Text, con); if (userreumeList != null && userreumeList.Count > 0) { r = SqlHelper.ExecuteCon("delete from sys_userresume where usercode=@Usercode", new { Usercode = model.Usercode }, tran, null, CommandType.Text, con); StringBuilder strsqlresume = new StringBuilder(); strsqlresume.Append("insert into sys_userresume(usercode,retype,beginendyear,content,majorduty) "); strsqlresume.Append(" values(@usercode,@retype,@beginendyear,@content,@majorduty)"); r = SqlHelper.ExecuteCon(strsqlresume.ToString(), userreumeList, tran, null, CommandType.Text, con); } if (orguserList != null && orguserList.Count > 0) { r = SqlHelper.ExecuteCon("delete from sys_organizeuser where usercode=@Usercode", new { Usercode = model.Usercode }, tran, null, CommandType.Text, con); StringBuilder strsqlorguser = new StringBuilder(); strsqlorguser.Append("insert into sys_organizeuser(orgcode,usercode) "); strsqlorguser.Append(" values(@orgcode,@usercode)"); r = SqlHelper.ExecuteCon(strsqlorguser.ToString(), orguserList, tran, null, CommandType.Text, con); } if (userroleList != null && userroleList.Count > 0) { r = SqlHelper.ExecuteCon("delete from sys_userrole where usercode=@Usercode", new { Usercode = model.Usercode }, tran, null, CommandType.Text, con); StringBuilder strsqluserrole = new StringBuilder(); strsqluserrole.Append("insert into sys_userrole(usercode,rolecode) "); strsqluserrole.Append(" values(@usercode,@rolecode)"); r = SqlHelper.ExecuteCon(strsqluserrole.ToString(), userroleList, 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); }