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 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); } } }
public DataTable GetDetail(string scheduleNo) { using (PersistentManager pm = new PersistentManager()) { CellDao cellDao = new CellDao(); return cellDao.FindDetail(scheduleNo); } }
public DataTable GetUnusedCell() { using (PersistentManager pm = new PersistentManager()) { CellDao cellDao = new CellDao(); return cellDao.FindUnusedCell(); } }
public DataTable GetCell(string productCode) { using (PersistentManager pm = new PersistentManager()) { CellDao cellDao = new CellDao(); return cellDao.Find(productCode); } }
public DataTable GetCell(string areaCode, string shelfCode) { using (PersistentManager pm = new PersistentManager()) { CellDao cellDao = new CellDao(); return cellDao.Find(areaCode, shelfCode); } }
public void AddCell(DataRow row) { using (PersistentManager pm = new PersistentManager()) { CellDao cellDao = new CellDao(); cellDao.Insert(row); } }
public void SaveCell(DataRow row) { using (PersistentManager pm = new PersistentManager()) { CellDao cellDao = new CellDao(); cellDao.Update(row); } }
//�ƿ���ҵ public void TaskBillMove(string billNo, string userID, string date) { using (PersistentManager pm = new PersistentManager()) { BillDao billDao = new BillDao(); ProductStateDao stateDao = new ProductStateDao(); TaskDao taskDao = new TaskDao(); CellDao cellDao = new CellDao(); try { pm.BeginTransaction(); DataTable masterTable = billDao.FindMaster(billNo); if (masterTable.Rows.Count != 0) { string taskType = masterTable.Rows[0]["TTYPE"].ToString(); string taskLevel = masterTable.Rows[0]["TASKLEVEL"].ToString(); string target = masterTable.Rows[0]["TARGET"].ToString(); int taskCount = stateDao.FindCount(billNo); //���Ļ�λ����״̬ int cellCount = cellDao.Update(billNo, taskType); int newCellCount = cellDao.Update2(billNo, taskType); if (taskCount != cellCount || taskCount != newCellCount) throw new Exception("��ҵ������ɲ�����λ������һ��"); //����task��ҵ�� taskDao.Insert(billNo, taskType, taskLevel, target); ////����billmaster״̬ billDao.UpdateMasterState(billNo, "3", "TASKER", userID, "TASKDATE", date); } else throw new Exception(string.Format("δ�ҵ����ݺ�Ϊ'{0}'�ĵ��ݡ�", billNo)); pm.Commit(); } catch (Exception e) { pm.Rollback(); throw new Exception(e.Message); } } }