/// <summary>
/// 获得数据列表
/// </summary>
public List<Model.AccountTrade> DataTableToList(DataTable dt)
{
List<Model.AccountTrade> modelList = new List<Model.AccountTrade>();
int rowsCount = dt.Rows.Count;
if (rowsCount > 0)
{
Model.AccountTrade model;
for (int n = 0; n < rowsCount; n++)
{
model = new Model.AccountTrade();
if (dt.Rows[0]["Pay"] != null && dt.Rows[0]["Pay"].ToString() != "")
{
model.Pay = decimal.Parse(dt.Rows[0]["Pay"].ToString());
}
if (dt.Rows[0]["PayCount"] != null && dt.Rows[0]["PayCount"].ToString() != "")
{
model.Buycourse = int.Parse(dt.Rows[0]["PayCount"].ToString());
}
if (dt.Rows[0]["InCome"] != null && dt.Rows[0]["InCome"].ToString() != "")
{
model.Income = decimal.Parse(dt.Rows[0]["InCome"].ToString());
}
if (dt.Rows[0]["SellCount"] != null && dt.Rows[0]["SellCount"].ToString() != "")
{
model.SellCount = int.Parse(dt.Rows[0]["SellCount"].ToString());
}
if (dt.Rows[0]["Rechange"] != null && dt.Rows[0]["Rechange"].ToString() != "")
{
model.Recharge = decimal.Parse(dt.Rows[0]["Rechange"].ToString());
}
if (dt.Rows[0]["ChangeCount"] != null && dt.Rows[0]["ChangeCount"].ToString() != "")
{
model.Count = int.Parse(dt.Rows[0]["ChangeCount"].ToString());
}
if (dt.Rows[0]["Blance"] != null && dt.Rows[0]["Blance"].ToString() != "")
{
model.Blance = decimal.Parse(dt.Rows[0]["Blance"].ToString());
}
modelList.Add(model);
}
}
return modelList;
}
/// <summary>
/// 获得用户账户信息
/// </summary>
/// <param name="UserId"></param>
/// <returns></returns>
public List<Model.AccountTrade> GetTradeDetials(int UserId)
{
SqlParameter[] parameters = {
new SqlParameter("@UserId",SqlDbType.Int)
};
parameters[0].Value = UserId;
Model.AccountTrade model = new Model.AccountTrade();
DataSet ds = DbHelperSQL.RunProcedure("sp_TradeDetails", parameters, "ds");
return DataTableToList(ds.Tables[0]);
}
