using System; using System.Collections.Generic; using System.Data; using SuperMap.RealEstate.ServiceModel; using Business = SuperMap.RealEstate.BasicArchives.Storage.Business; namespace GSYWApi.Helper { /// /// 退货表相关方法 /// public class BACKCOMMODITYHelper { #region 获取退货表列表 public static List GetBACKCOMMODITYList(Transaction transaction, ref int TotalCount, int PageIndex = 1, int PageSize = 10, string SortStr = "") { List BACKCOMMODITYList = new List(); string WhereSQL = "", RowFilterSQL = ""; DataTable dtBACKCOMMODITY = new Business.BACKCOMMODITY(transaction).FillDataTable(WhereSQL); if (RowFilterSQL != "") { dtBACKCOMMODITY.DefaultView.RowFilter = RowFilterSQL; } //排序： dtBACKCOMMODITY.DefaultView.Sort = SortStr; dtBACKCOMMODITY = dtBACKCOMMODITY.DefaultView.ToTable(); //获取查询结果总记录条数 TotalCount = dtBACKCOMMODITY.Rows.Count; //根据传入的页码和每页显示条数返回结果 dtBACKCOMMODITY = CommonHelper.GetDataTableWithPageSize(dtBACKCOMMODITY, PageSize, PageIndex); foreach (DataRow drBACKCOMMODITY in dtBACKCOMMODITY.Rows) { Model.BACKCOMMODITYModel backcommodityModel = new Model.BACKCOMMODITYModel(); backcommodityModel.BACKCOMMODITY_ID = drBACKCOMMODITY["BACKCOMMODITY_ID"].TryParseToInt(); //内码 backcommodityModel.SERVERPARTSTOCK_ID = drBACKCOMMODITY["SERVERPARTSTOCK_ID"].TryParseToInt(); //退货流水 backcommodityModel.SALESTOREPROINST_ID = drBACKCOMMODITY["SALESTOREPROINST_ID"].TryParseToInt(); //项目流程内码 backcommodityModel.COMMODITY_NAME = drBACKCOMMODITY["COMMODITY_NAME"].ToString(); //退货商品名称 backcommodityModel.COMMODITY_CODE = drBACKCOMMODITY["COMMODITY_CODE"].ToString(); //退货商品编码 backcommodityModel.COMMODITY_BARCODE = drBACKCOMMODITY["COMMODITY_BARCODE"].ToString(); //退货商品条码 backcommodityModel.BACK_COUNT = drBACKCOMMODITY["BACK_COUNT"].TryParseToDouble(); //退货商品数量 backcommodityModel.COMMODITY_ID = drBACKCOMMODITY["COMMODITY_ID"].TryParseToInt(); //商品内码 backcommodityModel.BACK_DATE = drBACKCOMMODITY["BACK_DATE"].TryParseToDateTime(); //退货请求时间 backcommodityModel.SUPPLIER_ID = drBACKCOMMODITY["SUPPLIER_ID"].TryParseToInt(); //供应商内码 backcommodityModel.PURCHASE_TAXPRICE = drBACKCOMMODITY["PURCHASE_TAXPRICE"].TryParseToDouble(); //含税进价 backcommodityModel.PURCHASE_PRICE = drBACKCOMMODITY["PURCHASE_PRICE"].TryParseToDouble(); //除税进价 backcommodityModel.BACKTAXPRICE = drBACKCOMMODITY["BACKTAXPRICE"].TryParseToDouble(); //含税金额 backcommodityModel.BACKPRICE = drBACKCOMMODITY["BACKPRICE"].TryParseToDouble(); //除税金额 backcommodityModel.BACK_DESC = drBACKCOMMODITY["BACK_DESC"].ToString(); //备注 backcommodityModel.BACK_SELLPRICE = drBACKCOMMODITY["BACK_SELLPRICE"].TryParseToDouble(); //除税售价金额 backcommodityModel.BACK_SELLTAXPRICE = drBACKCOMMODITY["BACK_SELLTAXPRICE"].TryParseToDouble(); //含税售价金额 backcommodityModel.SELLPRICE = drBACKCOMMODITY["SELLPRICE"].TryParseToDouble(); //除税售价 backcommodityModel.SELLTAXPRICE = drBACKCOMMODITY["SELLTAXPRICE"].TryParseToDouble(); //含税售价 backcommodityModel.SERVERPART_ID = drBACKCOMMODITY["SERVERPART_ID"].TryParseToInt(); //服务区内码 backcommodityModel.SERVERPART_NAME = drBACKCOMMODITY["SERVERPART_NAME"].ToString(); //服务区名称 backcommodityModel.SERVERPARTSHOP_ID = drBACKCOMMODITY["SERVERPARTSHOP_ID"].TryParseToInt(); //门店内码 backcommodityModel.SHOPNAME = drBACKCOMMODITY["SHOPNAME"].ToString(); //门店名称 backcommodityModel.SUPPLIER_NAME = drBACKCOMMODITY["SUPPLIER_NAME"].ToString(); //供应商名称 backcommodityModel.DUTY_PARAGRAPH = drBACKCOMMODITY["DUTY_PARAGRAPH"].TryParseToDouble(); //进价税率 backcommodityModel.RTCOMMODITY_ID = drBACKCOMMODITY["RTCOMMODITY_ID"].TryParseToInt(); //RTCOMMODITY_ID backcommodityModel.RTCOMMODITY_NAME = drBACKCOMMODITY["RTCOMMODITY_NAME"].ToString(); //RTCOMMODITY_NAME backcommodityModel.RTCOMMODITY_BARCODE = drBACKCOMMODITY["RTCOMMODITY_BARCODE"].ToString(); //RTCOMMODITY_BARCODE backcommodityModel.RTCOMMODITY_RULE = drBACKCOMMODITY["RTCOMMODITY_RULE"].ToString(); //RTCOMMODITY_RULE backcommodityModel.RTBACK_COUNT = drBACKCOMMODITY["RTBACK_COUNT"].TryParseToDouble(); //RTBACK_COUNT backcommodityModel.RTPURCHASE_TAXPRICE = drBACKCOMMODITY["RTPURCHASE_TAXPRICE"].TryParseToDouble(); //RTPURCHASE_TAXPRICE backcommodityModel.RTPURCHASE_PRICE = drBACKCOMMODITY["RTPURCHASE_PRICE"].TryParseToDouble(); //RTPURCHASE_PRICE backcommodityModel.RTCOMMODITY_CODE = drBACKCOMMODITY["RTCOMMODITY_CODE"].ToString(); //RTCOMMODITY_CODE BACKCOMMODITYList.Add(backcommodityModel); } return BACKCOMMODITYList; } #endregion #region 获取退货表列表 /// /// 获取退货表列表 /// /// 事务管理器 /// 查询结果总数 /// 查询条件对象 public static List GetBACKCOMMODITYList(Transaction transaction, ref int TotalCount, Models.SearchModel searchModel) { List BACKCOMMODITYList = new List(); string WhereSQL = "", RowFilterSQL = ""; if (searchModel.SearchParameter != null) { WhereSQL = OperationDataHelper.GetWhereSQL(searchModel.SearchParameter, searchModel.QueryType); if (WhereSQL != "") { WhereSQL = "WHERE " + WhereSQL; } } DataTable dtBACKCOMMODITY = new Business.BACKCOMMODITY(transaction).FillDataTable(WhereSQL); //增加组合查询条件 if (searchModel.keyWord != null && !string.IsNullOrWhiteSpace(searchModel.keyWord.Key)) { foreach (string KeyName in searchModel.keyWord.Key.Split(',')) { RowFilterSQL += (RowFilterSQL == "" ? "" : " or ") + KeyName + " like '%" + searchModel.keyWord.Value + "%'"; } } if (RowFilterSQL != "") { dtBACKCOMMODITY.DefaultView.RowFilter = RowFilterSQL; } //排序： dtBACKCOMMODITY.DefaultView.Sort = searchModel.SortStr; dtBACKCOMMODITY = dtBACKCOMMODITY.DefaultView.ToTable(); //获取查询结果总记录条数 TotalCount = dtBACKCOMMODITY.Rows.Count; //根据传入的页码和每页显示条数返回结果 dtBACKCOMMODITY = CommonHelper.GetDataTableWithPageSize(dtBACKCOMMODITY, searchModel.PageSize, searchModel.PageIndex); foreach (DataRow drBACKCOMMODITY in dtBACKCOMMODITY.Rows) { Model.BACKCOMMODITYModel backcommodityModel = new Model.BACKCOMMODITYModel(); backcommodityModel.BACKCOMMODITY_ID = drBACKCOMMODITY["BACKCOMMODITY_ID"].TryParseToInt(); //内码 backcommodityModel.SERVERPARTSTOCK_ID = drBACKCOMMODITY["SERVERPARTSTOCK_ID"].TryParseToInt(); //退货流水 backcommodityModel.SALESTOREPROINST_ID = drBACKCOMMODITY["SALESTOREPROINST_ID"].TryParseToInt(); //项目流程内码 backcommodityModel.COMMODITY_NAME = drBACKCOMMODITY["COMMODITY_NAME"].ToString(); //退货商品名称 backcommodityModel.COMMODITY_CODE = drBACKCOMMODITY["COMMODITY_CODE"].ToString(); //退货商品编码 backcommodityModel.COMMODITY_BARCODE = drBACKCOMMODITY["COMMODITY_BARCODE"].ToString(); //退货商品条码 backcommodityModel.BACK_COUNT = drBACKCOMMODITY["BACK_COUNT"].TryParseToDouble(); //退货商品数量 backcommodityModel.COMMODITY_ID = drBACKCOMMODITY["COMMODITY_ID"].TryParseToInt(); //商品内码 backcommodityModel.BACK_DATE = drBACKCOMMODITY["BACK_DATE"].TryParseToDateTime(); //退货请求时间 backcommodityModel.SUPPLIER_ID = drBACKCOMMODITY["SUPPLIER_ID"].TryParseToInt(); //供应商内码 backcommodityModel.PURCHASE_TAXPRICE = drBACKCOMMODITY["PURCHASE_TAXPRICE"].TryParseToDouble(); //含税进价 backcommodityModel.PURCHASE_PRICE = drBACKCOMMODITY["PURCHASE_PRICE"].TryParseToDouble(); //除税进价 backcommodityModel.BACKTAXPRICE = drBACKCOMMODITY["BACKTAXPRICE"].TryParseToDouble(); //含税金额 backcommodityModel.BACKPRICE = drBACKCOMMODITY["BACKPRICE"].TryParseToDouble(); //除税金额 backcommodityModel.BACK_DESC = drBACKCOMMODITY["BACK_DESC"].ToString(); //备注 backcommodityModel.BACK_SELLPRICE = drBACKCOMMODITY["BACK_SELLPRICE"].TryParseToDouble(); //除税售价金额 backcommodityModel.BACK_SELLTAXPRICE = drBACKCOMMODITY["BACK_SELLTAXPRICE"].TryParseToDouble(); //含税售价金额 backcommodityModel.SELLPRICE = drBACKCOMMODITY["SELLPRICE"].TryParseToDouble(); //除税售价 backcommodityModel.SELLTAXPRICE = drBACKCOMMODITY["SELLTAXPRICE"].TryParseToDouble(); //含税售价 backcommodityModel.SERVERPART_ID = drBACKCOMMODITY["SERVERPART_ID"].TryParseToInt(); //服务区内码 backcommodityModel.SERVERPART_NAME = drBACKCOMMODITY["SERVERPART_NAME"].ToString(); //服务区名称 backcommodityModel.SERVERPARTSHOP_ID = drBACKCOMMODITY["SERVERPARTSHOP_ID"].TryParseToInt(); //门店内码 backcommodityModel.SHOPNAME = drBACKCOMMODITY["SHOPNAME"].ToString(); //门店名称 backcommodityModel.SUPPLIER_NAME = drBACKCOMMODITY["SUPPLIER_NAME"].ToString(); //供应商名称 backcommodityModel.DUTY_PARAGRAPH = drBACKCOMMODITY["DUTY_PARAGRAPH"].TryParseToDouble(); //进价税率 backcommodityModel.RTCOMMODITY_ID = drBACKCOMMODITY["RTCOMMODITY_ID"].TryParseToInt(); //最小单位商品内码 backcommodityModel.RTCOMMODITY_NAME = drBACKCOMMODITY["RTCOMMODITY_NAME"].ToString(); //最小单位商品名称 backcommodityModel.RTCOMMODITY_BARCODE = drBACKCOMMODITY["RTCOMMODITY_BARCODE"].ToString(); //最小单位商品条码 backcommodityModel.RTCOMMODITY_RULE = drBACKCOMMODITY["RTCOMMODITY_RULE"].ToString(); //最小单位商品规格 backcommodityModel.RTBACK_COUNT = drBACKCOMMODITY["RTBACK_COUNT"].TryParseToDouble(); //最小单位商品退货数量 backcommodityModel.RTPURCHASE_TAXPRICE = drBACKCOMMODITY["RTPURCHASE_TAXPRICE"].TryParseToDouble(); //最小单位商品含税进价 backcommodityModel.RTPURCHASE_PRICE = drBACKCOMMODITY["RTPURCHASE_PRICE"].TryParseToDouble(); //最小单位商品除税进价 backcommodityModel.RTCOMMODITY_CODE = drBACKCOMMODITY["RTCOMMODITY_CODE"].ToString(); //最小单位商品编码 BACKCOMMODITYList.Add(backcommodityModel); } return BACKCOMMODITYList; } #endregion #region 获取退货表明细 public static Model.BACKCOMMODITYModel GetBACKCOMMODITYDetail(Transaction transaction, int BACKCOMMODITYId) { Model.BACKCOMMODITYModel backcommodityModel = new Model.BACKCOMMODITYModel(); Business.BACKCOMMODITY _BACKCOMMODITY = new Business.BACKCOMMODITY(transaction); _BACKCOMMODITY.BACKCOMMODITY_ID = BACKCOMMODITYId; if (_BACKCOMMODITY.Select()) { backcommodityModel.BACKCOMMODITY_ID = _BACKCOMMODITY.BACKCOMMODITY_ID; //内码 backcommodityModel.SERVERPARTSTOCK_ID = _BACKCOMMODITY.SERVERPARTSTOCK_ID; //退货流水 backcommodityModel.SALESTOREPROINST_ID = _BACKCOMMODITY.SALESTOREPROINST_ID; //项目流程内码 backcommodityModel.COMMODITY_NAME = _BACKCOMMODITY.COMMODITY_NAME; //退货商品名称 backcommodityModel.COMMODITY_CODE = _BACKCOMMODITY.COMMODITY_CODE; //退货商品编码 backcommodityModel.COMMODITY_BARCODE = _BACKCOMMODITY.COMMODITY_BARCODE; //退货商品条码 backcommodityModel.BACK_COUNT = _BACKCOMMODITY.BACK_COUNT; //退货商品数量 backcommodityModel.COMMODITY_ID = _BACKCOMMODITY.COMMODITY_ID; //商品内码 backcommodityModel.BACK_DATE = _BACKCOMMODITY.BACK_DATE; //退货请求时间 backcommodityModel.SUPPLIER_ID = _BACKCOMMODITY.SUPPLIER_ID; //供应商内码 backcommodityModel.PURCHASE_TAXPRICE = _BACKCOMMODITY.PURCHASE_TAXPRICE; //含税进价 backcommodityModel.PURCHASE_PRICE = _BACKCOMMODITY.PURCHASE_PRICE; //除税进价 backcommodityModel.BACKTAXPRICE = _BACKCOMMODITY.BACKTAXPRICE; //含税金额 backcommodityModel.BACKPRICE = _BACKCOMMODITY.BACKPRICE; //除税金额 backcommodityModel.BACK_DESC = _BACKCOMMODITY.BACK_DESC; //备注 backcommodityModel.BACK_SELLPRICE = _BACKCOMMODITY.BACK_SELLPRICE; //除税售价金额 backcommodityModel.BACK_SELLTAXPRICE = _BACKCOMMODITY.BACK_SELLTAXPRICE; //含税售价金额 backcommodityModel.SELLPRICE = _BACKCOMMODITY.SELLPRICE; //除税售价 backcommodityModel.SELLTAXPRICE = _BACKCOMMODITY.SELLTAXPRICE; //含税售价 backcommodityModel.SERVERPART_ID = _BACKCOMMODITY.SERVERPART_ID; //服务区内码 backcommodityModel.SERVERPART_NAME = _BACKCOMMODITY.SERVERPART_NAME; //服务区名称 backcommodityModel.SERVERPARTSHOP_ID = _BACKCOMMODITY.SERVERPARTSHOP_ID; //门店内码 backcommodityModel.SHOPNAME = _BACKCOMMODITY.SHOPNAME; //门店名称 backcommodityModel.SUPPLIER_NAME = _BACKCOMMODITY.SUPPLIER_NAME; //供应商名称 backcommodityModel.DUTY_PARAGRAPH = _BACKCOMMODITY.DUTY_PARAGRAPH; //进价税率 backcommodityModel.RTCOMMODITY_ID = _BACKCOMMODITY.RTCOMMODITY_ID; //RTCOMMODITY_ID backcommodityModel.RTCOMMODITY_NAME = _BACKCOMMODITY.RTCOMMODITY_NAME; //RTCOMMODITY_NAME backcommodityModel.RTCOMMODITY_BARCODE = _BACKCOMMODITY.RTCOMMODITY_BARCODE; //RTCOMMODITY_BARCODE backcommodityModel.RTCOMMODITY_RULE = _BACKCOMMODITY.RTCOMMODITY_RULE; //RTCOMMODITY_RULE backcommodityModel.RTBACK_COUNT = _BACKCOMMODITY.RTBACK_COUNT; //RTBACK_COUNT backcommodityModel.RTPURCHASE_TAXPRICE = _BACKCOMMODITY.RTPURCHASE_TAXPRICE; //RTPURCHASE_TAXPRICE backcommodityModel.RTPURCHASE_PRICE = _BACKCOMMODITY.RTPURCHASE_PRICE; //RTPURCHASE_PRICE backcommodityModel.RTCOMMODITY_CODE = _BACKCOMMODITY.RTCOMMODITY_CODE; //RTCOMMODITY_CODE } return backcommodityModel; } #endregion #region 同步退货表 /// /// 赋值退货表数据对象 /// /// 事务管理器 /// 退货表数据对象 public static bool SynchroBACKCOMMODITY(Transaction transaction, Model.BACKCOMMODITYModel backcommodityModel) { bool SynchroFlag = true; Business.BACKCOMMODITY _BACKCOMMODITY = new Business.BACKCOMMODITY(transaction); if (backcommodityModel.BACKCOMMODITY_ID != null) { _BACKCOMMODITY.BACKCOMMODITY_ID = backcommodityModel.BACKCOMMODITY_ID; if (_BACKCOMMODITY.Select()) { SynchroModelToObject(_BACKCOMMODITY, backcommodityModel); _BACKCOMMODITY.Update(); } else { SynchroFlag = false; } } else { SynchroModelToObject(_BACKCOMMODITY, backcommodityModel); _BACKCOMMODITY.Insert(); } return SynchroFlag; } #region 赋值退货表数据对象 /// /// 赋值退货表数据对象 /// /// /// public static void SynchroModelToObject(Business.BACKCOMMODITY _BACKCOMMODITY, Model.BACKCOMMODITYModel backcommodityModel) { _BACKCOMMODITY.SERVERPARTSTOCK_ID = backcommodityModel.SERVERPARTSTOCK_ID; //退货流水 _BACKCOMMODITY.SALESTOREPROINST_ID = backcommodityModel.SALESTOREPROINST_ID; //项目流程内码 _BACKCOMMODITY.COMMODITY_NAME = backcommodityModel.COMMODITY_NAME; //退货商品名称 _BACKCOMMODITY.COMMODITY_CODE = backcommodityModel.COMMODITY_CODE; //退货商品编码 _BACKCOMMODITY.COMMODITY_BARCODE = backcommodityModel.COMMODITY_BARCODE; //退货商品条码 _BACKCOMMODITY.BACK_COUNT = backcommodityModel.BACK_COUNT; //退货商品数量 _BACKCOMMODITY.COMMODITY_ID = backcommodityModel.COMMODITY_ID; //商品内码 _BACKCOMMODITY.BACK_DATE = backcommodityModel.BACK_DATE; //退货请求时间 _BACKCOMMODITY.SUPPLIER_ID = backcommodityModel.SUPPLIER_ID; //供应商内码 _BACKCOMMODITY.PURCHASE_TAXPRICE = backcommodityModel.PURCHASE_TAXPRICE; //含税进价 _BACKCOMMODITY.PURCHASE_PRICE = backcommodityModel.PURCHASE_PRICE; //除税进价 _BACKCOMMODITY.BACKTAXPRICE = backcommodityModel.BACKTAXPRICE; //含税金额 _BACKCOMMODITY.BACKPRICE = backcommodityModel.BACKPRICE; //除税金额 _BACKCOMMODITY.BACK_DESC = backcommodityModel.BACK_DESC; //备注 _BACKCOMMODITY.BACK_SELLPRICE = backcommodityModel.BACK_SELLPRICE; //除税售价金额 _BACKCOMMODITY.BACK_SELLTAXPRICE = backcommodityModel.BACK_SELLTAXPRICE; //含税售价金额 _BACKCOMMODITY.SELLPRICE = backcommodityModel.SELLPRICE; //除税售价 _BACKCOMMODITY.SELLTAXPRICE = backcommodityModel.SELLTAXPRICE; //含税售价 _BACKCOMMODITY.SERVERPART_ID = backcommodityModel.SERVERPART_ID; //服务区内码 _BACKCOMMODITY.SERVERPART_NAME = backcommodityModel.SERVERPART_NAME; //服务区名称 _BACKCOMMODITY.SERVERPARTSHOP_ID = backcommodityModel.SERVERPARTSHOP_ID; //门店内码 _BACKCOMMODITY.SHOPNAME = backcommodityModel.SHOPNAME; //门店名称 _BACKCOMMODITY.SUPPLIER_NAME = backcommodityModel.SUPPLIER_NAME; //供应商名称 _BACKCOMMODITY.DUTY_PARAGRAPH = backcommodityModel.DUTY_PARAGRAPH; //进价税率 _BACKCOMMODITY.RTCOMMODITY_ID = backcommodityModel.RTCOMMODITY_ID; //RTCOMMODITY_ID _BACKCOMMODITY.RTCOMMODITY_NAME = backcommodityModel.RTCOMMODITY_NAME; //RTCOMMODITY_NAME _BACKCOMMODITY.RTCOMMODITY_BARCODE = backcommodityModel.RTCOMMODITY_BARCODE; //RTCOMMODITY_BARCODE _BACKCOMMODITY.RTCOMMODITY_RULE = backcommodityModel.RTCOMMODITY_RULE; //RTCOMMODITY_RULE _BACKCOMMODITY.RTBACK_COUNT = backcommodityModel.RTBACK_COUNT; //RTBACK_COUNT _BACKCOMMODITY.RTPURCHASE_TAXPRICE = backcommodityModel.RTPURCHASE_TAXPRICE; //RTPURCHASE_TAXPRICE _BACKCOMMODITY.RTPURCHASE_PRICE = backcommodityModel.RTPURCHASE_PRICE; //RTPURCHASE_PRICE _BACKCOMMODITY.RTCOMMODITY_CODE = backcommodityModel.RTCOMMODITY_CODE; //RTCOMMODITY_CODE } #endregion #endregion #region 删除退货表 public static bool DeleteBACKCOMMODITY(Transaction transaction, int? BACKCOMMODITYId) { bool DeleteFlag = false; if (BACKCOMMODITYId != null) { Business.BACKCOMMODITY _BACKCOMMODITY = new Business.BACKCOMMODITY(transaction); _BACKCOMMODITY.BACKCOMMODITY_ID = BACKCOMMODITYId; if (_BACKCOMMODITY.Select()) { _BACKCOMMODITY.Delete(); DeleteFlag = true; } } return DeleteFlag; } #endregion } }