usersform.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 depart_users_usersform : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            if (Request.QueryString["did"] != null)
            {
                HiddenField1.Value = Request.QueryString["did"];
            }
            if (GridView1.Rows.Count == 0)
            {
                norecord.Visible = true;
            }
            else
            {
                norecord.Visible = false;
            }

            string columdelete = MyCommon.getAuthorization();
            if (columdelete[0] == '1')
            {
                GridView1.Columns[5].Visible = true;
                GridView1.Columns[6].Visible = true;
                btn.Visible = true;
            }
            else
            {
                GridView1.Columns[5].Visible = false;
                GridView1.Columns[6].Visible = false;
                btn.Visible = false;
            }
            //GridView1.Columns
        }
    }
    protected void GridView1_SelectedIndexChanged(object sender, EventArgs e)
    {
        string com;
        //string uid = GridView1.Rows[GridView1.SelectedIndex].Cells[0].Text;
        string logname = GridView1.Rows[GridView1.SelectedIndex].Cells[2].Text;
        //com = "delete from user where id= CONVERT (int, '" + uid + "')";
        com = "delete from [user] where logname='" + logname+"'";
        SqlConnection sqlcon = new SqlConnection(MyCommon.getConnectstr());
        SqlCommand sqlcom = new SqlCommand(com, sqlcon);
        sqlcon.Open();
        sqlcom.ExecuteNonQuery();
        sqlcon.Close();
        GridView1.DataBind();
    }
}