学步园

回忆码农这一道、基本可以用正文的代码概括。

现遭遇1年之痒，有些迷茫，有些疲惫。求大神指引。

看别人共享的代码和论道，感觉都好有深度哦~~。

     

  /// *****************大二时候码的代码***********************
        protected void Button1_Click(object sender, EventArgs e)
        {
            string connString = "data source =.;user id =sa;password=123456;";
            SqlConnection sConn = new SqlConnection(connString);
            sConn.Open();
            SqlDataAdapter sda = new SqlDataAdapter("select * from user", sConn);
            DataSet ds = new DataSet();
            sda.Fill(ds, "用户表");
            GridView1.DataSource = ds;
            GridView1.DataMember = ds.Tables[0].TableName;
            GridView1.DataBind();
        }

///*****************大四毕业设计时候用的代码*****************
        protected void Button1_Click(object sender, EventArgs e)
        {
            SQLHelper sqlHelper = new SQLHelper();
            string cmd = "select * from user where username ='" + TextBox1.Text + "'";
            DataSet ds = new DataSet();
            ds = sqlHelper.SearchData(cmd);
            GridView1.DataSource = ds;
            GridView1.DataMember = ds.Tables[0].TableName;
            GridView1.DataBind();
        }

       

///*******************入职培训后用的代码****************

        #region 事件
        #region 根据检索条件检索用户信息
        /// <summary>
        /// 根据检索条件检索用户信息
        /// </summary>
        protected void btnSearchUserInfo_Click(object sender, EventArgs e)
        {
            try
            {
                SQLHelper sqlHelper = new SQLHelper();
                string strUserName = txtUserName.Text.Trim();//用户姓名
                string strDepartmentName = txtDepartmentName.Text.Trim();//用户所属部门
                string cmd = string.Format("select * from D_1_User where vcUserName like '%{0}%' and vcDepartment like '%{1}% '", strUserName, strDepartmentName);
                DataTable dtUser = new DataTable();
                dtUser = sqlHelper.SearchByCMDText(cmd);
                gvUser.DataSource = dtUser;
                gvUser.DataBind();
            }
            catch (Exception ex)
            {
                this.RecordLogsAndShowMessageBox(ex, LogType.ApplicationError, MessageType.FailedSearch);
            }
        }
        #endregion
        #endregion

  

    ///*******************转正后码的代码****************
        #region 事件
        #region 根据检索条件检索用户信息
        /// <summary>
        /// 根据检索条件检索用户信息
        /// </summary>
        protected void btnSearchUserInfo_Click(object sender, EventArgs e)
        {
            try
            {
                string strUserName = txtUserName.Text.Trim();//用户姓名
                string strDepartmentID = ddlDepartment.SelectedValue;//用户所属部门ID
                DataTable dtUser = SearchUserInfo(strUserName, strDepartmentID);//获取用户数据
                BindGridView(dtUser);//绑定用户数据到GridView
            }
            catch (Exception ex)
            {
                this.RecordLogsAndShowMessageBox(ex, LogType.ApplicationError, MessageType.FailedSearch);
            }
        }
        #endregion
        #endre

    ///*******************毕业一年后的现在*********************
        #region 事件
        #region 根据检索条件检索用户信息
        /// <summary>
        /// 根据检索条件检索用户信息
        /// </summary>
        protected void btnSearchUserInfo_Click(object sender, EventArgs e)
        {
            try
            {
                string strEmployeeName = txtEmployeeName.Text.Trim();//员工姓名
                string strEmployeeID = txtEmployeeID.Text.Trim();//员工编号
                string strDepartmentID = ddlDepartment.SelectedValue;//用户所属部门ID
                string strAge= txtAge.Text.Trim();//年龄

                D_1_Entity d_1_Entity = new D_1_Entity();//用户实体初始化
                d_1_Entity._EmployeeName   = strEmployeeName;
                d_1_Entity._EmployeeID = strEmployeeID;
                d_1_Entity._DepartmentID = strDepartmentID;
                d_1_Entity._Age = strAge;
                DataTable dtUser = d_1_Entity.GetData();//获取用户数据
                BindGridView(dtUser);//绑定用户数据到GridView
            }
            catch (NoteException ex)
            {
                this.ShowMessageBox(ex, MessageType.FailedSearch);
            }
            catch (Exception ex)
            {
                this.RecordLogsAndShowMessageBox(ex, LogType.ApplicationError, MessageType.FailedSearch);
            }
        }
        #endregion
        #endregion