public C_KP_Rule GetKPRule(OleExec sfcdb, string partno, string mpn, string scanType)
{
C_KP_Rule kpRule = new C_KP_Rule();
try
{
string sql = $@" select * from c_kp_rule where partno='{partno}' and mpn='{mpn}' and scantype='{scanType}' ";
DataSet ds = sfcdb.ExecSelect(sql);
if (ds.Tables[0].Rows.Count > 0)
{
Row_C_KP_Rule row = (Row_C_KP_Rule)this.NewRow();
row.loadData(ds.Tables[0].Rows[0]);
kpRule = row.GetDataObject();
}
else
{
kpRule = null;
}
}
catch
{
kpRule = null;
}
return(kpRule);
}
public C_KP_Rule GetDataObject()
{
C_KP_Rule DataObject = new C_KP_Rule();
DataObject.EDIT_EMP = this.EDIT_EMP;
DataObject.EDIT_TIME = this.EDIT_TIME;
DataObject.REGEX = this.REGEX;
DataObject.SCANTYPE = this.SCANTYPE;
DataObject.MPN = this.MPN;
DataObject.PARTNO = this.PARTNO;
DataObject.ID = this.ID;
return(DataObject);
}