public QcavailablewidthModelList GetModelList(QcavailablewidthModel model) { QcavailablewidthTable table = new QcavailablewidthTable(); SelectSqlSection sql = DataAccess.DefaultDB.Select(table, table.AllColumns()); if (model.QualityCode != "") { sql.Where(table.QualityCode == model.QualityCode); } using (SafeDataReader sdr = new SafeDataReader(sql.ToDataReader())) { QcavailablewidthModelList result = new QcavailablewidthModelList(); while (sdr.Read()) { QcavailablewidthModel m = new QcavailablewidthModel(); m.Iden = sdr.GetInt32(table.Iden); m.QualityCode = sdr.GetString(table.QualityCode); m.Gauge = sdr.GetInt32(table.Gauge); m.Diameter = sdr.GetInt32(table.Diameter); m.TotalNeedles = sdr.GetInt32(table.TotalNeedles); m.Width = sdr.GetInt32(table.Width); m.MaxWidth = sdr.GetInt32(table.MaxWidth); m.UpdatedBy = sdr.GetString(table.UpdatedBy); m.UpdatedTime = sdr.GetDateTime(table.UpdatedTime); result.Add(m); } return(result); } }
public QcfinishdtlModelList GetModelList(QcfinishdtlModel model) { QcfinishdtlTable table = new QcfinishdtlTable(); PbknitfinishTable finishTable = new PbknitfinishTable(); SelectSqlSection sql = DataAccess.DefaultDB.Select(table, table.AllColumns(), finishTable.FinishingName); sql.Join(finishTable, table.FinishingCode == finishTable.FinishingCode); if (model.QualityCode != "") { sql.Where(table.QualityCode == model.QualityCode); } using (SafeDataReader sdr = new SafeDataReader(sql.ToDataReader())) { QcfinishdtlModelList result = new QcfinishdtlModelList(); while (sdr.Read()) { QcfinishdtlModel m = new QcfinishdtlModel(); m.Iden = sdr.GetInt32(table.Iden); m.Description = sdr.GetString(finishTable.FinishingName); m.QualityCode = sdr.GetString(table.QualityCode); m.FinishingCode = sdr.GetString(table.FinishingCode); result.Add(m); } return(result); } }
public QccustomerlibraryModelList GetModelList(QccustomerlibraryModel model) { QccustomerlibraryTable table = new QccustomerlibraryTable(); QcmaininfoTable main = new QcmaininfoTable(); SelectSqlSection sql = DataAccess.DefaultDB.Select(table, table.AllColumns(), main.Status); sql.Join(main, table.QualityCode == main.QualityCode); if (model.QualityCode != "") { sql.Where(table.QualityCode == model.QualityCode); } using (SafeDataReader sdr = new SafeDataReader(sql.ToDataReader())) { QccustomerlibraryModelList result = new QccustomerlibraryModelList(); while (sdr.Read()) { QccustomerlibraryModel m = new QccustomerlibraryModel(); m.Status = sdr.GetString(main.Status); m.QualityCode = sdr.GetString(table.QualityCode); m.BuyerId = sdr.GetString(table.BuyerId); m.Brand = sdr.GetString(table.Brand); m.CustomerQualityId = sdr.GetString(table.CustomerQualityId); m.Sales = sdr.GetString(table.Sales); m.SalesGroup = sdr.GetString(table.SalesGroup); m.MillComments = sdr.GetString(table.MillComments); m.IsFirstOwner = sdr.GetString(table.IsFirstOwner); m.CreateDate = sdr.GetDateTime(table.CreateDate); m.Creator = sdr.GetString(table.Creator); result.Add(m); } return(result); } }
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 QcyarndtlModelList GetModelList(QcyarndtlModel model) { QcyarndtlTable table = new QcyarndtlTable(); SelectSqlSection sql = DataAccess.DefaultDB.Select(table, table.AllColumns()); if (model.QualityCode != "") { sql.Where(table.QualityCode == model.QualityCode); } using (SafeDataReader sdr = new SafeDataReader(sql.ToDataReader())) { QcyarndtlModelList result = new QcyarndtlModelList(); while (sdr.Read()) { QcyarndtlModel m = new QcyarndtlModel(); m.Iden = sdr.GetInt32(table.Iden); m.QualityCode = sdr.GetString(table.QualityCode); m.YarnType = sdr.GetString(table.YarnType); m.YarnCount = sdr.GetString(table.YarnCount); m.Threads = sdr.GetInt32(table.Threads); m.YarnRatio = sdr.GetDecimal(table.YarnRatio); m.YarnComponent = sdr.GetString(table.YarnComponent); m.WarpWeft = sdr.GetString(table.WarpWeft); m.YarnDensity = sdr.GetInt32(table.YarnDensity); result.Add(m); } return(result); } }
public QcfinishdtlModelList GetModelListOne(QcfinishdtlModel model) { QcfinishdtlTable table = new QcfinishdtlTable(); PbknitfinishTable table1 = new PbknitfinishTable(); SelectSqlSection sql = DataAccess.DefaultDB.Select(table1, table1.FinishingName).Join(table, table.FinishingCode == table1.FinishingCode); if (model.QualityCode != "") { sql.Where(table.QualityCode == model.QualityCode); } using (SafeDataReader sdr = new SafeDataReader(sql.ToDataReader())) { QcfinishdtlModelList result = new QcfinishdtlModelList(); while (sdr.Read()) { QcfinishdtlModel m = new QcfinishdtlModel(); m.FinishingCode = sdr.GetString(table1.FinishingName); result.Add(m); } return(result); } }
/// <summary> /// 获取总记录条数 /// </summary> /// <param name="column">主键</param> /// <returns></returns> public static int GetTotalRecord(EDatabase db, IQueryTable table, WhereClip where, List <JoinTable> joinTables) { SelectSqlSection sql = db.Select(table, table.IDColumn.Count()); if (joinTables != null && joinTables.Count > 0) { foreach (JoinTable joinTable in joinTables) { joinTable.Join(sql); } } object obj = sql.Where(where).ToScalar(); if (obj != null) { return(Convert.ToInt32(obj)); } else { return(0); } }
public QcconstructiondtlModelList GetModelList(QcconstructiondtlModel model) { QcconstructiondtlTable table = new QcconstructiondtlTable(); SelectSqlSection sql = DataAccess.DefaultDB.Select(table, table.AllColumns()); if (model.QualityCode != "") { sql.Where(table.QualityCode == model.QualityCode); } using (SafeDataReader sdr = new SafeDataReader(sql.ToDataReader())) { QcconstructiondtlModelList result = new QcconstructiondtlModelList(); while (sdr.Read()) { QcconstructiondtlModel m = new QcconstructiondtlModel(); m.Iden = sdr.GetInt32(table.Iden); m.QualityCode = sdr.GetString(table.QualityCode); m.Construction = sdr.GetString(table.Construction); result.Add(m); } return(result); } }