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