public void Save(string channelID, string cigaretteCode, string cigaretteName, string status) { using (PersistentManager pm = new PersistentManager()) { ChannelDao channelDao = new ChannelDao(); channelDao.UpdateEntity(channelID, cigaretteCode, cigaretteName,status); } }
public DataTable GetAll(int pageIndex, int pageSize, string filter) { DataTable table = null; using (PersistentManager pm = new PersistentManager()) { ChannelDao channelDao = new ChannelDao(); table = channelDao.FindAll((pageIndex - 1) * pageSize, pageSize, filter); } return table; }
public int GetCount(string filter) { int count = 0; using (PersistentManager pm = new PersistentManager()) { ChannelDao channelDao = new ChannelDao(); count = channelDao.FindCount(filter); } return count; }
/// <summary> /// 手工补货优化 /// </summary> /// <param name="orderDate"></param> /// <param name="batchNo"></param> public void GenHandleSupplySchedule(string orderDate, int batchNo) { using (PersistentManager pm = new PersistentManager()) { HandleSupplyOptimize handleSupplyOptimize = new THOK.Optimize.HandleSupplyOptimize(); ScOrderDao scOrderDao = new ScOrderDao(); ChannelDao channelDao = new ChannelDao(); Dao.LineScheduleDao lineDao = new LineScheduleDao(); DataTable lineTable = lineDao.FindAllLine(orderDate, batchNo).Tables[0]; int currentCount = 0; int totalCount = lineTable.Rows.Count; foreach (DataRow lineRow in lineTable.Rows) { string lineCode = lineRow["LINECODE"].ToString(); DataTable handSupplyOrders = scOrderDao.FindHandleSupplyOrder(orderDate, batchNo, lineCode); DataTable multiBrandChannel = channelDao.FindMultiBrandChannel(lineCode); AddColumnForChannelTable(multiBrandChannel, multiBrandChannel.Rows.Count); //返回新的手工补货订单表 DataTable newSupplyOrders = handleSupplyOptimize.Optimize(handSupplyOrders, multiBrandChannel); //保存烟道空仓作业的SortNo channelDao.Update(multiBrandChannel,orderDate, batchNo); //删除sc_order原来的手工补货定单 scOrderDao.DeleteOldSupplyOrders(orderDate, batchNo, lineCode); //在sc_order中插入新的手工补货定单 scOrderDao.InsertNewSupplyOrders(newSupplyOrders); //在AS_SC_HANDLESUPPLY中插入新的手工补货定单 scOrderDao.InsertHandSupplyOrders(newSupplyOrders); if (OnSchedule != null) OnSchedule(this, new ScheduleEventArgs(8, "正在优化" + lineRow["LINECODE"].ToString() + "分拣线手工补货定单订单", ++currentCount, totalCount)); } } }
/// <summary> /// 补货优化2010-04-19 /// </summary> /// <param name="orderDate"></param> /// <param name="batchNo"></param> public void GenSupplySchedule(string orderDate, int batchNo) { using (PersistentManager pm = new PersistentManager()) { OrderDao orderDao = new OrderDao(); ChannelDao channelDao = new ChannelDao(); LineScheduleDao lineDao = new LineScheduleDao(); SupplyDao supplyDao = new SupplyDao(); SupplyOptimize supplyOptimize = new SupplyOptimize(); SysParameterDao parameterDao = new SysParameterDao(); Dictionary<string, string> parameter = parameterDao.FindParameters(); DataTable lineTable = lineDao.FindAllLine(orderDate, batchNo).Tables[0]; int currentCount = 0; int totalCount = lineTable.Rows.Count; foreach (DataRow lineRow in lineTable.Rows) { string lineCode = lineRow["LINECODE"].ToString(); int channelGroup = 1; int channelType = 2; int aheadCount = Convert.ToInt32(parameter[string.Format("SupplyAheadCount-{0}-{1}-{2}",lineCode,channelGroup,channelType)]); supplyDao.AdjustSortNo(orderDate, batchNo, lineCode, channelGroup, channelType, aheadCount); channelGroup = 1; channelType = 3; aheadCount = Convert.ToInt32(parameter[string.Format("SupplyAheadCount-{0}-{1}-{2}", lineCode, channelGroup, channelType)]); supplyDao.AdjustSortNo(orderDate, batchNo, lineCode, channelGroup, channelType, aheadCount); channelGroup = 2; channelType = 2; aheadCount = Convert.ToInt32(parameter[string.Format("SupplyAheadCount-{0}-{1}-{2}", lineCode, channelGroup, channelType)]); supplyDao.AdjustSortNo(orderDate, batchNo, lineCode, channelGroup, channelType, aheadCount); channelGroup = 2; channelType = 3; aheadCount = Convert.ToInt32(parameter[string.Format("SupplyAheadCount-{0}-{1}-{2}", lineCode, channelGroup, channelType)]); supplyDao.AdjustSortNo(orderDate, batchNo, lineCode, channelGroup, channelType, aheadCount); DataTable channelTable = channelDao.FindChannelSchedule(orderDate, batchNo, lineCode, Convert.ToInt32(parameter["RemainCount"])).Tables[0]; DataTable supplyTable = supplyOptimize.Optimize(channelTable); supplyDao.InsertSupply(supplyTable, Convert.ToBoolean(parameter["IsSupplyOrderbyCigaretteCode"])); if (OnSchedule != null) OnSchedule(this, new ScheduleEventArgs(7, "正在优化" + lineRow["LINECODE"].ToString() + "补货计划", currentCount++, totalCount)); } 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 serialNo = 1; currentCount = 0; totalCount = masterTable.Rows.Count; foreach (DataRow masterRow in masterTable.Rows) { DataRow[] orderRows = null; //查询当前订单明细 orderRows = orderTable.Select(string.Format("ORDERID = '{0}'", masterRow["ORDERID"]), "CIGARETTECODE"); DataTable supplyTable = supplyOptimize.Optimize(channelTable, orderRows,ref serialNo); supplyDao.InsertSupply(supplyTable,true); if (OnSchedule != null) OnSchedule(this, new ScheduleEventArgs(7, "正在优化" + lineRow["LINECODE"].ToString() + "分拣线订单补货!", ++currentCount, totalCount)); } } } }
/// <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(); 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)); } } }