WebUI/inventory/inventorys.aspx.cs

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

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

namespace hyst.inventory
{
    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 inventorys : 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 HtmlHead Head1;
        protected Label lbldanwei;
        protected Label lbltime;
        protected HtmlInputText startdate;
        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 yNum as 入库单号,yDate as 日期,yPaytype as 付款方式,iState as 入库状态,yMaker as 操作人,(select sName from shops where sNum=yShopnum ) as 店铺,yRemark as 备注 from inventory where 1=1  ";
            if ((sd != "") && (ed != ""))
            {
                string name5 = sql;
                sql = name5 + " and yDate >= '" + sd + "' and yDate <='" + 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 + "'";
            }