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;
}
}