public bool UpdateData(string userID, ControlStockData data) { bool ret = true; ProductMinMaxDAL oDAL = new ProductMinMaxDAL(); oDAL.GetDataByLOID(data.LOID, null); oDAL.STANDARD = Convert.ToDouble(data.STANDARD); oDAL.MINIMUM = Convert.ToDouble(data.MINIMUM); oDAL.MAXIMUM = Convert.ToDouble(data.MAXIMUM); ret = oDAL.UpdateCurrentData(userID, null); if (!ret) { _error = oDAL.ErrorMessage; } return ret; }
public bool DeleteData(ArrayList arrLOID) { bool ret = true; OracleDBObj objDB = new OracleDBObj(); objDB.CreateConnection(); objDB.CreateTransaction(); try { foreach (double LOID in arrLOID) { ProductMinMaxDAL oDAL = new ProductMinMaxDAL(); oDAL.GetDataByLOID(LOID, objDB.zTrans); oDAL.DeleteCurrentData(objDB.zTrans); } objDB.zTrans.Commit(); ret = true; } catch (Exception ex) { objDB.zTrans.Rollback(); _error = ex.Message; ret = false; } objDB.CloseConnection(); return ret; }
public bool UpdateData(string UserID, ControlStockData csData) { bool ret = true; ProductMinMaxDAL oDAL = new ProductMinMaxDAL(); oDAL.GetDataByLOID(csData.LOID, null); oDAL.STANDARD = csData.STANDARD; oDAL.MINIMUM = csData.MINIMUM; oDAL.MAXIMUM = csData.MAXIMUM; oDAL.ACTIVE = 1; ret = oDAL.UpdateCurrentData(UserID, null); if (ret == false) _error = oDAL.ErrorMessage; return ret; }