public WTradeUserInfo() { WUser = new Base_WUser(); TdUser = new TradeUser(); }
/// <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; }