/// <summary>
/// 删除实体
/// </summary>
/// <param name="param">删除条件实体</param>
/// <returns></returns>
public WCFAddUpdateResult DelInfo(STK_OutLineParam param)
{
this.CheckSession();
WCFAddUpdateResult ret = new WCFAddUpdateResult();
int affect = 0;
try
{
#region 判断
if (param.StkOutLineGuid == null)
{
throw new WarnException("请指定明细GUID！");
}
#endregion
WhereClip whereClip = GetWhereClip(param);
STK_OutLineResult info = new STK_OutLineResult();
info.IsDeleted = true;
affect = this.Update <STK_OutLineResult>(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);
}
public WCFAddUpdateResult DelInfo(STK_OutLineParam param)
{
WCFAddUpdateResult ret = new WCFAddUpdateResult();
ExeResult rst = new ExeResult();
rst = this.Execute("ZNLCRM.BLL.STK.STK_OutLineBLL", "DelInfo", param);
ret = (rst == null ? new WCFAddUpdateResult() : rst.Result as WCFAddUpdateResult);
return(ret);
}
public STK_OutLineResult GetInfo(STK_OutLineParam param)
{
STK_OutLineResult ret = new STK_OutLineResult();
ExeResult rst = new ExeResult();
rst = this.Execute("ZNLCRM.BLL.STK.STK_OutLineBLL", "GetInfo", param);
ret = rst == null ? new STK_OutLineResult() : rst.Result as STK_OutLineResult;
return(ret);
}
public PageList <STK_OutLineResult> GetPageList(STK_OutLineParam param)
{
ExeResult rst = new ExeResult();
rst = this.Execute("ZNLCRM.BLL.STK.STK_OutLineBLL", "GetPageList", param);
PageList <STK_OutLineResult> pageList = new PageList <STK_OutLineResult>();
pageList = (rst == null ? new PageList <STK_OutLineResult>() : rst.Result as PageList <STK_OutLineResult>);
return(pageList);
}
public List <STK_OutLineResult> GetList(STK_OutLineParam param)
{
ExeResult rst = new ExeResult();
rst = this.Execute("ZNLCRM.BLL.STK.STK_OutLineBLL", "GetList", param);
List <STK_OutLineResult> list = new List <STK_OutLineResult>();
list = (rst == null ? new List <STK_OutLineResult>() : rst.Result as List <STK_OutLineResult>);
return(list);
}
/// <summary>
/// 获取集合
/// </summary>
/// <param name="param"></param>
/// <returns></returns>
public List <STK_OutLineResult> GetList(STK_OutLineParam param)
{
this.CheckSession();
List <STK_OutLineResult> ret = new List <STK_OutLineResult>();
try
{
WhereClip whereClip = GetWhereClip(param);
ret = this.SelectList <STK_OutLineResult>(whereClip, STK_OutLine._.CreatedTime.Asc);
if (ret != null && ret.Count > 0)
{
Guid?[] StkOutGuids = ret.Select(a => a.StkOutGuid).Distinct().ToArray();
Guid?[] ItemCodes = ret.Select(a => a.ItemCode).Distinct().ToArray();
STK_OutBLL stkOutBLL = new STK_OutBLL();
stkOutBLL.SessionInfo = this.SessionInfo;
List <STK_OutResult> outResultList = stkOutBLL.GetList(new STK_OutParam()
{
StkOutGuids = StkOutGuids
});
STK_StockBLL stockBLL = new STK_StockBLL();
stockBLL.SessionInfo = this.SessionInfo;
List <STK_StockResult> stockResultList = stockBLL.GetList(new STK_StockParam()
{
ItemCodes = ItemCodes
});
foreach (STK_OutLineResult outLineResult in ret)
{
STK_OutResult outResult = outResultList.FirstOrDefault(a => a.StkOutGuid == outLineResult.StkOutGuid);
if (outResult != null)
{
outLineResult.StkOutBillNo = outResult.BillNo;
outLineResult.SourceBillNo = outResult.SourceBillNo;
}
STK_StockResult stockResult = stockResultList.FirstOrDefault(a => a.ItemCode == outLineResult.ItemCode);
if (stockResult != null)
{
outLineResult.BuyerID = stockResult.BuyerID;
outLineResult.BuyerName = stockResult.BuyerName;
}
}
}
}
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_OutLineResult> GetPageList(STK_OutLineParam param)
{
PageList <STK_OutLineResult> ret = new PageList <STK_OutLineResult>();
try
{
STK_OutParam outParam = new STK_OutParam()
{
SourceBillNo = param.SourceBillNo,
BillNo = param.StkOutBillNo,
PageIndex = 1,
PageSize = 5000,
Status = param.Status
};
STK_OutBLL outBLL = new STK_OutBLL();
outBLL.SessionInfo = this.SessionInfo;
PageList <STK_OutResult> outList = outBLL.GetPageList(outParam);
if (outList != null && outList.ResultList.Count > 0)
{
Guid?[] StkOutGuids = outList.ResultList.Select(a => (Guid?)a.StkOutGuid).Distinct().ToArray();
param.StkOutGuids = StkOutGuids;
ret = this.SelectList <STK_OutLineResult>(param.PageIndex.GetValueOrDefault(1), param.PageSize.GetValueOrDefault(50), new List <Field>()
{
Field.All
}, GetWhereClip(param), STK_OutLine._.CreatedTime.Desc);
if (ret != null && ret.ResultList.Count > 0)
{
foreach (STK_OutLineResult outLineResult in ret.ResultList)
{
//获取出库单号
STK_OutResult outResult = outList.ResultList.FirstOrDefault(a => a.StkOutGuid == outLineResult.StkOutGuid);
if (outResult != null)
{
outLineResult.StkOutBillNo = outResult.BillNo;
outLineResult.SourceBillNo = outResult.SourceBillNo;
}
}
}
}
}
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 STK_OutLineResult GetInfo(STK_OutLineParam param)
{
this.CheckSession();
STK_OutLineResult rst = new STK_OutLineResult();
#region 判断
if (param.StkOutLineGuid == null)
{
throw new WarnException("请指定明细GUID！");
}
#endregion
#region 获取实体
rst = this.Select <STK_OutLineResult>(GetWhereClip(param));
#endregion
return(rst);
}
private void BindDataGridView(int pageIndex)
{
STK_OutLineParam param = new STK_OutLineParam();
param.PageIndex = pageIndex;
param.PageSize = 100;
param.SourceBillGuid = SourceBillGuid;
param.StkOutLineGuid = StkOutLineGuid;
param.SourceBillNo = txtSourceBillNo.Text.Trim();
param.StkOutBillNo = txtStkOutBillNo.Text.Trim();
param.Model = txtModel.Text.Trim();
param.Status = "Complete"; //审核完成
param.IsReturnOver = false; //未退完
PageList <STK_OutLineResult> lstRst = outLineLogic.GetPageList(param);
dgvStkOutLine.DataSource = lstRst.ResultList;
pgStkOutLine.RecordCount = lstRst.TotalCount;
this.SetDataSource <STK_OutLineResult>(lstRst.ResultList);
SetGridCheck(this.dgvStkOutLine, _idColName, _chkColName);
}
WhereClip GetWhereClip(STK_OutLineParam param)
{
this.CheckSession();
WhereClip where = STK_OutLine._.IsDeleted == 0;
if (param.StkOutGuid != null)
{
where = where && STK_OutLine._.StkOutGuid == param.StkOutGuid;
}
if (param.StkOutGuids != null)
{
where = where && STK_OutLine._.StkOutGuid.In(param.StkOutGuids);
}
if (param.StkOutLineGuid != null)
{
where = where && STK_OutLine._.StkOutLineGuid == param.StkOutLineGuid;
}
if (param.SourceBillGuid != null)
{
where = where && STK_OutLine._.SourceBillGuid == param.SourceBillGuid;
}
if (!string.IsNullOrEmpty(param.Model))
{
where = where && STK_OutLine._.Model.Like("%" + param.Model + "%");
}
if (param.IsReturnOver != null && !param.IsReturnOver.ToBooleanHasNull())
{
where = where && STK_OutLine._.Qty > STK_OutLine._.ReturnOccQty.ToInt32();
}
if (param.StkOutLineGuids != null && param.StkOutLineGuids.Length > 0)
{
where = where && STK_OutLine._.StkOutLineGuid.In(param.StkOutLineGuids);
}
if (param.NoStkOutLineGuids != null && param.NoStkOutLineGuids.Length > 0)
{
where = where && !STK_OutLine._.StkOutLineGuid.In(param.NoStkOutLineGuids);
}
return(where);
}