/// <summary>
/// 获取集合
/// </summary>
/// <param name="param"></param>
/// <returns></returns>
public List <ORD_PurchaseOrderLineResult> GetList(ORD_PurchaseOrderLineParam param)
{
this.CheckSession();
return(GetSimpleList(param, new List <Field> {
Field.All
}));
}
/// <summary>
/// 删除实体
/// </summary>
/// <param name="param">删除条件实体</param>
/// <returns></returns>
public WCFAddUpdateResult DelInfo(ORD_PurchaseOrderLineParam param)
{
this.CheckSession();
WCFAddUpdateResult ret = new WCFAddUpdateResult();
int affect = 0;
try
{
#region 判断
if (param.POLineGuid == null)
{
throw new WarnException("请指定明细GUID！");
}
#endregion
WhereClip whereClip = GetWhereClip(param);
ORD_PurchaseOrderLineResult info = new ORD_PurchaseOrderLineResult();
info.IsDeleted = true;
affect = this.Update <ORD_PurchaseOrderLineResult>(info, whereClip);
#region 设置返回值
ret.Key = affect;
#endregion
}
catch (WarnException exp)
{
throw exp;
}
catch (System.Exception exp)
{
LogInfoBLL.WriteLog(this.SessionInfo, exp);
throw exp;
}
return(ret);
}
/// <summary>
/// 根据POGUID查询明细记录数
/// </summary>
/// <param name="_poGuid">采购明细POGUID</param>
private int GetOrderDetailCountsByID(Guid _poGuid)
{
ORD_PurchaseOrderLineParam param = new ORD_PurchaseOrderLineParam();
param.POGuid = _poGuid;
List <ORD_PurchaseOrderLineResult> orderList = orderLineLogic.GetList(param);
return(orderList.Count);
}
public WCFAddUpdateResult DelInfo(ORD_PurchaseOrderLineParam param)
{
WCFAddUpdateResult ret = new WCFAddUpdateResult();
ExeResult rst = new ExeResult();
rst = this.Execute("ZNLCRM.BLL.PPM.ORD_PurchaseOrderLineBLL", "DelInfo", param);
ret = (rst == null ? new WCFAddUpdateResult() : rst.Result as WCFAddUpdateResult);
return(ret);
}
public ORD_PurchaseOrderLineResult GetInfo(ORD_PurchaseOrderLineParam param)
{
ORD_PurchaseOrderLineResult ret = new ORD_PurchaseOrderLineResult();
ExeResult rst = new ExeResult();
rst = this.Execute("ZNLCRM.BLL.PPM.ORD_PurchaseOrderLineBLL", "GetInfo", param);
ret = rst == null ? new ORD_PurchaseOrderLineResult() : rst.Result as ORD_PurchaseOrderLineResult;
return(ret);
}
public List <ORD_PurchaseOrderLineResult> GetList(ORD_PurchaseOrderLineParam param)
{
ExeResult rst = new ExeResult();
rst = this.Execute("ZNLCRM.BLL.PPM.ORD_PurchaseOrderLineBLL", "GetList", param);
List <ORD_PurchaseOrderLineResult> list = new List <ORD_PurchaseOrderLineResult>();
list = (rst == null ? new List <ORD_PurchaseOrderLineResult>() : rst.Result as List <ORD_PurchaseOrderLineResult>);
return(list);
}
private void BindDataGridView()
{
ORD_PurchaseOrderLineParam param = new ORD_PurchaseOrderLineParam();
param.POGuid = POGuid;
param.Model = txtModel.Text.Trim();
param.NoPOLineGuids = NoPOLineGuids;
param.POLineGuid = POLineGuid;
List <ORD_PurchaseOrderLineResult> lstRst = lineLogic.GetList(param);
dgvPurchaseOrder.DataSource = lstRst;
this.SetDataSource <ORD_PurchaseOrderLineResult>(lstRst);
SetGridCheck(this.dgvPurchaseOrder, _idColName, _chkColName);
}
/// <summary>
/// 获取一条信息记录
/// </summary>
/// <param name="param"></param>
/// <returns></returns>
public ORD_PurchaseOrderLineResult GetInfo(ORD_PurchaseOrderLineParam param)
{
this.CheckSession();
ORD_PurchaseOrderLineResult rst = new ORD_PurchaseOrderLineResult();
#region 判断
if (param.POLineGuid == null)
{
throw new WarnException("请指定明细GUID！");
}
#endregion
#region 获取实体
rst = this.Select <ORD_PurchaseOrderLineResult>(GetWhereClip(param));
#endregion
return(rst);
}
public List <ORD_PurchaseOrderLineResult> GetSimpleList(ORD_PurchaseOrderLineParam param, List <Field> fields)
{
List <ORD_PurchaseOrderLineResult> ret = new List <ORD_PurchaseOrderLineResult>();
try
{
WhereClip whereClip = GetWhereClip(param);
ret = this.SelectList <ORD_PurchaseOrderLineResult>(fields, whereClip, ORD_PurchaseOrderLine._.CreatedTime.Asc);
if (ret != null && ret.Count > 0)
{
Guid?[] POGuids = ret.Select(a => a.POGuid).Distinct().ToArray();
ORD_PurchaseOrderBLL orderBLL = new ORD_PurchaseOrderBLL();
orderBLL.SessionInfo = this.SessionInfo;
List <ORD_PurchaseOrderResult> orderResultList = orderBLL.GetList(new ORD_PurchaseOrderParam()
{
POGuids = POGuids
});
foreach (ORD_PurchaseOrderLineResult lineResult in ret)
{
ORD_PurchaseOrderResult orderResult = orderResultList.FirstOrDefault(a => a.POGuid == lineResult.POGuid);
if (orderResult != null)
{
lineResult.POBillNo = orderResult.BillNo;
lineResult.Currency = orderResult.Currency;
lineResult.TaxRate = orderResult.TaxRate;
}
}
}
}
catch (WarnException exp)
{
throw exp;
}
catch (System.Exception exp)
{
LogInfoBLL.WriteLog(this.SessionInfo, exp);
throw exp;
}
return(ret);
}
WhereClip GetWhereClip(ORD_PurchaseOrderLineParam param)
{
this.CheckSession();
WhereClip where = ORD_PurchaseOrderLine._.IsDeleted == 0;
if (param.IsCancel != null)
{
where = where && ORD_PurchaseOrderLine._.IsCancel == param.IsCancel;
}
if (param.POLineGuid != null)
{
where = where && ORD_PurchaseOrderLine._.POLineGuid == param.POLineGuid;
}
if (param.POLineGuids != null && param.POLineGuids.Length > 0)
{
where = where && ORD_PurchaseOrderLine._.POLineGuid.In(param.POLineGuids);
}
if (param.POGuid != null)
{
where = where && ORD_PurchaseOrderLine._.POGuid == param.POGuid;
}
if (!string.IsNullOrEmpty(param.Model))
{
where = where && ORD_PurchaseOrderLine._.Model.Like("%" + param.Model + "%");
}
if (param.NoPOLineGuids != null && param.NoPOLineGuids.Length > 0)
{
where = where && !ORD_PurchaseOrderLine._.POLineGuid.In(param.NoPOLineGuids);
}
if (param.NoticeGuids != null && param.NoticeGuids.Length > 0)
{
where = where && ORD_PurchaseOrderLine._.NoticeGuid.In(param.NoticeGuids);
}
if (param.SOLineGuids != null && param.SOLineGuids.Length > 0)
{
where = where && ORD_PurchaseOrderLine._.SOLineGuid.In(param.SOLineGuids);
}
return(where);
}
/// <summary>
/// 删除订单明细
/// </summary>
private void DeleteOrderDetail()
{
ORD_PurchaseOrderLineParam p = new ORD_PurchaseOrderLineParam();
p.POGuid = poguid;
p.POLineGuid = poLineGuid;
ORD_PurchaseOrderLineResult r = orderLineLogic.GetInfo(p);
if (r != null)
{
if (MessageBox.Show("请确认是否要删除该记录", "操作提示",
MessageBoxButtons.OKCancel,
MessageBoxIcon.Question) == DialogResult.OK)
{
WCFAddUpdateResult result = this.AsyncExecute <WCFAddUpdateResult, ORD_PurchaseOrderLineParam>(
p, orderLineLogic.DelInfo, a => { SearchDtl(1); });
if (GetOrderDetailCountsByID(poguid) == 0)
{
DeletePurchaseOrder(false);
}
}
}
}
