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