public QC_HF_ChangeLogModelList GetModelList(string qualityCode) { QC_HF_ChangeLogTable table = new QC_HF_ChangeLogTable(); SelectSqlSection sql = DataAccess.DefaultDB.Select(table, table.AllColumns()); if (qualityCode != "") { sql.Where(table.QUALITY_CODE == qualityCode); } using (SafeDataReader sdr = new SafeDataReader(sql.ToDataReader())) { QC_HF_ChangeLogModelList result = new QC_HF_ChangeLogModelList(); while (sdr.Read()) { QC_HF_ChangeLogModel m = new QC_HF_ChangeLogModel(); m.QualityCode = sdr.GetString(table.QUALITY_CODE); m.QC_Ref_PPO_Old = sdr.GetString(table.QC_Ref_PPO_Old); m.QC_Ref_GP_Old = sdr.GetString(table.QC_Ref_GP_Old); m.HF_Ref_PPO_Old = sdr.GetString(table.HF_Ref_PPO_Old); m.HF_Ref_GP_Old = sdr.GetString(table.HF_Ref_GP_Old); m.QC_Ref_PPO_New = sdr.GetString(table.QC_Ref_PPO_New); m.QC_Ref_GP_New = sdr.GetString(table.QC_Ref_GP_New); m.HF_Ref_PPO_New = sdr.GetString(table.HF_Ref_PPO_New); m.HF_Ref_GP_New = sdr.GetString(table.HF_Ref_GP_New); m.CreateDate = sdr.GetDateTime(table.CREATE_DATE); m.Creator = sdr.GetString(table.CREATOR); result.Add(m); } return(result); } }
public void AddModels(QC_HF_ChangeLogModelList models, DbTransaction tran) { for (int i = 0; i < models.Count; i++) { this.AddModel(models[i], tran); } }