relmanage.aspx.cs

掌握计算机管理信息系统设计的一般方法

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 relmanage : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
     if (!Page.IsPostBack)
        {
            BindClassData();
            if (Session["jibie"].ToString().Equals("职工"))
            {
                Button1.Enabled = false;
                username.Enabled = false;
                pass.Enabled = false;
                jibie.Enabled = false;
            }
       }
    }
    private void BindClassData()
    {
        ///获取用户数据
        String s = "users";
          edit cla = new edit();
        DataSet dr = cla.GetInfro("select * from users,relation where users.username=relation.relationname");
        ///设置GridView的数据源，并绑定数据
       relationView.DataSource = dr;
        relationView.DataBind();//数据绑定
        ///关闭数据读取器
     //   dr.Close();
    }
    protected void relationView_RowEditing(object sender, GridViewEditEventArgs e)
    {
        String ctcodeID = null;
        ctcodeID = relationView.Rows[e.NewEditIndex].Cells[0].Text;
        Response.Redirect("update3.aspx?ctcodeID=" + ctcodeID);
    }
    protected void relationView_RowDeleting(object sender, GridViewDeleteEventArgs e)
    {
        string temp = relationView.Rows[e.RowIndex].Cells[0].Text;
        edit cla = new edit();
        String cmdtext = "delete from users   where username=" + "'" + temp + "'";
        cla.execute(cmdtext);
        Response.Write("<script>alert('" + "更新数据成功，请妥善保管好数据！" + "');</script>");
        BindClassData();
    }

    protected void Button1_Click(object sender, EventArgs e)
    {
        String cmdtext = "insert into users values("
            + "'" + username.Text.Trim() + "',"
            + "'" + pass.Text.Trim() + "',"
            + "'" + jibie.Text.Trim() + "')";
        int nResult = -1;
        SqlConnection myconnection = new SqlConnection(ConfigurationManager.ConnectionStrings["SQLCONNECTIONSTRING"].ConnectionString);
        SqlCommand mycommand = new SqlCommand(cmdtext, myconnection);
        try
        {
            ///打开链接
            myconnection.Open();
            ///执行SQL语句
            nResult = mycommand.ExecuteNonQuery();
        }
        catch (SqlException ex)
        {
            ///抛出异常
           /// throw new Exception(ex.Message, ex);
            int length = ex.Message.Length;
            string ec;
            if (ex.Message.Contains("\r\n"))
            {
                ec = ex.Message.Remove(length - 10);
            }
            else
            {

                ec = ex.Message.Remove(length - 1);
            }
            System.Web.HttpContext.Current.Response.Redirect("error.aspx?ec=" + ec); 
        }
        finally
        {   ///关闭链接

            myconnection.Close();
        }

        if (nResult != -1)
        {
            Response.Write("<script>alert('" + "添加新的职工！" + "');</script>");
            username.Text = "";
            pass.Text = "";
            jibie.Text = "";
            Response.Redirect("relmanage.aspx");

        }
       
    }
    protected void relationView_PageIndexChanging(object sender, GridViewPageEventArgs e)
    {
        relationView.PageIndex = e.NewPageIndex;
        BindClassData();
    }
}