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