/// <summary>
/// 删除实体
/// </summary>
/// <param name="param">删除条件实体</param>
/// <returns></returns>
public WCFAddUpdateResult DelInfo(ORD_SalesReturnLineParam param)
{
this.CheckSession();
WCFAddUpdateResult ret = new WCFAddUpdateResult();
int affect = 0;
try
{
#region 判断
if (param.SRLineGuid == null)
{
throw new WarnException("请指定明细GUID！");
}
#endregion
WhereClip whereClip = GetWhereClip(param);
ORD_SalesReturnLineResult info = new ORD_SalesReturnLineResult();
info.IsDeleted = true;
affect = this.Update <ORD_SalesReturnLineResult>(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);
}
WhereClip GetWhereClip(ORD_SalesReturnLineParam param)
{
this.CheckSession();
WhereClip where = ORD_SalesReturnLine._.IsDeleted == 0;
if (param.SRLineGuid != null)
{
where = where && ORD_SalesReturnLine._.SRLineGuid == param.SRLineGuid;
}
if (param.SRLineGuids != null && param.SRLineGuids.Length > 0)
{
where = where && ORD_SalesReturnLine._.SRLineGuid.In(param.SRLineGuids);
}
if (param.NoSRLineGuids != null && param.NoSRLineGuids.Length > 0)
{
where = where && !ORD_SalesReturnLine._.SRLineGuid.In(param.NoSRLineGuids);
}
if (param.SRGuid != null)
{
where = where && ORD_SalesReturnLine._.SRGuid == param.SRGuid;
}
if (!string.IsNullOrEmpty(param.Model))
{
where = where && ORD_SalesReturnLine._.Model.Like(param.Model + "%");
}
if (param.StkOutLineGuids != null && param.StkOutLineGuids.Length > 0)
{
where = where && ORD_SalesReturnLine._.StkOutLineGuid.In(param.StkOutLineGuids);
}
return(where);
}
/// <summary>
/// 获取集合
/// </summary>
/// <param name="param"></param>
/// <returns></returns>
public List <ORD_SalesReturnLineResult> GetList(ORD_SalesReturnLineParam param)
{
this.CheckSession();
List <ORD_SalesReturnLineResult> ret = new List <ORD_SalesReturnLineResult>();
try
{
WhereClip whereClip = GetWhereClip(param);
ret = this.SelectList <ORD_SalesReturnLineResult>(whereClip, ORD_SalesReturnLine._.CreatedTime.Asc);
if (ret != null)
{
STK_InLineBLL stkInLineBLL = new STK_InLineBLL();
stkInLineBLL.SessionInfo = this.SessionInfo;
Guid?[] stkInLineGuids = ret.Select(a => a.StkInLineGuid).Distinct().ToArray();
List <STK_InLineResult> linkInLineResultList = stkInLineBLL.GetList(new STK_InLineParam()
{
StkInLineGuids = stkInLineGuids
});
ORD_SalesReturnBLL returnBLL = new ORD_SalesReturnBLL();
returnBLL.SessionInfo = this.SessionInfo;
Guid?[] SRGuids = ret.Select(a => a.SRGuid).Distinct().ToArray();
List <ORD_SalesReturnResult> returnResultList = returnBLL.GetList(new ORD_SalesReturnParam()
{
SRGuids = SRGuids
});
foreach (ORD_SalesReturnLineResult returnLineResult in ret)
{
ORD_SalesReturnResult returnResult = returnResultList.FirstOrDefault(a => a.SRGuid == returnLineResult.SRGuid);
if (returnResult != null)
{
returnLineResult.SRBillNo = returnResult.BillNo;
}
STK_InLineResult linkStkInLineResult = linkInLineResultList.FirstOrDefault(a => a.StkInLineGuid == returnLineResult.StkInLineGuid);
if (linkStkInLineResult != null)
{
returnLineResult.LinkStkInCurrency = linkStkInLineResult.Currency;
returnLineResult.LinkStkInTaxRate = linkStkInLineResult.TaxRate;
returnLineResult.LinkStkInUnitPrice = linkStkInLineResult.UnitPrice;
returnLineResult.LinkStkInFreight = linkStkInLineResult.Freight;
returnLineResult.LinkStkInCostPrice = linkStkInLineResult.CostPrice;
}
}
}
}
catch (WarnException exp)
{
throw exp;
}
catch (System.Exception exp)
{
LogInfoBLL.WriteLog(this.SessionInfo, exp);
throw exp;
}
return(ret);
}
public List <ORD_SalesReturnLineResult> GetList(ORD_SalesReturnLineParam param)
{
ExeResult rst = new ExeResult();
rst = this.Execute("ZNLCRM.BLL.SPM.ORD_SalesReturnLineBLL", "GetList", param);
List <ORD_SalesReturnLineResult> list = new List <ORD_SalesReturnLineResult>();
list = (rst == null ? new List <ORD_SalesReturnLineResult>() : rst.Result as List <ORD_SalesReturnLineResult>);
return(list);
}
private void BindDataGridView()
{
ORD_SalesReturnLineParam param = new ORD_SalesReturnLineParam();
param.SRGuid = SRGuid;
param.Model = txtModel.Text.Trim();
param.NoSRLineGuids = NoSRLineGuids;
param.SRLineGuid = SRLineGuid;
List <ORD_SalesReturnLineResult> lstRst = lineLogic.GetList(param);
dgvSalesReturn.DataSource = lstRst;
this.SetDataSource <ORD_SalesReturnLineResult>(lstRst);
SetGridCheck(this.dgvSalesReturn, _idColName, _chkColName);
}
/// <summary>
/// 获取一条信息记录
/// </summary>
/// <param name="param"></param>
/// <returns></returns>
public ORD_SalesReturnLineResult GetInfo(ORD_SalesReturnLineParam param)
{
this.CheckSession();
ORD_SalesReturnLineResult rst = new ORD_SalesReturnLineResult();
#region 判断
if (param.SRLineGuid == null)
{
throw new WarnException("请指定明细GUID！");
}
#endregion
#region 获取实体
rst = this.Select <ORD_SalesReturnLineResult>(GetWhereClip(param));
#endregion
return(rst);
}
/// <summary>
/// 获取销售退货的分页信息
/// </summary>
/// <param name="param"></param>
/// <returns></returns>
public PageList <ORD_SalesReturnLineResult> GetPageList(ORD_SalesReturnLineParam param)
{
PageList <ORD_SalesReturnLineResult> ret = new PageList <ORD_SalesReturnLineResult>();
try
{
ret = this.SelectList <ORD_SalesReturnLineResult>(param.PageIndex.GetValueOrDefault(1), param.PageSize.GetValueOrDefault(50), new List <Field> {
Field.All
}, GetWhereClip(param), ORD_SalesReturnLine._.CreatedTime.Desc);
}
catch (WarnException exp)
{
throw exp;
}
catch (System.Exception exp)
{
LogInfoBLL.WriteLog(this.SessionInfo, exp);
throw exp;
}
return(ret);
}
