Exemple #1
0
        public void loadAllNotifi()
        {
            string    sqlQuery = "select IDThongBao,TieuDe,NoiDung,NgayDang, NguoiDang, HoThanhVien + ' ' + TenThanhVien as HoTen from ThongBao,ThanhVien where ThongBao.NguoiDang = ThanhVien.IDThanhVien and IDThongBao = " + caseData.DataTam.DuLieu.idTemp;
            DataTable dt       = dalnotifi.getNotifi(sqlQuery);

            XuLyChuoi.checkLink checklink = new XuLyChuoi.checkLink();
            List <checkLink>    link      = checklink.DetectLink(dt.Rows[0]["NoiDung"].ToString());

            frmnotification.lb_PosterFullName.Text = dt.Rows[0]["HoTen"].ToString();
            DateTime ngay = Convert.ToDateTime(dt.Rows[0]["NgayDang"].ToString());

            frmnotification.lb_DateTime.Text = "Thời gian: " + ngay.ToString("dd/MM/yyyy hh:mm:ss tt");
            frmnotification.lb_TieuDe.Text   = dt.Rows[0]["TieuDe"].ToString();
            frmnotification.tb_BaiViet.Text  = dt.Rows[0]["NoiDung"].ToString();
            int x = 5;

            for (int i = 0; i < link.Count; i++)
            {
                linklb_Link           = new LinkLabel();
                linklb_Link.AutoSize  = true;
                linklb_Link.LinkColor = System.Drawing.Color.FromArgb(0, 0, 254);
                linklb_Link.Location  = new System.Drawing.Point(x, 26);
                linklb_Link.Name      = "linklb" + i;
                linklb_Link.TabIndex  = i;
                linklb_Link.TabStop   = true;
                linklb_Link.Text      = link[i].getContent();
                linklb_Link.Links.Add(0, link[i].getContent().Length, link[i].getContent());
                linklb_Link.LinkClicked += new LinkLabelLinkClickedEventHandler(linkClick);

                frmnotification.pn_Link.Controls.Add(linklb_Link);
                x += linklb_Link.Size.Width + 10;
            }
        }
