using System; using System.Collections.Generic; using System.Linq; using System.Text; using WMS.Model.Stock; using WMS.IData; using WMS.Common; using System.Data; using WMS.Model.Base; using WMS.Model.RK; namespace WMS.Business.Stock { public class BussProvideRep : IBussFactory { #region 获得验收流水号 /// /// 获得验收流水号 /// /// public string GetNextValNum() { return DataProvider.Instance.ProvideRep.GetNextValNum(); } #endregion #region 查主表 /// /// 获得供应商补货主表List集合 /// /// 供应商补货Model /// public List GetProvideRepData(ProvideRepModel model) { DataTable dt = DataProvider.Instance.ProvideRep.GetProvideRepData(model); if (dt != null) { List list = list = ConvertHelper.ConvertToList(dt); return list; } return null; } #endregion #region 查明细表 /// /// 查询供应商补货明细表信息 /// /// 供应商补货编号ID /// public List GetProvideRepInfoData(string proID) { DataTable dt = DataProvider.Instance.ProvideRep.GetProvideRepInfoData(proID); if (dt != null) { List list = ConvertHelper.ConvertToList(dt); return list; } return null; } #endregion /// /// 同时新增供应商补货主表明细表数据 /// /// 供应商补货Model /// 供应商补货明细Model集合 /// public string InsertProvideRepData(ProvideRepModel model, List list ) { DataProvider.Instance.ProvideRep.InsertProvideRepData(model, list); TaCmtOrRak(); return this.ErrText; } /// /// 同时更新 供应商补货主表 明细表数据 /// /// 主表Model /// 明细表List /// public string UpdateProvideRepData(ProvideRepModel model, List lsit) { DataProvider.Instance.ProvideRep.UpdateProvideRepData(model, lsit); Transaction = DataProvider.Instance.TranOracle; logList.Add(DataProvider.Instance.logData); if (model.PROREP_STATUS == "1") { #region 入库单生成 //新增调拨入库通知单 // WareNoticeModel wareNoticeModel = new WareNoticeModel(); // List listWareNoticeTab = new List(); // int flag = 0; // //string strwareNoticeID = DataProvider.Instance.WareNotice.InsertOrUpdateWareNotice(wareNoticeModel, flag); // //新增调拨入库单主表 // //wareNoticeModel.WAREHOUSING_ID = strwareNoticeID; // wareNoticeModel.PURCHASE_ID = ""; // wareNoticeModel.ORDER_DATE = DateTime.Now; // wareNoticeModel.PROVIDER_ID = model.PRO_ID; // wareNoticeModel.PURCHASE_COUNT = model.TOTAL_NUM; // wareNoticeModel.AMOUNT = 0; // wareNoticeModel.TOTAL_VOLUME = 0; // wareNoticeModel.TOTAL_ROUGH_WEIGHT = 0; // wareNoticeModel.TOTAL_NET_WEIGH = 0; // wareNoticeModel.TOTAL_MONEY = 0; // wareNoticeModel.WARE_COUNT = 0; // wareNoticeModel.SHELVES_COUNT = 0; // wareNoticeModel.WAYBILL_ID = ""; // wareNoticeModel.SHIPPERS = ""; // wareNoticeModel.CARNO = ""; // wareNoticeModel.DRIVER = ""; // wareNoticeModel.CONFIRM_PERSON = ""; // wareNoticeModel.CONFIRM_DATE = DateTime.MinValue; // wareNoticeModel.EXPECTED_DELIVERY_DATE = model.EXPECT_DATE; // //终止日期在原预计到货延后2天 // wareNoticeModel.END_DELIVERY_DATE = model.EXPECT_DATE.AddDays(1); // wareNoticeModel.REAL_DELIVERY_DATE = model.EXPECT_DATE; // wareNoticeModel.RECIPIENTS = ""; // wareNoticeModel.CLASS_GROUP = ""; // wareNoticeModel.WARE_DATE = model.EXPECT_DATE; // wareNoticeModel.SHELVES_DATE = model.EXPECT_DATE; // wareNoticeModel.RECORD_PERSON = model.CONFIRM_MAN; // //parameters[24].Value = model.RECORD_DATE; // wareNoticeModel.CLOSE_PERSON = ""; // wareNoticeModel.CLOSE_DATE = DateTime.MinValue; // wareNoticeModel.CLOSE_REASON = ""; // wareNoticeModel.ORDER_MODE = "0"; // wareNoticeModel.STORAGE_MODE = "0"; // //已到货 // wareNoticeModel.STATE = "0"; // wareNoticeModel.TRAY_STATE = "0"; // wareNoticeModel.DISPATCHING_STATE = "0"; // wareNoticeModel.REMARK = model.REMARK; // wareNoticeModel.PALLET_COUNT = 0; // wareNoticeModel.PURCHASE_COUNT = model.TOTAL_NUM; // wareNoticeModel.ACCE_NUM = model.TOTAL_NUM; // wareNoticeModel.PASS_NUM = model.TOTAL_NUM; // // DataProvider.Instance.WareNotice.InsertOrUpdateWareNotice(wareNoticeModel, flag); // //新增入库调拨单明细表 // string strwareNoticeID = DataProvider.Instance.WareNotice.InsertOrUpdateWareNotice(wareNoticeModel, flag); // foreach (ProvideRepInfoModel item in lsit) // { // WareNoticeTabModel wareNoticeTabModel = new WareNoticeTabModel(); // wareNoticeTabModel.WAREHOUSING_ID = strwareNoticeID; // wareNoticeTabModel.PURCHASE_ID = ""; // wareNoticeTabModel.GOODS_ID = item.GOODS_ID; // //通过商品编号 查出商品信息 体积 毛重 等 // List goodsinfo = ConvertHelper.ConvertToList(DataProvider.Instance.Goods.GetGoodsDataTable(item.GOODS_ID, "", "", "")); // wareNoticeTabModel.AMOUNT = item.GOODS_COUNT; // if (goodsinfo.Count != 0) // { // wareNoticeTabModel.TOTAL_VOLUME = goodsinfo[0].GVOLUME; // wareNoticeTabModel.TOTAL_ROUGH_WEIGHT = goodsinfo[0].GROSS_WEIGHT; // wareNoticeTabModel.TOTAL_NET_WEIGH = goodsinfo[0].NET_WEIGHT; // } // wareNoticeTabModel.TOTAL_MONEY = item.SUMPRICE; // wareNoticeTabModel.PRODUCTION_DATE = DateTime.MinValue; // wareNoticeTabModel.STORAGE_ID = model.STORAGE_ID; // wareNoticeTabModel.STORAGE_AREA_ID = ""; // wareNoticeTabModel.PACKAGE_ID = ""; // wareNoticeTabModel.REMARK = item.REMARK; // wareNoticeTabModel.OPERATORID = ""; // wareNoticeTabModel.UNIT = item.UNIT; // wareNoticeTabModel.PRICE = item.PRICE; // wareNoticeTabModel.SCALE_UNIT = item.SCALE_UNIT; // wareNoticeTabModel.GVOLUME = 0; // wareNoticeTabModel.GOODS_TYPE_ID = ""; // wareNoticeTabModel.PROVIDER_ID = ""; // DataProvider.Instance.WareNoticeTab.InsertOrUpdateWareNoticeTab(wareNoticeTabModel, 0); // logList.Add(DataProvider.Instance.logData); // } //logList.Add(DataProvider.Instance.logData); #endregion } TaCmtOrRak(); return this.ErrText; } /// /// 同时删除主表明细表数据 /// /// /// public string DeleteProvideRepData(List strlist) { //删主表 DataProvider.Instance.ProvideRep.DeleteProvideRepData(strlist); Transaction = DataProvider.Instance.TranOracle; logList.Add(DataProvider.Instance.logData); TaCmtOrRak(); return this.ErrText; } /// /// 单独增主表数据 /// /// /// public string Add(List list) { DataProvider.Instance.ProvideRep.Add(list); Transaction = DataProvider.Instance.TranOracle; logList.Add(DataProvider.Instance.logData); TaCmtOrRak(); return this.ErrText; } /// /// 单独删除明细数据 /// /// /// public string Delete(List list) { DataProvider.Instance.ProvideRep.Delete(list); Transaction = DataProvider.Instance.TranOracle; logList.Add(DataProvider.Instance.logData); TaCmtOrRak(); return this.ErrText; } /// /// 单独更新供应商补货明细 /// /// /// /// /// public string NewProvideRepInfoFuc(ProvideRepModel prM, List upFuc, List insertFuc, List delFuc) { DataProvider.Instance.ProvideRep.NewProvideRepInfoFuc(prM, upFuc, insertFuc, delFuc); Transaction = DataProvider.Instance.TranOracle; logList.Add(DataProvider.Instance.logData); //修改规格明细 TaCmtOrRak(); return this.ErrText; } #region 同时删除主表和明细表数据 /// /// 同时删除供应商补货主表和明细表数据 /// /// ID集合 /// public string DeleteProvideRepByID(List strlist) { //删主表 DataProvider.Instance.ProvideRep.DeleteProvideRep(strlist); Transaction = DataProvider.Instance.TranOracle; logList.Add(DataProvider.Instance.logData); //删明细 DataProvider.Instance.ProvideRep.DeleteProvideRepInfo(strlist); Transaction = DataProvider.Instance.TranOracle; logList.Add(DataProvider.Instance.logData); TaCmtOrRak(); return this.ErrText; } #endregion #region 改主表 /// /// 更新主表单据一条数据 /// /// 更新主表一条数据 /// public string UpdateProvideRep(ProvideRepModel model) { DataProvider.Instance.ProvideRep.UpdateProvideRep(model); Transaction = DataProvider.Instance.TranOracle; logList.Add(DataProvider.Instance.logData); TaCmtOrRak(); return this.ErrText; } #endregion #region 改明细 /// /// 更新供应商补货明细表多条数据 /// /// 供应商补货明细Model集合 /// public string UpdateProvideRepInfo(List list) { DataProvider.Instance.ProvideRep.UpdateProvideRepInfo(list); Transaction = DataProvider.Instance.TranOracle; logList.Add(DataProvider.Instance.logData); TaCmtOrRak(); return this.ErrText; } #endregion #region 增主表 /// /// 供应商补货主表增一条数据 /// /// 供应商补货Model /// public string InsertProvideRep(ProvideRepModel model) { DataProvider.Instance.ProvideRep.InsertProvideRep(model); Transaction = DataProvider.Instance.TranOracle; logList.Add(DataProvider.Instance.logData); TaCmtOrRak(); return this.ErrText; } #endregion #region 增明细表 /// /// 供应商补货明细表增多条数据 /// /// 供应商补货明细Model集合 /// public string InsertStorageInfoRep(List list) { DataProvider.Instance.ProvideRep.InsertProvideRepInfo(list); Transaction = DataProvider.Instance.TranOracle; logList.Add(DataProvider.Instance.logData); TaCmtOrRak(); return this.ErrText; } #endregion /// /// 打印完成 /// /// 移位单 /// 是否成功 public string PrintOK(ProvideRepModel model) { //修改捡货单打印次数 model.PRINT_COUNT += 1; DataProvider.Instance.ProvideRep.UpdateProvideRep(model); Transaction = DataProvider.Instance.TranOracle; logList.Add(DataProvider.Instance.logData); TaCmtOrRak(); return ErrText; } #region 已废 删主表 public string DeleteProvideRep(List model) { DataProvider.Instance.ProvideRep.DeleteProvideRep(model); Transaction = DataProvider.Instance.TranOracle; logList.Add(DataProvider.Instance.logData); TaCmtOrRak(); return this.ErrText; } #endregion #region 已废 删明细 //删明细 public string DeleteProvideRepInfo(List model) { DataProvider.Instance.ProvideRep.DeleteProvideRepInfo(model); Transaction = DataProvider.Instance.TranOracle; logList.Add(DataProvider.Instance.logData); TaCmtOrRak(); return this.ErrText; } #endregion } }