phone.aspx.cs

学校的人事管理系统 适合初学者参考

                e.Row.Cells[1].Visible = false;
            }            
        }

        protected void LinkButton1_Command(object sender, CommandEventArgs e)
        {
            LinkButton eee = (LinkButton)sender;
            DataControlFieldCell dv = (DataControlFieldCell)eee.Parent;
            GridViewRow gvr = (GridViewRow)dv.Parent;
            int index = gvr.RowIndex;
            string ID = GridView1.Rows[index].Cells[1].Text;
            string No = Convert.ToString(index + 2);
            if (No.Length < 2)
            {
                No = "0" + No;
            }

            string gv = "GridView1$ctl" + No + "$ctl00";
            if (Request.Params[gv] != null)
            {
                string P = Request.Params[gv].ToString();
                SqlDataSource1.UpdateCommand = "UPDATE v_account set TelePhone ='" + P + "' where ID = '" + ID + "'";
                SqlDataSource1.Update();
            }
            string rr = GridView1.Rows[index].Cells[2].Text;
            string _rr = GridView1.Columns[3].HeaderText;
        }

        protected void chkSelectAll_Click(object sender, EventArgs e)
        {
            for (int i = 0; i < this.GridView1.Rows.Count; i++)
            {
                ((CheckBox)GridView1.Rows[i].FindControl("CheckBox1")).Checked = true;
            }
        }
        protected void delbtn_Click1(object sender, EventArgs e)
        {
            
            string ID = "";
            for (int i = 0; i < this.GridView1.Rows.Count; i++)
            {
                string No = Convert.ToString(i + 2);
                if (No.Length < 2)
                {
                    No = "0" + No;
                }

                string gv = "GridView1$ctl" + No + "$CheckBox1";//GridView1_ctl02_CheckBox1
               // bool isChecked = ((CheckBox)GridView1.Rows[i].FindControl(gv)).Checked;
                
                if (Request.Params[gv] != null)
                {
                    ID = ID + "," + GridView1.Rows[i].Cells[1].Text;
                    vv++;
                }                
                //((CheckBox)GridView1.Rows[i].FindControl("CheckBox1")).Checked = false;
            }
            if (vv == 0)
            {
                Response.Write("<script>alert(\"请先选择删除对象\")</script>");
            }
            else
            {
                if (ID.Length > 0)
                ID = ID.Substring(1);
                SqlDataSource1.UpdateCommand = "UPDATE v_account set TelePhone ='' where ID in (" + ID + ")";
                SqlDataSource1.Update();
                DataBind();
            }
        }

        protected void Button1_Click1(object sender, EventArgs e)
        {
            string _dsname = this.ddlSchool.SelectedItem.Text; ; //校机构选择的字段
            string _ddname = this.ddlDeperment.SelectedItem.Text; //本部门选择的字段
            string _dpname = this.ddlPerson.SelectedItem.Text; //联系人选择的字段
            string _ddd = this.ddlDeperment.SelectedValue;
            string phtxt = this.txtPhone.Text;

            if (this.ddlSchool.SelectedItem.Text == "--请选择--")
            {
                Response.Write("<script>alert(\"请选择校机构！\")</script>");
                this.ddlSchool.Focus();
            }
            else
            {
                if (this.ddlDeperment.SelectedItem.Text == "--请选择--")
                {
                    Response.Write("<script>alert(\"请选择本部门！\")</script>");
                    this.ddlDeperment.Focus();
                }
                else
                {
                    if (this.ddlPerson.SelectedItem.Text == "--请选择--")
                    {
                        Response.Write("<script>alert(\"请选择联系人！\")</script>");
                        this.ddlPerson.Focus();
                    }
                    else
                    {
                        if (txtPhone.Text == "" || txtPhone.Text == "()")
                        {
                            Response.Write("<script>alert(\"请输入电话！\")</script>");
                            this.txtPhone.Focus();
                        }
                        else
                        {                            
                            SqlDataSource1.UpdateCommand = "UPDATE v_account set TelePhone ='" + phtxt + "' where UserCName = '" + _dpname + "'";
                            SqlDataSource1.Update();
                            
                        }
                    }
                }
            }
        }

        protected void unchkSelectAll_Click(object sender, EventArgs e)
        {
            for (int i = 0; i < this.GridView1.Rows.Count; i++)
            {
                ((CheckBox)GridView1.Rows[i].FindControl("CheckBox1")).Checked = false;
            }
        }

        protected void ddlDeperment_SelectedIndexChanged(object sender, EventArgs e)
        {
            string ddlp = this.ddlDeperment.SelectedValue;
            SqlConnection conm = new SqlConnection(System.Configuration.ConfigurationManager.AppSettings.Get("den"));
            SqlDataAdapter daP = new SqlDataAdapter("SELECT Id, UserEName, UserCName, Office, OrderNum, UserKinds, "+
                "DocAdmin, SysAdmin, CompanyId, SignName, MobilePhone, OnlyKey, ChangeDateTime, ChangeTimes, Duty, Post, "+
                "PassWord, Disabled, TelePhone,(SELECT Company FROM dbo.Company WHERE (CompanyId = v_account.CompanyId)) "+
                "AS Company FROM v_account WHERE 1=1  and (TelePhone='' or TelePhone is null) and  CompanyId  = '" + this.ddlDeperment.SelectedValue + "'", conm);
            DataSet dse = new DataSet();
            daP.Fill(dse);
            this.ddlPerson.DataSource = dse;
            this.ddlPerson.DataTextField = "UserCName";
            this.ddlPerson.DataValueField = "id";
            this.ddlPerson.DataBind();
            this.ddlPerson.Items.Insert(0, "--请选择--");
            if (this.ddlSchool.SelectedItem.Text == "--请选择--")
            {
                this.ddlDeperment.SelectedItem.Text = "--请选择--";
                this.ddlPerson.SelectedItem.Text = "--请选择--";
            }
            Selbtn_Click(null, null);
        }

        protected void City_SelectedIndexChanged(object sender, EventArgs e)
        {
            string ccc = this.City.SelectedValue.ToString();
            string strconn = ConfigurationManager.AppSettings["den"];
            SqlConnection cn = new SqlConnection(strconn);
            cn.Open();
            string mysql = String.Format("SELECT City FROM PravinceCity WHERE PCID = " + ccc + "");
            SqlCommand cm = new SqlCommand(mysql, cn);
            SqlDataReader dr = cm.ExecuteReader();
            if (dr.Read())
            {
                if (dr[0] != null && dr[0].ToString()!="")
                    txtPhone.Text = "(" + dr[0].ToString() + ")";
                else
                    txtPhone.Text = "";
            }            
        }
        
        public string getUsername()
        {
            return Session["user"].ToString();
        }

        protected void province_SelectedIndexChanged(object sender, EventArgs e)
        {
            string rtt = this.province.SelectedValue.ToString();            
            
            SqlConnection conn = new SqlConnection(System.Configuration.ConfigurationManager.AppSettings.Get("den"));
            SqlDataAdapter daa = new SqlDataAdapter("SELECT PCName,PCID FROM PravinceCity WHERE PCID Like '" + rtt + "__'", conn);

            DataSet dss = new DataSet();
            daa.Fill(dss);
            this.City.DataSource = dss;
            this.City.DataTextField = "PCName";
            this.City.DataValueField = "PCID";
            this.City.DataBind();
            this.City.Items.Insert(0, "--请选择--");
            txtPhone.Text = "";
        }

        protected void GridView1_DataBound(object sender, EventArgs e)
        {

        }

        protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
        {

        }

        protected void LinkButton1_Click(object sender, EventArgs e)
        {

        }

        protected void LinkButton1_Click1(object sender, EventArgs e)
        {

        }

        protected void LinkButton1_Command1(object sender, CommandEventArgs e)
        {

        }
    }
}