public void DeleteModel(PbknitparameterModel model) { PbknitparameterTable table = new PbknitparameterTable(); DataAccess.DefaultDB.Delete(table) .Execute(); }
public void CheckModel(PbknitparameterModel model, bool isNew) { Validator v = new Validator(); //Check model's data here. if (!v.IsValid) { throw new ValidationException(v); } }
protected bool Exists(PbknitparameterModel model, bool isNew) { PbknitparameterTable table = new PbknitparameterTable(); SelectSqlSection sql = DataAccess.DefaultDB.Select(table, QueryColumn.All().Count()) .Where(table.Sort == model.Sort && table.Parameter == model.Parameter && table.IsActive == model.IsActive ); return(sql.ToScalar <int>() > 0); }
public void UpdateModel(PbknitparameterModel model) { //model.UpdateTime = System.DateTime.Now; PbknitparameterTable table = new PbknitparameterTable(); DataAccess.DefaultDB.Update(table) .AddColumn(table.Sort, model.Sort) .AddColumn(table.Parameter, model.Parameter) .AddColumn(table.IsActive, model.IsActive) .Execute(); }
public PbknitparameterModelList GetModelList(PbknitparameterModel model) { PbknitparameterTable table = new PbknitparameterTable(); SelectSqlSection sql = DataAccess.DefaultDB.Select(table, table.AllColumns()) ; using (SafeDataReader sdr = new SafeDataReader(sql.ToDataReader())) { PbknitparameterModelList result = new PbknitparameterModelList(); while (sdr.Read()) { PbknitparameterModel m = new PbknitparameterModel(); m.Sort = sdr.GetString(table.Sort); m.Parameter = sdr.GetString(table.Parameter); m.IsActive = sdr.GetString(table.IsActive); result.Add(m); } return(result); } }