using System; using System.Collections.Generic; using System.Linq; using System.Text; using WMS.Model.RK; using System.Data; using WMS.IData; using WMS.Common; using WMS.Model.Base; namespace WMS.Business.RK { public class BussAcceptance : IBussFactory { #region 查 /// /// 查 收货验收 查询数据 /// /// 验收Model /// public List GetAcceptanceData(AcceptanceModel model) { DataTable dt = DataProvider.Instance.Acceptance.GetAcceptanceData(model); List list = null; if (DataLogErrWrite(dt, "获取收货验收数据")) { list = ConvertHelper.ConvertToList(dt); } else { return list; } return list; } #endregion /// /// 查询入库批次明细表 除去 验单表已存在的商品数据 /// /// /// public List GetStorageLotInfoDistanct(string lotid) { DataTable dt = DataProvider.Instance.Acceptance.GetStorageLotInfoDistanct(lotid); List list = null; if (DataLogErrWrite(dt, "获取收货验收数据")) { list = ConvertHelper.ConvertToList(dt); } else { return list; } return list; } #region 增 /// /// 增 收货验收 写入数据库 /// /// 验收Model集合 /// public string AddAcceptance(List list) { int i = 0; string acceptData= IBussFactory.Instance().GetDocumentStream("收货单"); foreach (AcceptanceModel model in list) { model.ACCE_ID = acceptData; model.ACC_STATUS = "1"; DataProvider.Instance.Acceptance.AddAcceptance(model); if (i == 0) { Transaction = DataProvider.Instance.TranOracle; } logList.Add(DataProvider.Instance.logData); i++; } TaCmtOrRak(); //MessageModel messModel = new MessageModel(); //messModel.ID = "YS" + DateTime.Now.ToString("yyyyMMddHHmmss") + DataProvider.Instance.Message.GetSerialNum(); //messModel.MENU_FORM = "FrmAcceptance"; //messModel.MESS_CONTENT = "新增验收单,单据编号:" + list[0].ACCE_ID; //messModel.MESS_DATE = DateTime.Now; //messModel.MESS_DEP = list[0].STORAGE_ID; //messModel.MESS_FLAG = "0"; //messModel.MESS_STAR = list[0].OPERATORID; //messModel.MESS_STATUS = "0"; //messModel.WORK_KIND = "0"; //messModel.RELATIVE_NUMBER = list[0].ACCE_ID; //messModel.WORK_TYPE = "worktype007"; //messModel.STO_ID = list[0].OPERATORID; //messModel.MESS_TYPE = "RK"; //DataProvider.Instance.Message.Add(messModel); //logList.Add(DataProvider.Instance.logData); // Transaction = DataProvider.Instance.TranOracle; // TaCmtOrRak(); return this.ErrText; } #endregion /// /// 更新收货验收 回写入库批次主表 明细表数据 /// /// /// /// /// public string UpdateAcceptanceStorageData(List list, List stolist, List infolist) { //DataProvider.Instance.Acceptance.UpdateAcceptanceStorageData(list, stolist, infolist); Transaction = DataProvider.Instance.TranOracle; logList.Add(DataProvider.Instance.logData); TaCmtOrRak(); return this.ErrText; } public string UpdateAcceptance(List listModel) { for(int i=0;i /// 改 收货验收 更新数据 /// /// 验收Model集合 /// // public string UpdateAcceptance(List list) //{ // DataProvider.Instance.Acceptance.UpdateAcceptance(list); // Transaction = DataProvider.Instance.TranOracle; // logList.Add(DataProvider.Instance.logData); // TaCmtOrRak(); // return this.ErrText; //} #endregion /// /// 回写入库批次 个别字段信息 /// /// 入库批次Model集合 /// public string UpdateStorage(List list) { //DataProvider.Instance.Acceptance.UpdateStorage(list); Transaction = DataProvider.Instance.TranOracle; logList.Add(DataProvider.Instance.logData); TaCmtOrRak(); return this.ErrText; } /// /// 回写入库批次、入库批次明细表 接收数量 /// /// /// /// public string UpdateStorageData(List list, List listinfo) { DataProvider.Instance.Acceptance.UpdateStorageData(list, listinfo); Transaction = DataProvider.Instance.TranOracle; logList.Add(DataProvider.Instance.logData); TaCmtOrRak(); return this.ErrText; } #region 删 /// /// 删 收货验收 删除数据 /// /// 验收Model集合 /// public string DeleteAcceptance(List model) { DataProvider.Instance.Acceptance.DeleteAcceptance(model); Transaction = DataProvider.Instance.TranOracle; logList.Add(DataProvider.Instance.logData); //strs 单据编号 foreach (AcceptanceModel strs in model) { string st = strs.ACCE_ID; DataProvider.Instance.Message.DeleteMessByRelativeNumber(st); logList.Add(DataProvider.Instance.logData); } TaCmtOrRak(); return this.ErrText; } #endregion #region 删除数据添加到备份表 /// /// 删除数据添加到备份表 /// /// 验收Model集合 /// public string InsertAcceptanceBack(List list) { //先备份 DataProvider.Instance.Acceptance.InsertAcceptanceBack(list); Transaction = DataProvider.Instance.TranOracle; logList.Add(DataProvider.Instance.logData); //在删除 DataProvider.Instance.Acceptance.DeleteAcceptance(list); Transaction = DataProvider.Instance.TranOracle; logList.Add(DataProvider.Instance.logData); TaCmtOrRak(); return this.ErrText; } #endregion /// /// 获得验收流水号 /// /// public string GetNextValNum() { return DataProvider.Instance.Acceptance.GetNextValNum(); } public List GetWriteBackData(AcceptanceModel model) { DataTable dt = DataProvider.Instance.Acceptance.GetWriteBackData(model); List list = null; if (DataLogErrWrite(dt, "获取入库批次验收数据")) { list = ConvertHelper.ConvertToList(dt); } else { return list; } return list; } } }