WebUI/reportnew/outboundreport.aspx.cs

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

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

namespace hyst.reportnew
{
    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 outboundreport : Page
    {
        private BaseClass bc = new BaseClass();
        protected Button Button3;
        protected Button Button4;
        protected DropDownList ddldianpu;
        protected HtmlInputText enddate;
        protected HtmlForm form1;
        protected GridView GridView1;
        protected Label lbldanwei;
        protected Label lbltime;
        protected HtmlInputText startdate;
        private double sumdixin = 0.0;
        protected HtmlInputText txtlevel;
        protected HtmlInputText txtnum;

        protected void Button3_Click(object sender, EventArgs e)
        {
            string str = "出库单据" + this.startdate.Value + "至" + this.enddate.Value;
            ExportToSpreadsheet(this.DataBindToGridviewex(), str);
        }

        protected void Button4_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  a.lyNum as 出库单号,a.lCount as 出库数量,b.yDate as 日期,b.yMaker as 操作人,(select sName from shops where  sNum = b.yShopnum) as yShopnum as 店铺,a.lRemark  as 备注, from outboundlist a left join  outbound b on b.yNum=a.lyNum  where 1=1 ";
            if ((sd != "") && (ed != ""))
            {
                string name5 = sql;
                sql = name5 + " and yDate >= '" + sd + "' and Addtime <='" + ed + "'";
            }
            if (this.Session["shoptype"].ToString() == "003")
            {
                if (this.ddldianpu.SelectedValue != "NONE")
                {
                    sql = sql + " and yShopnum ='" + this.ddldianpu.SelectedValue + "'";
                }
            }
            else
            {
                sql = sql + " and yShopnum ='" + this.ddldianpu.SelectedValue + "'";
            }