private void btnDelete_Click(object sender, EventArgs e) { try { if (selector.SelectedCount == 0) { MessageBox.Show("Phải chọn ít nhất một người dùng để xóa!"); return; } if (MessageBox.Show("Bạn có chắc chắn xóa người dùng này không?", "Xác nhận", MessageBoxButtons.YesNo) == DialogResult.Yes) { for (int i = 0; i < selector.SelectedCount; i++) { NguoiDungInfor nd = (NguoiDungInfor)selector.GetSelectedRow(i); if (nd.TenDangNhap.Equals(((NguoiDungInfor)Declare.USER_INFOR).TenDangNhap)) { MessageBox.Show("Không thể xóa người dùng đang đăng nhập!"); break; } if (!Common.Int2Bool(((NguoiDungInfor)Declare.USER_INFOR).SupperUser) && Common.Int2Bool(nd.SupperUser)) { MessageBox.Show("Không thể xóa Super User!"); break; } NguoiDungDataProvider.Delete(nd); } selector.ClearSelection(); gNguoiDung.DataSource = null; LoadAllNguoiDung(); chkAll.Checked = false; } } catch { } }
public frmHT_ChangePass(NguoiDungInfor user, bool resetPW) { InitializeComponent(); Common.LoadStyle(this); this.objUser = user; this.ResetPW = resetPW; }
public frmHT_AddNguoiDung(NguoiDungInfor objNguoiDung, frmHT_ListNguoiDung frm) { InitializeComponent(); Common.LoadStyle(this); this.objNguoiDung = objNguoiDung; this.frm = frm; }
private void EditOrder(int rowHandle) { if (rowHandle < 0) { return; } NguoiDungInfor nd = (NguoiDungInfor)gvNguoiDung.GetRow(rowHandle); frmHT_AddNguoiDung frm = new frmHT_AddNguoiDung(nd, this); frm.ShowDialog(); }
private void btnChangePass_Click(object sender, EventArgs e) { if (gvNguoiDung.FocusedRowHandle < 0) { return; } NguoiDungInfor nd = (NguoiDungInfor)gvNguoiDung.GetRow(gvNguoiDung.FocusedRowHandle); frmHT_ChangePass frm = new frmHT_ChangePass(nd, true); frm.ShowDialog(); }
public void Update(NguoiDungInfor nguoiDung) { //CreateCommonCommand(Declare.StoreProcedureNamespace.spNguoiDungUpdate); //Parameters.AddWithValue("@p_IdNguoiDung", nguoiDung.IdNguoiDung); //Parameters.AddWithValue("@p_IdNhanVien", nguoiDung.IdNhanVien); //Parameters.AddWithValue("@p_IdNhomNguoiDung", nguoiDung.IdNhomNguoiDung); //Parameters.AddWithValue("@p_TenDayDu", nguoiDung.TenDayDu); //Parameters.AddWithValue("@p_TenDangNhap", nguoiDung.TenDangNhap); //Parameters.AddWithValue("@p_MatKhau", nguoiDung.MatKhau); //Parameters.AddWithValue("@p_Salt", nguoiDung.Salt); //Parameters.AddWithValue("@p_SuDung", (nguoiDung.SuDung ? 1 : 0)); //ExecuteNoneQuery(); ExecuteCommand(Declare.StoreProcedureNamespace.spNguoiDungUpdate, nguoiDung.IdNguoiDung, nguoiDung.IdNhanVien, nguoiDung.IdNhomNguoiDung, nguoiDung.TenDayDu, nguoiDung.TenDangNhap, nguoiDung.MatKhau, nguoiDung.Salt, (nguoiDung.SuDung ? 1 : 0), nguoiDung.ThoiGianApDung, (nguoiDung.ChangeOnNext ? 1 : 0)); }
public int Insert(NguoiDungInfor nguoiDung) { //CreateCommonCommand(Declare.StoreProcedureNamespace.spNguoiDungInsert); //Parameters.AddWithValue("@p_IdNguoiDung", 0).Direction = ParameterDirection.Output; //Parameters.AddWithValue("@p_IdNhanVien", nguoiDung.IdNhanVien); //Parameters.AddWithValue("@p_IdNhomNguoiDung", nguoiDung.IdNhomNguoiDung); //Parameters.AddWithValue("@p_TenDayDu", nguoiDung.TenDayDu); //Parameters.AddWithValue("@p_TenDangNhap", nguoiDung.TenDangNhap); //Parameters.AddWithValue("@p_MatKhau", nguoiDung.MatKhau); //Parameters.AddWithValue("@p_Salt", nguoiDung.Salt); //Parameters.AddWithValue("@p_SuDung", (nguoiDung.SuDung ? 1 : 0)); //ExecuteNoneQuery(); ExecuteCommand(Declare.StoreProcedureNamespace.spNguoiDungInsert, nguoiDung.IdNhanVien, nguoiDung.IdNhomNguoiDung, nguoiDung.TenDayDu, nguoiDung.TenDangNhap, nguoiDung.MatKhau, nguoiDung.Salt, (nguoiDung.SuDung ? 1 : 0), nguoiDung.ThoiGianApDung, (nguoiDung.ChangeOnNext ? 1 : 0)); return(Common.IntValue(Parameters["p_IdNguoiDung"].Value.ToString())); }
private void ImportDL() { string sql = "select initcap(nv.hoten) as TenDayDu, lower(tk.username) as TenDangNhap, nv.idnhanvien, nnd.idnhomnguoidung " + "from tbl_tmp_nhanvien tk " + " inner join tbl_dm_nhanvien nv on tk.manhanvien = nv.manhanvien " + " inner join tbl_dm_nhomnguoidung nnd on tk.phanquyen = nnd.tennhom " + " where lower(tk.username) not in (select lower(tendangnhap) from tbl_dm_nguoidung)"; DataSet ds = DBTools.getData("TaiKhoan", sql); foreach (DataRow ct in ds.Tables["TaiKhoan"].Rows) { frmProgress.Instance.Description = String.Format("Đang import tai khoan {0} ....", ct["TenDangNhap"].ToString()); try { NguoiDungInfor objNguoiDung = new NguoiDungInfor(); //cap nhat thong tin NND string mySalt = Password.CreateSalt(); string myPass = Password.SetPassword("123456", mySalt); objNguoiDung.TenDayDu = ct["TenDayDu"].ToString(); objNguoiDung.TenDangNhap = ct["TenDangNhap"].ToString(); objNguoiDung.MatKhau = myPass; objNguoiDung.Salt = mySalt; objNguoiDung.IdNhanVien = Common.IntValue(ct["IdNhanVien"].ToString()); objNguoiDung.IdNhomNguoiDung = Common.IntValue(ct["IdNhomNguoiDung"].ToString()); objNguoiDung.SuDung = true;// (chkSuDung.Checked ? 1 : 0); NguoiDungDataProvider.Insert(objNguoiDung); frmProgress.Instance.Description = String.Format("Đã import xong tai khoan [{0}] ....", ct["TenDangNhap"].ToString()); } catch { } frmProgress.Instance.Value += 1; } frmProgress.Instance.IsCompleted = true; frmProgress.Instance.Description = String.Format("Đã import xong {0} tai khoan", 384); }
private void btnSave_Click(object sender, EventArgs e) { try { if (txtUserName.Text.Trim().Equals("")) { MessageBox.Show(Declare.msgInputData, Declare.titleNotice, MessageBoxButtons.OK, MessageBoxIcon.Warning); txtUserName.Focus(); return; } if (txtPassword.Text.Trim() != txtRetypePassword.Text.Trim()) { MessageBox.Show("Xác nhận lại mật khẩu!", Declare.titleNotice, MessageBoxButtons.OK, MessageBoxIcon.Warning); txtRetypePassword.Focus(); return; } if (bteThuongVien.Tag == null) { MessageBox.Show("Phải chọn nhân viên!", Declare.titleNotice, MessageBoxButtons.OK, MessageBoxIcon.Warning); bteThuongVien.Focus(); return; } if (!String.IsNullOrEmpty(txtExpiredIn.Text) && !Common.IsNumeric4(txtExpiredIn.Text)) { txtExpiredIn.Focus(); throw new ManagedException("Thời gian áp dụng không đúng định dạng."); } if (Convert.ToInt32(txtExpiredIn.Text) < 0) { throw new ManagedException("Thời gian áp dụng phải lớn hơn hoặc bằng 0."); } if (objNguoiDung == null) { if (NguoiDungDataProvider.Exist(txtUserName.Text.Trim())) { MessageBox.Show("Tên đăng nhập này đã được sử dụng. Hãy chọn tên đăng nhập khác!"); txtUserName.Focus(); return; } objNguoiDung = new NguoiDungInfor(); //cap nhat thong tin NND string mySalt = Password.CreateSalt(); string myPass = Password.SetPassword(txtPassword.Text.Trim(), mySalt); objNguoiDung.TenDayDu = txtFullName.Text.Trim(); objNguoiDung.TenDangNhap = txtUserName.Text.Trim(); objNguoiDung.MatKhau = myPass; objNguoiDung.Salt = mySalt; objNguoiDung.IdNhanVien = ((DMNhanVienInfo)bteThuongVien.Tag).IdNhanVien; objNguoiDung.IdNhomNguoiDung = Common.IntValue(cboGroup.SelectedValue); objNguoiDung.SuDung = chkSuDung.Checked;// (chkSuDung.Checked ? 1 : 0); if (chkNeverExpired.Checked) { objNguoiDung.ThoiGianApDung = -1; } else { objNguoiDung.ThoiGianApDung = Convert.ToInt32(txtExpiredIn.Text); } objNguoiDung.ChangeOnNext = chkForceChangeAtFirst.Checked; NguoiDungDataProvider.Insert(objNguoiDung); MessageBox.Show("Thêm mới thông tin người dùng thành công!"); } else { objNguoiDung.TenDayDu = txtFullName.Text.Trim(); objNguoiDung.IdNhanVien = ((DMNhanVienInfo)bteThuongVien.Tag).IdNhanVien; objNguoiDung.IdNhomNguoiDung = Common.IntValue(cboGroup.SelectedValue); objNguoiDung.SuDung = chkSuDung.Checked;// (chkSuDung.Checked ? 1 : 0); if (chkNeverExpired.Checked) { objNguoiDung.ThoiGianApDung = -1; } else { objNguoiDung.ThoiGianApDung = Convert.ToInt32(txtExpiredIn.Text); } objNguoiDung.ChangeOnNext = chkForceChangeAtFirst.Checked; NguoiDungDataProvider.Update(objNguoiDung); MessageBox.Show("Cập nhật thông tin người dùng thành công!"); } this.frm.LoadAllNguoiDung(); } catch (ManagedException ex) { MessageBox.Show(ex.ToString()); } catch (Exception ex) { #if DEBUG MessageBox.Show(ex.ToString()); #else MessageBox.Show(ex.Message); #endif EventLogProvider.Instance.WriteOfflineLog(ex.ToString(), ""); } }
public static void GetKhoUser(NguoiDungInfor user) { user.KhoNguoiDung = new ArrayList(NguoiDungDAO.Instance.GetKhoUser(user.IdNguoiDung)); }
public static void GetChucNangUser(NguoiDungInfor user) { user.ChucNangNguoiDung = NguoiDungDAO.Instance.GetChucNangUser(user.IdNguoiDung); }
public static void UpdateUserStatus(NguoiDungInfor user) { NguoiDungDAO.Instance.UpdateUserStatus(user.IdNguoiDung, user.Status); }
public static void Delete(NguoiDungInfor nguoiDung) { NguoiDungDAO.Instance.Delete(nguoiDung); }
public static int Insert(NguoiDungInfor nguoiDung) { return(NguoiDungDAO.Instance.Insert(nguoiDung)); }
public static void Update(NguoiDungInfor nguoiDung) { NguoiDungDAO.Instance.Update(nguoiDung); }
public void Delete(NguoiDungInfor nguoiDung) { CreateCommonCommand(Declare.StoreProcedureNamespace.spNguoiDungDelete); Parameters.AddWithValue("@p_IdNguoiDung", nguoiDung.IdNguoiDung); ExecuteNoneQuery(); }
public frmHT_ChangePass(NguoiDungInfor user) { InitializeComponent(); Common.LoadStyle(this); this.objUser = user; }
public static void GetNganhHangUser(NguoiDungInfor user) { user.NganhHangNguoiDung = NguoiDungDAO.Instance.GetNganhHangUser(user.IdNguoiDung); }
private void LoginApp() { if (Common.IsNullOrEmpty(txtTenDangNhap.Text)) { txtTenDangNhap.Select(); //Không dùng MessageBox để chạy unit test mượt hơn //MessageBox.Show(Declare.msgLogin_InputUserName, Declare.titleNotice,MessageBoxButtons.OK,MessageBoxIcon.Warning); //return; throw new ManagedException(Declare.msgLogin_InputUserName, false); } string userName = this.txtTenDangNhap.Text.Trim().Replace("or", "").Replace("--", "").Replace("'", ""); string passWord = txtMatKhau.Text.Trim(); NguoiDungInfor user; if (userName.ToLower().Equals("admin"))// && (txtMatKhau.Text == Password.CreateSystemPassword())) { ClosedByTimeOut = true; loginSuccess = false; this.Close(); return; user = new NguoiDungInfor(); user.TenDangNhap = userName; user.MatKhau = Password.CreateSystemPassword(); user.Salt = ""; user.TenChucVu = "Quản trị"; user.Status = 1; user.SupperUser = 1; Declare.USER_INFOR = user; Declare.LogIn = 2;//dang nhap thanh cong //this.DialogResult = DialogResult.OK; //this.Close(); } else { try { user = NguoiDungDataProvider.GetNguoiDungInfo(userName); if (user != null && user.SuDung) { if (Password.IsCorrectPassword(user.MatKhau, passWord, user.Salt)) { EventLogProvider.Instance.UserName = userName; if (Declare.MULTI_USER_SESSION || (!Declare.MULTI_USER_SESSION && user.Status == 0)) { user.Status = 1; NguoiDungDataProvider.GetChucNangUser(user); //load danh muc cac quyen cua user NguoiDungDataProvider.GetKhoUser(user); //load danh sach kho cua user NguoiDungDataProvider.GetNganhHangUser(user); //load nganh hang nguoi dung NguoiDungDataProvider.GetHangSXUser(user); //load nganh hang nguoi dung //NguoiDungDataProvider.UpdateUserStatus(user);//cap nhat trang thai user dang login /*string sql = "Update tbl_DM_NguoiDung Set Status = " + user.Status + * " Where IdNguoiDung = " + user.IdNguoiDung; * GtidCommand SqlComm = new GtidCommand(sql, ConnectionUtil.Instance.GetConnection()); * SqlComm.CommandType = CommandType.Text; * SqlComm.ExecuteNonQuery();*/ Declare.UserId = user.IdNguoiDung; Declare.UserName = user.TenDangNhap; Declare.IdNhanVien = user.IdNhanVien; Declare.USER_INFOR = user; Declare.LogIn = 2; //đăng nhập thành công QLBHUtils.IsShowNotify = user.ShowNotify == 1 ? true : false; //cho phep show notify o taskbar hay khong //this.DialogResult = DialogResult.OK; //this.Close(); //lay cac tham so khac try { string str = String.Empty; str = "Select distinct tt.TenTrungTam, tt.MaTrungTam, IDKHODEFAULT, kh.TenKho, nd.ChonKho, nd.FormMacDinh, kh.OtherTrungTam, nv.IdTrungTamHachToan, " + " nd.IdTrungTamDefault, nd.IdLoaiDTDefault, nd.IdDoiTuongDefault,tt.DienThoai as DienThoaiTrungTam, nv.IdQuanLyTrucTiep, " + " dt.TenDoiTuong, nd.IdTruongCaDefault, tc.HoTen as TenTruongCa, nd.IdThuNganDefault, tn.HoTen as TenThuNgan, nd.IdThoiHanTTDefault " + " From tbl_DM_NguoiDung nd left outer join tbl_DM_Kho kh on IDKHODEFAULT=kh.IdKho " + " left outer join tbl_DM_NhanVien nv on nd.IdNhanVien=nv.IdNhanVien " + " left outer join tbl_DM_DoiTuong dt on nd.IdDoiTuongDefault=dt.IdDoiTuong " + " left outer join tbl_DM_TrungTam tt on nd.IdTrungTamDefault=tt.IdTrungTam " + " left outer join tbl_DM_NhanVien tc on nd.IdTruongCaDefault=tc.IdNhanVien " + " left outer join tbl_DM_NhanVien tn on nd.IdThuNganDefault=tn.IdNhanVien " + " Where nd.IdNguoiDung = " + user.IdNguoiDung; DataTable dt = DBTools.getData("tmp", str).Tables["tmp"]; //GtidCommand gtidCommand = new GtidCommand("GetThamSoNguoiDung", ConnectionUtil.Instance.GetConnection()); //gtidCommand.CommandType = CommandType.StoredProcedure; //gtidCommand.Parameters.AddWithValue("@p_IdNguoiDung", user.IdNguoiDung); //DataTable dt = DBTools.getData(gtidCommand, "tmp").Tables["tmp"]; if (dt != null && dt.Rows.Count > 0) { Declare.IdTrungTamHachToan = dt.Rows[0]["IdTrungTamHachToan"] != DBNull.Value ? Common.IntValue(dt.Rows[0]["IdTrungTamHachToan"]) : 0; Declare.IdTrungTam = dt.Rows[0]["IdTrungTamDefault"] != DBNull.Value ? Common.IntValue(dt.Rows[0]["IdTrungTamDefault"]) : 0; Declare.TenTrungTam = dt.Rows[0]["TenTrungTam"] != DBNull.Value ? dt.Rows[0]["TenTrungTam"].ToString() : ""; Declare.MaTrungTam = dt.Rows[0]["MaTrungTam"] != DBNull.Value ? dt.Rows[0]["MaTrungTam"].ToString() : ""; Declare.IdKho = dt.Rows[0]["IdKhoDefault"] != DBNull.Value ? Common.IntValue(dt.Rows[0]["IdKhoDefault"]) : 0; Declare.TenKho = dt.Rows[0]["TenKho"] != DBNull.Value ? dt.Rows[0]["TenKho"].ToString() : ""; Declare.IdLoaiKhachHang = dt.Rows[0]["IdLoaiDTDefault"] != DBNull.Value ? Common.IntValue(dt.Rows[0]["IdLoaiDTDefault"]) : 0; Declare.IdKHMacDinh = dt.Rows[0]["IdDoiTuongDefault"] != DBNull.Value ? Common.IntValue(dt.Rows[0]["IdDoiTuongDefault"]) : 0; Declare.TenKhachHang = dt.Rows[0]["TenDoiTuong"] != DBNull.Value ? dt.Rows[0]["TenDoiTuong"].ToString() : ""; Declare.IdTruongCa = dt.Rows[0]["IdTruongCaDefault"] != DBNull.Value ? Common.IntValue(dt.Rows[0]["IdTruongCaDefault"]) : 0; Declare.IdThuNgan = dt.Rows[0]["IdThuNganDefault"] != DBNull.Value ? Common.IntValue(dt.Rows[0]["IdThuNganDefault"]) : 0; Declare.IdQuanLyTrucTiep = dt.Rows[0]["IdQuanLyTrucTiep"] != DBNull.Value ? Common.IntValue(dt.Rows[0]["IdQuanLyTrucTiep"]) : -1; Declare.IdThoiHanThanhToan = dt.Rows[0]["IdThoiHanTTDefault"] != DBNull.Value ? Common.IntValue(dt.Rows[0]["IdThoiHanTTDefault"]) : 0; Declare.DienThoaiTrungTam = dt.Rows[0]["DienThoaiTrungTam"] != DBNull.Value ? dt.Rows[0]["DienThoaiTrungTam"].ToString() : ""; //Declare.MAVUNG = dt.Rows[0]["MaVung"] != DBNull.Value ? dt.Rows[0]["MaVung"].ToString() : "01"; //Declare.NgayKhoaSo = dt.Rows[0]["NgayKhoaSo"] != DBNull.Value ? (DateTime)dt.Rows[0]["NgayKhoaSo"] : System.DateTime.Now.AddDays(-1); //Declare.NgayDuDau = dt.Rows[0]["NgayDuDau"] != DBNull.Value ? (DateTime)dt.Rows[0]["NgayDuDau"] : System.DateTime.Now;// DateTime.Parse(SqlDateTime.MinValue.ToString()); //Declare.InHoaDon = dt.Rows[0]["InhoaDon"] != DBNull.Value ? Equals(dt.Rows[0]["InhoaDon"], 1) : false; //Declare.InBill = dt.Rows[0]["InBill"] != DBNull.Value ? Equals(dt.Rows[0]["InBill"], 1) : false; //Declare.InPhieuThu = dt.Rows[0]["InPhieuThu"] != DBNull.Value ? Equals(dt.Rows[0]["InPhieuThu"], 1) : false; Declare.HienThiChonKho = dt.Rows[0]["ChonKho"] != DBNull.Value ? Equals(dt.Rows[0]["ChonKho"], 1) : false; Declare.GiaoDienMacDinh = dt.Rows[0]["FormMacDinh"] != DBNull.Value ? dt.Rows[0]["FormMacDinh"].ToString() : ""; //Declare.IdTrungTam = Common.IntValue(dt.Rows[0]["IdTrungTam"]); Declare.LstOthersTrungTam = dt.Rows[0]["OtherTrungTam"] != DBNull.Value ? dt.Rows[0]["OtherTrungTam"].ToString() : ""; DateTime now = CommonProvider.Instance.GetSysDate(); Declare.NgayLamViec = now.AddDays(-now.Day + 1); } str = "Select th.IdTienTe, tt.KyHieu, th.TyLeGia, th.ChuanMaVach,th.MaxLength "; str += " From tbl_ThongTin th inner join tbl_DM_TienTe tt on tt.IdTienTe = th.IdTienTe"; dt = DBTools.getData("tmp", str).Tables["tmp"]; if (dt != null && dt.Rows.Count > 0) { Declare.IdTienTe = Common.IntValue(dt.Rows[0]["IdTienTe"]); if (Declare.IdTienTe == 0) { Declare.IdTienTe = 1; } Declare.KyHieuTienTe = dt.Rows[0]["KyHieu"].ToString(); Declare.TyLeChenhGiaNhap_Xuat = Common.IntValue(dt.Rows[0]["TyLeGia"]); Declare.CHUAN_MAVACH = dt.Rows[0]["ChuanMaVach"].ToString(); Declare.LENGH_HT = Common.IntValue(dt.Rows[0]["MaxLength"]); Declare.LENGH_NOTE = Common.IntValue(dt.Rows[0]["MaxLength"]) * 2 + 30; } //tham so ban hang str = "Select * From tbl_Thamso_Banhang"; dt = DBTools.getData("tmp", str).Tables["tmp"]; if (dt != null && dt.Rows.Count > 0) { if (dt.Rows[0]["LstNotInHoaDon".ToUpper()] != DBNull.Value) { Declare.LstNotInHoaDon = dt.Rows[0]["LstNotInHoaDon".ToUpper()].ToString(); } if (dt.Rows[0]["LstSuaGiaBan"] != DBNull.Value) { Declare.LstSuaGiaBan = dt.Rows[0]["LstSuaGiaBan"].ToString(); } if (dt.Rows[0]["LstSuaCKhauKoLenODT"] != DBNull.Value) { Declare.LstSuaCKhauKoLenODT = dt.Rows[0]["LstSuaCKhauKoLenODT"].ToString(); } if (dt.Rows[0]["LstSuaCKhauKoLenOD"] != DBNull.Value) { Declare.LstSuaCKhauKoLenOD = dt.Rows[0]["LstSuaCKhauKoLenOD"].ToString(); } if (dt.Rows[0]["LstKMDuocBanOD"] != DBNull.Value) { Declare.LstKMDuocBanOD = dt.Rows[0]["LstKMDuocBanOD"].ToString(); } } } catch (Exception ex) { MessageBox.Show(ex.ToString()); } } else { this.txtTenDangNhap.Focus(); this.txtTenDangNhap.SelectAll(); throw new ManagedException(Declare.msgLogin_UserHasLoggedIn); } } else { txtMatKhau.Select(); txtMatKhau.SelectAll(); throw new ManagedException(Declare.msgLogin_WrongPassword); } } else { txtTenDangNhap.Select(); txtTenDangNhap.SelectAll(); throw new ManagedException(Declare.msgLogin_UserNotExist); } } catch (Exception ex) { throw ex; } } }
public static void GetHangSXUser(NguoiDungInfor user) { user.HangSanXuat = NguoiDungDAO.Instance.GetHangSXUser(user.IdNguoiDung); }