/// <summary>
        /// 获取微交易用户信息
        /// </summary>
        /// <param name="sql"></param>
        /// <returns></returns>
        public static Base_WUser GetWUser(string sql)
        {
            System.Data.Common.DbDataReader dbreader = null;
            Base_WUser wuser = new Base_WUser();

            try
            {
                dbreader = DbHelper.ExecuteReader(sql);
                while (dbreader.Read())
                {
                    wuser.AccountType = System.DBNull.Value != dbreader["AccountType"] ? dbreader["AccountType"].ToString() : string.Empty;
                    wuser.Name        = System.DBNull.Value != dbreader["Name"] ? dbreader["Name"].ToString() : string.Empty;
                    wuser.PhoneNum    = System.DBNull.Value != dbreader["PhoneNum"] ? dbreader["PhoneNum"].ToString() : string.Empty;
                    wuser.PWUserId    = System.DBNull.Value != dbreader["PWUserId"] ? dbreader["PWUserId"].ToString() : string.Empty;
                    wuser.Ticket      = System.DBNull.Value != dbreader["Ticket"] ? dbreader["Ticket"].ToString() : string.Empty;
                    wuser.Url         = System.DBNull.Value != dbreader["Url"] ? dbreader["Url"].ToString() : string.Empty;
                    wuser.UserID      = System.DBNull.Value != dbreader["UserID"] ? dbreader["UserID"].ToString() : string.Empty;
                    wuser.WAccount    = System.DBNull.Value != dbreader["WAccount"] ? dbreader["WAccount"].ToString() : string.Empty;
                    wuser.WUserId     = System.DBNull.Value != dbreader["WUserId"] ? dbreader["WUserId"].ToString() : string.Empty;

                    break;
                }
            }
            catch (Exception ex)
            {
                throw new Exception(ex.Message, ex);
            }
            finally
            {
                if (null != dbreader)
                {
                    dbreader.Close();
                    dbreader.Dispose();
                }
            }
            return(wuser);
        }
Ejemplo n.º 2
0
 public WUserInfo()
 {
     WUser = new Base_WUser();
     TdUser = new TradeUser();
 }
Ejemplo n.º 3
0
 public WUserInfo()
 {
     WUser  = new Base_WUser();
     TdUser = new TradeUser();
 }