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