public PageList <Sys_EmpRightResult> GetPageList(Sys_EmpRightParam param) { ExeResult rst = new ExeResult(); rst = this.Execute("ZNLCRM.BLL.Sys.Sys_EmpRightBLL", "GetPageList", param); PageList <Sys_EmpRightResult> pageList = (rst == null ? new PageList <Sys_EmpRightResult>() : (PageList <Sys_EmpRightResult>)rst.Result); return(pageList); }
/// <summary> /// 获取员工的操作权限 /// </summary> /// <param name="param"></param> /// <returns></returns> public PageList <Sys_EmpRightResult> GetPageList(Sys_EmpRightParam param) { this.CheckSession(); PageList <Sys_EmpRightResult> pagelist = new PageList <Sys_EmpRightResult>(); try { WhereClip whereClip = WhereClip.All;// if (param.IsNoAction) { whereClip = whereClip && Sys_EmpRight._.ActionCode.IsNull(); } else { whereClip = GetWhereClip(param); } if (param.MenuID > 0) { whereClip = whereClip && Sys_Module._.MenuID.At("b") == param.MenuID; } if (!string.IsNullOrEmpty(param.ModuleName)) { whereClip = whereClip && Sys_Module._.ModuleName.At("b").Like("%" + param.ModuleName + "%"); } List <Field> fiels = new List <Field>() { Sys_EmpRight._.EmpRightID, Sys_EmpRight._.EmpID, Sys_Module._.ModuleID.At("b"), Sys_EmpRight._.ActionCode, Sys_Module._.ModuleName.At("b"), Sys_Module._.ModuleCode.At("b"), Sys_Module._.MenuID.At("b"), Sys_Module._.ActionCode.At("b").As("BaseActionCode") }; WhereClip onWhereClip = Sys_EmpRight._.ModuleID == Sys_Module._.ModuleID.At("b"); pagelist = this.SelectList <Sys_EmpRightResult, Sys_Module>(JoinType.RightJoin, onWhereClip, param.PageIndex.GetValueOrDefault(1), param.PageSize.GetValueOrDefault(50), fiels, whereClip, Sys_Module._.ModuleCode.At("b").Asc, null, null); pagelist.ResultJoinList.Columns.Add("RightName"); } catch (WarnException exp) { throw exp; } catch (System.Exception exp) { LogInfoBLL.WriteLog(this.SessionInfo, exp); throw exp; } return(pagelist); }
WhereClip GetWhereClip(Sys_EmpRightParam param) { this.CheckSession(); WhereClip where = Sys_EmpRight._.IsDeleted == false; if (param.EmpRightID > 0) { where = where && Sys_EmpRight._.EmpRightID == param.EmpRightID; } if (param.EmpID > 0) { where = where && Sys_EmpRight._.EmpID == param.EmpID; } if (param.ModuleID > 0) { where = where && Sys_EmpRight._.ModuleID == param.ModuleID; } return(where); }
public int SaveEmpRight(Sys_EmpRightParam param) { this.CheckSession(); int ret = 0; if (param.EmpID.ToInt32() <= 0) { throw new WarnException("请指定员工!"); } List <Sys_EmpRightResult> lstEmpRight = new List <Sys_EmpRightResult>(); lstEmpRight = this.SelectList <Sys_EmpRightResult>(Sys_EmpRight._.EmpID == param.EmpID && Sys_EmpRight._.IsDeleted == false); List <Sys_EmpRightResult> lstEditEmpRight = param.EmpRightList; if (lstEditEmpRight == null) { lstEditEmpRight = new List <Sys_EmpRightResult>(); } List <Sys_EmpRightResult> lstNewEmpRight = lstEditEmpRight.Where(a => !lstEmpRight.Exists(b => b.ModuleID == a.ModuleID)).Distinct().ToList(); List <Sys_EmpRightResult> lstModifyEmpRight = lstEditEmpRight.Where(a => lstEmpRight.Exists(b => b.ModuleID == a.ModuleID)).Distinct().ToList(); List <Sys_EmpRightResult> lstDelEmpRight = lstEmpRight.Where(a => !lstEditEmpRight.Exists(b => b.ModuleID == a.ModuleID)).Distinct().ToList(); if (lstNewEmpRight.Count > 0) { this.BatchInsertOrUpdate <Sys_EmpRightResult>(lstNewEmpRight); } if (lstModifyEmpRight.Count > 0) { this.BatchInsertOrUpdate <Sys_EmpRightResult>(lstModifyEmpRight); } if (lstDelEmpRight.Count > 0) { this.BatchDelete <Sys_EmpRightResult>(lstDelEmpRight); } ret = this.BatchExecute(); return(ret); }
/// <summary> /// 保存 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnSaveEditModule_Click(object sender, EventArgs e) { Sys_EmpRightParam param = new Sys_EmpRightParam(); param.ModuleID = Convert.ToInt32(ModuleID); param.EmpID = Convert.ToInt32(EmpID); //param.GCompanyID = Guid.NewGuid(); //当前公司的Guid param.ActionCode = GetEmpModuleOperation(); //ExeResult res = new Sys_EmpRightLogic().UpdataModuleOperation(param); //if (res.Complete == ExeComplete.Succeed) //{ // //ShowMessage("保存数据成功!"); // if (refreshPeantHandler != null) // { // refreshPeantHandler(); // this.Close(); // } //} //else //{ // ShowMessage(res.DebugMsg); //} }
/// <summary> /// 绑定数据源 /// </summary> /// <param name="dgv"></param> /// <param name="tr"></param> /// <param name="page"></param> private void BindDataGridView(int pageIndex) { panelShowRight.Hide(); if (adtMenu.SelectedNode == null) { return; } List <Sys_MenuResult> lstRst = new List <Sys_MenuResult>(); Sys_EmpRightParam param = new Sys_EmpRightParam(); param.EmpID = _empID; param.PageIndex = pageIndex; param.PageSize = 50; param.MenuID = adtMenu.SelectedNode.Name.Substring(3).ToInt32(); param.ModuleName = txtModuleName.Text.Trim(); param.IsNoAction = cboIsNoSet.Checked; PageList <Sys_EmpRightResult> pgList = rightLogic.GetPageList(param); if (pgList.ResultJoinList != null && pgList.ResultJoinList.Rows.Count > 0) { foreach (DataRow row in pgList.ResultJoinList.Rows) { string actionCode = row["ActionCode"].ToStringHasNull(); if (string.IsNullOrEmpty(actionCode)) { continue; } row["RightName"] = GetRightName(actionCode); } dgvModule.DataSource = pgList.ResultJoinList; pgEmpRight.RecordCount = pgList.TotalCount; pgEmpRight.Refresh(); } }