C# (CSharp) UserPrivilegeEntity示例

示例#1

        public static IList <UserPrivilegeEntity> Query(string userId, string rootId)

        {
            var sql = string.Format("SELECT {0} FROM user_privilege WHERE user_id = @p_user_id AND unit_root_id=@p_unit_root_id", COLUMN_SQL);

            var db = DatabaseFactory.CreateDatabase();
            var dc = db.GetSqlStringCommand(sql);

            db.AddInParameter(dc, "p_user_id", DbType.String, userId);
            db.AddInParameter(dc, "p_unit_root_id", DbType.String, rootId);

            var list = new List <UserPrivilegeEntity>();

            using (var reader = db.ExecuteReader(dc))
            {
                while (reader.Read())
                {
                    var entity = new UserPrivilegeEntity();
                    entity.Init(reader);

                    list.Add(entity);
                }
            }

            return(list);
        }

示例#2

        private static void Add(UserPrivilegeEntity entity, Database db, DbTransaction trans)
        {
            var sql = string.Format(@"INSERT INTO user_privilege({0})
VALUES(@p_id, @p_user_id, @p_unit_root_id, @p_unit_id, @p_query, @p_operate,
@p_created_id, @p_created_time, @p_updated_id, @p_updated_time)", COLUMN_SQL);

            var dc = db.GetSqlStringCommand(sql);

            db.AddInParameter(dc, "p_id", DbType.String, entity.Id);
            db.AddInParameter(dc, "p_user_id", DbType.String, entity.UserId);
            db.AddInParameter(dc, "p_unit_root_id", DbType.String, entity.UnitRootId);
            db.AddInParameter(dc, "p_unit_id", DbType.String, entity.UnitId);
            db.AddInParameter(dc, "p_query", DbType.Boolean, entity.Query);
            db.AddInParameter(dc, "p_operate", DbType.Boolean, entity.Operate);
            db.AddInParameter(dc, "p_created_id", DbType.String, entity.CreatedId);
            db.AddInParameter(dc, "p_created_time", DbType.DateTime, entity.CreatedTime);
            db.AddInParameter(dc, "p_updated_id", DbType.String, entity.UpdatedId);
            db.AddInParameter(dc, "p_updated_time", DbType.DateTime, entity.UpdatedTime);

            db.ExecuteNonQuery(dc, trans);
        }