editprice_file.aspx.cs

简单的Web平台。能够读取Excel文件

using System;
using System.Data;
using System.Data.OleDb;
using System.Data.SqlClient;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;

public partial class EditPrice_File : System.Web.UI.Page
{

    #region 时间处理函数
    protected void Page_Load(object sender, EventArgs e)
    {
        if ( !Page.IsPostBack )
        {
            string strVersion = Request.QueryString["version"];
            string strModels = Request.QueryString["models"];

            hidVersion.Value = strVersion;      // 价格版本号
            hidModels.Value = strModels;        // 查询的车系序列

            string strSQL_PriceInfo = "SELECT * FROM priceInfo INNER JOIN level ON priceInfo.价格层次=level.级别层次 WHERE 价格版本号 LIKE '" + strVersion + "'";
            DBConnector dbConn = new DBConnector();
            DataSet dsPriceInfo = dbConn.Query( strSQL_PriceInfo );

            txtPriceName.Text = dsPriceInfo.Tables[0].Rows[0]["价格版本号"].ToString(); // 价格名称
            txtLevel.Text = dsPriceInfo.Tables[0].Rows[0]["级别名称"].ToString();       // 价格层次
            int iStatus = Convert.ToInt32( dsPriceInfo.Tables[0].Rows[0]["状态"] );     // 价格状态
            if (1 == iStatus)
                txtStatus.Text = "制作中";
            else if (2 == iStatus)
                txtStatus.Text = "已完成";
            else if (3 == iStatus)
                txtStatus.Text = "已发布";
            else
                txtStatus.Text = "已废弃";

            txtImpUpper.Text = dsPriceInfo.Tables[0].Rows[0]["导入上限"].ToString();    // 价格导入上限
            txtImpLower.Text = dsPriceInfo.Tables[0].Rows[0]["导入下限"].ToString();    // 价格导入下限

            txtPrcUpper.Text = dsPriceInfo.Tables[0].Rows[0]["波动上限"].ToString();    // 价格波动上限
            txtPrcLower.Text = dsPriceInfo.Tables[0].Rows[0]["波动下限"].ToString();    // 价格波动下限

            txtRemark.Text = dsPriceInfo.Tables[0].Rows[0]["备注"].ToString();          // 价格备注

            hidTableName.Value = dsPriceInfo.Tables[0].Rows[0]["数据表名称"].ToString();    // 价格信息所在的表名称
        }
    }

    #region 过滤符号的处理
    protected void btnFilter_Click(object sender, EventArgs e)
    {
        if (plFilter.Visible)
            btnFilter.Text = "显示";
        else
            btnFilter.Text = "隐藏";

        plFilter.Visible = !plFilter.Visible;
    }

