/// <summary> /// 更新一条数据 /// </summary> public void Update(Wuyiju.Model.AccessCopy model) { StringBuilder sql = new StringBuilder(); sql.Append("update ec_accesscopy set "); sql.Append(" role_id = @role_id , "); sql.Append(" node_id = @node_id , "); sql.Append(" level = @level , "); sql.Append(" module = @module "); sql.Append(" where role_id = @role_id, node_id = @node_id"); DynamicParameters param = new DynamicParameters(); if (model != null) { param.AddDynamicParams(model); } var rows = db.Execute(sql, param); if (rows < 1) { throw new ApplicationException("更新数据无效"); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Wuyiju.Model.AccessCopy Get(Wuyiju.Model.AccessCopy model) { StringBuilder sql = new StringBuilder(); sql.Append("select role_id, node_id, level, module "); sql.Append(" from ec_access_copy "); sql.Append(" where role_id = @role_id, node_id = @node_id"); DynamicParameters param = new DynamicParameters(); //param.Add("id", id); if (model != null) { param.AddDynamicParams(model); } return(db.Get <Wuyiju.Model.AccessCopy>(sql, param)); }
/// <summary> /// 删除一条数据 /// </summary> public void Delete(Wuyiju.Model.AccessCopy model) { StringBuilder sql = new StringBuilder(); sql.Append("delete from ec_access_copy "); sql.Append(" where role_id = @role_id, node_id = @node_id"); DynamicParameters param = new DynamicParameters(); //param.Add("id", id); if (model != null) { param.AddDynamicParams(model); } var rows = db.Execute(sql, param); if (rows < 1) { throw new ApplicationException("删除数据无效"); } }
/// <summary> /// 增加一条数据 /// </summary> public void Insert(Wuyiju.Model.AccessCopy model) { StringBuilder sql = new StringBuilder(); sql.Append("insert into ec_access_copy("); sql.Append("role_id,node_id,level,module"); sql.Append(") values ("); sql.Append("@role_id,@node_id,@level,@module"); sql.Append(") "); DynamicParameters param = new DynamicParameters(); if (model != null) { param.AddDynamicParams(model); } var rows = db.Execute(sql, param); if (rows < 1) { throw new ApplicationException("插入数据无效"); } }