public void UpdateModelOne(QccustomerlibraryModel model, DbTransaction tran) { QccustomerlibraryTable table = new QccustomerlibraryTable(); UpdateSqlSection sql = DataAccess.DefaultDB.Update(table); if (tran != null) { sql.SetTransaction(tran); } sql.AddColumn(table.MillComments, model.MillComments).Where(table.QualityCode == model.QualityCode && table.BuyerId == model.BuyerId) .Execute(); }
public void UpdateModel(QcfinishdtlModel model, DbTransaction tran) { QcfinishdtlTable table = new QcfinishdtlTable(); UpdateSqlSection sql = DataAccess.DefaultDB.Update(table); if (tran != null) { sql.SetTransaction(tran); } sql.AddColumn(table.FinishingCode, model.FinishingCode) .Execute(); }
public void UpdateModel(QcconstructiondtlModel model, DbTransaction tran) { QcconstructiondtlTable table = new QcconstructiondtlTable(); UpdateSqlSection sql = DataAccess.DefaultDB.Update(table); if (tran != null) { sql.SetTransaction(tran); } sql.AddColumn(table.Construction, model.Construction) .Execute(); }
public void UpdateModel(QcyarndtlModel model, DbTransaction tran) { QcyarndtlTable table = new QcyarndtlTable(); UpdateSqlSection sql = DataAccess.DefaultDB.Update(table); if (tran != null) { sql.SetTransaction(tran); } sql.AddColumn(table.YarnType, model.YarnType) .AddColumn(table.YarnCount, model.YarnCount) .AddColumn(table.Threads, model.Threads) .AddColumn(table.YarnRatio, model.YarnRatio) .AddColumn(table.YarnComponent, model.YarnComponent) .Where(table.QualityCode == model.QualityCode) .Execute(); }
public void UpdateModel(QcavailablewidthModel model, DbTransaction tran) { QcavailablewidthTable table = new QcavailablewidthTable(); UpdateSqlSection sql = DataAccess.DefaultDB.Update(table); if (tran != null) { sql.SetTransaction(tran); } sql.AddColumn(table.Gauge, model.Gauge) .AddColumn(table.Diameter, model.Diameter) .AddColumn(table.TotalNeedles, model.TotalNeedles) .AddColumn(table.Width, model.Width) .AddColumn(table.MaxWidth, model.MaxWidth) .AddColumn(table.UpdatedBy, model.UpdatedBy) .AddColumn(table.UpdatedTime, model.UpdatedTime) .Execute(); }
public void UpdateModel(QC_HF_ChangeLogModel model, DbTransaction tran) { QC_HF_ChangeLogTable table = new QC_HF_ChangeLogTable(); UpdateSqlSection sql = DataAccess.DefaultDB.Update(table); if (tran != null) { sql.SetTransaction(tran); } sql.AddColumn(table.QUALITY_CODE, model.QualityCode) .AddColumn(table.CREATE_DATE, model.CreateDate) .AddColumn(table.CREATOR, model.Creator) .AddColumn(table.QC_Ref_PPO_Old, model.QC_Ref_PPO_Old) .AddColumn(table.QC_Ref_GP_Old, model.QC_Ref_GP_Old) .AddColumn(table.HF_Ref_PPO_Old, model.HF_Ref_PPO_Old) .AddColumn(table.HF_Ref_GP_Old, model.HF_Ref_GP_Old) .AddColumn(table.QC_Ref_PPO_New, model.QC_Ref_PPO_New) .AddColumn(table.QC_Ref_GP_New, model.QC_Ref_GP_New) .AddColumn(table.HF_Ref_PPO_New, model.HF_Ref_PPO_New) .AddColumn(table.HF_Ref_GP_New, model.HF_Ref_GP_New).Where(table.QUALITY_CODE == model.QualityCode) .Execute(); }