/// <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();
}
}
