ModelManage/SaleManage/StoreManage/StockUpdate.aspx.cs

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

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

using System;
using System.Data;
using System.Text;
using System.Data.SqlClient;
public partial class SaleManage_StoreManage_StockUpdate : PageBase
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            btnUpdate.Visible = RoleControl("|1159_2|");
            this.Form.DefaultButton = "btnQuery";
            txtStartTime.Attributes.Add("readonly", "true");
            txtEndTime.Attributes.Add("readonly", "true");
        }
    }
    //查询出来数据
    private void QueryTable(string IFUpdate)
    {
        //汇报产量
        DataTable dtCount = new DataTable();
        StringBuilder strSql = new StringBuilder();
        SqlParameter[] parameters = new SqlParameter[] { 
                new SqlParameter("@StartDay", SqlDbType.VarChar, 20),
                new SqlParameter("@EndDay", SqlDbType.VarChar, 20),
                new SqlParameter("@OrderNum", SqlDbType.VarChar, 50),
                new SqlParameter("@OrderModel", SqlDbType.VarChar, 50),
                new SqlParameter("@SurName", SqlDbType.VarChar, 200),
                new SqlParameter("@CostName", SqlDbType.VarChar, 200) ,
                new SqlParameter("@IFUpdate", SqlDbType.VarChar, 20)
             };
        if (txtStartTime.Value.Trim() != "" && txtEndTime.Value.Trim() != "")
        {
            parameters[0].Value = Convert.ToDateTime(txtStartTime.Value).ToString("yyyy-MM-dd");
            parameters[1].Value = Convert.ToDateTime(txtEndTime.Value).ToString("yyyy-MM-dd");
            parameters[2].Value = "";
            parameters[3].Value = "";
            parameters[4].Value = "";
            parameters[5].Value = "";
            parameters[6].Value = IFUpdate;
            DataSet dsMoney = DBUtility.DbHelperSQL.RunProcedure("Pro_hfly_kf_P_Detail", parameters, "ProductDetail");
            dtCount = dsMoney.Tables[0];
        }
        if (dtCount.Rows.Count > 0)
        {
            lblCount.Text = dtCount.Rows[0][0].ToString();
        }
    } 

    //查询
    protected void btnQuery_Click(object sender, EventArgs e)
    {
        QueryTable("0");
        
    }
    //导出功能
    protected void btnExcel_Click(object sender, EventArgs e)
    {
        QueryTable("1");
    }