public Tuple <IEnumerable <RechargeLog>, int> GetRechargeLogs(string code, string key, DateTime?startTime, DateTime?endTime, int startIndex, int count, string outTradeNo = null)
{
var ch = new CashbagHelper(_webUrLfunds + "Recharge", "GET");
var data = ch.GetURLEncodeData(code, key, startTime, endTime, startIndex, count, outTradeNo);
var result = ch.GetBackJsonData(data);
if (result.status == false)
{
throw new CashBagException(result.message.ToString());
}
var lists = new List <RechargeLog>();
var rows = JArray.FromObject(result.result.rows);
int totalcount = result.result.total;
foreach (var item in rows)
{
var rl = new RechargeLog
{
SerialNum = item.SerialNum,
RechargeTime = item.RechargeTime,
TypeName = item.TypeName,
RechargeMoney = item.RechargeMoney,
CashSource = item.CashSource,
RechargeStatus = item.RechargeStatus,
OutTradeNo = item.OutTradeNo
};
lists.Add(rl);
}
var tuple = new Tuple <IEnumerable <RechargeLog>, int>(lists, totalcount);
return(tuple);
}
public List <RechargeLog> getRechargeList(string userPhone)
{
List <RechargeLog> rechargeLogList = new List <RechargeLog>();
StringBuilder builder = new StringBuilder();
builder.AppendFormat(ShipSqls.SELECT_RECHARGE_BY_PHONE, userPhone);
string sql = builder.ToString();
DataTable dt = DatabaseOperationWeb.ExecuteSelectDS(sql, "T").Tables[0];
if (dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
RechargeLog rechargeLog = new RechargeLog
{
id = dt.Rows[i]["id"].ToString(),
createTime = dt.Rows[i]["createTime"].ToString(),
userName = dt.Rows[i]["user_name"].ToString(),
userPhone = dt.Rows[i]["user_phone"].ToString(),
store = dt.Rows[i]["store"].ToString(),
beforeStore = dt.Rows[i]["before_store"].ToString(),
afterStore = dt.Rows[i]["after_store"].ToString(),
beforePrice = dt.Rows[i]["before_price"].ToString(),
afterPrice = dt.Rows[i]["after_price"].ToString(),
inputMember = dt.Rows[i]["inputMember"].ToString(),
};
rechargeLogList.Add(rechargeLog);
}
}
return(rechargeLogList);
}
