ModelManage/SaleReport/Sale/ProInDay.aspx.cs

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

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

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Text;
using System.Data.SqlClient;

public partial class SaleReport_Sale_ProInDay : PageBase
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            this.Form.DefaultButton = "btnQuery";
            btnExcel.Visible = RoleControl("|1315_6|");
            btnPrint.Visible = RoleControl("|1315_7|");
            txtStartTime.Attributes.Add("readonly", "true");
            txtEndTime.Attributes.Add("readonly", "true");
            txtStartTime.Text = DateTime.Now.ToShortDateString();
            txtEndTime.Text = DateTime.Now.ToShortDateString();
            DataBindData();
            hidBuilder.Value = Session["TrueName"].ToString();
        }
    }  //查询出来数据
    private DataTable QueryTable
    {
        get
        {
            //汇报产量
            StringBuilder strSql = new StringBuilder();
            SqlParameter[] parameters = new SqlParameter[] { 
                new SqlParameter("@StartDay", SqlDbType.VarChar, 20),
                new SqlParameter("@EndDay", SqlDbType.VarChar, 20)
            };
            DataTable dtCount = new DataTable();
            if (txtStartTime.Text.Trim() != "")
            {
                parameters[0].Value = Convert.ToDateTime(txtStartTime.Text).ToString("yyyy-MM-dd");
                parameters[1].Value = Convert.ToDateTime(txtEndTime.Text).ToString("yyyy-MM-dd");
                DataSet dsMoney = DBUtility.DbHelperSQL.RunProcedure("Pro_hfly_kf_ProDayTable", parameters, "ProDayTable");
                dtCount = dsMoney.Tables[0];
            }
            else
            {
                dtCount = new DataTable();
            }

            return dtCount;
        }
    }

    protected void DataBindData()
    {
        rpt.DataSource = QueryTable;//绑定数据源
        rpt.DataBind();
    }
    //查询