/// <summary> /// 分配货位,返回 0:TaskID,1:货位; /// </summary> /// <param name="strWhere"></param> public string[] AssignCell(string strWhere,string ApplyStation) { using (PersistentManager pm = new PersistentManager()) { TaskDao dao = new TaskDao(); return dao.AssignCell(strWhere, ApplyStation); } }
/// <summary> /// 分配货位,返回 0:TaskID,1:货位 /// </summary> /// <param name="strWhere"></param> public string[] AssignNewCell(string strWhere, string CranNo) { using (PersistentManager pm = new PersistentManager()) { TaskDao dao = new TaskDao(); return dao.AssignCell(strWhere, CranNo); } }
/// <summary> /// 小车待出库任务数量 /// </summary> /// <param name="strWhere"></param> /// <returns></returns> public int CarTaskInfo() { using (PersistentManager pm = new PersistentManager()) { TaskDao dao = new TaskDao(); return dao.CarTaskInfo(); } }
/// <summary> /// 获取入库的堆垛机信息 /// </summary> /// <returns></returns> public DataTable CraneTaskIn(string strWhere) { using (PersistentManager pm = new PersistentManager()) { TaskDao dao = new TaskDao(); return dao.CraneTaskIn(strWhere); } }
// /// <summary> /// 二楼分配货位,更新货位信息,返回 0:TaskID,1:任务号,2:货物到达入库站台的目的地址--平面号,3:堆垛机入库站台,4:货位,5:堆垛机编号,6:小车站台 /// </summary> /// <param name="strWhere"></param> public string[] AssignCellTwo(string strWhere) { using (PersistentManager pm = new PersistentManager()) { TaskDao dao = new TaskDao(); return dao.AssignCellTwo(strWhere); } }
/// <summary> /// ���仺��������뻺�浽��������ػ����ID�� /// </summary> /// <param name="TaskID"></param> /// <returns></returns> public string InsertChannel(string TaskID, string Bill_No) { using (PersistentManager pm = new PersistentManager()) { string strChannel_No = ""; TaskDao dao = new TaskDao(); DataTable dt = dao.TaskInfo(string.Format("TASK_ID='{0}'", TaskID)); string Line_No = dt.Rows[0]["TARGET_CODE"].ToString().Trim(); string BillNo = dt.Rows[0]["BILL_NO"].ToString(); ChannelDao Cdao = new ChannelDao(); dt = Cdao.ChannelInfo(Line_No); if (!Cdao.HasTaskInChannel(TaskID)) { switch (Line_No) { case "01": case "02": strChannel_No = Cdao.GetChannelNoByBillNo(BillNo); if (strChannel_No == "") { DataRow[] drs = dt.Select("QTY=0 AND QTY<CACHE_QTY", "ORDERNO"); if (drs.Length > 0) strChannel_No = drs[0]["CHANNEL_NO"].ToString(); } else { DataRow[] drs = dt.Select(string.Format("QTY<CACHE_QTY and CHANNEL_NO='{0}'", strChannel_No), "ORDERNO"); if (drs.Length == 0) { drs = dt.Select("QTY=0 AND QTY<CACHE_QTY", "ORDERNO"); if (drs.Length > 0) strChannel_No = drs[0]["CHANNEL_NO"].ToString(); } } break; case "03": if (int.Parse(dt.Rows[0]["CACHE_QTY"].ToString()) - int.Parse(dt.Rows[0]["QTY"].ToString()) > 15) { strChannel_No = dt.Rows[0]["CHANNEL_NO"].ToString(); } break; } if (strChannel_No != "") { Cdao.InsertChannel(TaskID, Bill_No, strChannel_No); } } return strChannel_No; } }
/// <summary> /// 二楼退库单据,产生任务,任务明细,更新货位错误标志, 返回任务ID。 /// </summary> /// /// <returns>TaskID</returns> public string CreateCancelBillInTask(string TaskID,string BillNo) { using (PersistentManager pm = new PersistentManager()) { BillDao dao = new BillDao(); string strTaskID = dao.CreateCancelBillInTask(TaskID, BillNo); TaskDao tdao = new TaskDao(); tdao.InsertTaskDetail(strTaskID); tdao.UpdateTaskState(strTaskID, "1");//更新任务开始执行 return strTaskID; } }
/// <summary> /// 更新堆垛机错误编号 /// </summary> /// <param name="TaskID"></param> /// <param name="QueueNO"></param> /// <param name="ItemNo"></param> public void UpdateCraneErrCode(string TaskID, string ItemNo, string ErrCode) { using (PersistentManager pm = new PersistentManager()) { TaskDao dao = new TaskDao(); dao.UpdateCraneErrCode(TaskID, ItemNo, ErrCode); } }
/// <summary> /// 根据任务号返回的任务号TaskID,及单号Bill_NO /// </summary> /// <param name="TaskNo"></param> /// <returns></returns> public string[] GetTaskInfo(string TaskNo) { using (PersistentManager pm = new PersistentManager()) { TaskDao dao = new TaskDao(); return dao.GetTaskInfo(TaskNo); } }
/// <summary> /// 获取堆垛机最大流水号 /// </summary> /// <returns></returns> public string GetMaxSQUENCENO() { using (PersistentManager pm = new PersistentManager()) { TaskDao dao = new TaskDao(); return dao.GetMaxSQUENCENO(); } }
/// <summary> /// 插入明细Task_Detail。 /// </summary> /// <param name="task_id"></param> /// <returns></returns> public string InsertTaskDetail(string task_id) { using (PersistentManager pm = new PersistentManager()) { TaskDao dao = new TaskDao(); return dao.InsertTaskDetail(task_id); } }
/// <summary> /// 烟包替换记录 /// </summary> /// <param name="strWhere"></param> public void InsertChangeProduct(string ProductBarcode,string ProductCode,string NewProductBarcode,string NewProductCode) { using (PersistentManager pm = new PersistentManager()) { TaskDao dao = new TaskDao(); dao.InsertChangeProduct(ProductBarcode, ProductCode, NewProductBarcode, NewProductCode); } }
/// <summary> /// 更新起始位置,目标位置 /// </summary> /// <param name="FromStation"></param> /// <param name="ToStation"></param> /// <param name="strWhere"></param> public void UpdateTaskDetailStation(string FromStation, string ToStation, string state, string strWhere) { using (PersistentManager pm = new PersistentManager()) { TaskDao dao = new TaskDao(); dao.UpdateTaskDetailStation(FromStation, ToStation, state, strWhere); } }
/// <summary> /// 更新任务状态 /// </summary> /// <param name="TaskID"></param> /// <param name="state"></param> public void UpdateTaskState(string TaskID, string state) { using (PersistentManager pm = new PersistentManager()) { TaskDao dao = new TaskDao(); dao.UpdateTaskState(TaskID, state); } }
/// <summary> /// 出库任务排序,判断能否给穿梭车下达出库任务 blnCar=false 堆垛机 blnCar=true 穿梭车 /// </summary> /// <param name="ForderBillNo"></param> /// <param name="Forder"></param> /// <param name="IsMix"></param> /// <returns></returns> public bool ProductCanToCar(string ForderBillNo, string Forder, string IsMix, bool blnCar, bool blnOutOrder) { if (!blnOutOrder) //不需要排序 { return true; } else { using (PersistentManager pm = new PersistentManager()) { TaskDao dao = new TaskDao(); return dao.ProductCanToCar(ForderBillNo, Forder, IsMix, blnCar); } } }
/// <summary> /// 更新Task_Detail状态 State /// </summary> /// <param name="strWhere"></param> /// <param name="State"></param> public void UpdateTaskDetailState(string strWhere, string State) { using (PersistentManager pm = new PersistentManager()) { TaskDao dao = new TaskDao(); dao.UpdateTaskDetailState(strWhere, State); } }
/// <summary> /// 根据任务号,返回产品信息。 /// </summary> /// <param name="TaskID"></param> /// <returns></returns> public DataTable GetProductInfoByTaskID(string TaskID) { using (PersistentManager pm = new PersistentManager()) { TaskDao dao = new TaskDao(); return dao.GetProductInfoByTaskID(TaskID); } }
/// <summary> /// 二楼出库--条码校验出错,记录错误标志,及新条码。 /// </summary> public void UpdateTaskCheckBarCode(string TaskID,string BarCode) { using (PersistentManager pm = new PersistentManager()) { TaskDao dao = new TaskDao(); dao.UpdateTaskCheckBarCode(TaskID, BarCode); } }
/// <summary> /// ���½��뻺���ʱ�䣬��ORDER_NO /// </summary> /// <returns></returns> public int UpdateInChannelTime(string TaskID, string Bill_No, string ChannelNo) { using (PersistentManager pm = new PersistentManager()) { int strValue = 0; ChannelDao dao = new ChannelDao(); int count = dao.ProductCount(Bill_No); TaskDao tdao = new TaskDao(); int taskCount = tdao.TaskCount(Bill_No); if (count == 0) strValue = 1; if (count == taskCount - 1) strValue = 2; dao.UpdateInChannelTime(TaskID, Bill_No, ChannelNo); return strValue; } }
public DataTable TaskOutToDetail() { using (PersistentManager pm = new PersistentManager()) { TaskDao dao = new TaskDao(); return dao.TaskOutToDetail(); } }
/// <summary> /// 根据单号,返回任务数量 /// </summary> /// <param name="BillNo"></param> /// <returns></returns> public int TaskCount(string BillNo) { using (PersistentManager pm = new PersistentManager()) { TaskDao dao = new TaskDao(); return dao.TaskCount(BillNo); } }
/// <summary> /// 根据条件,返回小车任务明细。 /// </summary> /// <param name="strWhere"></param> /// <returns></returns> public DataTable TaskCarDetail(string strWhere) { using (PersistentManager pm = new PersistentManager()) { TaskDao dao = new TaskDao(); return dao.TaskCarDetail(strWhere); } }
/// <summary> /// 判断二楼出库,任务号到达拆盘处,是否已经执行? /// </summary> /// <param name="TaskID"></param> /// <returns></returns> public bool SeparateTaskDetailStart(string TaskID) { using (PersistentManager pm = new PersistentManager()) { TaskDao dao = new TaskDao(); return dao.SeparateTaskDetailStart(TaskID); } }
/// <summary> /// 更新堆垛机顺序号 /// </summary> /// <param name="TaskID"></param> /// <param name="QueueNO"></param> /// <param name="ItemNo"></param> public void UpdateCraneQuenceNo(string TaskID,string QueueNO,string ItemNo) { using (PersistentManager pm = new PersistentManager()) { TaskDao dao = new TaskDao(); dao.UpdateCraneQuenceNo(TaskID, QueueNO, ItemNo); } }
/// <summary> /// 二楼托盘组入库申请,判断是否有排程,小车未接货的任务。 /// </summary> /// <param name="BillNo"></param> /// <returns></returns> public string GetPalletInTask() { using (PersistentManager pm = new PersistentManager()) { TaskDao dao = new TaskDao(); return dao.GetPalletInTask(); } }