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