public List <R_WO_KP_Repalce> GetWoRepalceKpBySkuPartno(string Sku, string Partno, string ReplaceKp, OleExec DB)
{
List <R_WO_KP_Repalce> ret = new List <R_WO_KP_Repalce>();
string strSql = $@" select a.* from R_WO_KP_Repalce a,r_wo_base b where a.wo=b.workorderno and b.skuno='{Sku}' and a.partno='{Partno}' and a.repalcepartno='{ReplaceKp}' ";
DataSet res = DB.RunSelect(strSql);
for (int i = 0; i < res.Tables[0].Rows.Count; i++)
{
Row_R_WO_KP_Repalce R = new Row_R_WO_KP_Repalce(this.DataInfo);
R.loadData(res.Tables[0].Rows[i]);
ret.Add(R.GetDataObject());
}
return(ret);
}
public List <R_WO_KP_Repalce> GetWoRepalceKP(string WO, OleExec DB)
{
List <R_WO_KP_Repalce> ret = new List <R_WO_KP_Repalce>();
string strSql = $@"select * from R_WO_KP_Repalce where wo = '{WO}'";
DataSet res = DB.RunSelect(strSql);
for (int i = 0; i < res.Tables[0].Rows.Count; i++)
{
Row_R_WO_KP_Repalce R = new Row_R_WO_KP_Repalce(this.DataInfo);
//(Row_R_WO_KP_Repalce)this.ConstructRow(res.Tables[0].Rows[i]);
R.loadData(res.Tables[0].Rows[i]);
ret.Add(R.GetDataObject());
}
return(ret);
}
