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 void SaveBill(DataRow masterRow, DataTable detailTable, Dictionary<string, DataTable> productState) { 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.UpdateMaster(masterRow); //���뵥����ϸ�� billDao.DeleteDetail(billNo); billDao.InsertDetail(billNo, detailTable); //����ProductState�� if (productState != null) { stateDao.Delete(billNo); 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 BackBill(string billNo, string oriBillNo) { using (PersistentManager pm = new PersistentManager()) { try { BillDao billDao = new BillDao(); ProductStateDao stateDao = new ProductStateDao(); pm.BeginTransaction(); billDao.DeleteMaster(billNo); billDao.DeleteDetail(billNo); billDao.DeleteMaster("T" + billNo); billDao.DeleteDetail("T" + billNo); billDao.UpdateMasterState(oriBillNo, "2", "SENDER", "", "SENDDATE", ""); stateDao.Delete(billNo); stateDao.Delete("T" + billNo); pm.Commit(); } catch (Exception e) { pm.Rollback(); throw new Exception(e.Message); } } }
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); } } }