public Row_R_SN_PACKING GetDataBySNID(string SN_ID, OleExec DB)
{
string strSql = $@"select * from R_SN_PACKING where SN_ID = '{SN_ID}' ";
DataSet res = DB.RunSelect(strSql);
if (res.Tables[0].Rows.Count > 0)
{
Row_R_SN_PACKING ret = (Row_R_SN_PACKING)NewRow();
ret.loadData(res.Tables[0].Rows[0]);
return(ret);
}
return(null);
}
public List <Row_R_SN_PACKING> GetPackItem(string PackID, OleExec DB)
{
List <Row_R_SN_PACKING> ret = new List <Row_R_SN_PACKING>();
string strSql = $@"select * from R_SN_PACKING where PACK_ID = '{PackID}' ";
DataSet res = DB.RunSelect(strSql);
for (int i = 0; i < res.Tables[0].Rows.Count; i++)
{
Row_R_SN_PACKING R = (Row_R_SN_PACKING)NewRow();
R.loadData(res.Tables[0].Rows[i]);
ret.Add(R);
}
return(ret);
}