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);
}
}
protected bool Exists(QcfinishdtlModel model, bool isNew)
{
QcfinishdtlTable table = new QcfinishdtlTable();
SelectSqlSection sql = DataAccess.DefaultDB.Select(table, QueryColumn.All().Count())
.Where(table.Iden == model.Iden &&
table.QualityCode == model.QualityCode &&
table.FinishingCode == model.FinishingCode
);
return(sql.ToScalar <int>() > 0);
}
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 DeleteModel(QcfinishdtlModel model, DbTransaction tran)
{
if (tran == null)
{
QcfinishdtlTable table = new QcfinishdtlTable();
DataAccess.DefaultDB.Delete(table).Where(table.QualityCode == model.QualityCode)
.Execute();
}
else
{
QcfinishdtlTable table = new QcfinishdtlTable();
DataAccess.DefaultDB.Delete(table).SetTransaction(tran).Where(table.QualityCode == model.QualityCode)
.Execute();
}
}
public void AddModel(QcfinishdtlModel model, DbTransaction tran)
{
//model.CreateTime = System.DateTime.Now;
QcfinishdtlTable table = new QcfinishdtlTable();
InsertSqlSection insertSql = DataAccess.DefaultDB.Insert(table);
if (tran != null)
{
insertSql.SetTransaction(tran);
}
int iden = DataAccess.DefaultDB.CustomSql("select QCFINISHDTLIDEN.nextval from dual").ToScalar <int>();
insertSql.AddColumn(table.QualityCode, model.QualityCode)
.AddColumn(table.FinishingCode, model.FinishingCode)
.AddColumn(table.Iden, iden)
.Execute();
}
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);
}
}