    protected void btnFilterMark_1_Click(object sender, EventArgs e)
    {
        int iIndex = txtFilter.Text.IndexOf(btnFilterMark_1.Text);
        if (iIndex < 0)
        {
            txtFilter.Text += btnFilterMark_1.Text + ",";
        }
        else
        {
            txtFilter.Text = txtFilter.Text.Remove(iIndex, 2);
        }

    }
    protected void btnFilterMark_2_Click(object sender, EventArgs e)
    {
        int iIndex = txtFilter.Text.IndexOf(btnFilterMark_2.Text);
        if (iIndex < 0)
        {
            txtFilter.Text += btnFilterMark_2.Text + ",";
        }
        else
        {
            txtFilter.Text = txtFilter.Text.Remove(iIndex, 2);
        }
    }
    protected void btnFilterMark_3_Click(object sender, EventArgs e)
    {
        int iIndex = txtFilter.Text.IndexOf(btnFilterMark_3.Text);
        if (iIndex < 0)
        {
            txtFilter.Text += btnFilterMark_3.Text + ",";
        }
        else
        {
            txtFilter.Text = txtFilter.Text.Remove(iIndex, 2);
        }
    }
    protected void btnFilterMark_4_Click(object sender, EventArgs e)
    {
        int iIndex = txtFilter.Text.IndexOf(btnFilterMark_4.Text);
        if (iIndex < 0)
        {
            txtFilter.Text += btnFilterMark_4.Text + ",";
        }
        else
        {
            txtFilter.Text = txtFilter.Text.Remove(iIndex, 2);
        }
    }
    protected void btnFilterMark_5_Click(object sender, EventArgs e)
    {
        int iIndex = txtFilter.Text.IndexOf(btnFilterMark_5.Text);
        if (iIndex < 0)
        {
            txtFilter.Text += btnFilterMark_5.Text + ",";
        }
        else
        {
            txtFilter.Text = txtFilter.Text.Remove(iIndex, 2);
        }
    }
    protected void btnFilterMark_6_Click(object sender, EventArgs e)
    {
        int iIndex = txtFilter.Text.IndexOf(btnFilterMark_6.Text);
        if (iIndex < 0)
        {
            txtFilter.Text += btnFilterMark_6.Text + ",";
        }
        else
        {
            txtFilter.Text = txtFilter.Text.Remove(iIndex, 2);
        }
    }
    protected void btnFilterMark_7_Click(object sender, EventArgs e)
    {
        int iIndex = txtFilter.Text.IndexOf(btnFilterMark_7.Text);
        if (iIndex < 0)
        {
            txtFilter.Text += btnFilterMark_7.Text + ",";
        }
        else
        {
            txtFilter.Text = txtFilter.Text.Remove(iIndex, 2);
        }
    }
    protected void btnFilterMark_8_Click(object sender, EventArgs e)
    {
        int iIndex = txtFilter.Text.IndexOf(btnFilterMark_8.Text);
        if (iIndex < 0)
        {
            txtFilter.Text += btnFilterMark_8.Text + ",";
        }
        else
        {
            txtFilter.Text = txtFilter.Text.Remove(iIndex, 2);
        }
    }
    protected void btnFilterMark_9_Click(object sender, EventArgs e)
    {
        int iIndex = txtFilter.Text.IndexOf(btnFilterMark_9.Text);
        if (iIndex < 0)
        {
            txtFilter.Text += btnFilterMark_9.Text + ",";
        }
        else
        {
            txtFilter.Text = txtFilter.Text.Remove(iIndex, 2);
        }
    }
    protected void btnFilterMark_10_Click(object sender, EventArgs e)
    {
        int iIndex = txtFilter.Text.IndexOf(btnFilterMark_10.Text);
        if (iIndex < 0)
        {
            txtFilter.Text += btnFilterMark_10.Text + ",";
        }
        else
        {
            txtFilter.Text = txtFilter.Text.Remove(iIndex, 2);
        }
    }
    protected void btnFilterMark_11_Click(object sender, EventArgs e)
    {
        int iIndex = txtFilter.Text.IndexOf(btnFilterMark_11.Text);
        if (iIndex < 0)
        {
            txtFilter.Text += btnFilterMark_11.Text + ",";
        }
        else
        {
            txtFilter.Text = txtFilter.Text.Remove(iIndex, 2);
        }
    }
    protected void btnFilterMark_12_Click(object sender, EventArgs e)
    {
        int iIndex = txtFilter.Text.IndexOf(btnFilterMark_12.Text);
        if (iIndex < 0)
        {
            txtFilter.Text += btnFilterMark_12.Text + ",";
        }
        else
        {
            txtFilter.Text = txtFilter.Text.Remove(iIndex, 2);
        }

    }
    protected void btnFilterMark_13_Click(object sender, EventArgs e)
    {
        int iIndex = txtFilter.Text.IndexOf(btnFilterMark_13.Text);
        if (iIndex < 0)
        {
            txtFilter.Text += btnFilterMark_13.Text + ",";
        }
        else
        {
            txtFilter.Text = txtFilter.Text.Remove(iIndex, 2);
        }
    }
    #endregion

    /// <summary>
    /// 检查文件
    /// </summary>
    /// <param name="sender"></param>
    /// <param name="e"></param>
    protected void btnCheck_Click(object sender, EventArgs e)
    {
        /////////////////////////////////////////////////////////////////////////
        // 过滤符号
        const string strDefualtFilter = " -";   // 默认过滤符号
        ////////////////////////////////////
        string strFilterCharacter = null;              // 过滤符号字符串

        if (txtFilter.Text.Length > 0)
        {
            strFilterCharacter = txtFilter.Text.Replace(",", "");
        }
        strFilterCharacter += strDefualtFilter;
        /////////////////////////////////////////////////////////////////////////