private void Query() { //查询的时候先清空两个DataGridView表数据 //清空物料代码表数据 DataTable dt_User = (DataTable)dgv_User.DataSource; if (dt_User != null) { dt_User.Clear(); } DataTable dt_Menu = (DataTable)dgv_Menu.DataSource; if (dt_Menu != null) { dt_Menu.Clear(); } string strWhere = " WHERE 1=1"; if (txt_MaterialCode.Text != string.Empty)//料号 { strWhere += string.Format(" AND UserID='{0}'", txt_MaterialCode.Text.Trim()); } DataTable dt = BLL_SysDatUser.Select(strWhere); dgv_User.DataSource = dt; }
private void FrmUserEdit_Load(object sender, EventArgs e) { if (_Action_Type == true) { txt_Password.Visible = false; lbl_Pwd.Visible = false; DataTable dt = BLL_SysDatUser.Select(string.Format(" Where UserID='{0}'", _UserID)); if (dt.Rows.Count > 0) { txt_UserID.Text = _UserID; txt_UserName.Text = dt.Rows[0]["UserName"].ToString(); //txt_Password.Text = dt.Rows[0]["Password"].ToString(); dt_Menu = BLL_SysdatMenu.Select(_UserID); dgv_Menu.DataSource = dt_Menu; } } else { dt_Menu = BLL_SysdatMenu.Select(_UserID);//空值 dgv_Menu.DataSource = dt_Menu; } }