void BindModuleList(int pageIndex)
{
string moduleCode = "";
this.ShowWaitting(enuWaitMsgType.BindData);
DevComponents.AdvTree.Node node = this.treMenu.SelectedNode;
if (node == null)
{
HideWaitting();
return;
}
moduleCode = node.Tag.ToStringHasNull();
Sys_ModuleLogic logic = new Sys_ModuleLogic(this);
PageList <Sys_ModuleResult> lstRst = new PageList <Sys_ModuleResult>();
Sys_ModuleParam param = new Sys_ModuleParam();
param.PageIndex = pageIndex;
param.ModuleCode = moduleCode;
param.PageSize = this.pagModule.PageSize;
param.NotModuleIDs = moduleID;
param = this.ConvertControlToEntity <Sys_ModuleParam>(this.grpSearch.Controls, param, null);
lstRst = logic.GetPageList(param);
dgvModule.DataSource = lstRst.ResultList;
this.pagModule.RecordCount = lstRst.TotalCount;
this.SetDataSource <Sys_ModuleResult>(lstRst.ResultList);
SetGridCheck(this.dgvModule, _idColName, _chkColName);
HideWaitting();
}
WhereClip GetWhereClip(Sys_ModuleParam param)
{
this.CheckSession();
WhereClip where = Sys_Module._.IsDeleted == 0;
if (param.ModuleID > 0)
{
where = where && Sys_Module._.ModuleID == param.ModuleID;
}
if (param.MenuID > 0)
{
where = where && Sys_Module._.MenuID == param.MenuID;
}
if (param.ModuleCode != null)
{
where = where && Sys_Module._.ModuleCode.Like(param.ModuleCode + "%");
}
if (param.ModuleName != null)
{
where = where && Sys_Module._.ModuleName.Like("%" + param.ModuleName + "%");
}
if (param.ModuleIDs != null && param.ModuleIDs.Length > 0)
{
where = where && Sys_Module._.ModuleID.In(param.ModuleIDs);
}
if (param.NotModuleIDs != null && param.NotModuleIDs.Length > 0)
{
where = where && !Sys_Module._.ModuleID.In(param.NotModuleIDs);
}
return(where);
}
public PageList <Sys_ModuleResult> GetPageList(Sys_ModuleParam param)
{
this.CheckSession();
PageList <Sys_ModuleResult> ret = new PageList <Sys_ModuleResult>();
try
{
WhereClip whereClip = GetWhereClip(param);
List <Field> lstField = new List <Field>()
{
Sys_Module._.MenuID, Sys_Module._.ModuleCode, Sys_Module._.ModuleID
, Sys_Module._.ModuleName, Sys_Module._.ActionCode
};
ret = this.SelectList <Sys_ModuleResult>(param.PageIndex.GetValueOrDefault(1), param.PageSize.GetValueOrDefault(20), lstField, whereClip, Sys_Module._.ModuleCode.Desc);
}
catch (WarnException exp)
{
throw exp;
}
catch (System.Exception exp)
{
LogInfoBLL.WriteLog(this.SessionInfo, exp);
}
return(ret);
}
/// <summary>
/// 删除实体
/// </summary>
/// <param name="param">删除条件实体</param>
/// <returns></returns>
public WCFAddUpdateResult DelInfo(Sys_ModuleParam param)
{
this.CheckSession();
WCFAddUpdateResult ret = new WCFAddUpdateResult();
int affect = 0;
try
{
#region 判断
if (param.ModuleID.ToInt32() <= 0)
{
throw new WarnException("请指定要删除的模块ID！");
}
#endregion
#region 除关联性,暂未加上
#endregion
WhereClip where = GetWhereClip(param);
Sys_ModuleResult info = new Sys_ModuleResult();
info.IsDeleted = true;
affect = this.Update <Sys_ModuleResult>(info, where);
#region 设置返回值
ret.Key = affect;
#endregion
}
catch (WarnException exp)
{
throw exp;
}
catch (System.Exception exp)
{
LogInfoBLL.WriteLog(this.SessionInfo, exp);
}
return(ret);
}
/// <summary>
/// 获取一条信息记录
/// </summary>
/// <param name="param"></param>
/// <returns></returns>
public Sys_ModuleResult GetInfo(Sys_ModuleParam param)
{
this.CheckSession();
Sys_ModuleResult rst = new Sys_ModuleResult();
#region 判断
if (param.ModuleID.ToInt32() <= 0)
{
throw new WarnException("请指定ID！");
}
#endregion
#region 保存实体
WhereClip where = Sys_Module._.ModuleID == param.ModuleID;
rst = this.Select <Sys_ModuleResult>(where);
#region 父级菜单
if (rst.ModuleCode.ToStringHasNull().Length > 3)
{
string parentCode = rst.ModuleCode.Substring(0, rst.ModuleCode.Length - 3);
Sys_MenuResult parMenu = this.Select <Sys_MenuResult>(new List <Field>()
{
Sys_Menu._.MenuName
}
, Sys_Menu._.MenuCode == parentCode);
if (parMenu != null)
{
rst.ParentMenuName = parMenu.MenuName;
}
}
#endregion
#endregion
return(rst);
}
public List <Sys_ModuleResult> GetModuleList(Sys_ModuleParam param)
{
this.CheckSession();
List <Sys_ModuleResult> ret = new List <Sys_ModuleResult>();
try
{
WhereClip whereClip = GetWhereClip(param);
List <Field> lstField = new List <Field>()
{
Sys_Module._.MenuID,
Sys_Module._.ModuleCode,
Sys_Module._.ModuleID,
Sys_Module._.ModuleName,
Sys_Module._.ActionCode
};
ret = this.SelectList <Sys_ModuleResult>(whereClip, Sys_Module._.ModuleCode.Desc);
}
catch (WarnException exp)
{
throw exp;
}
catch (System.Exception exp)
{
LogInfoBLL.WriteLog(this.SessionInfo, exp);
}
return(ret);
}
public ExeResult GetModuleAndEmp(Sys_ModuleParam param)
{
//ExeResult rst = new ExeResult();
//rst = this.Execute("ZNLCRM.BLL.Sys.Sys_ModuleBLL", "GetPageList", param);
//PageList<Sys_ModuleResult> pageList = new PageList<Sys_ModuleResult>();
//pageList = (rst == null ? new PageList<Sys_ModuleResult>() : rst.Result as PageList<Sys_ModuleResult>);
//return pageList;
return(this.Execute("ZNLCRM.BLL.Sys.Sys_ModuleBLL", "GetModuleAndEmp", param));
}
public PageList <Sys_ModuleResult> GetPageList(Sys_ModuleParam param)
{
ExeResult rst = new ExeResult();
rst = this.Execute("ZNLCRM.BLL.Sys.Sys_ModuleBLL", "GetPageList", param);
PageList <Sys_ModuleResult> pageList = new PageList <Sys_ModuleResult>();
pageList = (rst == null ? new PageList <Sys_ModuleResult>() : rst.Result as PageList <Sys_ModuleResult>);
return(pageList);
}
public Sys_ModuleResult GetInfo(Sys_ModuleParam param)
{
Sys_ModuleResult ret = new Sys_ModuleResult();
ExeResult rst = new ExeResult();
if (param.ModuleID.ToInt32() <= 0)
{
this.ShowMessage("请指定要修改的记录！");
return(ret);
}
rst = this.Execute("ZNLCRM.BLL.Sys.Sys_ModuleBLL", "GetInfo", param);
ret = rst == null ? new Sys_ModuleResult() : rst.Result as Sys_ModuleResult;
return(ret);
}
public WCFAddUpdateResult DelInfo(Sys_ModuleParam param)
{
WCFAddUpdateResult ret = new WCFAddUpdateResult();
if (param.ModuleID <= 0)
{
this.ShowMessage("请指定要删除的记录！");
return(ret);
}
ExeResult rst = new ExeResult();
rst = this.Execute("ZNLCRM.BLL.Sys.Sys_ModuleBLL", "DelInfo", param);
ret = (rst == null ? new WCFAddUpdateResult() : rst.Result as WCFAddUpdateResult);
return(ret);
}
void DelModule()
{
DataGridViewCell cell = this.dgvModule.CurrentCell;
if (cell == null || cell.RowIndex < 0)
{
this.ShowMessage("请选择要删除的模块！");
return;
}
int moduleID = 0;
moduleID = this.dgvModule["col_Sys_Module_ModuleID", cell.RowIndex].Value.ToInt32();
if (MessageBox.Show("是否真的删除当前记录？", "删除提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.No)
{
return;
}
Sys_ModuleParam info = new Sys_ModuleParam();
info.ModuleID = moduleID;
Sys_ModuleLogic logic = new Sys_ModuleLogic(this);
WCFAddUpdateResult rst = this.AsyncExecute <WCFAddUpdateResult, Sys_ModuleParam>(info, logic.DelInfo, (a) => { this.BindModuleList(); });
}
private void txtModuleName_KeyUp(object sender, KeyEventArgs e)
{
if (IsSysKeys(e.KeyCode))
{
return;
}
Sys_ModuleParam param = new Sys_ModuleParam();
param.ModuleName = this.txtModuleName.Text;
List <DropGridCol> lstCol = new List <DropGridCol>();
lstCol.Add(new DropGridCol()
{
IsDropSource = false, ColName = "ModuleID", HeadText = "模块ID", IsShow = false, ToControl = this.txtModuleID, Width = 10
});
lstCol.Add(new DropGridCol()
{
IsDropSource = true, ColName = "ModuleName", HeadText = "模块模块名称", IsShow = true, ToControl = this.txtModuleName, Width = 200
});
Sys_ModuleLogic logic = new Sys_ModuleLogic(this);
CreateDropGrid <PageList <Sys_ModuleResult>, Sys_ModuleResult, Sys_ModuleParam>(300, 200, lstCol, param, logic.GetPageList);
}
