public void DeleteFormula(string formulaCode) { using (PersistentManager pm = new PersistentManager()) { FormulaDao formulaDao = new FormulaDao(); ScheduleDao scheduleDao = new ScheduleDao(); try { pm.BeginTransaction(); if (scheduleDao.Find(formulaCode) == 0) { formulaDao.DeleteDetail(formulaCode); formulaDao.DeleteMaster(formulaCode); } 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 void AddSchedule(string scheduleBatch, string cigaretteCode, string cigaretteName, string quantity) { using (PersistentManager pm = new PersistentManager()) { ScheduleDao scheduleDao = new ScheduleDao(); string scheduleNo = scheduleBatch; //scheduleDao.Insert(scheduleBatch.PadLeft(10, '0'), scheduleUnit, cigaretteCode, cigaretteName, quantity); if (scheduleDao.FindSchedule(scheduleNo) == 0) scheduleDao.Insert(scheduleBatch, cigaretteCode, cigaretteName, quantity); else throw new Exception("���κ�'" + scheduleNo + "'�Ѵ��ڣ����������롣"); } }
public void ClearFormula(string scheduleNo, string formulaCode) { using (PersistentManager pm = new PersistentManager()) { ScheduleDao scheduleDao = new ScheduleDao(); FormulaDao formulaDao = new FormulaDao(); try { pm.BeginTransaction(); formulaDao.PlusUseCount(formulaCode); scheduleDao.UpdateFormula(scheduleNo, ""); pm.Commit(); } catch (Exception e) { pm.Rollback(); throw new Exception(e.Message); } } }
public void AddBill(DataRow masterRow, DataTable detailTable, Dictionary<string, DataTable> productState, string prefix, string billDate) { using (PersistentManager pm = new PersistentManager()) { try { BillDao billDao = new BillDao(); ProductStateDao stateDao = new ProductStateDao(); ScheduleDao scheduleDao = new ScheduleDao(); pm.BeginTransaction(); string billNo = billDao.FindNewBillNo(prefix, billDate); masterRow["BILLNO"] = billNo; //���뵥������ billDao.InsertMaster(masterRow); //���뵥����ϸ�� billDao.InsertDetail(billNo, detailTable); if (productState != null) { //����ProductState�� int itemNo = 1; foreach (DataTable stateTable in productState.Values) { stateDao.Insert(masterRow["SCHEDULENO"].ToString(), billNo, stateTable, ref itemNo); } } pm.Commit(); } catch (Exception e) { pm.Rollback(); throw new Exception(e.Message); } } }
public void ClearBillNo(string scheduleNo, string billNo) { using (PersistentManager pm = new PersistentManager()) { ScheduleDao scheduleDao = new ScheduleDao(); BillDao billDao = new BillDao(); ProductStateDao stateDao = new ProductStateDao(); try { pm.BeginTransaction(); DataTable billTable = billDao.FindMaster(billNo); if (billTable.Rows.Count != 0) { if (billTable.Rows[0]["STATE"].ToString() == "1") { billDao.DeleteDetail(billNo); billDao.DeleteMaster(billNo); stateDao.Delete(billNo); scheduleDao.UpdateBillNo(scheduleNo, ""); } else throw new Exception("����״̬Ϊ'���'�����ܽ����������"); } else throw new Exception(string.Format("���ݱ��Ϊ'{0}'�ĵ��ݲ����ڡ�", billNo)); pm.Commit(); } catch (Exception e) { pm.Rollback(); throw new Exception(e.Message); } } }
public string GenBill(string formulaCode, string scheduleNo, double quantity, String userID, string sysDate, string sysDate8) { string billNo = null; using (PersistentManager pm = new PersistentManager()) { FormulaDao formulaDao = new FormulaDao(); DataTable formulaTable = formulaDao.FindDetail(formulaCode); BillDao billDao = new BillDao(); DataTable detailTable = billDao.FindDetailEmpty(); int itemNo = 1; foreach (DataRow formulaRow in formulaTable.Rows) { DataRow detailRow = detailTable.NewRow(); detailRow["ITEMNO"] = itemNo++; detailRow["PRODUCTCODE"] = formulaRow["PRODUCTCODE"]; detailRow["QUANTITY"] = quantity * (Convert.ToDouble(formulaRow["QUANTITY"]) / 100.0); detailRow["PACKAGECOUNT"] = 0; detailRow["NCCOUNT"] = 0; detailRow["OTHERCODE"] = formulaRow["OTHERCODE"]; detailTable.Rows.Add(detailRow); } try { pm.BeginTransaction(); //string warehousePrefix = "C"; //billNo = warehousePrefix + sysDate8 + billDao.FindBillNo(sysDate, warehousePrefix).ToString().PadLeft(5, '0'); billNo = billDao.FindNewBillNo("C", sysDate); billDao.InsertMaster(billNo, DateTime.Now.ToShortDateString(), "002", scheduleNo, scheduleNo, "", "", "1", "1", userID); billDao.InsertDetail(billNo, detailTable); ScheduleDao scheduleDao = new ScheduleDao(); scheduleDao.UpdateBillNo(scheduleNo, billNo); pm.Commit(); } catch (Exception e) { pm.Rollback(); throw new Exception(e.Message); } } return billNo; }
public void SaveIsLock(string scheduleNo, string isLock) { using (PersistentManager pm = new PersistentManager()) { ScheduleDao scheduleDao = new ScheduleDao(); scheduleDao.UpdateIsLock(scheduleNo, isLock); } }
public DataTable GetStockSchedule() { using (PersistentManager pm = new PersistentManager()) { ScheduleDao scheduleDao = new ScheduleDao(); return scheduleDao.FindStockSchedule(); } }
public int GetFormula(string formulaCode) { using (PersistentManager pm = new PersistentManager()) { ScheduleDao scheduleDao = new ScheduleDao(); return scheduleDao.Find(formulaCode); } }
public DataTable GetAvaliableSchedule() { using (PersistentManager pm = new PersistentManager()) { ScheduleDao scheduleDao = new ScheduleDao(); return scheduleDao.FindAvailable(); } }
/// <summary> /// ������ҵ /// </summary> /// <param name="billNo"></param> /// <param name="userID"></param> /// <param name="date"></param> public DataTable TaskBill(string billNo, string status, string userID, string date) { DataTable table = null; using (PersistentManager pm = new PersistentManager()) { BillDao billDao = new BillDao(); ProductStateDao stateDao = new ProductStateDao(); TaskDao taskDao = new TaskDao(); try { pm.BeginTransaction(); DataTable masterTable = billDao.FindMaster(billNo); if (masterTable.Rows.Count != 0) { string scheduleNo = masterTable.Rows[0]["SCHEDULENO"].ToString(); //PRODUCTSTATE��û������ if (stateDao.FindDetail(billNo).Rows.Count == 0) { DataTable detailTable = billDao.FindDetail(billNo); int item = 1; stateDao.Insert(scheduleNo, billNo, detailTable, ref item); } string result = billDao.TaskOutBill(billNo); if (result != "0") throw new Exception("û��Ϊ��Ʒ�ҵ���λ���⡣"); ScheduleDao scheduleDao = new ScheduleDao(); scheduleDao.UpdateOutSchedule(scheduleNo); ////����billmaster״̬ billDao.UpdateMasterState(billNo, "3", "TASKER", userID, "TASKDATE", date); //���ij����ܰ��� int packageCount = taskDao.FindTaskCount(billNo); scheduleDao.UpdatePackageCount(scheduleNo, packageCount); } else throw new Exception(string.Format("δ�ҵ����ݺ�Ϊ'{0}'�ĵ��ݡ�", billNo)); table = stateDao.FindDetail(billNo); pm.Commit(); return table; } catch (Exception e) { pm.Rollback(); throw new Exception(e.Message); } } }
public void SaveAlcoholizeBill(DataRow masterRow, DataTable detailTable, Dictionary<string, DataTable> productState, string userID) { using (PersistentManager pm = new PersistentManager()) { try { BillDao billDao = new BillDao(); ProductStateDao stateDao = new ProductStateDao(); ScheduleDao scheduleDao = new ScheduleDao(); string billNo = masterRow["BILLNO"].ToString(); pm.BeginTransaction(); //���뵥������ billDao.UpdateMaster2(masterRow); //���뵥����ϸ�� billDao.SaveAlcoholizeDetail(billNo, detailTable); //����ProductState�� if (productState != null) { foreach (string productCode in productState.Keys) { DataTable stateTable = productState[productCode]; //stateDao.Delete(billNo, productCode); stateDao.Insert(billNo, masterRow["SCHEDULENO"].ToString(), stateTable, userID); } } pm.Commit(); } catch (Exception e) { pm.Rollback(); throw new Exception(e.Message); } } }
public string RecoverBill(string outBillNo, string sysDate) { string billNo = ""; using (PersistentManager pm = new PersistentManager()) { try { BillDao billDao = new BillDao(); ProductStateDao stateDao = new ProductStateDao(); ScheduleDao scheduleDao = new ScheduleDao(); pm.BeginTransaction(); billNo = billDao.FindNewBillNo("P", sysDate); billDao.UpdateMasterBillNo(billNo, outBillNo, sysDate); billDao.UpdateDetailBillNo(billNo, outBillNo); stateDao.UpdateBillNo(billNo, outBillNo); scheduleDao.UpdateIsOut(billNo); pm.Commit(); } catch (Exception e) { pm.Rollback(); throw new Exception(e.Message); } } return billNo; }
public void DeleteBill(string scheduleNo, string billNo) { using (PersistentManager pm = new PersistentManager()) { try { BillDao billDao = new BillDao(); ProductStateDao stateDao = new ProductStateDao(); ScheduleDao scheduleDao = new ScheduleDao(); pm.BeginTransaction(); billDao.DeleteMaster(billNo); billDao.DeleteDetail(billNo); if (scheduleNo != null) { stateDao.Delete(billNo); scheduleDao.UpdateBillNo(scheduleNo, ""); } pm.Commit(); } catch (Exception e) { pm.Rollback(); throw new Exception(e.Message); } } }