public string UpdateCloseFlagByPackID(string packID, string closedFlag, OleExec sfcdb) { Row_R_PACKING rowPacking = (Row_R_PACKING)this.GetObjByID(packID, sfcdb); rowPacking.CLOSED_FLAG = closedFlag; return(sfcdb.ExecSQL(rowPacking.GetUpdateString(DB_TYPE_ENUM.Oracle))); }
public string UpdateQtyByID(string packId, bool isAdd, double qty, string emp, OleExec sfcdb) { Row_R_PACKING rowPacking = (Row_R_PACKING)this.GetObjByID(packId, sfcdb); if (isAdd) { rowPacking.QTY = rowPacking.QTY + qty; } else { rowPacking.QTY = rowPacking.QTY - qty; } rowPacking.EDIT_TIME = this.GetDBDateTime(sfcdb); rowPacking.EDIT_EMP = emp; return(sfcdb.ExecSQL(rowPacking.GetUpdateString(DB_TYPE_ENUM.Oracle))); }