/// <summary> /// 将用户绑定到lue上。 /// </summary> /// <param name="lueControl"></param> public static void FillLueUser(DevExpress.XtraEditors.LookUpEdit lueControl) { //设置显示格式和字段 lueControl.Properties.Appearance.Font = new System.Drawing.Font("SimSun", 10.5F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(134))); lueControl.Properties.Appearance.Options.UseFont = true; lueControl.Properties.AppearanceDropDown.Font = new System.Drawing.Font("SimSun", 10.5F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(0))); lueControl.Properties.AppearanceDropDown.Options.UseFont = true; lueControl.Properties.Columns.Clear(); lueControl.Properties.Columns.AddRange(new DevExpress.XtraEditors.Controls.LookUpColumnInfo[] { new DevExpress.XtraEditors.Controls.LookUpColumnInfo("F_USER_ID", "用户编号") , new DevExpress.XtraEditors.Controls.LookUpColumnInfo("F_USER_NAME", "用户名") }); lueControl.Properties.DisplayMember = "F_USER_NAME"; lueControl.Properties.ValueMember = "F_USER_ID"; lueControl.Properties.TextEditStyle = TextEditStyles.DisableTextEditor; ProxyBllSYSTEM_USER bllSystemUser = new ProxyBllSYSTEM_USER(); //获得数据集 DataSet dsUsers = bllSystemUser.GetAllList(); //有数据情况下绑定 if (dsUsers != null && dsUsers.Tables.Count > 0) { lueControl.Properties.DataSource = dsUsers.Tables[0]; } }
private void btnLoing_Click(object sender, EventArgs e) { string userid = ""; string password = ""; if (txtUserid.Text.Trim().Equals("")) { MessageBox.Show("请输入登录用户名!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); txtUserid.Focus(); return; } else if (txtPassword.Text.Trim().Equals("")) { MessageBox.Show("请输入登录用户密码!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); txtPassword.Focus(); return; } userid = txtUserid.Text.Trim(); password = txtPassword.Text.Trim(); password = RelayTest.Util.DBUtility.DESEncrypt.Encrypt(txtPassword.Text.Trim()); ProxyBllSYSTEM_USER bllSystemUser = new ProxyBllSYSTEM_USER(); DataSet dsUser = bllSystemUser.GetList(" F_USER_ID='" + userid + "' AND F_PASSWORD='******'"); if (dsUser != null && dsUser.Tables[0].Rows.Count != 0) { AppGlobal.GUserId = userid; AppGlobal.GUserName = dsUser.Tables[0].Rows[0]["F_USER_NAME"].ToString(); Close(); } else { login_failure_count = login_failure_count + 1; if (login_failure_count < 3) { MessageBox.Show("输入的用户名或密码不正确,请重新输入!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); return; } else { MessageBox.Show("输入的用户名或密码不正确,错误次数已达到3次,登录错误!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); AppGlobal.GUserId = "未登录"; AppGlobal.GUserName = "******"; AppGlobal.GLoginName = "未登录"; Close(); } } }