void BindDgvDept()
{
if (trOrg.SelectedNode != null)
{
HR_DepartmentParam param = new HR_DepartmentParam();
if (trOrg.SelectedNode.Name.Contains("trnOrg"))
{
param.OrgID = int.Parse(trOrg.SelectedNode.Name.Substring(6));
}
if (!string.IsNullOrEmpty(txtDeptName.Text))
{
param.DeptName = txtDeptName.Text.Trim();
}
param.NoDeptIDs = deptIds;
List <HR_DepartmentResult> lstRst = deptLogic.GetDeptList(param);
dgvDept.DataSource = lstRst;
this.SetDataSource <HR_DepartmentResult>(lstRst);
SetGridCheck(this.dgvDept, _idColName, _chkColName);
}
else
{
this.ShowMessage("请选择要搜索的机构！");
}
}
/// <summary>
/// 获取一条信息记录
/// </summary>
/// <param name="param"></param>
/// <returns></returns>
public HR_DepartmentResult GetInfo(HR_DepartmentParam param)
{
this.CheckSession();
HR_DepartmentResult rst = new HR_DepartmentResult();
#region 判断
if (param.DeptID == null)
{
throw new WarnException("请指定关键字DeptID！");
}
#endregion
#region 获取实体
rst = this.Select <HR_DepartmentResult>(GetWhereClip(param));
rst.DeptOrgGuID = rst.OrgGuID;
rst.DeptOrgID = rst.OrgID;
HR_DepartmentResult parentResult = this.Select <HR_DepartmentResult>(HR_Department._.DeptID == rst.ParentID && HR_Department._.OrgGuID == rst.OrgGuID);
if (parentResult != null)
{
rst.ParentDeptName = parentResult.DeptName;
}
HR_OrgResult orgResult = this.Select <HR_OrgResult>(HR_Org._.OrgGuID == rst.OrgGuID);
if (orgResult != null)
{
rst.DeptOrgName = orgResult.OrgName;
}
#endregion
return(rst);
}
/// <summary>
/// 删除实体
/// </summary>
/// <param name="param">删除条件实体</param>
/// <returns></returns>
public WCFAddUpdateResult DelInfo(HR_DepartmentParam param)
{
this.CheckSession();
WCFAddUpdateResult ret = new WCFAddUpdateResult();
int affect = 0;
try
{
#region 判断
if (param.DeptID == null)
{
throw new WarnException("请指定要删除的记录！");
}
#endregion
WhereClip where = GetWhereClip(param);
HR_DepartmentResult info = new HR_DepartmentResult();
info.IsActive = 2;
affect = this.Update <HR_DepartmentResult>(info, where);
#region 设置返回值
ret.Key = affect;
#endregion
}
catch (WarnException exp)
{
throw exp;
}
catch (System.Exception exp)
{
LogInfoBLL.WriteLog(this.SessionInfo, exp);
throw exp;
}
return(ret);
}
public WCFAddUpdateResult DelInfo(HR_DepartmentParam param)
{
WCFAddUpdateResult ret = new WCFAddUpdateResult();
ExeResult rst = new ExeResult();
rst = this.Execute("ZNLCRM.BLL.HR.HR_DepartmentBLL", "DelInfo", param);
ret = (rst == null ? new WCFAddUpdateResult() : rst.Result as WCFAddUpdateResult);
return(ret);
}
public PageList <HR_DepartmentResult> GetPageList(HR_DepartmentParam param)
{
ExeResult rst = new ExeResult();
rst = this.Execute("ZNLCRM.BLL.HR.HR_DepartmentBLL", "GetPageList", param);
PageList <HR_DepartmentResult> pageList = (rst == null ? new PageList <HR_DepartmentResult>() : rst.Result as PageList <HR_DepartmentResult>);
return(pageList);
}
public HR_DepartmentResult GetInfo(HR_DepartmentParam param)
{
HR_DepartmentResult ret = new HR_DepartmentResult();
ExeResult rst = new ExeResult();
rst = this.Execute("ZNLCRM.BLL.HR.HR_DepartmentBLL", "GetInfo", param);
ret = rst == null ? new HR_DepartmentResult() : rst.Result as HR_DepartmentResult;
return(ret);
}
public void BindComboBox(Controls.UcComboBox c, HR_DepartmentParam param)
{
if (c != null && param != null)
{
List <HR_DepartmentResult> deptList = this.GetDeptList(param);
c.ValueMember = "DeptID";
c.DisplayMember = "DeptName";
c.DataSource = deptList;
}
}
/// <summary>
/// 分页集合
/// </summary>
/// <param name="param"></param>
/// <returns></returns>
public PageList <ORD_PurchaseOrderResult> GetPageList(ORD_PurchaseOrderParam param)
{
this.CheckSession();
PageList <ORD_PurchaseOrderResult> ret = new PageList <ORD_PurchaseOrderResult>();
try
{
List <Field> field = new List <Field>()
{
Field.All
};
ret = this.SelectList <ORD_PurchaseOrderResult>(param.PageIndex.GetValueOrDefault(1), param.PageSize.GetValueOrDefault(50), field, GetWhereClip(param), ORD_PurchaseOrder._.CreatedTime.Desc);
if (ret.ResultList != null && ret.ResultList.Count > 0)
{
HR_OrgBLL orgBLL = new HR_OrgBLL();
orgBLL.SessionInfo = this.SessionInfo;
HR_OrgParam orgParam = new HR_OrgParam();
orgParam.OrgIDs = ret.ResultList.Where(a => a.PurOrgID != null).Select(a => a.PurOrgID).Distinct().ToArray();
List <HR_OrgResult> orgList = orgBLL.GetOrgTree(orgParam);
HR_DepartmentBLL deptBLL = new HR_DepartmentBLL();
deptBLL.SessionInfo = this.SessionInfo;
HR_DepartmentParam deptParam = new HR_DepartmentParam();
deptParam.DeptIDs = ret.ResultList.Where(a => a.PurDeptID != null).Select(a => a.PurDeptID).Distinct().ToArray();
List <HR_DepartmentResult> deptList = deptBLL.GetDeptList(deptParam);
HR_Org findOrg = null;
HR_DepartmentResult findDept = null;
foreach (ORD_PurchaseOrderResult orderResult in ret.ResultList)
{
findOrg = orgList.Find(a => a.OrgID == orderResult.PurOrgID);
if (findOrg != null)
{
orderResult.PurOrgName = findOrg.OrgName;
}
findDept = deptList.Find(a => a.DeptID == orderResult.PurDeptID);
if (findDept != null)
{
orderResult.PurDeptName = findDept.DeptName;
}
orderResult.AllStatus = orderResult.StkInStatus + "->" + orderResult.StkOutStatus;
}
}
}
catch (WarnException exp)
{
throw exp;
}
catch (System.Exception exp)
{
LogInfoBLL.WriteLog(this.SessionInfo, exp);
throw exp;
}
return(ret);
}
/// <summary>
/// 分页集合
/// </summary>
/// <param name="param"></param>
/// <returns></returns>
public PageList <STK_OutResult> GetPageList(STK_OutParam param)
{
this.CheckSession();
PageList <STK_OutResult> ret = new PageList <STK_OutResult>();
try
{
List <Field> field = new List <Field>()
{
Field.All
};
ret = this.SelectList <STK_OutResult>(param.PageIndex.GetValueOrDefault(1), param.PageSize.GetValueOrDefault(50), field, GetWhereClip(param), STK_Out._.CreatedTime.Desc);
if (ret.ResultList != null && ret.ResultList.Count > 0)
{
HR_OrgBLL orgBLL = new HR_OrgBLL();
orgBLL.SessionInfo = this.SessionInfo;
HR_OrgParam orgParam = new HR_OrgParam();
orgParam.OrgIDs = ret.ResultList.Where(a => a.OperDeptID != null).Select(a => a.OperOrgID).Distinct().ToArray();
List <HR_OrgResult> orgList = orgBLL.GetOrgTree(orgParam);
HR_DepartmentBLL deptBLL = new HR_DepartmentBLL();
deptBLL.SessionInfo = this.SessionInfo;
HR_DepartmentParam deptParam = new HR_DepartmentParam();
deptParam.DeptIDs = ret.ResultList.Where(a => a.OperDeptID != null).Select(a => a.OperDeptID).Distinct().ToArray();
List <HR_DepartmentResult> deptList = deptBLL.GetDeptList(deptParam);
foreach (STK_OutResult orderResult in ret.ResultList)
{
if (orderResult.OperOrgID != null)
{
orderResult.OperOrgName = orgList.FirstOrDefault(a => a.OrgID == orderResult.OperOrgID).OrgName;
}
if (orderResult.OperDeptID != null)
{
orderResult.OperDeptName = deptList.FirstOrDefault(a => a.DeptID == orderResult.OperDeptID).DeptName;
}
}
}
}
catch (WarnException exp)
{
throw exp;
}
catch (System.Exception exp)
{
LogInfoBLL.WriteLog(this.SessionInfo, exp);
throw exp;
}
return(ret);
}
public PageList <ORD_SalesOrderResult> GetSimplePageList(ORD_SalesOrderParam param, List <Field> fields)
{
PageList <ORD_SalesOrderResult> ret = new PageList <ORD_SalesOrderResult>();
try
{
ret = this.SelectList <ORD_SalesOrderResult>(param.PageIndex.GetValueOrDefault(1), param.PageSize.GetValueOrDefault(50), fields, GetWhereClip(param), ORD_SalesOrder._.CreatedTime.Desc);
if (ret.ResultList != null && ret.ResultList.Count > 0)
{
HR_OrgBLL orgBLL = new HR_OrgBLL();
orgBLL.SessionInfo = this.SessionInfo;
HR_OrgParam orgParam = new HR_OrgParam();
orgParam.OrgIDs = ret.ResultList.Where(a => a.SalDeptID != null).Select(a => a.SalOrgID).Distinct().ToArray();
List <HR_OrgResult> orgList = orgBLL.GetOrgTree(orgParam);
HR_DepartmentBLL deptBLL = new HR_DepartmentBLL();
deptBLL.SessionInfo = this.SessionInfo;
HR_DepartmentParam deptParam = new HR_DepartmentParam();
deptParam.DeptIDs = ret.ResultList.Where(a => a.SalDeptID != null).Select(a => a.SalDeptID).Distinct().ToArray();
List <HR_DepartmentResult> deptList = deptBLL.GetDeptList(deptParam);
foreach (ORD_SalesOrderResult orderResult in ret.ResultList)
{
if (orderResult.SalOrgID != null)
{
orderResult.SalOrgName = orgList.FirstOrDefault(a => a.OrgID == orderResult.SalOrgID).OrgName;
}
if (orderResult.SalDeptID != null)
{
orderResult.SalDeptName = deptList.FirstOrDefault(a => a.DeptID == orderResult.SalDeptID).DeptName;
}
orderResult.AllStatus = orderResult.NotifyStatus + "->" + orderResult.PurchaseStatus + "->" + orderResult.StkInStatus + "->" + orderResult.StkOutStatus;
}
}
}
catch (WarnException exp)
{
throw exp;
}
catch (System.Exception exp)
{
LogInfoBLL.WriteLog(this.SessionInfo, exp);
throw exp;
}
return(ret);
}
private void btnDelDept_Click(object sender, EventArgs e)
{
HR_DepartmentParam param = new HR_DepartmentParam();
param.DeptID = (int)deptID;
HR_DepartmentResult rst = deptLogic.GetInfo(param);
if (rst != null)
{
if (MessageBox.Show("请确认是否要删除部门：【" + rst.DeptName + "】", "操作提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Question) == DialogResult.OK)
{
WCFAddUpdateResult result = this.AsyncExecute <WCFAddUpdateResult, HR_DepartmentParam>(param, deptLogic.DelInfo, (a) => { BindOrgTree(); });
}
}
else
{
this.ShowMessage("请选择要删除的部门！");
}
}
/// <summary>
/// 获取集合
/// </summary>
/// <param name="param"></param>
/// <returns></returns>
public List <HR_DepartmentResult> GetDeptList(HR_DepartmentParam param)
{
this.CheckSession();
List <HR_DepartmentResult> ret = new List <HR_DepartmentResult>();
try
{
WhereClip whereClip = GetWhereClip(param);
ret = this.SelectList <HR_DepartmentResult>(whereClip, HR_DepartmentResult._.DeptNo.Asc);
}
catch (WarnException exp)
{
throw exp;
}
catch (System.Exception exp)
{
LogInfoBLL.WriteLog(this.SessionInfo, exp);
throw exp;
}
return(ret);
}
/// <summary>
/// 获取条件的公共方法
/// </summary>
/// <param name="param">条件实体</param>
/// <returns></returns>
WhereClip GetWhereClip(HR_DepartmentParam param)
{
this.CheckSession();
WhereClip where = HR_Department._.IsActive == 2;
if (param.DeptID != null)
{
where = where && HR_Department._.DeptID == param.DeptID;
}
if (param.OrgID != null)
{
where = where && HR_Department._.OrgID == param.OrgID;
}
if (param.OrgGuID != null)
{
where = where && HR_Department._.OrgGuID == param.OrgGuID;
}
if (param.DeptIDs != null)
{
where = where && HR_Department._.DeptID.In(param.DeptIDs);
}
return(where);
}
/// <summary>
/// 获取部门和机构信息
/// </summary>
/// <param name="param"></param>
/// <returns></returns>
public PageList <HR_DepartmentResult> GetPageList(HR_DepartmentParam param)
{
this.CheckSession();
PageList <HR_DepartmentResult> pagelist = new PageList <HR_DepartmentResult>();
try
{
WhereClip whereClip = GetWhereClip(param);
if (!string.IsNullOrEmpty(param.OrgName))
{
whereClip = whereClip && HR_Org._.OrgName.At("b") == param.OrgName;
}
List <Field> fiels = new List <Field>()
{
HR_Department._.DeptID,
HR_Department._.DeptName,
HR_Department._.DeptNo,
HR_Org._.OrgID.At("b"),
HR_Org._.OrgNo.At("b"),
HR_Org._.OrgName.At("b")
};
WhereClip onWhereClip = HR_Department._.OrgID == HR_Org._.OrgID.At("b");
pagelist = this.SelectList <HR_DepartmentResult, HR_Org>(JoinType.InnerJoin, onWhereClip, param.PageIndex.GetValueOrDefault(1), param.PageSize.GetValueOrDefault(50), fiels, whereClip, HR_Department._.DeptNo.Asc, null, null);
}
catch (WarnException exp)
{
throw exp;
}
catch (System.Exception exp)
{
LogInfoBLL.WriteLog(this.SessionInfo, exp);
throw exp;
}
return(pagelist);
}
