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 void AddModel(QccustomerlibraryModel model, DbTransaction tran)
{
//model.CreateTime = System.DateTime.Now;
QccustomerlibraryTable table = new QccustomerlibraryTable();
InsertSqlSection insertSql = DataAccess.DefaultDB.Insert(table);
if (tran != null)
{
insertSql.SetTransaction(tran);
}
int iden = DataAccess.DefaultDB.CustomSql("select QCCUSTOMERLIBRARYIDEN.nextval from dual").ToScalar <int>();
insertSql.AddColumn(table.QualityCode, model.QualityCode)
.AddColumn(table.BuyerId, model.BuyerId)
.AddColumn(table.Brand, model.Brand)
.AddColumn(table.CustomerQualityId, model.CustomerQualityId)
.AddColumn(table.Sales, model.Sales)
.AddColumn(table.SalesGroup, model.SalesGroup)
.AddColumn(table.MillComments, model.MillComments)
.AddColumn(table.IsFirstOwner, model.IsFirstOwner)
.AddColumn(table.CreateDate, model.CreateDate)
.AddColumn(table.Creator, model.Creator)
.AddColumn(table.Iden, iden)
.Execute();
}
public void DeleteModel(QccustomerlibraryModel model, DbTransaction tran)
{
QccustomerlibraryTable table = new QccustomerlibraryTable();
DeleteSqlSection sql = DataAccess.DefaultDB.Delete(table);
if (tran != null)
{
sql.SetTransaction(tran);
}
sql.Where(table.QualityCode == model.QualityCode)
.Execute();
}
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();
}
protected bool Exists(QccustomerlibraryModel model, bool isNew)
{
QccustomerlibraryTable table = new QccustomerlibraryTable();
SelectSqlSection sql = DataAccess.DefaultDB.Select(table, QueryColumn.All().Count())
.Where(table.Iden == model.Iden &&
table.QualityCode == model.QualityCode &&
table.BuyerId == model.BuyerId &&
table.Brand == model.Brand &&
table.CustomerQualityId == model.CustomerQualityId &&
table.Sales == model.Sales &&
table.SalesGroup == model.SalesGroup &&
table.MillComments == model.MillComments &&
table.IsFirstOwner == model.IsFirstOwner &&
table.CreateDate == model.CreateDate &&
table.Creator == model.Creator
);
return(sql.ToScalar <int>() > 0);
}