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