WebUI/reports/comreport.aspx.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

namespace hyst.reports
{
    using DBUtility;
    using System;
    using System.Data;
    using System.IO;
    using System.Text;
    using System.Web;
    using System.Web.UI;
    using System.Web.UI.HtmlControls;
    using System.Web.UI.WebControls;

    public class comreport : Page
    {
        private BaseClass bc = new BaseClass();
        protected Button Button1;
        protected Button Button3;
        protected DropDownList ddldianpu;
        protected DropDownList ddltype;
        protected DropDownList ddlxiaofei;
        protected HtmlInputText enddate;
        protected HtmlForm form1;
        protected GridView GridView1;
        protected HtmlHead Head1;
        protected HiddenField HiddenField1;
        protected HtmlInputHidden hidurl;
        protected Label lbldanwei;
        protected Label lbltime;
        private double qitabutie = 0.0;
        private double quanqin = 0.0;
        protected HtmlInputText startdate;
        private double sumdixin = 0.0;
        private double sumjiaban = 0.0;
        private double sumjiabanxiaoshi = 0.0;
        private double sumzhijing = 0.0;
        protected HtmlInputText txturl;
        private double zeng = 0.0;

        protected void Button1_Click(object sender, EventArgs e)
        {
            string str = "消费报表" + this.startdate.Value + "至" + this.enddate.Value;
            ExportToSpreadsheet(this.DataBindToGridviewex(), str);
        }

        protected void Button3_Click(object sender, EventArgs e)
        {
            this.daying();
        }

        public DataTable DataBindToGridviewex()
        {
            string sd = this.startdate.Value + " 00:00";
            string ed = this.enddate.Value + " 23:59";
            string sql = "select C_Id as 消费单号,Card_Id as 卡号,ClientName as 姓名,CardType as 卡类型,cast(Money as decimal(18, 2)) as 销费金额,BlancePay as 储值消费,GivePay as 赠送消费,CashPay as 现金消费,BankPay as 银行消费,JifenPay as 积分,ElsePay as 其他,Type as 消费类型,Addtime as 消费时间,(select sName from shops where sNum=ShopId)  as 消费店铺  from Consumption_Back_select where 1=1  ";
            if ((sd != "") && (ed != ""))
            {
                string name5 = sql;
                sql = name5 + " and Addtime >= '" + sd + "' and Addtime <='" + ed + "'";
            }
            if (this.Session["shoptype"].ToString() == "003")