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 string GetMinFormula(string cigaretteName, string formulaCode) { using (PersistentManager pm = new PersistentManager()) { FormulaDao formulaDao = new FormulaDao(); return formulaDao.FindMinNo(cigaretteName, formulaCode); } }
public DataTable GetFormulaMaster(string cigaretteName) { using (PersistentManager pm = new PersistentManager()) { FormulaDao formulaDao = new FormulaDao(); return formulaDao.FindMaster(cigaretteName); } }
public DataTable GetFormulaDetail(string formulaCode) { using (PersistentManager pm = new PersistentManager()) { FormulaDao formulaDao = new FormulaDao(); return formulaDao.FindDetail(formulaCode); } }
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 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; }
private void SaveFormula(bool isAdd, string formulaCode, string formulaName, string formulaDate, string cigaretteName, string quantity, string operater, string formulaNo, DataTable detailTable) { using (PersistentManager pm = new PersistentManager()) { FormulaDao formulaDao = new FormulaDao(); ProductDao productDao = new ProductDao(); try { pm.BeginTransaction(); if (isAdd) formulaDao.InserMaster(formulaCode, formulaName, formulaDate, cigaretteName, quantity, formulaNo, operater); else formulaDao.UpdateMaster(formulaCode, formulaName, formulaDate, cigaretteName, quantity, formulaNo, operater); formulaDao.DeleteDetail(formulaCode); for (int i = 0; i < detailTable.Rows.Count; i++) { DataRow row = detailTable.Rows[i]; string productCode = row["PRODUCTCODE"].ToString().ToUpper(); formulaDao.InsertDetail(formulaCode, productCode, i.ToString(), row["QUANTITY"].ToString(), row["OTHERCODE"].ToString()); if (productDao.Find(productCode) == 0) { productDao.Insert(productCode, row["ORIGINAL"].ToString(), row["YEARS"].ToString(), row["GRADE"].ToString(), row["STYLE"].ToString()); } else { productDao.Update(productCode, row["ORIGINAL"].ToString(), row["YEARS"].ToString(), row["GRADE"].ToString(), row["STYLE"].ToString()); } } pm.Commit(); } catch (Exception e) { pm.Rollback(); throw new Exception(e.Message); } } }
public DataTable GetStyle() { using (PersistentManager pm = new PersistentManager()) { FormulaDao formulaDao = new FormulaDao(); return formulaDao.FindStyle(); } }