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