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