/// <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]); }