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 = "保存失败"
}));
}
}
