public DbQueryResult GetBalanceDrawRequest4Report(BalanceDrawRequestSupplierQuery query, bool isAdmin)
{
DbQueryResult dbQueryResult = new DbQueryResult();
StringBuilder stringBuilder = new StringBuilder();
string text = this.BuildBalanceDrawRequestQuery(query);
stringBuilder.AppendFormat("select B.*,S.SupplierName");
stringBuilder.Append(" from Hishop_SupplierBalanceDrawRequest B join Hishop_Supplier S on b.SupplierId=S.SupplierId where 0=0 ");
if (isAdmin)
{
text += " AND IsPass IS NULL ";
}
switch (query.DrawRequestType)
{
case 3:
text += " AND IsAlipay = 1";
break;
case 1:
text += " AND IsWeixin <> 1 AND IsAlipay <> 1";
break;
}
stringBuilder.AppendFormat("{0} ORDER BY RequestTime DESC", text);
DbCommand sqlStringCommand = base.database.GetSqlStringCommand(stringBuilder.ToString());
using (IDataReader reader = base.database.ExecuteReader(sqlStringCommand))
{
dbQueryResult.Data = DataHelper.ConverDataReaderToDataTable(reader);
}
return(dbQueryResult);
}
public void ExportExcel(HttpContext context)
{
BalanceDrawRequestSupplierQuery dataQuery = this.GetDataQuery(context);
DbQueryResult balanceDrawRequest4Report = BalanceHelper.GetBalanceDrawRequest4Report(dataQuery, true);
string empty = string.Empty;
empty += "用户名";
empty += ",供应商";
empty += ",申请时间";
empty += ",业务摘要";
empty += ",提现金额";
empty += ",备注\r\n";
foreach (DataRow row in balanceDrawRequest4Report.Data.Rows)
{
empty += row["UserName"];
empty = empty + "," + row["SupplierName"];
empty = empty + "," + row["RequestTime"];
empty += ",银行卡提现";
empty = empty + "," + row["Amount"];
empty = empty + "," + row["Remark"] + "\r\n";
}
context.Response.Clear();
context.Response.Buffer = false;
context.Response.Charset = "GB2312";
context.Response.AppendHeader("Content-Disposition", "attachment;filename=DrawRequest.csv");
context.Response.ContentEncoding = Encoding.GetEncoding("GB2312");
context.Response.ContentType = "application/octet-stream";
context.Response.Write(empty);
context.Response.End();
}
public void GetList(HttpContext context)
{
BalanceDrawRequestSupplierQuery dataQuery = this.GetDataQuery(context);
DataGridViewModel <Dictionary <string, object> > dataList = this.GetDataList(dataQuery);
string s = base.SerializeObjectToJson(dataList);
context.Response.Write(s);
context.Response.End();
}
private void GetListBalance(HttpContext context)
{
BalanceDrawRequestSupplierQuery listBalanceqQuery = this.getListBalanceqQuery(context);
DataGridViewModel <SupplierBalanceDrawRequestInfo> balance = this.GetBalance(listBalanceqQuery);
string s = base.SerializeObjectToJson(balance);
context.Response.Write(s);
context.Response.End();
}
private BalanceDrawRequestSupplierQuery GetDataQuery(HttpContext context)
{
BalanceDrawRequestSupplierQuery balanceDrawRequestSupplierQuery = new BalanceDrawRequestSupplierQuery();
balanceDrawRequestSupplierQuery.UserName = base.GetParameter(context, "UserName", true);
balanceDrawRequestSupplierQuery.UserId = base.GetIntParam(context, "UserId", true);
balanceDrawRequestSupplierQuery.FromDate = base.GetDateTimeParam(context, "FromDate");
balanceDrawRequestSupplierQuery.ToDate = base.GetDateTimeParam(context, "ToDate");
balanceDrawRequestSupplierQuery.AuditState = 1;
balanceDrawRequestSupplierQuery.DrawRequestType = 1;
balanceDrawRequestSupplierQuery.PageIndex = base.CurrentPageIndex;
balanceDrawRequestSupplierQuery.PageSize = base.CurrentPageSize;
return(balanceDrawRequestSupplierQuery);
}
private DataGridViewModel <Dictionary <string, object> > GetDataList(BalanceDrawRequestSupplierQuery query)
{
DataGridViewModel <Dictionary <string, object> > dataGridViewModel = new DataGridViewModel <Dictionary <string, object> >();
if (query != null)
{
PageModel <SupplierBalanceDrawRequestInfo> balanceDrawRequests = BalanceHelper.GetBalanceDrawRequests(query, true);
dataGridViewModel.rows = new List <Dictionary <string, object> >();
dataGridViewModel.total = balanceDrawRequests.Total;
foreach (SupplierBalanceDrawRequestInfo model in balanceDrawRequests.Models)
{
Dictionary <string, object> item = model.ToDictionary();
dataGridViewModel.rows.Add(item);
}
}
return(dataGridViewModel);
}
private DataGridViewModel <Dictionary <string, object> > GetDataList(BalanceDrawRequestSupplierQuery query)
{
DataGridViewModel <Dictionary <string, object> > dataGridViewModel = new DataGridViewModel <Dictionary <string, object> >();
if (query != null)
{
PageModel <SupplierBalanceDrawRequestInfo> balanceDrawRequests = BalanceHelper.GetBalanceDrawRequests(query, true);
dataGridViewModel.rows = new List <Dictionary <string, object> >();
dataGridViewModel.total = balanceDrawRequests.Total;
foreach (SupplierBalanceDrawRequestInfo model in balanceDrawRequests.Models)
{
Dictionary <string, object> dictionary = model.ToDictionary();
dictionary.Add("RequestStateText", OnLinePaymentEnumHelper.GetOnLinePaymentDescription(model.RequestState));
dataGridViewModel.rows.Add(dictionary);
}
}
return(dataGridViewModel);
}
public PageModel <SupplierBalanceDrawRequestInfo> GetBalanceDrawRequests(BalanceDrawRequestSupplierQuery query, bool IsAdmin = true)
{
PageModel <SupplierBalanceDrawRequestInfo> pageModel = new PageModel <SupplierBalanceDrawRequestInfo>();
StringBuilder stringBuilder = new StringBuilder();
string text = this.BuildBalanceDrawRequestQuery(query);
stringBuilder.AppendFormat("select top {0} B.*,S.SupplierName", query.PageSize);
stringBuilder.Append(" from Hishop_SupplierBalanceDrawRequest B join Hishop_Supplier S on b.SupplierId=S.SupplierId where 0=0 ");
if (IsAdmin)
{
text += " AND IsPass IS NULL ";
}
switch (query.DrawRequestType)
{
case 3:
text += " AND IsAlipay = 1";
break;
case 1:
text += " AND IsWeixin <> 1 AND IsAlipay <> 1";
break;
}
if (query.PageIndex == 1)
{
stringBuilder.AppendFormat("{0} ORDER BY RequestTime DESC", text);
}
else
{
stringBuilder.AppendFormat(" and RequestTime < (select min(RequestTime) from (select top {0} RequestTime from Hishop_SupplierBalanceDrawRequest where 0=0 {1} ORDER BY RequestTime DESC ) as tbltemp) {1} ORDER BY RequestTime DESC", (query.PageIndex - 1) * query.PageSize, text);
}
if (query.IsCount)
{
stringBuilder.AppendFormat(";select count(1) as Total from Hishop_SupplierBalanceDrawRequest B where 0=0 {0}", text);
}
DbCommand sqlStringCommand = base.database.GetSqlStringCommand(stringBuilder.ToString());
using (IDataReader objReader = base.database.ExecuteReader(sqlStringCommand))
{
pageModel.Models = DataHelper.ReaderToList <SupplierBalanceDrawRequestInfo>(objReader).ToList();
pageModel.Total = pageModel.Models.Count();
}
return(pageModel);
}
private string BuildBalanceDrawRequestQuery(BalanceDrawRequestSupplierQuery query)
{
StringBuilder stringBuilder = new StringBuilder();
if (query.Id.HasValue && query.Id.Value > 0)
{
stringBuilder.AppendFormat(" AND Id={0}", query.Id.Value);
}
if (query.UserId.HasValue && query.UserId.Value > 0)
{
stringBuilder.AppendFormat(" AND B.SupplierId = {0}", query.UserId.Value);
}
if (!string.IsNullOrEmpty(query.UserName))
{
stringBuilder.AppendFormat(" AND UserName like '%{0}%'", DataHelper.CleanSearchString(query.UserName));
}
if (query.FromDate.HasValue)
{
stringBuilder.AppendFormat(" AND RequestTime >= '{0}'", DataHelper.GetSafeDateTimeFormat(query.FromDate.Value));
}
if (query.ToDate.HasValue)
{
stringBuilder.AppendFormat(" AND RequestTime <= '{0}'", query.ToDate.Value.ToString("yyyy-MM-dd") + " 23:59:59");
}
switch (query.AuditState)
{
case 1:
stringBuilder.Append(" and IsPass is null ");
break;
case 2:
stringBuilder.Append(" AND AccountDate is not null and IsPass=1 ");
break;
case 3:
stringBuilder.Append(" AND AccountDate is not null and IsPass=0 ");
break;
}
return(stringBuilder.ToString());
}
public DataGridViewModel <SupplierBalanceDrawRequestInfo> GetBalance(BalanceDrawRequestSupplierQuery query)
{
DataGridViewModel <SupplierBalanceDrawRequestInfo> dataGridViewModel = new DataGridViewModel <SupplierBalanceDrawRequestInfo>();
if (query != null)
{
PageModel <SupplierBalanceDrawRequestInfo> balanceDrawRequests = BalanceHelper.GetBalanceDrawRequests(query, false);
List <SupplierBalanceDrawRequestInfo> list = new List <SupplierBalanceDrawRequestInfo>();
foreach (SupplierBalanceDrawRequestInfo model in balanceDrawRequests.Models)
{
if (model.IsAlipay)
{
model.DrawType = "支付宝支付";
model.ReceiverName = model.AlipayRealName;
model.ReceiverID = model.AlipayCode;
}
else
{
model.DrawType = "银行卡转账";
model.ReceiverName = model.AccountName;
model.ReceiverID = model.MerchantCode;
}
model.StateStr = this.ParseDrawStatus(model.IsPass);
if (model.IsPass == true && model.IsPass.HasValue)
{
model.AccountDateStr = model.AccountDate.ToString();
}
else
{
model.AccountDateStr = "--";
}
list.Add(model);
}
dataGridViewModel.rows = balanceDrawRequests.Models.ToList();
dataGridViewModel.total = balanceDrawRequests.Total;
}
return(dataGridViewModel);
}
private void ExportToExcelBalance(HttpContext context)
{
BalanceDrawRequestSupplierQuery listBalanceqQuery = this.getListBalanceqQuery(context);
listBalanceqQuery.PageIndex = 1;
listBalanceqQuery.PageSize = 2147483647;
DbQueryResult balanceDrawRequest4Report = BalanceHelper.GetBalanceDrawRequest4Report(listBalanceqQuery, false);
string empty = string.Empty;
empty += "申请时间";
empty += ",提现金额";
empty += ",提现方式";
empty += ",收款人";
empty += ",收款账号";
empty += ",状态";
empty += ",拒绝理由";
empty += ",放款时间\r\n";
foreach (DataRow row in balanceDrawRequest4Report.Data.Rows)
{
empty += row["RequestTime"];
empty = empty + "," + row["Amount"];
empty = empty + "," + ((row["IsAlipay"].ToString() == "False") ? "银行卡转账" : "支付宝支付");
empty = empty + "," + ((row["IsAlipay"].ToString() == "False") ? row["AccountName"] : row["AlipayRealName"]);
empty = empty + "," + ((row["IsAlipay"].ToString() == "False") ? row["MerchantCode"] : row["AlipayCode"]);
empty = empty + "," + this.ParseDrawStatus(row["IsPass"]);
empty = empty + "," + row["ManagerRemark"];
empty = empty + "," + ((row["IsPass"] != null && row["IsPass"].ToString() == "True") ? row["AccountDate"].ToString() : "--") + "\r\n";
}
context.Response.Clear();
context.Response.Buffer = false;
context.Response.Charset = "GB2312";
context.Response.AppendHeader("Content-Disposition", "attachment;filename=MyBalance.csv");
context.Response.ContentEncoding = Encoding.GetEncoding("GB2312");
context.Response.ContentType = "application/ms-excel";
context.Response.Write(empty);
context.Response.End();
}
protected void Page_Load(object sender, EventArgs e)
{
if (!int.TryParse(this.Page.Request.QueryString["OrderId"], out this.orderId))
{
base.GotoResourceNotFound();
}
else if (!this.Page.IsPostBack)
{
this.lblUserName.Text = this.Page.Request.QueryString["Name"].ToNullString();
BalanceDrawRequestSupplierQuery query = new BalanceDrawRequestSupplierQuery
{
Id = this.orderId,
PageSize = 1,
PageIndex = 1,
IsCount = false
};
PageModel <SupplierBalanceDrawRequestInfo> balanceDrawRequests = BalanceHelper.GetBalanceDrawRequests(query, false);
if (balanceDrawRequests != null && balanceDrawRequests.Models.Count() > 0)
{
SupplierBalanceDrawRequestInfo supplierBalanceDrawRequestInfo = balanceDrawRequests.Models.FirstOrDefault();
this.lblAlipayCode.Text = supplierBalanceDrawRequestInfo.AlipayCode.ToNullString();
this.lblAlipayRealName.Text = supplierBalanceDrawRequestInfo.AlipayRealName.ToNullString();
this.lblAccountName.Text = supplierBalanceDrawRequestInfo.AccountName.ToNullString();
this.lblBankName.Text = supplierBalanceDrawRequestInfo.BankName.ToNullString();
this.lblMerchantCode.Text = supplierBalanceDrawRequestInfo.MerchantCode.ToNullString();
if (supplierBalanceDrawRequestInfo.IsAlipay.ToBool())
{
this.isAlipay = true;
}
if (supplierBalanceDrawRequestInfo.IsWeixin.ToBool())
{
this.isWeixin = true;
}
}
}
}
public static PageModel <SupplierBalanceDrawRequestInfo> GetBalanceDrawRequests(BalanceDrawRequestSupplierQuery query, bool isAdmin = true)
{
return(new BalanceDao().GetBalanceDrawRequests(query, isAdmin));
}
public static DbQueryResult GetBalanceDrawRequest4Report(BalanceDrawRequestSupplierQuery query, bool isAdmin)
{
return(new BalanceDao().GetBalanceDrawRequest4Report(query, isAdmin));
}
private BalanceDrawRequestSupplierQuery getListBalanceqQuery(HttpContext context)
{
int num = 1;
int num2 = 10;
string empty = string.Empty;
DateTime?fromDate = null;
DateTime?toDate = null;
int auditState = 0;
BalanceDrawRequestSupplierQuery balanceDrawRequestSupplierQuery = new BalanceDrawRequestSupplierQuery();
empty = context.Request["DateStart"];
if (!string.IsNullOrWhiteSpace(empty))
{
try
{
fromDate = DateTime.Parse(empty);
}
catch
{
fromDate = null;
}
}
empty = context.Request["DateEnd"];
if (!string.IsNullOrWhiteSpace(empty))
{
try
{
toDate = DateTime.Parse(empty);
}
catch
{
toDate = null;
}
}
empty = context.Request["TradeType"];
if (!string.IsNullOrWhiteSpace(empty))
{
try
{
auditState = int.Parse(empty);
}
catch
{
auditState = 0;
}
}
num = base.GetIntParam(context, "page", false).Value;
if (num < 1)
{
num = 1;
}
num2 = base.GetIntParam(context, "rows", false).Value;
if (num2 < 1)
{
num2 = 10;
}
balanceDrawRequestSupplierQuery.UserId = this.CurrentManager.StoreId;
balanceDrawRequestSupplierQuery.FromDate = fromDate;
balanceDrawRequestSupplierQuery.ToDate = toDate;
balanceDrawRequestSupplierQuery.AuditState = auditState;
balanceDrawRequestSupplierQuery.PageSize = num2;
balanceDrawRequestSupplierQuery.PageIndex = num;
return(balanceDrawRequestSupplierQuery);
}
