/// <summary>
/// //添加单按钮
/// </summary>
/// <param name="btnId"></param>
/// <param name="ManuId"></param>
/// <returns></returns>
public JsonResult AddManuBtn(string BtnId, string ManuId, string OrderNo)
{
string sql = " select * from rms_menubuttons where buttonid='" + BtnId + "' and manuid='" + ManuId + "'";
rms_menubuttons item = RMS_MenuButtonsService.Instance.First(sql);
if (item != null)
{
item.orderno = int.Parse(OrderNo);
// spmodel.GroupId = GroupId;
if (RMS_MenuButtonsService.Instance.Update(item) > 0)
{
return(Json("OK"));
}
}
item = new rms_menubuttons();
//item.id = Guid.NewGuid().ToString();
item.buttonid = int.Parse(BtnId);
item.manuid = int.Parse(ManuId);
item.orderno = int.Parse(OrderNo);
RMS_MenuButtonsService.Instance.Insert(item);
return(Json("OK"));
}
public string SaveRoleOP(string RoleManus, string RoleManuButtons, string RoleId)
{
RMS_RoleManusService.Instance.GetDatabase().BeginTransaction(); //事务开始
RMS_RoleManuButtonsService.Instance.GetDatabase().BeginTransaction(); //事务开始
RMS_RoleService.Instance.GetDatabase().BeginTransaction(); //事务开始
try
{
List <string> manu = RoleManus.Split('_').ToList();
int res = 0;
int f = RMS_RoleManusService.Instance.DeleteW(" roleid='" + RoleId + "'");
for (int i = 0; i < manu.Count; i++)
{
if (!string.IsNullOrEmpty(manu[i]))
{
rms_rolemanus item = new rms_rolemanus();
//item.id = Guid.NewGuid().ToString();
item.roleid = RoleId;
item.manuid = int.Parse(manu[i]);
RMS_RoleManusService.Instance.Insert(item);
res++;
}
}
List <string> ManuButtons = RoleManuButtons.Split('_').ToList();
int ff = RMS_RoleManuButtonsService.Instance.DeleteW(" roleid='" + RoleId + "'");
for (int i = 0; i < ManuButtons.Count; i++)
{
rms_rolemanubuttons item = new rms_rolemanubuttons();
//item.id = Guid.NewGuid().ToString();
string[] data = ManuButtons[i].Split(':');
if (!string.IsNullOrEmpty(data[0]) && !string.IsNullOrEmpty(data[1]))
{
item.roleid = RoleId;
string sql = " manuid=" + data[0] + " and buttonid=" + data[1] + "";
rms_menubuttons bItem = RMS_MenuButtonsService.Instance.SingleW(sql);
if (bItem != null)
{
item.menubuttonsid = bItem.id.ToString();
}
RMS_RoleManuButtonsService.Instance.Insert(item);
res++;
}
}
bool isSucces = true;//操作是否成功
//if (res == manu.Count + ManuButtons.Count)
//{
// #region 生成权限 json
// bool ies = RDBiz.SetJurisdiction(RoleId);//保存 权限json
// if (ies)
// {
// isSucces = true;
// }
// else
// {
// isSucces = false;
// }
// #endregion
//}
//else
//{
// isSucces = false;
//}
if (isSucces) //是否成功
{
RMS_RoleManusService.Instance.GetDatabase().CompleteTransaction(); //事务完成
RMS_RoleManuButtonsService.Instance.GetDatabase().CompleteTransaction(); //事务完成
RMS_RoleService.Instance.GetDatabase().CompleteTransaction(); //事务完成
bool ies = RMS_RoleService.Instance.SetJurisdiction(RoleId); //保存 权限json
return("ok");
}
else
{
RMS_RoleManusService.Instance.GetDatabase().AbortTransaction(); //事务回滚
RMS_RoleManuButtonsService.Instance.GetDatabase().AbortTransaction(); //事务回滚
RMS_RoleService.Instance.GetDatabase().AbortTransaction(); //事务回滚
return("Nok");
}
}
catch (Exception ex)
{
RMS_RoleManusService.Instance.GetDatabase().AbortTransaction(); //事务回滚
RMS_RoleManuButtonsService.Instance.GetDatabase().AbortTransaction(); //事务回滚
RMS_RoleService.Instance.GetDatabase().AbortTransaction(); //事务回滚
return("Nok");
}
}
