/// <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> /// �ж��Ƿ��Ѿ��ڻ�����У�true ���� /// </summary> /// <param name="TaskID"></param> /// <returns></returns> public bool HasTaskInChannel(string TaskID) { using (PersistentManager pm = new PersistentManager()) { bool blnValue = false; ChannelDao dao = new ChannelDao(); blnValue= dao.HasTaskInChannel(TaskID); return blnValue; } }
/// <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> /// ���ݵ��ţ���ȡ������Ļ������š� /// </summary> /// <param name="BillNo"></param> /// <returns></returns> public string GetChannelNoByBillNo(string BillNo) { using (PersistentManager pm = new PersistentManager()) { string strChannelNo = ""; ChannelDao dao = new ChannelDao(); strChannelNo = dao.GetChannelNoByBillNo(BillNo); return strChannelNo; } }
/// <summary> /// ���³��� /// </summary> public void UpdateOutChannelTime(string TaskID) { using (PersistentManager pm = new PersistentManager()) { ChannelDao dao = new ChannelDao(); dao.UpdateOutChannelTime(TaskID); } }
/// <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; } }