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 Row_R_PACKING GetRPackingByPackNo(OleExec DB, string PackNo)
{
string strSql = $@" SELECT * FROM R_PACKING where PACK_NO='{PackNo}' ";
DataSet ds = DB.ExecSelect(strSql);
Row_R_PACKING r = (Row_R_PACKING)this.NewRow();
r.loadData(ds.Tables[0].Rows[0]);
return(r);
}
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)));
}
public R_PACKING GetPackingObjectBySN(string sn, OleExec sfcdb)
{
string sql = $@"select * from r_packing where id in (select n.pack_id from r_sn_packing n,r_sn m where n.sn_id=m.id and m.sn='{sn}' and m.valid_flag='1')";
DataSet ds = sfcdb.ExecSelect(sql);
if (ds.Tables[0].Rows.Count > 0)
{
Row_R_PACKING rowPacking = (Row_R_PACKING)this.NewRow();
rowPacking.loadData(ds.Tables[0].Rows[0]);
return(rowPacking.GetDataObject());
}
else
{
return(null);
}
}
