companytype.aspx.cs

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

using System;
using System.Data;
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 CompanyType : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {        
        if (  !Page.IsPostBack )
        {
            QueryCompanyType();
        }             

        if (lstCmyType.SelectedIndex < 0)
        {
            
            btnDel.Enabled = false;
            txtCmyName.Text = "";
            txtRemark.Text = "";
        }
        else
        {
            
            btnDel.Enabled = true;
        }
    }

    protected void lstCmyType_SelectedIndexChanged(object sender, EventArgs e)
    {
        if ( lstCmyType.SelectedIndex < 0 )
        {
            return;
        }
        txtCmyName.Text = lstCmyType.SelectedItem.Text;


        string strSQL_CmyTypeInfo = "SELECT * FROM companyType WHERE ID = " + lstCmyType.SelectedValue;

        DBConnector dbConn = new DBConnector();

        DataSet dsCmyTypeInfo = dbConn.Query( strSQL_CmyTypeInfo );

        txtRemark.Text = dsCmyTypeInfo.Tables[0].Rows[0]["备注"].ToString();
    }
    
    protected void chkViewDel_CheckedChanged(object sender, EventArgs e)
    {        
        QueryCompanyType();
    }

    private void QueryCompanyType()
    {
        lstCmyType.Items.Clear();

        DBConnector dbConn = new DBConnector();

        string strSQL_CmyTypeInfo = "SELECT 类型名称,ID FROM companyType WHERE 删除标志 = ";

        if (chkViewDel.Checked)
            strSQL_CmyTypeInfo += "删除标志";
        else
            strSQL_CmyTypeInfo += "0";

        DataSet dsCmyTypeInfo = dbConn.Query(strSQL_CmyTypeInfo);

        for (int i = 0; i < dsCmyTypeInfo.Tables[0].Rows.Count; i++)
        {
            ListItem lt = new ListItem(dsCmyTypeInfo.Tables[0].Rows[i][0].ToString(),
                                       dsCmyTypeInfo.Tables[0].Rows[i][1].ToString());
            lstCmyType.Items.Add(lt);
        }
    }

    protected void btnAdd_Click(object sender, EventArgs e)
    {
        lstCmyType.SelectedIndex = -1;

        txtCmyName.Text = "";
        txtRemark.Text = "";

        txtCmyName.Focus();

        btnModify.Text = "保存";
    }

    protected void btnDel_Click(object sender, EventArgs e)
    {
        string strIndex = lstCmyType.SelectedValue;

        if (null == strIndex)
            return;

        string strSQL_Del = "UPDATE companyType SET 删除标志 = 1 WHERE ID = " + strIndex;

        DBConnector dbConn = new DBConnector();
        int iRow = dbConn.Execute( strSQL_Del );
    }

    protected void btnModify_Click(object sender, EventArgs e)
    {
        string strSQL;
        SqlCommand sqlComm = null;
        
        if ( "保存" == btnModify.Text )
        {
            strSQL = "INSERT INTO companyType VALUES (@TypeName, @Remark, @DelFlag)";
            sqlComm = new SqlCommand(strSQL);

            sqlComm.Parameters.Add("@TypeName", SqlDbType.VarChar, 20);
            sqlComm.Parameters.Add("@Remark", SqlDbType.VarChar, 200);
            sqlComm.Parameters.Add("@DelFlag", SqlDbType.Int);

            sqlComm.Parameters["@TypeName"].Value = txtCmyName.Text;
            sqlComm.Parameters["@Remark"].Value = txtRemark.Text;
            sqlComm.Parameters["@DelFlag"].Value = "0";            
            
        }
        else if ( "修改" == btnModify.Text )
        {
            strSQL = "UPDATE companyType SET 类型名称=@TypeName,备注=@Remark WHERE ID=" + lstCmyType.SelectedValue;
            sqlComm = new SqlCommand( strSQL );

            sqlComm.Parameters.Add("@TypeName", SqlDbType.VarChar, 20);
            sqlComm.Parameters.Add("@Remark", SqlDbType.VarChar, 200);

            sqlComm.Parameters["@TypeName"].Value = txtCmyName.Text;
            sqlComm.Parameters["@Remark"].Value = txtRemark.Text;
        }

        DBConnector dbConn = new DBConnector();
        int iEffectRow = dbConn.Execute( sqlComm );

        if (  1== iEffectRow )
        {
            MessageBox.Show(this, "更新成功");        
        }
    }
}