/// <summary>增加一条数据 /// /// </summary> public int Add(Nikita.Base.CacheStore.Model.CacheTables model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into CacheTables("); strSql.Append("TableName, Remark, Status )"); strSql.Append(" values ("); strSql.Append("@TableName, @Remark, @Status )"); strSql.Append(";select @@IDENTITY"); IDbHelper h = GlobalHelp.GetDataAccessHelper(); h.CreateCommand(strSql.ToString()); if (model.TableName == null) { h.AddParameter("@TableName", DBNull.Value); } else { h.AddParameter("@TableName", model.TableName); } 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); } 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.CacheTables model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update CacheTables set "); strSql.Append("TableName=@TableName, 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.TableName == null) { h.AddParameter("@TableName", DBNull.Value); } else { h.AddParameter("@TableName", model.TableName); } 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); } return(h.ExecuteNonQuery()); }