default.aspx.cs

这是asp.net^和Visual C++Sharp编写的串并口通讯的书籍 源代码

using System;
using System.Data;
using System.Configuration;
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;
using System.Data.SqlClient;

public partial class _Default : System.Web.UI.Page 
{
    SqlConnection sqlcon;
    SqlCommand sqlcom;
    SqlDataAdapter myda;
    DataSet myds;
    string strCon = "Data Source=(local);Database=db_05;Uid=sa;Pwd=";
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            Namebind();
            GVbind();
            for (int i = 0; i < CheckBoxList1.Items.Count; i++)
            {
                CheckBoxList1.Items[i].Selected = true;
            }
        }
    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        GVbind();
    }
    protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e)
    {
        GridView1.PageIndex = e.NewPageIndex;
        GVbind();
    }
    //绑定GridView控件
    protected void GVbind()
    {
        sqlcon = new SqlConnection(strCon);
        sqlcom = new SqlCommand("proc_clairvoyant_table", sqlcon);
        sqlcom.CommandType = CommandType.StoredProcedure;
        sqlcom.Parameters.Add("@TableName", SqlDbType.VarChar, 50).Value = "员工信息表";
        sqlcom.Parameters.Add("@PageFieldByColumn", SqlDbType.VarChar, 50).Value = "dept";
        sqlcom.Parameters.Add("@RowFieldByColumn", SqlDbType.VarChar, 50).Value = "name";
        sqlcom.Parameters.Add("@ColumnFieldByColumn", SqlDbType.VarChar, 50).Value = "duty";
        sqlcom.Parameters.Add("@PageFieldValue", SqlDbType.VarChar, 50).Value = "";
        if (CheckBox1.Checked)
        {
            sqlcom.Parameters.Add("@RowFieldValue", SqlDbType.VarChar, 200).Value = "";
        }
        else
        {
            string strRow = "";
            for (int i = 0; i < CheckBoxList1.Items.Count; i++)
            {
                if (CheckBoxList1.Items[i].Selected == true)
                    strRow += CheckBoxList1.Items[i].Text.Trim() + ",";
            }
            sqlcom.Parameters.Add("@RowFieldValue", SqlDbType.VarChar, 200).Value = strRow;
        }
        sqlcom.Parameters.Add("@ColumnFieldValue", SqlDbType.VarChar, 200).Value = "";
        sqlcom.Parameters.Add("@DataFieldByColumn", SqlDbType.VarChar, 50).Value = "salary";
        sqlcom.Parameters.Add("@DataFieldOperateMethod", SqlDbType.VarChar, 10).Value = "SUM";
        myda = new SqlDataAdapter();
        myda.SelectCommand = sqlcom;
        myds = new DataSet();
        myda.Fill(myds);
        GridView1.DataSource = myds;
        GridView1.DataBind();
    }
    //绑定员工姓名
    protected void Namebind()
    {
        sqlcon = new SqlConnection(strCon);
        myda = new SqlDataAdapter("select distinct name from 员工信息表", sqlcon);
        myds = new DataSet();
        myda.Fill(myds);
        CheckBoxList1.DataSource = myds;
        CheckBoxList1.DataTextField = "name";
        CheckBoxList1.DataBind();
    }
    protected void CheckBox1_CheckedChanged(object sender, EventArgs e)
    {
        if (CheckBox1.Checked)
        {
            for (int i = 0; i < CheckBoxList1.Items.Count; i++)
            {
                CheckBoxList1.Items[i].Selected = true;
            }
        }
        else
        {
            for (int i = 0; i < CheckBoxList1.Items.Count; i++)
            {
                CheckBoxList1.Items[i].Selected = false;
            }
        }
    }
}