public void DeleteModel(PbknitconstructionModel model)
{
PbknitconstructionTable table = new PbknitconstructionTable();
DataAccess.DefaultDB.Delete(table)
.Execute();
}
protected bool Exists(PbknitconstructionModel model, bool isNew)
{
PbknitconstructionTable table = new PbknitconstructionTable();
SelectSqlSection sql = DataAccess.DefaultDB.Select(table, QueryColumn.All().Count())
.Where(table.Construction == model.Construction &&
table.Description == model.Description &&
table.DescriptionCn == model.DescriptionCn &&
table.SingleDouble == model.SingleDouble &&
table.IsSpecial == model.IsSpecial &&
table.IsActive == model.IsActive
);
return(sql.ToScalar <int>() > 0);
}
public void UpdateModel(PbknitconstructionModel model)
{
//model.UpdateTime = System.DateTime.Now;
PbknitconstructionTable table = new PbknitconstructionTable();
DataAccess.DefaultDB.Update(table)
.AddColumn(table.Construction, model.Construction)
.AddColumn(table.Description, model.Description)
.AddColumn(table.DescriptionCn, model.DescriptionCn)
.AddColumn(table.SingleDouble, model.SingleDouble)
.AddColumn(table.IsSpecial, model.IsSpecial)
.AddColumn(table.IsActive, model.IsActive)
.Execute();
}
public QcconstructiondtlModelList GetModelListOne(QcconstructiondtlModel model)
{
QcconstructiondtlTable table = new QcconstructiondtlTable();
PbknitconstructionTable table1 = new PbknitconstructionTable();
SelectSqlSection sql = DataAccess.DefaultDB.Select(table1, table1.Description).Join(table, table1.Construction == table.Construction);
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.Construction = sdr.GetString(table1.Description);
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);
}
}