public static double InsertPdOrder(string UserID,string Remark,string reftable, double refloid) { double POLoid = 0; PDOrderDAL poDAL = new PDOrderDAL(); poDAL.REMARK = Remark.Trim(); poDAL.ORDERTYPE = "PD"; poDAL.ACTIVE = "1"; poDAL.STATUS = "WA"; poDAL.POTYPE = "N"; poDAL.SUPPLIER = Constz.ProductionDepartment.LOID; poDAL.REFLOID = refloid; poDAL.REFTABLE = reftable; bool ret = poDAL.InsertCurrentData(UserID, null); if (ret == true) { POLoid = poDAL.LOID; return POLoid; } else return 0; }
public bool NewPDOrder(string UserID, PurchaseOrderData data) { bool ret = true; OracleDBObj obj = new OracleDBObj(); obj.CreateConnection(); obj.CreateTransaction(); try { PDOrderDAL _DAL = new PDOrderDAL(); _DAL.OnDB = false; _DAL.ACTIVE = data.ACTIVE; _DAL.CODE = data.CODE; _DAL.ORDERDATE = data.ORDERDATE; _DAL.STATUS = data.STATUS; _DAL.VAT = data.VAT; _DAL.ORDERTYPE = Constz.OrderType.PO.Code; _DAL.POTYPE = "N"; ret = _DAL.InsertCurrentData(UserID, obj.zTrans); _LOID = _DAL.LOID; if (!ret) { throw new ApplicationException(_DAL.ErrorMessage); } POItemDAL _DALItem = new POItemDAL(); for (int i = 0; i < data.ITEM.Count; ++i) { _DALItem.OnDB = false; POItemData itemData = (POItemData)data.ITEM[i]; _DALItem.PRODUCT = itemData.PRODUCT; _DALItem.PRITEM = itemData.PRITEM; _DALItem.PDORDER = _DAL.LOID; _DALItem.QTY = itemData.QTY; _DALItem.UNIT = itemData.UNIT; _DALItem.PRICE = itemData.PRICE; _DALItem.DUEDATE = DateTime.Now.Date; _DALItem.ACTIVE = itemData.ACTIVE; ret = _DALItem.InsertCurrentData(UserID, obj.zTrans); if (!ret) { throw new ApplicationException(_DALItem.ErrorMessage); } } obj.zTrans.Commit(); obj.CloseConnection(); } catch (Exception ex) { obj.zTrans.Rollback(); obj.CloseConnection(); ret = false; _error = ex.Message; } return ret; }
public bool UpdateData(string userID, StockinQCData data) { bool ret = true; if (ValidateData(data)) { OracleDBObj obj = new OracleDBObj(); obj.CreateConnection(); obj.CreateTransaction(); try { DALObj.OnDB = false; DALObj.GetDataByLOID(data.LOID, obj.zTrans); data.PDORDERLOID= DALObj.PDORDER ; PDOrderDAL PDDAL = new PDOrderDAL(); PDDAL.GetDataByLOID(data.PDORDERLOID, null); PDDAL.ANACODE = data.ANACODE; PDDAL.ANADATE = data.ANADATE; if (PDDAL.OnDB) ret = PDDAL.UpdateCurrentData(userID, obj.zTrans); else ret = PDDAL.InsertCurrentData(userID, obj.zTrans); _LOID = PDOrderDALObj.LOID; if (!ret) { throw new ApplicationException(PDOrderDALObj.ErrorMessage); } obj.zTrans.Commit(); obj.CloseConnection(); } catch (Exception ex) { obj.zTrans.Rollback(); obj.CloseConnection(); ret = false; _error = ex.Message; } } else ret = false; return ret; }