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 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 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 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 PbknityarncountModelList GetModelList(PbknityarncountModel model)
{
PbknityarncountTable table = new PbknityarncountTable();
SelectSqlSection sql = DataAccess.DefaultDB.Select(table, table.AllColumns())
;
using (SafeDataReader sdr = new SafeDataReader(sql.ToDataReader()))
{
PbknityarncountModelList result = new PbknityarncountModelList();
while (sdr.Read())
{
PbknityarncountModel m = new PbknityarncountModel();
m.YarnCount = sdr.GetString(table.YarnCount);
m.IsActive = sdr.GetString(table.IsActive);
result.Add(m);
}
return(result);
}
}
public PbknitdyemethodModelList GetModelList(PbknitdyemethodModel model)
{
PbknitdyemethodTable table = new PbknitdyemethodTable();
SelectSqlSection sql = DataAccess.DefaultDB.Select(table, table.AllColumns())
;
using (SafeDataReader sdr = new SafeDataReader(sql.ToDataReader()))
{
PbknitdyemethodModelList result = new PbknitdyemethodModelList();
while (sdr.Read())
{
PbknitdyemethodModel m = new PbknitdyemethodModel();
m.DyeMethod = sdr.GetString(table.DyeMethod);
m.DyeType = sdr.GetString(table.DyeType);
m.Description = sdr.GetString(table.Description);
result.Add(m);
}
return(result);
}
}
public PbknitfinishModelList GetModelList(PbknitfinishModel model)
{
PbknitfinishTable table = new PbknitfinishTable();
SelectSqlSection sql = DataAccess.DefaultDB.Select(table, table.AllColumns())
;
using (SafeDataReader sdr = new SafeDataReader(sql.ToDataReader()))
{
PbknitfinishModelList result = new PbknitfinishModelList();
while (sdr.Read())
{
PbknitfinishModel m = new PbknitfinishModel();
m.FinishingCode = sdr.GetString(table.FinishingCode);
m.FinishingName = sdr.GetString(table.FinishingName);
m.Description = sdr.GetString(table.Description);
m.WashingFlag = sdr.GetString(table.WashingFlag);
m.IsActive = sdr.GetString(table.IsActive);
result.Add(m);
}
return(result);
}
}
public PbknityarntypeModelList GetModelList(PbknityarntypeModel model)
{
PbknityarntypeTable table = new PbknityarntypeTable();
SelectSqlSection sql = DataAccess.DefaultDB.Select(table, table.AllColumns()).Where(table.YarnType == model.YarnType)
;
using (SafeDataReader sdr = new SafeDataReader(sql.ToDataReader()))
{
PbknityarntypeModelList result = new PbknityarntypeModelList();
while (sdr.Read())
{
PbknityarntypeModel m = new PbknityarntypeModel();
m.YarnType = sdr.GetString(table.YarnType);
m.Description = sdr.GetString(table.Description);
m.IeDescription = sdr.GetString(table.IeDescription);
m.CustomerDescription = sdr.GetString(table.CustomerDescription);
m.IsActive = sdr.GetString(table.IsActive);
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);
}
}
public QcmaininfologModelList GetModelList(QcmaininfologModel model)
{
QcmaininfologTable table = new QcmaininfologTable();
SelectSqlSection sql = DataAccess.DefaultDB.Select(table, table.AllColumns())
;
using (SafeDataReader sdr = new SafeDataReader(sql.ToDataReader()))
{
QcmaininfologModelList result = new QcmaininfologModelList();
while (sdr.Read())
{
QcmaininfologModel m = new QcmaininfologModel();
m.QualityCode = sdr.GetString(table.QualityCode);
m.Status = sdr.GetString(table.Status);
m.EditReason = sdr.GetString(table.EditReason);
m.EditorContent = sdr.GetString(table.EditorContent);
m.Editor = sdr.GetString(table.Editor);
m.EditorTime = sdr.GetDateTime(table.EditorTime);
result.Add(m);
}
return(result);
}
}
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);
}
}
public PbknitconstructionModelList GetModelList(PbknitconstructionModel model)
{
PbknitconstructionTable table = new PbknitconstructionTable();
SelectSqlSection sql = DataAccess.DefaultDB.Select(table, table.AllColumns())
;
using (SafeDataReader sdr = new SafeDataReader(sql.ToDataReader()))
{
PbknitconstructionModelList result = new PbknitconstructionModelList();
while (sdr.Read())
{
PbknitconstructionModel m = new PbknitconstructionModel();
m.Construction = sdr.GetString(table.Construction);
m.Description = sdr.GetString(table.Description);
m.DescriptionCn = sdr.GetString(table.DescriptionCn);
m.SingleDouble = sdr.GetString(table.SingleDouble);
m.IsSpecial = sdr.GetString(table.IsSpecial);
m.IsActive = sdr.GetString(table.IsActive);
result.Add(m);
}
return(result);
}
}
/// <summary>
/// 獲得表信息
/// </summary>
/// <param name="modelList">modelList</param>
/// <param name="table">table</param>
/// <param name="model">model</param>
/// <param name="sdr">SafeDataReader sdr</param>
public static void GetTable(IList modelList, QueryTable table, Object model, SelectSqlSection sql, int sum)
{
Type modelType = model.GetType(); //model的類型
Type tableType = table.GetType(); //table的類型
string proName = ""; //屬性名稱
using (SafeDataReader sdr = new SafeDataReader(sql.ToDataReader()))
{
while (sdr.Read())
{
object modelObj = Activator.CreateInstance(modelType); //創建新對象
Type modelObjType = modelObj.GetType(); //獲得對象的類型
foreach (System.Reflection.PropertyInfo modelInfo in modelObjType.GetProperties()) //遍曆model的所有屬性
{
proName = modelInfo.Name;
if (proName.Equals("GridRowCount"))
{
modelInfo.SetValue(modelObj, sum, null);
continue;
}
if (table.GetType().GetProperty(proName) == null)
{
continue;
}
Comfy.Data.QueryColumn queryColumn = (Comfy.Data.QueryColumn)table.GetType().GetProperty(proName).GetValue(table, null);
//匹配類型
if (modelInfo.PropertyType.Equals(typeof(string)))
{
modelInfo.SetValue(modelObj, sdr.GetString(queryColumn), null);
}
else if (modelInfo.PropertyType.Equals(typeof(DateTime)))
{
modelInfo.SetValue(modelObj, sdr.GetDateTime(queryColumn), null);
}
else if (modelInfo.PropertyType.Equals(typeof(int)))
{
modelInfo.SetValue(modelObj, sdr.GetInt32(queryColumn), null);
}
else if (modelInfo.PropertyType.Equals(typeof(long)))
{
modelInfo.SetValue(modelObj, sdr.GetInt64(queryColumn), null);
}
else if (modelInfo.PropertyType.Equals(typeof(short)))
{
modelInfo.SetValue(modelObj, sdr.GetInt16(queryColumn), null);
}
else if (modelInfo.PropertyType.Equals(typeof(bool)))
{
modelInfo.SetValue(modelObj, sdr.GetBoolean(queryColumn), null);
}
else if (modelInfo.PropertyType.Equals(typeof(float)))
{
modelInfo.SetValue(modelObj, sdr.GetFloat(queryColumn), null);
}
else if (modelInfo.PropertyType.Equals(typeof(double)))
{
modelInfo.SetValue(modelObj, sdr.GetDouble(queryColumn), null);
}
else if (modelInfo.PropertyType.Equals(typeof(decimal)))
{
modelInfo.SetValue(modelObj, sdr.GetDecimal(queryColumn), null);
}
else
{
throw new Exception("沒有匹配中類型");
}
}
modelList.Add(modelObj);
}
}
}
