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();
        }
Esempio n. 6
0
        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));
        }
Esempio n. 7
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(), "");
            }
        }
Esempio n. 10
0
 public static void GetKhoUser(NguoiDungInfor user)
 {
     user.KhoNguoiDung = new ArrayList(NguoiDungDAO.Instance.GetKhoUser(user.IdNguoiDung));
 }
Esempio n. 11
0
 public static void GetChucNangUser(NguoiDungInfor user)
 {
     user.ChucNangNguoiDung = NguoiDungDAO.Instance.GetChucNangUser(user.IdNguoiDung);
 }
Esempio n. 12
0
 public static void UpdateUserStatus(NguoiDungInfor user)
 {
     NguoiDungDAO.Instance.UpdateUserStatus(user.IdNguoiDung, user.Status);
 }
Esempio n. 13
0
 public static void Delete(NguoiDungInfor nguoiDung)
 {
     NguoiDungDAO.Instance.Delete(nguoiDung);
 }
Esempio n. 14
0
 public static int Insert(NguoiDungInfor nguoiDung)
 {
     return(NguoiDungDAO.Instance.Insert(nguoiDung));
 }
Esempio n. 15
0
 public static void Update(NguoiDungInfor nguoiDung)
 {
     NguoiDungDAO.Instance.Update(nguoiDung);
 }
Esempio n. 16
0
 public void Delete(NguoiDungInfor nguoiDung)
 {
     CreateCommonCommand(Declare.StoreProcedureNamespace.spNguoiDungDelete);
     Parameters.AddWithValue("@p_IdNguoiDung", nguoiDung.IdNguoiDung);
     ExecuteNoneQuery();
 }
Esempio n. 17
0
 public frmHT_ChangePass(NguoiDungInfor user)
 {
     InitializeComponent();
     Common.LoadStyle(this);
     this.objUser = user;
 }
Esempio n. 18
0
 public static void GetNganhHangUser(NguoiDungInfor user)
 {
     user.NganhHangNguoiDung = NguoiDungDAO.Instance.GetNganhHangUser(user.IdNguoiDung);
 }
Esempio n. 19
0
        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;
                }
            }
        }
Esempio n. 20
0
 public static void GetHangSXUser(NguoiDungInfor user)
 {
     user.HangSanXuat = NguoiDungDAO.Instance.GetHangSXUser(user.IdNguoiDung);
 }