/// <summary>
/// 查询资金记录
/// </summary>
/// <returns></returns>
public JsonResult QueryWithdrawalInfos()
{
RequestUser();
try
{
int pageIndex;
int pageSize;
int fundType;
int userType = 0;
int userInfo;
DateTime starttimes;
DateTime endtimes;
string starttime = string.Empty;
string endtime = string.Empty;
string select = string.Empty;
DataDictionary result1 = new DataDictionary();
DataDictionary result2 = new DataDictionary();
DataDictionary result3 = new DataDictionary();
result3.Key = "";
if (GetParams("pageIndex") == null && GetParams("pageSize") == null)
{
resultData.msg = "索引值和页面大小不能为空";
return(this.ResultJson(resultData));
}
else
{
pageIndex = int.Parse(GetParams("pageIndex"));
pageSize = int.Parse(GetParams("pageSize"));
if (GetParams("fundType") != null)
{
fundType = int.Parse(GetParams("fundType"));
result1 = IDDC.ITEM(fund_type_Index, fundType);
}
if (GetParams("userType") != null)
{
userType = int.Parse(GetParams("userType"));
result2 = IDDC.ITEM(user_type_Index, userType);
}
if (GetParams("userInfo") != null && GetParams("select") != null)
{
select = GetParams("select");
userInfo = int.Parse(GetParams("userInfo"));
result3 = IDDC.ITEM(user_info_Index, userInfo);
}
if (GetParams("starttime") != null && GetParams("endtime") != null)
{
starttime = GetParams("starttime");
endtime = GetParams("endtime");
}
if (result1.Key.Equals("全部"))
{
if (result2.Key.Equals("全部"))
{
if (!string.IsNullOrEmpty(starttime) && !string.IsNullOrEmpty(endtime))
{
starttimes = DateTime.Parse(starttime);
endtimes = DateTime.Parse(endtime);
switch (result3.Key)
{
case "":
rpd = ICC.QueryMoney(pageIndex, pageSize, o => o.Time >= starttimes && o.Time <= endtimes, o => o.ID);
break;
//mode字段1:表示充值,2:表示提现
case "用户名":
rpd = ICC.QueryMoney(pageIndex, pageSize, o => o.UserName.Equals(select) && o.Time >= starttimes && o.Time <= endtimes, o => o.ID);
break;
case "邮箱":
rpd = ICC.QueryMoney(pageIndex, pageSize, o => o.Email.Equals(select) && o.Time >= starttimes && o.Time <= endtimes, o => o.ID);
break;
case "手机号":
rpd = ICC.QueryMoney(pageIndex, pageSize, o => o.PhoneNumber.Equals(select) && o.Time >= starttimes && o.Time <= endtimes, o => o.ID);
break;
}
}
else
{
switch (result3.Key)
{
case "":
rpd = ICC.QueryMoney(pageIndex, pageSize, o => o.ID > 0, o => o.ID);
break;
//mode字段1:表示充值,2:表示提现
case "用户名":
rpd = ICC.QueryMoney(pageIndex, pageSize, o => o.UserName.Equals(select), o => o.ID);
break;
case "邮箱":
rpd = ICC.QueryMoney(pageIndex, pageSize, o => o.Email.Equals(select), o => o.ID);
break;
case "手机号":
rpd = ICC.QueryMoney(pageIndex, pageSize, o => o.PhoneNumber.Equals(select), o => o.ID);
break;
}
}
}
else
{
if (!string.IsNullOrEmpty(starttime) && !string.IsNullOrEmpty(endtime))
{
starttimes = DateTime.Parse(starttime);
endtimes = DateTime.Parse(endtime);
switch (result3.Key)
{
case "":
rpd = ICC.QueryMoney(pageIndex, pageSize, o => o.Time >= starttimes && o.Time <= endtimes && o.Mode == result2.Value, o => o.ID);
break;
//mode字段1:表示充值,2:表示提现
case "用户名":
rpd = ICC.QueryMoney(pageIndex, pageSize, o => o.UserName.Equals(select) && o.Time >= starttimes && o.Time <= endtimes && o.Mode == result2.Value, o => o.ID);
break;
case "邮箱":
rpd = ICC.QueryMoney(pageIndex, pageSize, o => o.Email.Equals(select) && o.Time >= starttimes && o.Time <= endtimes && o.Mode == result2.Value, o => o.ID);
break;
case "手机号":
rpd = ICC.QueryMoney(pageIndex, pageSize, o => o.PhoneNumber.Equals(select) && o.Time >= starttimes && o.Time <= endtimes && o.Mode == result2.Value, o => o.ID);
break;
}
}
else
{
switch (result3.Key)
{
case "":
rpd = ICC.QueryMoney(pageIndex, pageSize, o => o.Mode == result2.Value, o => o.ID);
break;
//mode字段1:表示充值,2:表示提现
case "用户名":
rpd = ICC.QueryMoney(pageIndex, pageSize, o => o.UserName.Equals(select) && o.Mode == result2.Value, o => o.ID);
break;
case "邮箱":
rpd = ICC.QueryMoney(pageIndex, pageSize, o => o.Email.Equals(select) && o.Mode == result2.Value, o => o.ID);
break;
case "手机号":
rpd = ICC.QueryMoney(pageIndex, pageSize, o => o.PhoneNumber.Equals(select) && o.Mode == result2.Value, o => o.ID);
break;
}
}
}
}
else
{
if (result2.Key.Equals("全部"))
{
if (!string.IsNullOrEmpty(starttime) && !string.IsNullOrEmpty(endtime))
{
starttimes = DateTime.Parse(starttime);
endtimes = DateTime.Parse(endtime);
switch (result3.Key)
{
case "":
rpd = ICC.QueryMoney(pageIndex, pageSize, o => o.Time >= starttimes && o.Time <= endtimes && o.MoneyType == result1.Value, o => o.ID);
break;
//mode字段1:表示充值,2:表示提现
case "用户名":
rpd = ICC.QueryMoney(pageIndex, pageSize, o => o.UserName.Equals(select) && o.Time >= starttimes && o.Time <= endtimes && o.MoneyType == result1.Value, o => o.ID);
break;
case "邮箱":
rpd = ICC.QueryMoney(pageIndex, pageSize, o => o.Email.Equals(select) && o.Time >= starttimes && o.Time <= endtimes && o.MoneyType == result1.Value, o => o.ID);
break;
case "手机号":
rpd = ICC.QueryMoney(pageIndex, pageSize, o => o.PhoneNumber.Equals(select) && o.Time >= starttimes && o.Time <= endtimes && o.MoneyType == result1.Value, o => o.ID);
break;
}
}
else
{
switch (result3.Key)
{
case "":
rpd = ICC.QueryMoney(pageIndex, pageSize, o => o.MoneyType == result1.Value, o => o.ID);
break;
//mode字段1:表示充值,2:表示提现
case "用户名":
rpd = ICC.QueryMoney(pageIndex, pageSize, o => o.UserName.Equals(select) && o.MoneyType == result1.Value, o => o.ID);
break;
case "邮箱":
rpd = ICC.QueryMoney(pageIndex, pageSize, o => o.Email.Equals(select) && o.MoneyType == result1.Value, o => o.ID);
break;
case "手机号":
rpd = ICC.QueryMoney(pageIndex, pageSize, o => o.PhoneNumber.Equals(select) && o.MoneyType == result1.Value, o => o.ID);
break;
}
}
}
else
{
if (!string.IsNullOrEmpty(starttime) && !string.IsNullOrEmpty(endtime))
{
starttimes = DateTime.Parse(starttime);
endtimes = DateTime.Parse(endtime);
switch (result3.Key)
{
case "":
rpd = ICC.QueryMoney(pageIndex, pageSize, o => o.Time >= starttimes && o.Time <= endtimes && o.Mode == result2.Value && o.MoneyType == result1.Value, o => o.ID);
break;
//mode字段1:表示充值,2:表示提现
case "用户名":
rpd = ICC.QueryMoney(pageIndex, pageSize, o => o.UserName.Equals(select) && o.Time >= starttimes && o.Time <= endtimes && o.Mode == result2.Value && o.MoneyType == result1.Value, o => o.ID);
break;
case "邮箱":
rpd = ICC.QueryMoney(pageIndex, pageSize, o => o.Email.Equals(select) && o.Time >= starttimes && o.Time <= endtimes && o.Mode == result2.Value && o.MoneyType == result1.Value, o => o.ID);
break;
case "手机号":
rpd = ICC.QueryMoney(pageIndex, pageSize, o => o.PhoneNumber.Equals(select) && o.Time >= starttimes && o.Time <= endtimes && o.Mode == result2.Value && o.MoneyType == result1.Value, o => o.ID);
break;
}
}
else
{
switch (result3.Key)
{
case "":
rpd = ICC.QueryMoney(pageIndex, pageSize, o => o.Mode == result2.Value && o.MoneyType == result1.Value, o => o.ID);
break;
//mode字段1:表示充值,2:表示提现
case "用户名":
rpd = ICC.QueryMoney(pageIndex, pageSize, o => o.UserName.Equals(select) && o.Mode == result2.Value && o.MoneyType == result1.Value, o => o.ID);
break;
case "邮箱":
rpd = ICC.QueryMoney(pageIndex, pageSize, o => o.Email.Equals(select) && o.Mode == result2.Value && o.MoneyType == result1.Value, o => o.ID);
break;
case "手机号":
rpd = ICC.QueryMoney(pageIndex, pageSize, o => o.PhoneNumber.Equals(select) && o.Mode == result2.Value && o.MoneyType == result1.Value, o => o.ID);
break;
}
}
}
}
}
if (rpd.total != 0)
{
resultData.res = 200;
resultData.msg = "查询成功";
resultData.data = rpd;
return(this.ResultJson(resultData));
}
else
{
resultData.res = 200;
resultData.msg = "未查到符合条件的数据";
return(this.ResultJson(resultData));
}
}
catch (Exception ex)
{
resultData.res = 500;
resultData.msg = ex.Message;
return(this.ResultJson(resultData));
}
}