Exemple #2
0
        public void loadInfo()
        {
            string    sqlMember = "select IDThanhVien,HoThanhVien + ' ' + TenThanhVien as HoTen, GioiTinh, NgaySinh,DiaChiCuThe,TenXa,TenHuyen,TenTinh,SDT,MSSV,Khoa,Lop,LinkFB,AnhDaiDien,TenChucVu from ChucVu,ThanhVien, DiaChi,Tinh,Huyen,Xa where ThanhVien.IDDiaChi = DiaChi.IDDiaChi and DiaChi.IDXa = Xa.IDXa and Xa.IDHuyen = Huyen.IDHuyen and Huyen.IDTinh = Tinh.IDTinh and ThanhVien.IDChucVu =  ChucVu.IDChucVu and MSSV =  '" + caseData.DataTam.DuLieu.idTemp + "';";
            DataTable dtInfo    = dalmember.getTable(sqlMember);

            XuLyChuoi.checkLink checklink = new XuLyChuoi.checkLink();
            if (dtInfo.Rows.Count < 1)
            {
                caseData.txtRead        txtread = new caseData.txtRead();
                logical.GgSheetAPI      ggsheet = new logical.GgSheetAPI();
                string[]                idTable = txtread.readfile(0);
                IList <IList <Object> > values  = ggsheet.docfile(idTable[1], idTable[2]);
                int       id                    = int.Parse(caseData.DataTam.DuLieu.idTemp);
                string    sqlBirthDay           = "SELECT * FROM [ThanhVien],[ChucVu] where ThanhVien.IDChucVu = ChucVu.IDChucVu and MSSV = '" + values[id][1].ToString() + "';";
                DataTable dt                    = dalmember.getTable(sqlBirthDay);
                List <XuLyChuoi.checkLink> link = checklink.DetectLink(values[id][10].ToString());
                frmMemberInfor.lb_HoTen.Text = (values[id][2].ToString() + " " + values[id][3].ToString()).ToUpper();
                if (dt.Rows.Count > 0)
                {
                    if (dt.Rows[0]["RoiCLB"].ToString() == "")
                    {
                        frmMemberInfor.lb_HoTen.Text += " - ĐÃ LÀ THÀNH VIÊN!";
                    }
                    else
                    {
                        frmMemberInfor.lb_HoTen.Text += " - ĐÃ RỜI CLB NGÀY: " + dt.Rows[0]["RoiCLB"].ToString();
                    }
                    try
                    {
                        XuLyAnh.MaHoaHinhAnh mhAnh = new XuLyAnh.MaHoaHinhAnh();
                        frmMemberInfor.pic_Avartar.Image = mhAnh.ChuoiSangAnh(dt.Rows[0]["AnhDaiDien"].ToString());
                    }
                    catch { }
                    frmMemberInfor.lb_HoTen.ForeColor = System.Drawing.Color.Red;
                    frmMemberInfor.tb_ChucVu.Text     = dt.Rows[0]["TenChucVu"].ToString();
                }
                else
                {
                    frmMemberInfor.tb_ChucVu.Text = "Chưa xét duyệt";
                }
                frmMemberInfor.tb_mssv.Text      = values[id][1].ToString();
                frmMemberInfor.tb_Sdt.Text       = values[id][4].ToString();
                frmMemberInfor.tb_Khoa.Text      = values[id][8].ToString();
                frmMemberInfor.tb_Lop.Text       = values[id][9].ToString();
                frmMemberInfor.tb_DiaChi.Text    = values[id][7].ToString();
                frmMemberInfor.dtp_NgaySinh.Text = values[id][6].ToString();
                frmMemberInfor.tb_Sdt.Text       = values[id][4].ToString();
                if (link.Count > 0)
                {
                    frmMemberInfor.link_Facebook.Text = "Mở Facebook";
                    frmMemberInfor.link_Facebook.Links.Add(0, link[0].getContent().Length, link[0].getContent());
                    frmMemberInfor.link_Facebook.LinkClicked += new LinkLabelLinkClickedEventHandler(linkClick);
                }
                else
                {
                    frmMemberInfor.link_Facebook.Text = values[id][10].ToString();
                    frmMemberInfor.link_Facebook.Links.Add(0, 0);
                }
                if (values[id][5].ToString() == "Nam")
                {
                    frmMemberInfor.ra_Nam.Checked = true;
                }
                else
                {
                    frmMemberInfor.ra_nu.Checked = true;
                }
            }
            else
            {
                frmMemberInfor.lb_HoTen.Text  = dtInfo.Rows[0]["HoTen"].ToString();
                frmMemberInfor.tb_mssv.Text   = dtInfo.Rows[0]["MSSV"].ToString();
                frmMemberInfor.tb_Sdt.Text    = dtInfo.Rows[0]["SDT"].ToString();
                frmMemberInfor.tb_Khoa.Text   = dtInfo.Rows[0]["Khoa"].ToString();
                frmMemberInfor.tb_Lop.Text    = dtInfo.Rows[0]["Lop"].ToString();
                frmMemberInfor.tb_DiaChi.Text = dtInfo.Rows[0]["DiaChiCuThe"].ToString() + " - " + dtInfo.Rows[0]["TenXa"].ToString() + " - " + dtInfo.Rows[0]["TenHuyen"].ToString() + " - " + dtInfo.Rows[0]["TenTinh"].ToString();
                DateTime ngay = Convert.ToDateTime(dtInfo.Rows[0]["NgaySinh"].ToString());
                frmMemberInfor.dtp_NgaySinh.Text = ngay.ToString("dd/MM/yyyy");
                frmMemberInfor.tb_Sdt.Text       = dtInfo.Rows[0]["SDT"].ToString();
                frmMemberInfor.tb_ChucVu.Text    = dtInfo.Rows[0]["TenChucVu"].ToString();
                List <XuLyChuoi.checkLink> link = checklink.DetectLink(dtInfo.Rows[0]["LinkFB"].ToString());
                if (link.Count > 0)
                {
                    frmMemberInfor.link_Facebook.Text = "Mở Facebook";
                    frmMemberInfor.link_Facebook.Links.Add(0, link[0].getContent().Length, link[0].getContent());
                    frmMemberInfor.link_Facebook.LinkClicked += new LinkLabelLinkClickedEventHandler(linkClick);
                }
                else
                {
                    frmMemberInfor.link_Facebook.Text = dtInfo.Rows[0]["LinkFB"].ToString();
                    frmMemberInfor.link_Facebook.Links.Add(0, 0);
                }
                if (Convert.ToBoolean(dtInfo.Rows[0]["GioiTinh"]))
                {
                    frmMemberInfor.ra_Nam.Checked = true;
                }
                else
                {
                    frmMemberInfor.ra_nu.Checked = true;
                }
                try
                {
                    XuLyAnh.MaHoaHinhAnh mhAnh = new XuLyAnh.MaHoaHinhAnh();
                    frmMemberInfor.pic_Avartar.Image = mhAnh.ChuoiSangAnh(dtInfo.Rows[0]["AnhDaiDien"].ToString());
                }
                catch { }
            }
        }