iteam_update.aspx.cs

vc.net编程实现的教师数据库管理系统的实现

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

public partial class research_iteam_update : System.Web.UI.Page
{
    private string strConnect = ConfigurationSettings.AppSettings["ConnectionString"];
    protected void Page_Load(object sender, EventArgs e)
    {
        //所有代码必须放在if (!IsPostBack)的代码段中，否则出错
        if (!IsPostBack)
        {
            DropDownListDataBind();

            //接受另1页传的session项目编号变量
            String ser;
            ser = Session["xmbh"].ToString();
            //从人员表读
            //初始化sql连接
            SqlConnection objConnection = new SqlConnection("data source=localhost;database=new;user=sa; password=teacherdb");
            SqlCommand cm = new SqlCommand("iteam_read_xmnr", objConnection);
            //类型为存储过程
            cm.CommandType = CommandType.StoredProcedure;
            //申明存储过程变量
            cm.Parameters.Add(new SqlParameter("@xmnum", SqlDbType.Char, 12));
            cm.Parameters.Add(new SqlParameter("@xmyear", SqlDbType.Char, 4));
            cm.Parameters.Add(new SqlParameter("@xmclass", SqlDbType.Char, 2));
            cm.Parameters.Add(new SqlParameter("@xmname", SqlDbType.Char, 300));
            cm.Parameters.Add(new SqlParameter("@xmsource", SqlDbType.Char, 60));
            cm.Parameters.Add(new SqlParameter("@stime", SqlDbType.DateTime, 8));
            cm.Parameters.Add(new SqlParameter("@pznum", SqlDbType.Char, 200));
            cm.Parameters.Add(new SqlParameter("@endtime", SqlDbType.DateTime, 8));
            cm.Parameters.Add(new SqlParameter("@zzmoney", SqlDbType.Decimal, 5));
            cm.Parameters.Add(new SqlParameter("@xmprocess", SqlDbType.Char, 10));
            cm.Parameters.Add(new SqlParameter("@ettime", SqlDbType.DateTime, 8));
            cm.Parameters.Add(new SqlParameter("@etformal", SqlDbType.Char, 2));
            cm.Parameters.Add(new SqlParameter("@etnotice", SqlDbType.Char, 20));
            cm.Parameters.Add(new SqlParameter("@etforma", SqlDbType.Char, 40));
            cm.Parameters.Add(new SqlParameter("@kyclass", SqlDbType.Char, 1));


            cm.Parameters.Add(new SqlParameter("@class", SqlDbType.Char, 1));
            cm.Parameters.Add(new SqlParameter("@depart", SqlDbType.VarChar, 40));
            //给存储过程变量赋值，并确定参数是输入参数还是输出参数
            cm.Parameters["@xmnum"].Direction = ParameterDirection.Input;
            cm.Parameters["@xmnum"].Value = Session["xmbh"].ToString();
            cm.Parameters["@xmyear"].Direction = ParameterDirection.Output;
            cm.Parameters["@xmclass"].Direction = ParameterDirection.Output;
            cm.Parameters["@xmname"].Direction = ParameterDirection.Output;
            cm.Parameters["@xmsource"].Direction = ParameterDirection.Output;
            cm.Parameters["@stime"].Direction = ParameterDirection.Output;
            cm.Parameters["@pznum"].Direction = ParameterDirection.Output;
            cm.Parameters["@endtime"].Direction = ParameterDirection.Output;
            cm.Parameters["@zzmoney"].Direction = ParameterDirection.Output;
            cm.Parameters["@xmprocess"].Direction = ParameterDirection.Output;
            cm.Parameters["@ettime"].Direction = ParameterDirection.Output;
            cm.Parameters["@etformal"].Direction = ParameterDirection.Output;
            cm.Parameters["@etnotice"].Direction = ParameterDirection.Output;
            cm.Parameters["@kyclass"].Direction = ParameterDirection.Output;
            cm.Parameters["@class"].Direction = ParameterDirection.Output;
            cm.Parameters["@depart"].Direction = ParameterDirection.Output;
            cm.Parameters["@etforma"].Direction = ParameterDirection.Output;
            //将存储过程参数输出并赋给控件变量
            //打开连接
            cm.Connection.Open();
            //执行存储过程
            cm.ExecuteNonQuery();
            //给存储过程变量赋值 
            //项目年度
            DropDownList2.Text = cm.Parameters["@xmyear"].Value.ToString();
            //项目类别
            DropDownList1.Text = cm.Parameters["@xmclass"].Value.ToString();
            //项目名称
            TextBox1.Text = cm.Parameters["@xmname"].Value.ToString();
            //项目来源
            TextBox2.Text = cm.Parameters["@xmsource"].Value.ToString();
            //起始时间
            TextBox4.Text = System.Convert.ToDateTime(cm.Parameters["@stime"].Value).ToShortDateString();
            //批准编号
            TextBox3.Text = cm.Parameters["@pznum"].Value.ToString();
            //截至时间
            TextBox5.Text = System.Convert.ToDateTime(cm.Parameters["@endtime"].Value).ToShortDateString();
            //资助经费
            TextBox6.Text = cm.Parameters["@zzmoney"].Value.ToString();
            //项目进度
            DropDownList4.SelectedItem.Text = cm.Parameters["@xmprocess"].Value.ToString();
            //结束时间
            TextBox7.Text = System.Convert.ToDateTime(cm.Parameters["@ettime"].Value).ToShortDateString();
            //结题形式
            DropDownList5.SelectedItem.Text = cm.Parameters["@etforma"].Value.ToString();
            //结题意见
            TextBox8.Text = cm.Parameters["@etnotice"].Value.ToString();
            //科研类型
            DropDownList1.Text = cm.Parameters["@kyclass"].Value.ToString();

            //级别
            DropDownList6.Text = cm.Parameters["@class"].Value.ToString();
            //项目部门
            DropDownList3.Text = cm.Parameters["@depart"].Value.ToString();
            //Response.Write(cm.Parameters["@etforma"].Value.ToString());
            //Response.Write(cm.Parameters["@class"].Value.ToString());
            cm.Connection.Close();
            //count变量用于记录这个项目共有几个人参加
            int count;
            //index变量用于控制列表框文本是第几行
            int index;
            String ltemp;
            int lsnum;
            int smwc = 1;
            //初始化sql连接
            //读出有几人参与这个项目
            SqlConnection objConnection3 = new SqlConnection("data source=localhost;database=new;user=sa; password=teacherdb");
            SqlCommand cm3 = new SqlCommand("iteam_read_rynum", objConnection3);
            //类型为存储过程
            cm3.CommandType = CommandType.StoredProcedure;
            //申明存储过程变量
            cm3.Parameters.Add(new SqlParameter("@xmbh", SqlDbType.Char, 12));
            cm3.Parameters.Add(new SqlParameter("@jnum", SqlDbType.Int, 4));

            //给存储过程变量赋值，并确定参数是输入参数还是输出参数
            cm3.Parameters["@jnum"].Direction = ParameterDirection.Output;

            cm3.Parameters["@xmbh"].Value = Session["xmbh"].ToString();
            //打开连接并执行存储过程
            cm3.Connection.Open();

            cm3.ExecuteNonQuery();
            //记录这个项目有几人参与
            count = System.Convert.ToInt32(cm3.Parameters["@jnum"].Value);
            //关闭连接
            cm3.Connection.Close();
            //初始化sql连接
            SqlConnection objConnection2 = new SqlConnection("data source=localhost;database=new;user=sa; password=teacherdb");
            SqlCommand cm2 = new SqlCommand("iteam_read_xmry ", objConnection2);
            //类型为存储过程
            cm2.CommandType = CommandType.StoredProcedure;
            //申明存储过程变量
            cm2.Parameters.Add(new SqlParameter("@xmbh", SqlDbType.Char, 12));
            cm2.Parameters.Add(new SqlParameter("@jsnum", SqlDbType.Char, 7));
            cm2.Parameters.Add(new SqlParameter("@jsname", SqlDbType.Char, 8));
            cm2.Parameters.Add(new SqlParameter("@smwc", SqlDbType.Char, 2));
            cm2.Parameters.Add(new SqlParameter("@lsnum", SqlDbType.Int, 4));
            cm2.Parameters.Add(new SqlParameter("@department", SqlDbType.Char, 25));
            //给存储过程变量赋值，并确定参数是输入参数还是输出参数
            cm2.Parameters["@xmbh"].Direction = ParameterDirection.Input;
            cm2.Parameters["@lsnum"].Direction = ParameterDirection.Input;
            cm2.Parameters["@jsnum"].Direction = ParameterDirection.Output;
            cm2.Parameters["@smwc"].Direction = ParameterDirection.Output;
            cm2.Parameters["@jsname"].Direction = ParameterDirection.Output;
            cm2.Parameters["@department"].Direction = ParameterDirection.Output;
            //初始化sql连接
            //读出人员表中的流水号
            SqlConnection objConnection4 = new SqlConnection("data source=localhost;database=new;user=sa; password=teacherdb");
            SqlCommand cm4 = new SqlCommand("iteam_read_rylsnum ", objConnection4);
            //类型为存储过程
            cm4.CommandType = CommandType.StoredProcedure;
            //申明存储过程变量
            cm4.Parameters.Add(new SqlParameter("@xmbh", SqlDbType.Char, 12));

            cm4.Parameters.Add(new SqlParameter("@smwc", SqlDbType.Char, 2));
            cm4.Parameters.Add(new SqlParameter("@lsnum", SqlDbType.Int, 4));
            //给存储过程变量赋值，并确定参数是输入参数还是输出参数
            cm4.Parameters["@xmbh"].Direction = ParameterDirection.Input;
            cm4.Parameters["@lsnum"].Direction = ParameterDirection.Output;

            cm4.Parameters["@smwc"].Direction = ParameterDirection.Input;
            //打开连接
            cm4.Connection.Open();
            cm2.Connection.Open();
            //读1条记录向列表框插入
            for (index = 0; index < count; index++)
            {     //项目 编号
                cm4.Parameters["@xmbh"].Value = Session["xmbh"].ToString();
                //署名位次
                cm4.Parameters["@smwc"].Value = smwc.ToString();
                cm4.ExecuteNonQuery();
                //读出流水号
                lsnum = System.Convert.ToInt32(cm4.Parameters["@lsnum"].Value.ToString());
                cm2.Parameters["@xmbh"].Value = Session["xmbh"].ToString();
                cm2.Parameters["@lsnum"].Value = lsnum;

                cm2.ExecuteNonQuery();
                //读出教师信息
                //拼接成列表框内容
                ltemp = cm2.Parameters["@jsnum"].Value.ToString() + "," + cm2.Parameters["@jsname"].Value.ToString() + "," + cm2.Parameters["@smwc"].Value.ToString() + "," + cm2.Parameters["@department"].Value;
                //向列表框插入
                this.ListBox1.Items.Add(ltemp);
                smwc++;


            }
            //关闭连接
            cm4.Connection.Close();
            cm2.Connection.Close();

            
        }

    }
    protected void Button3_Click(object sender, EventArgs e)
    {
        DropDownList10.Items.Clear();
        //DropDownList10.Items.Insert(0, "两个以上用户，请选择");
        SqlConnection conn = new SqlConnection("data source=localhost;database=new;user=sa; password=teacherdb");
        conn.Open();
        SqlDataAdapter da = new SqlDataAdapter("select 姓名,所在单位,教师编号 from H_人事核心视图  where 姓名 like '" + TextBox9.Text + "%' order by 姓名", conn);
        DataSet ds = new DataSet();
        da.Fill(ds);
        //读取内容文件的数据到临时数组
        string[] temp = new string[ds.Tables[0].Rows.Count];
        int i = 0;
        foreach (DataRow dr in ds.Tables[0].Rows)
        {

            DropDownList10.Items.Insert(i, dr["所在单位"].ToString()); //+dr["所在单位"].ToString();
            //DropDownList10.SelectedItem.Text = dr["所在单位"].ToString();
            //DropDownList10.Items.FindByText(dr["所在单位"].ToString()).Selected = true;
            DropDownList10.SelectedIndex = i;
            TextBox11.Text= dr["教师编号"].ToString();
            i++;
        }
        if (i == 0)
        {
            DropDownList10.Items.Insert(0, "校外");
           TextBox11.Text = "9999999";
        }
        if(i==1)
        {
            //TextBox11.Text = dr["教师编号"].ToString();
            DropDownList10.Enabled = false;
            TextBox11.Enabled = false;
        }
        //将临时数组的内容赋给返回数组
        if (conn.State == ConnectionState.Open)