bool checkUser(string uid, string pass, ref string group_list) { string strCmd = ""; string _pass = mahoa.mahoa(pass); bool b = false; SqlDataAdapter adapter = new SqlDataAdapter(); strCmd = "select group_list,tennv from _User where user_id='" + uid + "' and user_pass='******'"; conn.Open(); myCommand = new SqlCommand(strCmd, conn); //myCommand.CommandText = "select group_list from _User where user_id='" + uid + "' and user_pass='******'"; reader = myCommand.ExecuteReader(); //adapter.SelectCommand = new SqlCommand(strCmd, frmMain.conn); //reader = adapter.SelectCommand.ExecuteReader(); //olecom.CommandText= "select group_list from _User where user_id='"+uid+"' and user_pass='******'"; //reader=olecom.ExecuteReader(); if (reader.Read()) { group_list = reader.GetString(0); b = true; hoten = reader.GetString(1); } reader.Close(); conn.Close(); return(b); }
private void layDanhsach() { dgvDanhsach.Refresh(); DataTable dtDanhsach = new DataTable(); DataColumn col = null; col = new DataColumn("STT", typeof(int)); dtDanhsach.Columns.Add(col); col = new DataColumn("Mã CN", typeof(string)); dtDanhsach.Columns.Add(col); col = new DataColumn("Tên đăng nhập", typeof(string)); dtDanhsach.Columns.Add(col); col = new DataColumn("Mật khẩu", typeof(string)); dtDanhsach.Columns.Add(col); col = new DataColumn("Họ tên", typeof(string)); dtDanhsach.Columns.Add(col); col = new DataColumn("Nhóm người dùng", typeof(string)); dtDanhsach.Columns.Add(col); col = new DataColumn("Phòng ban", typeof(string)); dtDanhsach.Columns.Add(col); col = new DataColumn("Chức vụ", typeof(string)); dtDanhsach.Columns.Add(col); col = new DataColumn("Ghi chú", typeof(string)); dtDanhsach.Columns.Add(col); //strCmd = "Select nv.*, pb.TenPB from _USER as nv left join PHONGBAN as pb on (nv.MACN=pb.MACN and nv.MAPB=pb.MAPB) "; //strCmd += " Where nv.MACN='" + cbbMaCN.SelectedValue.ToString() + "' and nv.maPB='" + arrPhong[cbbPhong.Items.IndexOf(cbbPhong.Text.Trim())].ToString() + "' "; strCmd = "Select nv.*, pb.TenPB from _USER as nv left join PHONGBAN as pb on (nv.MACN=pb.MACN and nv.MAPB=pb.MAPB) "; strCmd += " Where nv.MACN='" + cbbMaCN.SelectedValue.ToString() + "' and nv.maPB='" + cbbPhong.SelectedValue.ToString() + "' "; SqlDataAdapter adapter = new SqlDataAdapter(); try { if (frmMain.conn.State == ConnectionState.Open) { frmMain.conn.Close(); } frmMain.conn.Open(); adapter.SelectCommand = new SqlCommand(strCmd, frmMain.conn); adapter.SelectCommand.ExecuteReader(); frmMain.conn.Close(); } catch { if (frmMain.conn.State == ConnectionState.Open) { frmMain.conn.Close(); } } DataSet ds = new DataSet(); adapter.Fill(ds); dtResult = ds.Tables[0]; int iRows = dtResult.Rows.Count; for (int i = 0; i < iRows; i++) { try { DataRow row = dtDanhsach.NewRow(); row[0] = i + 1; row[1] = dtResult.Rows[i]["MaCN"].ToString(); row[2] = dtResult.Rows[i]["User_ID"].ToString(); string pass = dtResult.Rows[i]["User_Pass"].ToString(); pass = mahoa.mahoa(pass); row[3] = pass; row[4] = dtResult.Rows[i]["TenNV"].ToString(); String groupList = dtResult.Rows[i]["group_list"].ToString(); string[] groupID = groupList.Split(','); string groupName = ""; foreach (string id in groupID) { string str = "select * from _group Where Group_ID='" + id + "' "; SqlDataAdapter adapter1 = new SqlDataAdapter(); try { if (frmMain.conn.State == ConnectionState.Open) { frmMain.conn.Close(); } frmMain.conn.Open(); adapter1.SelectCommand = new SqlCommand(str, frmMain.conn); adapter1.SelectCommand.ExecuteReader(); frmMain.conn.Close(); } catch { if (frmMain.conn.State == ConnectionState.Open) { frmMain.conn.Close(); } } DataSet ds1 = new DataSet(); adapter1.Fill(ds1); DataTable dtResult1 = ds1.Tables[0]; try { if (groupName == "") { groupName = dtResult1.Rows[0]["group_Name"].ToString(); } else { groupName += "," + dtResult1.Rows[0]["group_Name"].ToString(); } } catch { } } row[5] = groupName; row[6] = dtResult.Rows[i]["TenPB"].ToString(); row[7] = dtResult.Rows[i]["Chucvu"].ToString(); row[8] = dtResult.Rows[i]["Ghichu"].ToString(); dtDanhsach.Rows.Add(row); } catch { if (frmMain.conn.State == ConnectionState.Open) { frmMain.conn.Close(); } } } dgvDanhsach.DataSource = dtDanhsach; dgvDanhsach.ColumnHeadersDefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter; dgvDanhsach.Columns[0].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight; dgvDanhsach.Columns[0].Width = 50; dgvDanhsach.Columns[1].Width = 80; dgvDanhsach.Columns[2].Width = 150; dgvDanhsach.Columns[3].Width = 120; dgvDanhsach.Columns[3].Visible = false; dgvDanhsach.Columns[4].Width = 200; dgvDanhsach.Columns[5].Width = 300; dgvDanhsach.Columns[6].Width = 200; dgvDanhsach.Columns[7].Width = 150; dgvDanhsach.Columns[8].Width = 200; }
private void btnSave_Click(object sender, EventArgs e) { if (txtPass_old.Text == "") { MessageBox.Show("Chưa nhập mật khẩu cũ."); txtPass_old.Focus(); return; } else if (txtPass_new.Text == "") { MessageBox.Show("Chưa nhập mật khẩu mới."); txtPass_new.Focus(); return; } else if (txtConfirm.Text == "") { MessageBox.Show("Chưa xác nhận mật khẩu mới."); txtConfirm.Focus(); return; } if (txtPass_old.Text != frmDangnhap.matkhau) { MessageBox.Show("Mật khẩu cũ không đúng."); txtPass_old.Focus(); return; } if (txtConfirm.Text != txtConfirm.Text) { MessageBox.Show("Mật khẩu mới không giống nhau."); txtPass_new.Text = ""; txtConfirm.Text = ""; txtPass_new.Focus(); return; } string pass_new = txtPass_new.Text; string pass_confirm = txtConfirm.Text; strCmd = "SELECT * FROM _User WHERE User_ID='" + frmDangnhap.UserID + "' "; SqlDataAdapter adapter = new SqlDataAdapter(); try { if (frmMain.conn.State == ConnectionState.Open) { frmMain.conn.Close(); } frmMain.conn.Open(); adapter.SelectCommand = new SqlCommand(strCmd, frmMain.conn); adapter.SelectCommand.ExecuteNonQuery(); frmMain.conn.Close(); } catch { if (frmMain.conn.State == ConnectionState.Open) { frmMain.conn.Close(); } } DataSet ds = new DataSet(); adapter.Fill(ds); dtResult = ds.Tables[0]; if (dtResult.Rows.Count > 0) { pass_new = mahoa.mahoa(pass_new); pass_confirm = mahoa.mahoa(pass_confirm); strCmd = "Update _User Set User_pass='******' Where User_ID='" + frmDangnhap.UserID + "' "; try { if (frmMain.conn.State == ConnectionState.Open) { frmMain.conn.Close(); } frmMain.conn.Open(); adapter.UpdateCommand = new SqlCommand(strCmd, frmMain.conn); adapter.UpdateCommand.ExecuteNonQuery(); frmMain.conn.Close(); MessageBox.Show("Đã thay đổi.", "Thông báo"); txtPass_old.Text = ""; txtPass_new.Text = ""; txtConfirm.Text = ""; } catch { if (frmMain.conn.State == ConnectionState.Open) { frmMain.conn.Close(); } } } }