/// <summary>增加一条数据 /// /// </summary> public int Add(Nikita.Base.CacheStore.Model.CacheSetting model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into CacheSetting("); strSql.Append("SetKey, SetText, CreateDate, Remark )"); strSql.Append(" values ("); strSql.Append("@SetKey, @SetText, @CreateDate, @Remark )"); strSql.Append(";select @@IDENTITY"); IDbHelper h = GlobalHelp.GetDataAccessHelper(); h.CreateCommand(strSql.ToString()); if (model.SetKey == null) { h.AddParameter("@SetKey", DBNull.Value); } else { h.AddParameter("@SetKey", model.SetKey); } if (model.SetText == null) { h.AddParameter("@SetText", DBNull.Value); } else { h.AddParameter("@SetText", model.SetText); } if (model.CreateDate == null) { h.AddParameter("@CreateDate", DBNull.Value); } else { h.AddParameter("@CreateDate", model.CreateDate); } if (model.Remark == null) { h.AddParameter("@Remark", DBNull.Value); } else { h.AddParameter("@Remark", model.Remark); } int intResult; string obj = h.ExecuteScalar(); if (!int.TryParse(obj, out intResult)) { return(0); } return(intResult); }
/// <summary>更新一条数据 /// /// </summary> public bool Update(Nikita.Base.CacheStore.Model.CacheSetting model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update CacheSetting set "); strSql.Append("SetKey=@SetKey, SetText=@SetText, CreateDate=@CreateDate, Remark=@Remark "); strSql.Append(" where Id=@Id "); IDbHelper h = GlobalHelp.GetDataAccessHelper(); h.CreateCommand(strSql.ToString()); if (model.Id == null) { h.AddParameter("@Id", DBNull.Value); } else { h.AddParameter("@Id", model.Id); } if (model.SetKey == null) { h.AddParameter("@SetKey", DBNull.Value); } else { h.AddParameter("@SetKey", model.SetKey); } if (model.SetText == null) { h.AddParameter("@SetText", DBNull.Value); } else { h.AddParameter("@SetText", model.SetText); } if (model.CreateDate == null) { h.AddParameter("@CreateDate", DBNull.Value); } else { h.AddParameter("@CreateDate", model.CreateDate); } if (model.Remark == null) { h.AddParameter("@Remark", DBNull.Value); } else { h.AddParameter("@Remark", model.Remark); } return(h.ExecuteNonQuery()); }
/// <summary>对象实体绑定数据 /// /// </summary> public Nikita.Base.CacheStore.Model.CacheSetting ReaderBind(IDataReader dataReader) { Nikita.Base.CacheStore.Model.CacheSetting model = new Nikita.Base.CacheStore.Model.CacheSetting(); object ojb; ojb = dataReader["Id"]; if (ojb != null && ojb != DBNull.Value) { model.Id = int.Parse(ojb.ToString()); } model.SetKey = dataReader["SetKey"].ToString(); model.SetText = dataReader["SetText"].ToString(); ojb = dataReader["CreateDate"]; if (ojb != null && ojb != DBNull.Value) { model.CreateDate = DateTime.Parse(ojb.ToString()); } model.Remark = dataReader["Remark"].ToString(); return(model); }
/// <summary>得到一个对象实体 /// /// </summary> public Nikita.Base.CacheStore.Model.CacheSetting GetModel(int Id) { StringBuilder strSql = new StringBuilder(); strSql.Append("select * from CacheSetting "); strSql.Append(" where Id=@Id "); IDbHelper h = GlobalHelp.GetDataAccessHelper(); h.CreateCommand(strSql.ToString()); h.AddParameter("@Id", Id); Nikita.Base.CacheStore.Model.CacheSetting model = null; using (IDataReader dataReader = h.ExecuteReader()) { if (dataReader.Read()) { model = ReaderBind(dataReader); } h.CloseConn(); } return(model); }
/// <summary>根据条件得到一个对象实体 /// /// </summary> public Nikita.Base.CacheStore.Model.CacheSetting GetModelByCond(string strCond) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 * from CacheSetting "); if (!string.IsNullOrEmpty(strCond)) { strSql.Append(" where " + strCond); } IDbHelper h = GlobalHelp.GetDataAccessHelper(); h.CreateCommand(strSql.ToString()); Nikita.Base.CacheStore.Model.CacheSetting model = null; using (IDataReader dataReader = h.ExecuteReader()) { if (dataReader.Read()) { model = ReaderBind(dataReader); } h.CloseConn(); } return(model); }