public void DeleteModel(PbknityarntypeModel model) { PbknityarntypeTable table = new PbknityarntypeTable(); DataAccess.DefaultDB.Delete(table) .Execute(); }
protected bool Exists(PbknityarntypeModel model, bool isNew) { PbknityarntypeTable table = new PbknityarntypeTable(); SelectSqlSection sql = DataAccess.DefaultDB.Select(table, QueryColumn.All().Count()) .Where(table.YarnType == model.YarnType && table.Description == model.Description && table.IeDescription == model.IeDescription && table.CustomerDescription == model.CustomerDescription && table.IsActive == model.IsActive ); return(sql.ToScalar <int>() > 0); }
public void UpdateModel(PbknityarntypeModel model) { //model.UpdateTime = System.DateTime.Now; PbknityarntypeTable table = new PbknityarntypeTable(); DataAccess.DefaultDB.Update(table) .AddColumn(table.YarnType, model.YarnType) .AddColumn(table.Description, model.Description) .AddColumn(table.IeDescription, model.IeDescription) .AddColumn(table.CustomerDescription, model.CustomerDescription) .AddColumn(table.IsActive, model.IsActive) .Execute(); }
public PbknityarntypeModelList GetModelList(PbknityarntypeModel model) { PbknityarntypeTable table = new PbknityarntypeTable(); SelectSqlSection sql = DataAccess.DefaultDB.Select(table, table.AllColumns()).Where(table.YarnType == model.YarnType) ; using (SafeDataReader sdr = new SafeDataReader(sql.ToDataReader())) { PbknityarntypeModelList result = new PbknityarntypeModelList(); while (sdr.Read()) { PbknityarntypeModel m = new PbknityarntypeModel(); m.YarnType = sdr.GetString(table.YarnType); m.Description = sdr.GetString(table.Description); m.IeDescription = sdr.GetString(table.IeDescription); m.CustomerDescription = sdr.GetString(table.CustomerDescription); m.IsActive = sdr.GetString(table.IsActive); result.Add(m); } return(result); } }