/// <summary>对象实体绑定数据 /// /// </summary> public Nikita.Base.CacheStore.Model.CacheConfig ReaderBind(IDataReader dataReader) { Nikita.Base.CacheStore.Model.CacheConfig model = new Nikita.Base.CacheStore.Model.CacheConfig(); object ojb; ojb = dataReader["Id"]; if (ojb != null && ojb != DBNull.Value) { model.Id = int.Parse(ojb.ToString()); } model.ConnectionString = dataReader["ConnectionString"].ToString(); model.TableName = dataReader["TableName"].ToString(); model.Filter = dataReader["Filter"].ToString(); model.CacheTableName = dataReader["CacheTableName"].ToString(); model.CacheChekGuid = dataReader["CacheChekGuid"].ToString(); model.CacheVersion = dataReader["CacheVersion"].ToString(); model.CreateUser = dataReader["CreateUser"].ToString(); ojb = dataReader["CreateDate"]; if (ojb != null && ojb != DBNull.Value) { model.CreateDate = DateTime.Parse(ojb.ToString()); } model.Remark = dataReader["Remark"].ToString(); ojb = dataReader["Status"]; if (ojb != null && ojb != DBNull.Value) { model.Status = int.Parse(ojb.ToString()); } return(model); }
/// <summary>得到一个对象实体 /// /// </summary> public Nikita.Base.CacheStore.Model.CacheConfig GetModel(int Id) { StringBuilder strSql = new StringBuilder(); strSql.Append("select * from CacheConfig "); strSql.Append(" where Id=@Id "); IDbHelper h = GlobalHelp.GetDataAccessHelper(); h.CreateCommand(strSql.ToString()); h.AddParameter("@Id", Id); Nikita.Base.CacheStore.Model.CacheConfig model = null; using (IDataReader dataReader = h.ExecuteReader()) { if (dataReader.Read()) { model = ReaderBind(dataReader); } h.CloseConn(); } return(model); }
/// <summary>根据条件得到一个对象实体 /// /// </summary> public Nikita.Base.CacheStore.Model.CacheConfig GetModelByCond(string strCond) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 * from CacheConfig "); if (!string.IsNullOrEmpty(strCond)) { strSql.Append(" where " + strCond); } IDbHelper h = GlobalHelp.GetDataAccessHelper(); h.CreateCommand(strSql.ToString()); Nikita.Base.CacheStore.Model.CacheConfig model = null; using (IDataReader dataReader = h.ExecuteReader()) { if (dataReader.Read()) { model = ReaderBind(dataReader); } h.CloseConn(); } return(model); }
/// <summary>增加一条数据 /// /// </summary> public int Add(Nikita.Base.CacheStore.Model.CacheConfig model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into CacheConfig("); strSql.Append("ConnectionString, TableName, Filter, CacheTableName, CacheChekGuid, CacheVersion, CreateUser, CreateDate, Remark, Status )"); strSql.Append(" values ("); strSql.Append("@ConnectionString, @TableName, @Filter, @CacheTableName, @CacheChekGuid, @CacheVersion, @CreateUser, @CreateDate, @Remark, @Status )"); strSql.Append(";select @@IDENTITY"); IDbHelper h = GlobalHelp.GetDataAccessHelper(); h.CreateCommand(strSql.ToString()); if (model.ConnectionString == null) { h.AddParameter("@ConnectionString", DBNull.Value); } else { h.AddParameter("@ConnectionString", model.ConnectionString); } if (model.TableName == null) { h.AddParameter("@TableName", DBNull.Value); } else { h.AddParameter("@TableName", model.TableName); } if (model.Filter == null) { h.AddParameter("@Filter", DBNull.Value); } else { h.AddParameter("@Filter", model.Filter); } if (model.CacheTableName == null) { h.AddParameter("@CacheTableName", DBNull.Value); } else { h.AddParameter("@CacheTableName", model.CacheTableName); } if (model.CacheChekGuid == null) { h.AddParameter("@CacheChekGuid", DBNull.Value); } else { h.AddParameter("@CacheChekGuid", model.CacheChekGuid); } if (model.CacheVersion == null) { h.AddParameter("@CacheVersion", DBNull.Value); } else { h.AddParameter("@CacheVersion", model.CacheVersion); } if (model.CreateUser == null) { h.AddParameter("@CreateUser", DBNull.Value); } else { h.AddParameter("@CreateUser", model.CreateUser); } 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); } if (model.Status == null) { h.AddParameter("@Status", DBNull.Value); } else { h.AddParameter("@Status", model.Status); } model.CacheChekGuid = Guid.NewGuid().ToString(); int intResult; string obj = h.ExecuteScalar(); if (!int.TryParse(obj, out intResult)) { return(0); } #region 新增缓存配置:如果是则需要推送更新缓存的消息。。即是发消息告诉服务端我修改了缓存配置,让服务端统一向所有在线客户端发送更新缓存消息 h.CreateCommand("select * from CacheConfig where id =" + intResult + ""); DataTable dt = h.ExecuteQuery(); dt.TableName = "CacheConfig"; CacheMessageEntity messageEntity = new CacheMessageEntity { CacheKey = model.CacheTableName, Operation = "Add", DataTableCache = dt }; CacheListener.AddMessage(messageEntity); #endregion return(intResult); }
/// <summary>更新一条数据 /// /// </summary> public bool Update(Nikita.Base.CacheStore.Model.CacheConfig model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update CacheConfig set "); strSql.Append("ConnectionString=@ConnectionString, TableName=@TableName, Filter=@Filter, CacheTableName=@CacheTableName, CacheChekGuid=@CacheChekGuid, CacheVersion=@CacheVersion, CreateUser=@CreateUser, CreateDate=@CreateDate, Remark=@Remark, Status=@Status "); 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.ConnectionString == null) { h.AddParameter("@ConnectionString", DBNull.Value); } else { h.AddParameter("@ConnectionString", model.ConnectionString); } if (model.TableName == null) { h.AddParameter("@TableName", DBNull.Value); } else { h.AddParameter("@TableName", model.TableName); } if (model.Filter == null) { h.AddParameter("@Filter", DBNull.Value); } else { h.AddParameter("@Filter", model.Filter); } if (model.CacheTableName == null) { h.AddParameter("@CacheTableName", DBNull.Value); } else { h.AddParameter("@CacheTableName", model.CacheTableName); } if (model.CacheChekGuid == null) { h.AddParameter("@CacheChekGuid", DBNull.Value); } else { h.AddParameter("@CacheChekGuid", model.CacheChekGuid); } if (model.CacheVersion == null) { h.AddParameter("@CacheVersion", DBNull.Value); } else { h.AddParameter("@CacheVersion", model.CacheVersion); } if (model.CreateUser == null) { h.AddParameter("@CreateUser", DBNull.Value); } else { h.AddParameter("@CreateUser", model.CreateUser); } 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); } if (model.Status == null) { h.AddParameter("@Status", DBNull.Value); } else { h.AddParameter("@Status", model.Status); } bool blnReturn = h.ExecuteNonQuery(); return(blnReturn); }