Exemplos de WeiBar.BLL DbHelperMySqlForWeiBar em C# (CSharp)

Exemplo n.º 1

        /// <summary>
        /// 添加用户
        /// </summary>
        /// <returns></returns>
        public static bool Add(UserModel model)
        {
            string sql = @"
insert into user
(UserID
,NickName
,CreateTime
,loginKey
)
values
(@UserID
,@NickName
,@CreateTime
,@loginKey
);
";

            MySqlParameter[] _parameter =
            {
                new MySqlParameter("@UserID",     MySqlDbType.VarChar, 36)
                {
                    Value = model.UserID
                },
                new MySqlParameter("@NickName",   MySqlDbType.VarChar, 36)
                {
                    Value = model.NickName
                },
                new MySqlParameter("@CreateTime", MySqlDbType.VarChar, 36)
                {
                    Value = model.CreateTime
                },
                new MySqlParameter("@loginKey",   MySqlDbType.VarChar, 36)
                {
                    Value = model.LoginKey
                },
            };
            var _rows = DbHelperMySqlForWeiBar.ExecuteSql(sql, _parameter);

            return(_rows > 0);
        }

Exemplo n.º 2

        /// <summary>
        /// 添加吧
        /// </summary>
        /// <returns></returns>
        public static bool Add(UserBarModel model)
        {
            string sql = @"
insert into user_bar
(UserID
,BarID
,CreateTime
,IsFollow
)
values
(@UserID
,@BarID
,@CreateTime
,@IsFollow
);
";

            MySqlParameter[] _parameter =
            {
                new MySqlParameter("@UserID",     MySqlDbType.VarChar, 36)
                {
                    Value = model.UserID
                },
                new MySqlParameter("@BarID",      MySqlDbType.Int64)
                {
                    Value = model.BarID
                },
                new MySqlParameter("@CreateTime", MySqlDbType.Int64)
                {
                    Value = model.CreateTime
                },
                new MySqlParameter("@IsFollow",   MySqlDbType.Int32)
                {
                    Value = model.IsFollow
                },
            };
            var _rows = DbHelperMySqlForWeiBar.ExecuteSql(sql, _parameter);

            return(_rows > 0);
        }

Exemplo n.º 3

        /// <summary>
        /// 添加用户
        /// </summary>
        /// <returns></returns>
        public static bool Add(UserModel model, AuthorizeModel authmodel)
        {
            string sql = @"
insert into user
(UserID
,NickName
,CreateTime
,loginKey
)
values
(@UserID
,@NickName
,@CreateTime
,@loginKey
);

-- 授权
insert into authorize
(UserID
,AuthID
,Data
)
values
(@UserID
,@AuthID
,@Data
);

-- 关注官方的几个吧
insert into user_bar
(UserID
,BarID
,CreateTime
,IsFollow
)
values
(@UserID
,1
,@CreateTime
,1
);

";

            MySqlParameter[] _parameter =
            {
                new MySqlParameter("@UserID",     MySqlDbType.VarChar, 36)
                {
                    Value = model.UserID
                },
                new MySqlParameter("@NickName",   MySqlDbType.VarChar, 36)
                {
                    Value = model.NickName
                },
                new MySqlParameter("@CreateTime", MySqlDbType.VarChar, 36)
                {
                    Value = model.CreateTime
                },
                new MySqlParameter("@loginKey",   MySqlDbType.VarChar, 36)
                {
                    Value = model.LoginKey
                },
                new MySqlParameter("@AuthID",     MySqlDbType.VarChar, 100)
                {
                    Value = authmodel.AuthID
                },
                new MySqlParameter("@Data",       MySqlDbType.LongText)
                {
                    Value = authmodel.Data
                },
            };
            var _rows = DbHelperMySqlForWeiBar.ExecuteSql(sql, _parameter);

            return(_rows > 0);
        }