WebUI/settles/zonglist.aspx.cs

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

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

namespace hyst.settles
{
    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 zonglist : Page
    {
        private BaseClass bc = new BaseClass();
        protected HtmlInputText begins;
        protected Button Button1;
        protected Button Button3;
        protected Button Button4;
        protected DropDownList ddldian;
        protected HtmlForm form1;
        protected GridView GridView1;
        protected HtmlHead Head1;
        protected HiddenField HiddenField1;
        protected Label lbldanwei;
        protected Label lbltime;
        protected HtmlInputText overs;
        private double qitabutie = 0.0;
        private double quanqin = 0.0;
        private double sumdixin = 0.0;
        private double sumjiaban = 0.0;
        private double sumjiabanxiaoshi = 0.0;
        private double sumzhijing = 0.0;
        protected HtmlInputText Text1;
        protected HtmlInputText txturl;

        protected void Button1_Click(object sender, EventArgs e)
        {
            string str = "总部结算" + this.begins.Value + "至" + this.overs.Value;
            ExportToSpreadsheet(this.DataBindToGridviewex(), str);
        }

        protected void Button3_Click(object sender, EventArgs e)
        {
        }

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

        public DataTable DataBindToGridviewex()
        {
            string begin = this.begins.Value + " 00:00";
            string over = this.overs.Value + " 23:59";
            string sql = "select ShopId as 店铺编号,Shop as 店铺名称,sum(CONVERT(decimal(18, 2),[money])) as 销售金额, sum(BlancePay) as 储值,sum(CashPay) as 现金,sum(BankPay) as 银行,sum(JifenPay) as 积分,sum(ElsePay) as 其他 from Consumption_Back_select  where 1=1 ";
            if ((begin != "") && (over != ""))
            {
                string name5 = sql;
                sql = name5 + "and  Addtime >='" + begin + "' and Addtime <='" + over + "'";