public R_WO_BASE CreateLanguageClass(DataRow dr)
{
Row_R_WO_BASE row = (Row_R_WO_BASE)NewRow();
row.loadData(dr);
return(row.GetDataObject());
}
/// <summary>
/// 查詢工單前綴為00251且沒有關閉的工單信息
/// </summary>
/// <param name="sfcdb"></param>
/// <param name="prefix"></param>
/// <returns></returns>
public List <R_WO_BASE> MatchSpecialPrefixWO(OleExec sfcdb, string prefix)
{
List <R_WO_BASE> woes = new List <R_WO_BASE>();
if (string.IsNullOrEmpty(prefix))
{
return(null);
}
DataTable dt = null;
Row_R_WO_BASE row_wo = null;
string sql = $@"select * from {this.TableName} where workorderno like '{prefix.Replace("'", "''")}%' and closed_flag='0' ";
dt = sfcdb.ExecSelect(sql).Tables[0];
foreach (DataRow dr in dt.Rows)
{
row_wo = (Row_R_WO_BASE)this.NewRow();
row_wo.loadData(dr);
woes.Add(row_wo.GetDataObject());
}
return(woes);
}
