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)));
}
