/// <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); }