public void CancelTask(string billNo) { using (PersistentManager pm = new PersistentManager()) { TaskDao taskDao = new TaskDao(); BillDao billDao = new BillDao(); CellDao cellDao = new CellDao(); try { pm.BeginTransaction(); int count = taskDao.FindExecutingTask(billNo); if (count != 0) throw new Exception("����δִ�л�ִ���е���ҵ��"); if (cellDao.Update(billNo) > 0) { taskDao.Backup(billNo); taskDao.Delete(billNo); billDao.UpdateMasterState(billNo, "6");//����Ϊȡ�� } else throw new Exception("�õ���ȫ����ҵ�����"); pm.Commit(); } catch (Exception e) { pm.Rollback(); throw new Exception(e.Message); } } }
public void DeleteFormula(string formulaCode) { using (PersistentManager pm = new PersistentManager()) { FormulaDao formulaDao = new FormulaDao(); ScheduleDao scheduleDao = new ScheduleDao(); try { pm.BeginTransaction(); if (scheduleDao.Find(formulaCode) == 0) { formulaDao.DeleteDetail(formulaCode); formulaDao.DeleteMaster(formulaCode); } else throw new Exception("��ǰ�䷽�����������ƻ��Ѱ�"); pm.Commit(); } catch (Exception e) { pm.Rollback(); throw new Exception(e.Message); } } }
/// <summary> /// ������������������� /// </summary> /// <param name="startDate"></param> /// <param name="endDate"></param> /// <returns></returns> public bool GetInBill(string startDate, string endDate, string EmployeeCode,string wareCode,string billtype, out string errorInfo) { bool tag = false; Employee = EmployeeCode; errorInfo = string.Empty; using (PersistentManager pm = new PersistentManager()) { DownInBillDao dao = new DownInBillDao(); DataTable emply = dao.FindEmployee(EmployeeCode); DataTable inMasterBillNo = this.GetInBillNo(); string billnolist = UtinString.StringMake(inMasterBillNo, "bill_no"); billnolist = UtinString.StringMake(billnolist); billnolist = string.Format("ORDER_DATE >='{0}' AND ORDER_DATE <='{1}' AND ORDER_ID NOT IN({2})", startDate, endDate, billnolist); DataTable masterdt = this.InBillMaster(billnolist); string inDetailList = UtinString.StringMake(masterdt, "ORDER_ID"); inDetailList = UtinString.StringMake(inDetailList); inDetailList = "ORDER_ID IN(" + inDetailList + ")"; DataTable detaildt = this.InBillDetail(inDetailList); if (masterdt.Rows.Count > 0 && detaildt.Rows.Count > 0) { DataSet masterds = this.InBillMaster(masterdt, emply.Rows[0]["employee_id"].ToString(), wareCode, billtype); DataSet detailds = this.InBillDetail(detaildt); this.Insert(masterds, detailds); tag = true; } else errorInfo = "û���µ���ⵥ���أ�"; } return tag; }
public void AddBill(DataRow masterRow, string userID, DataTable detailTable) { using (PersistentManager pm = new PersistentManager()) { try { pm.BeginTransaction(); string billNo = palletDao.FindNewBillNo(masterRow["BILLDATE"].ToString()); masterRow["BILLNO"] = billNo; //���뵥������ palletDao.InsertMaster(masterRow, userID); //���뵥����ϸ�� palletDao.InsertDetail(billNo, detailTable); pm.Commit(); } catch (Exception e) { pm.Rollback(); throw new Exception(e.Message); } } }
//选择时间下载分拣数据 public bool GetSortingOrderDate(string startDate, string endDate,string sortingLine,string batch, out string errorInfo) { bool tag = false; errorInfo = string.Empty; using (PersistentManager dbpm = new PersistentManager()) { DownSortingInfoDao dao = new DownSortingInfoDao(); try { string sort = string.Empty; if (sortingLine != string.Empty || sortingLine != null) { sort = " AND SORTINGLINECODE='" + sortingLine + "' AND BATCHID='" + batch + "'"; } //查询仓库7天内的订单号 DataTable orderdt = this.GetOrderId(startDate, endDate); string orderlist = UtinString.MakeString(orderdt, "order_id"); string orderlistDate = "ORDERDATE >='" + startDate + "' AND ORDERDATE <='" + endDate + "'" + sort; DataTable masterdt = this.GetSortingOrder(orderlistDate); DataRow[] masterdr = masterdt.Select("ORDERID NOT IN(" + orderlist + ")"); string ordermasterlist = UtinString.MakeString(masterdr, "OrderID"); ordermasterlist = "OrderID IN (" + ordermasterlist + ")"; DataTable detaildt = this.GetSortingOrderDetail(ordermasterlist); if (masterdr.Count() > 0 && detaildt.Rows.Count > 0) { DataSet masterds = this.SaveSortingOrder(masterdr); DataSet detailds = this.SaveSortingOrderDetail(detaildt); this.Insert(masterds, detailds); //上报分拣订单 //upload.uploadSort(masterds, detailds); if (sort != string.Empty) { try { DataTable diapLine = this.GetDispatchLine(ordermasterlist); DataSet dispDs = this.SaveDispatch(diapLine, sortingLine); this.Insert(dispDs); tag = true; } catch (Exception e) { errorInfo = "调度出错,请手动进行线路调度,出错原因:" + e.Message; } } else errorInfo = "没有选择分拣线!下载完成后,请手动进行线路调度!"; //tag = true; } else errorInfo = "没有可用的数据下载!"; } catch (Exception e) { errorInfo = "下载错误:" + e.Message; } } return tag; }
internal void SaveCigarette(string cigaretteCode, string classSymbol,string cigaretteName) { using (PersistentManager pm = new PersistentManager()) { cigaretteDao.Update(cigaretteCode,classSymbol, cigaretteName); } }
public void AddBill3(DataRow masterRow, DataTable detailTable) { using (PersistentManager pm = new PersistentManager()) { try { BillDao billDao = new BillDao(); ProductStateDao stateDao = new ProductStateDao(); pm.BeginTransaction(); string billNo = billDao.FindNewBillNo("P", masterRow["BILLDATE"].ToString()); masterRow["BILLNO"] = billNo; //���뵥������ billDao.InsertMaster(masterRow); stateDao.Insert(billNo, detailTable); pm.Commit(); } catch (Exception e) { pm.Rollback(); throw new Exception(e.Message); } } }
public DataTable GetAll() { using (PersistentManager pm = new PersistentManager()) { return cigaretteDao.Find(); } }
internal void DeleteCigarette(string cigaretteCode) { using (PersistentManager pm = new PersistentManager()) { cigaretteDao.Delete(cigaretteCode); } }
public void AddCigarette(string cigaretteCode,string classSymbol, string cigaretteName) { using (PersistentManager pm = new PersistentManager()) { cigaretteDao.Insert(cigaretteCode,classSymbol, cigaretteName); } }
public DataTable GetDetail(string billNo) { using (PersistentManager pm = new PersistentManager()) { return palletDao.FindDetail(billNo); } }
public DataTable GetMaster(string billType) { using (PersistentManager pm = new PersistentManager()) { return palletDao.FindMaster(billType); } }
public int AddMix(string billNo, DataRow newRow) { int result = 1; using (PersistentManager pm = new PersistentManager()) { ProductStateDao psDao = new ProductStateDao(); try { pm.BeginTransaction(); result = psDao.UpdateMix(billNo, newRow["MIXID"].ToString(), Convert.ToDouble(newRow["QUANTITY"])); if (result != 1) throw new Exception("����������Ϊ1"); result = psDao.UpdateMixID(billNo, newRow["PRODUCTCODE"].ToString(), newRow["ITEMNO"].ToString(), newRow["MIXID"].ToString()); if (result != 1) throw new Exception("����������Ϊ1"); pm.Commit(); } catch { pm.Rollback(); } } return result; }
public void CancelTaskIn(string billNo) { using (PersistentManager pm = new PersistentManager()) { TaskDao taskDao = new TaskDao(); BillDao billDao = new BillDao(); CellDao cellDao = new CellDao(); ScheduleDao scheduleDao = new ScheduleDao(); ProductStateDao productStateDao = new ProductStateDao(); try { pm.BeginTransaction(); int count = taskDao.FindExecutingTask(billNo); if (count != 0) throw new Exception("����δִ�л�ִ���е���ҵ��"); taskDao.Backup(billNo); taskDao.Delete(billNo); billDao.UpdateMasterState(billNo, "6");//����Ϊȡ�� productStateDao.Delete(billNo); //�������ⵥ���̰����������������ƻ�ISOUTΪ����� scheduleDao.UpdateIsIn(billNo); pm.Commit(); } catch (Exception e) { pm.Rollback(); throw new Exception(e.Message); } } }
/// <summary> /// ɾ��7��֮ǰ����·����ּ��м��ͷּ��(����ϸ��)����ҵ���ȱ� /// </summary> public void DeleteTable() { using (PersistentManager dbPm = new PersistentManager()) { DownRouteDao dao = new DownRouteDao(); dao.DeleteTable(); } }
/// <summary> /// 返回堆垛机错误列表 /// </summary> /// <returns></returns> public DataTable GetErrMessageList() { using (PersistentManager pm = new PersistentManager()) { CraneErrMessageDao dao = new CraneErrMessageDao(); return dao.GetErrMessageList(); } }
public DataTable GetDistStationCode() { using (PersistentManager dbPm = new PersistentManager()) { DownDistCarBillDao dao = new DownDistCarBillDao(); return dao.GetDistStationCode(); } }
public DataTable GetArea() { using (PersistentManager pm = new PersistentManager()) { AreaDao areaDao = new AreaDao(); return areaDao.Find(); } }
public void SaveShelf(DataRow row) { using (PersistentManager pm = new PersistentManager()) { ShelfDao shelfDao = new ShelfDao(); shelfDao.Update(row); } }
public void AddArea(DataRow row) { using (PersistentManager pm = new PersistentManager()) { AreaDao areaDao = new AreaDao(); areaDao.Insert(row); } }
public void Save(string cigaretteCode, string cigaretteName,string isAbnormity, string barcode) { using (PersistentManager pm = new PersistentManager()) { CigaretteDao cigaretteDao = new CigaretteDao(); cigaretteDao.UpdateEntity(cigaretteCode,cigaretteName,isAbnormity, barcode); } }
public DataTable GetShelf() { using (PersistentManager pm = new PersistentManager()) { ShelfDao shelfDao = new ShelfDao(); return shelfDao.Find(); } }
/// <summary> /// ��ѯ4��֮�ڵķּ� /// </summary> /// <returns></returns> public DataTable GetOrderId(string orderDate) { using (PersistentManager dbpm = new PersistentManager()) { DownSortingOrderDao dao = new DownSortingOrderDao(); return dao.GetOrderId(orderDate); } }
public DataSet GetGroupList(int pageIndex, int pageSize, string filter, string OrderByFields) { using (THOK.Util.PersistentManager pm = new THOK.Util.PersistentManager()) { SysGroupDao GroupDao = new SysGroupDao(); return(GroupDao.QueryGroup(strTableView, strPrimaryKey, strQueryFields, pageIndex, pageSize, OrderByFields, filter, strTableView)); } }
/// <summary> /// ��ȡ����Ļ���� /// </summary> /// <param name="TaskNO"></param> /// <param name="BillNo"></param> /// <returns></returns> public string GetChannelFromTask(string TaskNO, string BillNo) { using (PersistentManager pm = new PersistentManager()) { ChannelDao dao = new ChannelDao(); return dao.GetChannelFromTask(TaskNO, BillNo); } }
/// <summary> /// ��ȡ��λϵͳ���ֶ� /// </summary> /// <returns></returns> public DataTable GetUnitProduct() { using (PersistentManager pm = new PersistentManager()) { DownUnitDao dao = new DownUnitDao(); return dao.GetUnitProduct(); } }
/// <summary> /// ���ݾ��̲�ѯ��λ��Ϣ /// </summary> /// <param name="productCode"></param> /// <returns></returns> public DataTable FindProductCodeInfo(string productCode) { using (PersistentManager dbPm = new PersistentManager()) { DownProductDao dao = new DownProductDao(); return dao.FindProductCodeInfo(productCode); } }
public DataTable GetFormatParameter() { using (PersistentManager pm = new PersistentManager()) { SysSystemParameterDao parameterDao = new SysSystemParameterDao(); return parameterDao.FindFormatParameter(); } }
/// <summary> /// 删除配车单 /// </summary> public void Delete() { using (PersistentManager dbPm = new PersistentManager()) { DownDistCarBillDao dao = new DownDistCarBillDao(); dao.Delete(); } }
public void SaveArea(DataRow row) { using (PersistentManager pm = new PersistentManager()) { AreaDao areaDao = new AreaDao(); areaDao.Update(row); } }
public void AddShelf(DataRow row) { using (PersistentManager pm = new PersistentManager()) { ShelfDao shelfDao = new ShelfDao(); shelfDao.Insert(row); } }
/// <summary> /// 备货烟道优化2010-07-08 /// </summary> /// <param name="orderDate"></param> /// <param name="batchNo"></param> public void GenStockChannelSchedule(string orderDate, int batchNo) { using (THOK.Util.PersistentManager pm = new THOK.Util.PersistentManager()) { StockChannelDao schannelDao = new StockChannelDao(); OrderDao orderDao = new OrderDao(); OrderDao detailDao = new OrderDao(); SysParameterDao parameterDao = new SysParameterDao(); Dictionary <string, string> parameter = parameterDao.FindParameters(); LineInfoDao lineDao1 = new LineInfoDao(); DataTable lineTable1 = lineDao1.GetAvailabeLine("3").Tables[0]; bool isUseWholePiecesSortLine = lineTable1.Rows.Count > 0; //每天分拣结束后备货烟道是否为空 if (parameter["ClearStockChannel"] == "1") { schannelDao.ClearCigarette(); } //查询补货烟道表 DataTable channelTable = schannelDao.FindChannel(); //查询通道机卷烟数量信息表 DataTable orderCTable = orderDao.FindCigaretteQuantityFromChannelUsed(orderDate, batchNo, "3"); //查询立式机卷烟数量信息表(应加上混合烟道问题) DataTable orderTTable = orderDao.FindCigaretteQuantityFromChannelUsed(orderDate, batchNo, "2"); //取所有订单品牌及总数量 DataTable orderTable = detailDao.FindAllCigaretteQuantity(orderDate, batchNo, isUseWholePiecesSortLine).Tables[0]; StockOptimize stockOptimize = new StockOptimize(); bool isUseSynchronizeOptimize = Convert.ToBoolean(parameter["IsUseSynchronizeOptimize"]); DataTable mixTable = stockOptimize.Optimize(isUseSynchronizeOptimize, channelTable, isUseSynchronizeOptimize ? orderCTable : orderTable, isUseSynchronizeOptimize ? orderTTable : orderTable, orderDate, batchNo); schannelDao.InsertMixChannel(mixTable); //取整件打码线所有订单品牌及总数量 if (isUseWholePiecesSortLine) { orderTable = detailDao.FindAllCigaretteQuantityForWholePiecesSortLine(orderDate, batchNo).Tables[0]; mixTable = stockOptimize.Optimize(channelTable, orderTable, orderDate, batchNo); schannelDao.InsertMixChannel(mixTable); } schannelDao.InsertStockChannelUsed(orderDate, batchNo, channelTable); if (OnSchedule != null) { OnSchedule(this, new ScheduleEventArgs(6, "备货烟道优化", 1, 1)); } } }
/// <summary> /// 生产线优化 2008-12-11修改 /// </summary> /// <param name="orderDate"></param> /// <param name="batchNo"></param> public void GenLineSchedule(string orderDate, int batchNo) { using (THOK.Util.PersistentManager pm = new THOK.Util.PersistentManager()) { LineInfoDao lineDao = new LineInfoDao(); OrderDao detailDao = new OrderDao(); LineScheduleDao lineScDao = new LineScheduleDao(); THOK.Optimize.LineOptimize lineSchedule = new THOK.Optimize.LineOptimize(); DataTable routeTable = detailDao.FindRouteQuantity(orderDate, batchNo).Tables[0]; DataTable lineTable = lineDao.GetAvailabeLine("2").Tables[0]; DataTable scLineTable = new DataTable(); if (lineTable.Rows.Count > 0) { scLineTable = lineSchedule.Optimize(routeTable, lineTable, orderDate, batchNo); lineScDao.SaveLineSchedule(scLineTable); } else { throw new Exception("没有可用的分拣线!"); } routeTable = detailDao.FindRouteQuantity(orderDate, batchNo).Tables[0]; lineTable = lineDao.GetAvailabeLine("3").Tables[0]; if (lineTable.Rows.Count > 0) { scLineTable = lineSchedule.Optimize(routeTable, lineTable, orderDate, batchNo); lineScDao.SaveLineSchedule(scLineTable); } if (OnSchedule != null) { OnSchedule(this, new ScheduleEventArgs(2, "生产线优化", 1, 1)); } } }
/// <summary> /// 订单优化2010-07-07 /// </summary> /// <param name="orderDate"></param> /// <param name="batchNo"></param> public void GenOrderSchedule(string orderDate, int batchNo) { using (THOK.Util.PersistentManager pm = new THOK.Util.PersistentManager()) { OrderDao orderDao = new OrderDao(); ChannelDao channelDao = new ChannelDao(); OrderScheduleDao orderScheduleDao = new OrderScheduleDao(); SupplyDao supplyDao = new SupplyDao(); OrderOptimize orderSchedule = new OrderOptimize(); SysParameterDao parameterDao = new SysParameterDao(); Dictionary <string, string> parameter = parameterDao.FindParameters(); LineScheduleDao lineDao = new LineScheduleDao(); DataTable lineTable = lineDao.FindAllLine(orderDate, batchNo).Tables[0]; foreach (DataRow lineRow in lineTable.Rows) { string lineCode = lineRow["LINECODE"].ToString(); //查询订单主表 DataTable masterTable = orderDao.FindTmpMaster(orderDate, batchNo, lineCode); //查询订单明细表 DataTable orderTable = orderDao.FindTmpDetail(orderDate, batchNo, lineCode); //查询分拣烟道表 DataTable channelTable = channelDao.FindChannelSchedule(orderDate, batchNo, lineCode, Convert.ToInt32(parameter["RemainCount"])).Tables[0]; int sortNo = 1; int currentCount = 0; int totalCount = masterTable.Rows.Count; foreach (DataRow masterRow in masterTable.Rows) { DataRow[] orderRows = null; //查询当前订单明细 orderRows = orderTable.Select(string.Format("SORTNO = '{0}'", masterRow["SORTNO"]), "CHANNELGROUP, CHANNELCODE"); DataSet ds = orderSchedule.Optimize(masterRow, orderRows, channelTable, ref sortNo); orderScheduleDao.SaveOrder(ds); supplyDao.InsertSupply(ds.Tables["SUPPLY"], lineCode, orderDate, batchNo); if (OnSchedule != null) { OnSchedule(this, new ScheduleEventArgs(5, "正在优化" + lineRow["LINECODE"].ToString() + "分拣线订单", ++currentCount, totalCount)); } } channelDao.Update(channelTable); } LineInfoDao lineDao1 = new LineInfoDao(); DataTable lineTable1 = lineDao1.GetAvailabeLine("3").Tables[0]; foreach (DataRow lineRow in lineTable1.Rows) { string lineCode = lineRow["LINECODE"].ToString(); //查询烟道信息表 DataTable channelTable = channelDao.FindChannelSchedule(orderDate, batchNo, lineCode, Convert.ToInt32(parameter["RemainCount"])).Tables[0]; //查询订单主表 DataTable masterTable = orderDao.FindOrderMaster(orderDate, batchNo, lineCode).Tables[0]; //查询订单明细表 DataTable orderTable = orderDao.FindOrderDetail(orderDate, batchNo, lineCode).Tables[0]; int sortNo = 1; int currentCount = 0; int totalCount = masterTable.Rows.Count; foreach (DataRow masterRow in masterTable.Rows) { DataRow[] orderRows = null; //查询当前订单明细 orderRows = orderTable.Select(string.Format("ORDERID = '{0}'", masterRow["ORDERID"]), "CIGARETTECODE"); DataSet ds = orderSchedule.OptimizeUseWholePiecesSortLine(masterRow, orderRows, channelTable, ref sortNo); orderScheduleDao.SaveOrder(ds); if (OnSchedule != null) { OnSchedule(this, new ScheduleEventArgs(5, "正在优化" + lineRow["LINECODE"].ToString() + "分拣线订单", ++currentCount, totalCount)); } } channelDao.UpdateQuantity(channelTable, false); } } }
/// <summary> /// 订单拆分2010-07-05 /// </summary> /// <param name="orderDate"></param> /// <param name="batchNo"></param> public void GenSplitOrder(string orderDate, int batchNo) { using (THOK.Util.PersistentManager pm = new THOK.Util.PersistentManager()) { OrderDao orderDao = new OrderDao(); ChannelDao channelDao = new ChannelDao(); OrderScheduleDao orderScheduleDao = new OrderScheduleDao(); LineScheduleDao lineDao = new LineScheduleDao(); OrderSplitOptimize orderSchedule = new OrderSplitOptimize(); THOK.AS.Dao.SysParameterDao parameterDao = new SysParameterDao(); Dictionary <string, string> parameter = parameterDao.FindParameters(); //查询分拣线表 DataTable lineTable = lineDao.FindAllLine(orderDate, batchNo).Tables[0]; //清理临时表 orderScheduleDao.ClearSplitOrder(); LineInfoDao lineDao1 = new LineInfoDao(); DataTable lineTable1 = lineDao1.GetAvailabeLine("3").Tables[0]; bool isUseWholePiecesSortLine = lineTable1.Rows.Count > 0; foreach (DataRow lineRow in lineTable.Rows) { string lineCode = lineRow["LINECODE"].ToString(); //查询烟道信息表 DataTable channelTable = channelDao.FindChannelSchedule(orderDate, batchNo, lineCode, Convert.ToInt32(parameter["RemainCount"])).Tables[0]; //查询订单主表 DataTable masterTable = orderDao.FindOrderMaster(orderDate, batchNo, lineCode).Tables[0]; //查询订单明细表 DataTable orderTable = orderDao.FindOrderDetail(orderDate, batchNo, lineCode).Tables[0]; DataTable orderDetail = null; HashTableHandle hashTableHandle = new HashTableHandle(orderTable); int sortNo = 1; int currentCount = 0; int totalCount = masterTable.Rows.Count; orderSchedule.moveToMixChannelProducts.Clear(); orderSchedule.moveToMixTChannelProducts.Clear(); foreach (DataRow masterRow in masterTable.Rows) { DataRow[] orderRows = null; orderDetail = hashTableHandle.Select("ORDERID", masterRow["ORDERID"]); orderRows = orderDetail.Select(string.Format("ORDERID = '{0}'", masterRow["ORDERID"]), "QUANTITY"); DataSet ds = orderSchedule.Optimize(masterRow, orderRows, channelTable, lineCode, ref sortNo, parameter, isUseWholePiecesSortLine); orderScheduleDao.SaveSplitOrder(ds); if (OnSchedule != null) { OnSchedule(this, new ScheduleEventArgs(4, "正在优化" + lineRow["LINECODE"].ToString() + "分拣线订单", ++currentCount, totalCount)); } } channelDao.UpdateQuantity(channelTable, Convert.ToBoolean(parameter["IsUseBalance"])); } } }
/// <summary> /// 生产线烟道优化 /// </summary> /// <param name="orderDate"></param> /// <param name="batchNo"></param> public void GenChannelSchedule(string orderDate, int batchNo) { using (THOK.Util.PersistentManager pm = new THOK.Util.PersistentManager()) { ChannelDao channelDao = new ChannelDao(); OrderDao detailDao = new OrderDao(); LineDeviceDao deviceDao = new LineDeviceDao(); ChannelOptimize channelSchedule = new ChannelOptimize(); THOK.AS.Dao.SysParameterDao parameterDao = new SysParameterDao(); Dictionary <string, string> parameter = parameterDao.FindParameters(); LineScheduleDao lineDao = new LineScheduleDao(); DataTable lineTable = lineDao.FindAllLine(orderDate, batchNo).Tables[0]; LineInfoDao lineDao1 = new LineInfoDao(); DataTable lineTable1 = lineDao1.GetAvailabeLine("3").Tables[0]; bool isUseWholePiecesSortLine = lineTable1.Rows.Count > 0; int currentCount = 0; int totalCount = lineTable.Rows.Count; foreach (DataRow lineRow in lineTable.Rows) { string lineCode = lineRow["LINECODE"].ToString(); //查询分拣线烟道表 DataTable channelTable = channelDao.FindAvailableChannel(lineCode).Tables[0]; //查询分拣线设备参数表 DataTable deviceTable = deviceDao.FindLineDevice(lineCode).Tables[0]; //通道机两条分拣线品牌必须一致,立式机两条分拣线则不需要一致 //取所有订单品牌及总数量 DataTable orderTable = detailDao.FindAllCigaretteQuantity(orderDate, batchNo, isUseWholePiecesSortLine).Tables[0]; //取每条线订单品牌及总数量 DataTable lineOrderTable = detailDao.FindLineCigaretteQuantity(orderDate, batchNo, lineCode, isUseWholePiecesSortLine).Tables[0]; bool isUseSynchronizeOptimize = Convert.ToBoolean(parameter["IsUseSynchronizeOptimize"]); channelSchedule.Optimize(isUseSynchronizeOptimize ? orderTable : lineOrderTable, lineOrderTable, channelTable, deviceTable, parameter); channelDao.SaveChannelSchedule(channelTable, orderDate, batchNo); if (OnSchedule != null) { OnSchedule(this, new ScheduleEventArgs(3, "正在优化" + lineRow["LINECODE"].ToString() + "分拣线烟道", ++currentCount, totalCount)); } } currentCount = 0; totalCount = lineTable1.Rows.Count; foreach (DataRow lineRow in lineTable1.Rows) { string lineCode = lineRow["LINECODE"].ToString(); //查询分拣线烟道表 DataTable channelTable = channelDao.FindAvailableChannel(lineCode).Tables[0]; channelDao.SaveChannelSchedule(channelTable, orderDate, batchNo); if (OnSchedule != null) { OnSchedule(this, new ScheduleEventArgs(3, "正在优化" + lineRow["LINECODE"].ToString() + "分拣线烟道", ++currentCount, totalCount)); } } } }
public void SetPersistentManager(PersistentManager persistentManager) { this.persistentManager = persistentManager; this.fromPool = false; }