Example #1
0
        DanhSachMonThi DsMonThi()
        {
            DanhSachMonThi Dsmt = new DanhSachMonThi(new List <MonThi>());

            foreach (DataGridViewRow r in grwDanhSach.Rows)
            {
                if (Convert.ToString(r.Cells["NHÓM"].Value) != "")
                {
                    MonThi mt     = new MonThi(Convert.ToString(r.Cells["MÃ HP"].Value));
                    string phong1 = Convert.ToString(((DataGridViewTextBoxCell)r.Cells["PHÒNG"]).Value);
                    string nhom1  = Convert.ToString(r.Cells["NHÓM"].Value);
                    if (phong1 != "")
                    {
                        mt.MonThucHanh = true;
                    }
                    foreach (DataGridViewRow r2 in grwDanhSach.Rows)
                    {
                        if (r2.Index != r.Index)
                        {
                            string nhom2  = Convert.ToString(r2.Cells["NHÓM"].Value);
                            string phong2 = Convert.ToString(((DataGridViewTextBoxCell)r2.Cells["PHÒNG"]).Value);
                            if (DuLieu.KiemTraTrung(nhom1, nhom2) || DuLieu.KiemTraTrung(phong1, phong2))
                            {
                                mt.ThemMonCungNhom(Convert.ToString(r2.Cells[1].Value));
                            }
                        }
                    }
                    Dsmt.ds.Add(mt);
                }
            }
            return(Dsmt);
        }
Example #2
0
 private void frmXepLichThi_Load(object sender, EventArgs e)
 {
     labelX1.Location = new Point((this.Width - labelX1.Width) / 2, labelX1.Location.Y);
     labelX6.Location = new Point((this.Width - labelX6.Width) / 2, labelX6.Location.Y);
     rtMain.Select();
     lbStatus.Text = "Hãy mở file dữ liệu và thực hiện sắp xếp lịch thi";
     lblTime.Text  = DuLieu.GetDay();
     if (XuLyXml.DaTaoTaiKhoan())
     {
         Active_Form(false);
     }
     else
     {
         DialogResult rs = MessageBox.Show("Ứng dụng chưa đăng kí tài khoản, bạn có muốn tạo tài khoản kô", "Chưa tạo tài khoản", MessageBoxButtons.OKCancel, MessageBoxIcon.Question, MessageBoxDefaultButton.Button1);
         if (rs == DialogResult.OK)
         {
             TaoTaiKhoan();
         }
         else
         {
             Active_Form(false);
             btnDangNhap.Text = "Tạo tài khoản";
         }
     }
 }
Example #3
0
        List <VerticeEntity> DsMonThi()
        {
            List <VerticeEntity> ListVertice = new List <VerticeEntity>();

            foreach (DataGridViewRow r in grwDanhSach.Rows)
            {
                if (Convert.ToString(r.Cells["NHÓM"].Value) != "")
                {
                    SubjectEntity mt     = new SubjectEntity(Convert.ToString(r.Cells["MÃ HP"].Value));
                    string        phong1 = Convert.ToString(((DataGridViewTextBoxCell)r.Cells["PHÒNG"]).Value);
                    string        nhom1  = Convert.ToString(r.Cells["NHÓM"].Value);
                    foreach (DataGridViewRow r2 in grwDanhSach.Rows)
                    {
                        if (r2.Index != r.Index)
                        {
                            string nhom2  = Convert.ToString(r2.Cells["NHÓM"].Value);
                            string phong2 = Convert.ToString(((DataGridViewTextBoxCell)r2.Cells["PHÒNG"]).Value);
                            if (DuLieu.CheckContain(nhom1, nhom2) || DuLieu.CheckContain(phong1, phong2))
                            {
                                mt.AddSubjectRelated(Convert.ToString(r2.Cells[1].Value));
                            }
                        }
                    }
                    ListVertice.Add(mt);
                }
            }
            return(ListVertice);
        }
Example #4
0
        private void btnSet_Click(object sender, EventArgs e)
        {
            string servername = txtServer.Text;
            string connString = @"Data Source=" + servername + @";Initial Catalog=QLPM;Integrated Security=True";

            DuLieu.SetConn(connString);
            this.Close();
        }
Example #5
0
 public DuLieuBanCo(DuLieu.DuLieuTuyChon tc)
 {
     SoOBc=56;
     SoNguoichoi=tc.SoNguoiChoi;
     UserHienTai=tc.NguoiUuTien;
     HinhBanCo=Application.StartupPath+"/HinhBanCo/BanCo1.bmp";
     InitArrBC();
     KhoiTao(tc.SoNguaQuan);
 }
Example #6
0
 // GET api/dulieu
 public IEnumerable <DuLieu> Get()
 {
     if (Test() == false)
     {
         throw new HttpResponseException(new HttpResponseMessage(HttpStatusCode.NotFound));
     }
     Dulieu_DAO = new DuLieuDAO();
     DuLieu[] list_dulieu = new DuLieu[Dulieu_DAO.get_Ds_DuLieu().Count];
     list_dulieu = Dulieu_DAO.get_Ds_DuLieu().ToArray();
     return(list_dulieu);
 }
Example #7
0
 int[] InDuongDi(DuLieu x)
 {
     int[] kq = new int[100];
     kq[0] = Canh1 + 2;
     kq[1] = Tong1;
     kq[2] = (x.di + 1);
     for (int i = 3; i < Canh1 + 2; i++)
     {
         kq[i] = (L1[i - 2] + 1);
     }
     return(kq);
 }
Example #8
0
        // POST api/dulieu
        public HttpResponseMessage Post([FromBody] DuLieu value)
        {
            if (Test() == false)
            {
                throw new HttpResponseException(new HttpResponseMessage(HttpStatusCode.NotFound));
            }
            Dulieu_DAO = new DuLieuDAO();
            bool ret      = Dulieu_DAO.insert_DuLieu(value);
            var  response = Request.CreateResponse <bool>(HttpStatusCode.Created, ret);

            return(response);
        }
Example #9
0
        public string ConnectionString(string severName)
        {
            string connString = @"Data Source=" + severName + @";Initial Catalog=QLPM;Integrated Security=True";
            DuLieu duLieu     = new DuLieu();

            if (!duLieu.MoKetNoi(connString))
            {
                return("failed");
            }
            else
            {
                return("successed");
            }
        }
Example #10
0
 void KhoiTao(ref DuLieu x)
 {
     x.den = x.den - 1;
     x.di  = x.di - 1;
     for (int i = 0; i < x.sodinh; i++)
     {
         DanhDau[i] = 0;   //Các đỉnh chưa được đánh dấu
         L[i]       = 0;
     }
     DanhDau[x.di] = 1;    //Dánh dấu đỉnh xuẩt phát
     L[0]          = x.di; //Đường đi đầu tiên qua đỉnh đầu
     Tong          = 0;    //Trong số đường đi
     Tong1         = 0;    //Lưu lại trọng số lớn nhất của đường đi
 }
Example #11
0
        // GET api/dulieu/5
        //Lấy thông tin dữ liệu có tên địa điểm, tên phường, tên quận huyện (kết các bảng lại với nhau)

        public IEnumerable <DuLieu> Get(int ma_dulieu)
        {
            if (Test() == false)
            {
                throw new HttpResponseException(new HttpResponseMessage(HttpStatusCode.NotFound));
            }
            Dulieu_DAO = new DuLieuDAO();
            DuLieu[] dulieu = new DuLieu[Dulieu_DAO.get_DuLieu(ma_dulieu).Count];
            dulieu = Dulieu_DAO.get_DuLieu(ma_dulieu).ToArray();
            if (dulieu.Length == 0)
            {
                throw new HttpResponseException(HttpStatusCode.NotFound);
            }
            return(dulieu);
        }
Example #12
0
        private void btnTest_Click(object sender, EventArgs e)
        {
            string servername = txtServer.Text;
            string connString = @"Data Source=" + servername + @";Initial Catalog=QLPM;Integrated Security=True";
            DuLieu duLieu     = new DuLieu();

            if (!duLieu.MoKetNoi(connString))
            {
                MessageBox.Show("Không thành công");
            }
            else
            {
                MessageBox.Show("Thành công");
                btnSet.Enabled = true;
            }
        }
Example #13
0
 public int[] TimDuong(DuLieu x)
 {
     int[] s = new int[100];
     KhoiTao(ref x);
     TimKiem(1, x);
     if (Tong1 == 0)
     {
         s[0] = -1;
         return(s);
     }
     else
     {
         s = InDuongDi(x);
         return(s);
     }
 }
Example #14
0
 void TimKiem(int SoCanh, DuLieu x)
 {
     if (L[SoCanh - 1] == x.den)
     {
         XuLy(SoCanh);
     }
     else
     {
         for (int i = 0; i < x.sodinh; i++)
         {
             if (x.mt[L[SoCanh - 1], i] > 0 && DanhDau[i] == 0)
             {
                 L[SoCanh]  = i;
                 DanhDau[i] = 1;
                 Tong      += x.mt[L[SoCanh - 1], i];
                 TimKiem(SoCanh + 1, x);
                 L[SoCanh]  = 0;
                 Tong      -= x.mt[L[SoCanh - 1], i];
                 DanhDau[i] = 0;
             }
         }
     }
 }
Example #15
0
 private void frmXepLichThi_Load(object sender, EventArgs e)
 {
     rtMain.Select();
     cbbStyle.SelectedIndex   = 0;
     cbbNgonNgu.SelectedIndex = 0;
     lblTime.Text             = DuLieu.GetDay();
     if (XuLyXml.DaTaoTaiKhoan())
     {
         Active_Form(true);
     }
     else
     {
         DialogResult rs = MessageBox.Show("Ứng dụng chưa đăng kí tài khoản, bạn có muốn tạo tài khoản kô", "Chưa tạo tài khoản", MessageBoxButtons.OKCancel, MessageBoxIcon.Question, MessageBoxDefaultButton.Button1);
         if (rs == DialogResult.OK)
         {
             TaoTaiKhoan();
         }
         else
         {
             Active_Form(false);
             btnDangNhap.Text = "Tạo tài khoản";
         }
     }
 }
Example #16
0
 public NVTonKho()
 {
     dl = new DuLieu();
 }
Example #17
0
        public void KhoiTaoMangVeDich(int iUser,DuLieu.DuLieuUser User)
        {
            Point p;
            int d=27;
            int n=6;
            int t;
            if(iUser==0)
            {
                p=new Point(224,388);
                for(int i=0;i<n;i++)
                {
                    t=p.Y+(-d*i);
                    User.arrVtDich[i]=new Point(p.X,t);
                }
            }

            if(iUser==1)
            {
                p=new Point(395,222);
                for(int i=0;i<n;i++)
                {
                    t=p.X+(-d*i);
                    User.arrVtDich[i]=new Point(t,p.Y);
                }
            }
            if(iUser==2)
            {
                p=new Point(224,50);
                for(int i=0;i<n;i++)
                {
                    t=p.Y+d*i;
                    User.arrVtDich[i]=new Point(p.X,t);
                }
            }
            if(iUser==3)
            {
                p=new Point(58,222);
                for(int i=0;i<n;i++)
                {
                    t=p.X+d*i;
                    User.arrVtDich[i]=new Point(t,p.Y);
                }
            }
        }
Example #18
0
 public NVLSNhapHang()
 {
     dl = new DuLieu();
 }
Example #19
0
        public int[] TimDuong(DuLieu x)
        {
            int min;

            int[] nhan    = new int[100];
            int[] daDuyet = new int[100];
            int[] kq      = new int[100];
            int   dem     = 0;

            int[,] mts = new int[100, 100];
            int[] s = new int[1000];
            for (int i = 1; i <= x.sodinh; i++)
            {
                for (int j = 1; j <= x.sodinh; j++)
                {
                    mts[i, j] = x.mt[i - 1, j - 1];
                }
            }
            for (int i = 1; i <= x.sodinh; i++)
            {
                nhan[i]    = 0;
                kq[i]      = 1000000;
                daDuyet[i] = 0;
            }
            int vet = x.di;

            nhan[vet] = 1;
            kq[vet]   = 0;
            while (vet != x.den && dem <= x.sodinh)
            {
                for (int i = 1; i <= x.sodinh; i++)
                {
                    if (mts[vet, i] >= 0 && kq[vet] + mts[vet, i] < kq[i] && nhan[i] == 0)
                    {
                        kq[i]      = kq[vet] + mts[vet, i];
                        daDuyet[i] = vet;
                    }
                }
                min = 1000000;
                for (int j = 1; j <= x.sodinh; j++)
                {
                    if (min > kq[j] && nhan[j] == 0)
                    {
                        min = kq[j];
                        vet = j;
                    }
                }
                nhan[vet] = 1;
                dem++;
            }
            if (dem < x.sodinh)
            {
                s[1] = kq[x.den];
                s[2] = x.den;
                int index = 3;
                int tmp   = daDuyet[x.den];

                while (tmp != x.di)
                {
                    // if (tmp == 0) break;
                    s[index] = tmp;
                    tmp      = daDuyet[tmp];
                    index++;
                    //if(tmp==0) break;
                }
                s[index++] = x.di;
                s[0]       = index;
                //s[3] = dem;
            }
            else
            {
                s[0] = -1;
            }
            return(s);
        }
Example #20
0
 //sap bc
 public void SapBanCo( System.Windows.Forms.Panel panel,DuLieu.DuLieuTuyChon tc)
 {
     HuyBC(panel);
     CapNhatDuLieuBanco(tc);
     int n=DLBC.SoNguoichoi;
     for(int i=0;i<n;i++)
         TaoViTriQuan((Point)DLBC.arrVTChuong[i],i,(DuLieu.DuLieuUser)DLBC.arrUsers[i],panel);
 }
        public ExcelFile CreateReport(String path, String iNamLamViec, String iThang, String iID_MaChungTuChiTiet, String LoaiBaoCao, String iID_MaChungTu)
        {
            FlexCelReport fr = new FlexCelReport();
            String BoQuocPhong = ReportModels.CauHinhTenDonViSuDung(1);
            String CucTaiChinh = ReportModels.CauHinhTenDonViSuDung(2);
            DateTime dt = new System.DateTime(DateTime.Now.Year, DateTime.Now.Month, DateTime.Now.Day);
            //Load data
            DuLieu _DuLieu = new DuLieu();
            _DuLieu = PhieuThu(iNamLamViec, iThang, iID_MaChungTuChiTiet, iID_MaChungTu);
            String TK1="", TK2="";
            DataTable dtNo = _DuLieu.dtNo;
            DataTable dtCo = _DuLieu.dtCo;
            if (_DuLieu.dtCo.Rows.Count == 1 && _DuLieu.dtNo.Rows.Count >= 1)
            {
                TK1 = "Có";
                TK2 = "Nợ";
            }
            else if (_DuLieu.dtNo.Rows.Count == 1 && _DuLieu.dtCo.Rows.Count >= 1)
            {
                TK1 = "Nợ";
                TK2 = "Có";
                dtCo = _DuLieu.dtNo;
                dtNo = _DuLieu.dtCo;
            }

            fr.AddTable("dtNo", dtNo);
            fr.AddTable("dtCo", dtCo);
            fr.AddTable("dtNo1", dtNo);
            fr.AddTable("dtCo1", dtCo);
            fr.SetValue("TenNguoiNhan", _DuLieu.TenNguoiNhan);
            fr.SetValue("DiaChi", _DuLieu.DiaChi);
            fr.SetValue("Lydo", _DuLieu.Lydo);
            fr.SetValue("GhiChu", _DuLieu.GhiChu);
            fr.SetValue("SoTien", _DuLieu.SoTien);
            fr.SetValue("NgayCT", _DuLieu.NgayCT);
            fr.SetValue("ThangCT", _DuLieu.ThangCT);
            fr.SetValue("SoPT", _DuLieu.SoPT);
            String DuongDan = "";
            if (LoaiBaoCao == "PT1")
            {
                DuongDan = sFilePathPT1;
            }
            else if (LoaiBaoCao == "PT2")
            {
                DuongDan = sFilePathPT2;
            }
            else if (LoaiBaoCao == "PT3")
            {
                DuongDan = sFilePathPT3;
            }
            else
            {
                DuongDan = sFilePathPT4;
            }

            XlsFile Result = new XlsFile(true);
            Result.Open(Server.MapPath(DuongDan));

            fr = ReportModels.LayThongTinChuKy(fr, "rptKTTienMat_PhieuThu1");
            fr.SetValue("TK1", TK1);
            fr.SetValue("TK2", TK2);
            fr.SetValue("Nam", iNamLamViec);
            fr.SetValue("Thang", iThang);
            fr.SetValue("BoQuocPhong", BoQuocPhong);
            fr.SetValue("CucTaiChinh", CucTaiChinh);
            fr.SetValue("Ngay", String.Format("{0:dd}", dt));
            fr.SetValue("Thangs", String.Format("{0:MM}", dt));
            fr.SetValue("Nams", DateTime.Now.Year);
            fr.SetValue("Tien", CommonFunction.TienRaChu(long.Parse(_DuLieu.SoTien.ToString())));
            fr.Run(Result);
            return Result;
        }
Example #22
0
        public int[] TimDuong(DuLieu x)
        {
            int[] data = new int[100];
            int[,] maTran  = x.mt;
            int[,] maTran2 = new int[x.sodinh, x.sodinh];
            int[] P = new int[x.sodinh];
            int[] L = new int[x.sodinh];

            for (int i = 0; i < x.sodinh; i++)
            {
                for (int j = 0; j < x.sodinh; j++)
                {
                    if (maTran[i, j] == 0)
                    {
                        maTran[i, j] = int.MaxValue;
                    }
                }
            }

            for (int i = 0; i < L.Length; i++)
            {
                L[i] = int.MaxValue;
            }

            L[x.di] = 0;

            bool stop = false;
            int  k    = 0;

            while (!stop)
            {
                stop = true;
                k    = k + 1;

                for (int i = 0; i < x.sodinh; i++)
                {
                    for (int j = 0; j < x.sodinh; j++)
                    {
                        if (maTran[i, j] > 0 && maTran[i, j] < int.MaxValue)
                        {
                            if (L[j] > L[i] + maTran[i, j])
                            {
                                L[j] = L[i] + maTran[i, j];
                                P[j] = i;
                                stop = false;
                            }
                        }
                    }
                }

                for (int i = 0; i < x.sodinh; i++)
                {
                    for (int j = 0; j < x.sodinh; j++)
                    {
                        if (maTran[i, j] > 0 && maTran[i, j] < int.MaxValue)
                        {
                            if (L[j] > L[i] + maTran[i, j])
                            {
                                L[j] = L[i] + maTran[i, j];
                                P[j] = i;
                                stop = false;
                            }
                        }
                    }
                }

                if (k > x.sodinh)
                {
                    if (stop == false)
                    {
                        stop = true;
                    }
                }
            }

            int    den   = x.den;
            int    count = 0;
            string str   = "";

            while (den != x.di && den < x.sodinh && den != P[den])
            {
                count++;
                den = P[den];
                str = den + str;
            }

            count++;
            str += x.den;
            str  = count.ToString() + L[x.den].ToString() + str;

            data = new int[str.Length];

            for (int i = 0; i < data.Length; i++)
            {
                data[i] = int.Parse(str[i].ToString());
            }

            return(data);
        }
Example #23
0
 public void CapNhatDL(DuLieu.DuLieuTuyChon tc)
 {
     arrUsers.Clear();
     arrVTChuong.Clear();
     this.SoNguoichoi=tc.SoNguoiChoi;
     this.UserHienTai=tc.NguoiUuTien;
     this.gtRQ1=tc.gtRaQuan1;
     this.gtRQ2=tc.gtRaQuan2;
     this.gtVD1=tc.gtVeDich1;
     this.gtVD2=tc.gtVeDich2;
     this.KhoiTao(tc.SoNguaQuan);
 }
Example #24
0
 private void frmXepLichThi_Load(object sender, EventArgs e)
 {
     //pnTitle.Left = (this.Width - pnTitle.Width) / 2;
     lblTime.Text = DuLieu.GetDay();
     Active_Form();
 }
Example #25
0
 public BanCo(DuLieu.DuLieuBanCo DL)
 {
     DLBC=DL;
 }
Example #26
0
 public NVHangHoa()
 {
     dl = new DuLieu();
 }
Example #27
0
 public NVLoaiSP()
 {
     dl = new DuLieu();
 }
Example #28
0
 public NVNhaCC()
 {
     dl = new DuLieu();
 }
Example #29
0
 //tao cac quan tren bc
 public void TaoViTriQuan(Point vtCB,int i,DuLieu.DuLieuUser User,System.Windows.Forms.Panel panel)
 {
     Point p;
     int X=-24,Y=-24;
     if(i==1){Y=-Y;}
     if(i==2){X=-X;Y=-Y;}
     if(i==3){X=-X;}
     for(int j=0;j<User.SoQuanCo;j++)
     {
         if(j==0||j==2||j==4)
             p=new Point(vtCB.X+(j/2*X),vtCB.Y);
         else
             p=new Point(vtCB.X+((j-1)/2*X),vtCB.Y+Y);
         XuLy.QuanCo qc=(XuLy.QuanCo)User.arrQC[j];
         qc.QCDL.ViTriTrongChuong=p;
         qc.QCDL.ViTriTrenBanCo=-1;
         qc.QCDL.ViTriRaQuan=i*14;
         if(qc.QCDL.ViTriRaQuan==0)qc.QCDL.ViTriVeDich=55;
         else qc.QCDL.ViTriVeDich=qc.QCDL.ViTriRaQuan-1;
         qc.QCDL.MauCo=i+1;
         qc.QCTH.picQC.Location=new Point(qc.QCDL.ViTriTrongChuong.X,qc.QCDL.ViTriTrongChuong.Y);
         qc.QCTH.HienThi(i+1);
         panel.Controls.Add(qc.QCTH.picQC);
     }
 }
Example #30
0
 public NVKhachHang()
 {
     dl = new DuLieu();
 }
Example #31
0
 public NVKhoHang()
 {
     dl = new DuLieu();
 }
        public DuLieu PhieuThu(String iNamLamViec, String iThang, String iID_MaChungTuChiTiet,String iID_MaChungTu)
        {
            DuLieu _DuLieu = new DuLieu();
            String DK = "";
            //String SQL = String.Format("SELECT ISNULL(SUM(rSoTien),0) As rSoTien FROM KTTM_ChungTuChiTiet WHERE iTrangThai=1 AND iID_MaTrangThaiDuyet={1} AND iID_MaChungTu='{0}'", iID_MaChungTuChiTiet, LuongCongViecModel.Get_iID_MaTrangThaiDuyet_DaDuyet(PhanHeModels.iID_MaPhanHeKeToanTongHop));
            String SQL = String.Format("SELECT ISNULL(SUM(rSoTien),0) As rSoTien FROM KTTM_ChungTuChiTiet WHERE iTrangThai=1 AND iID_MaChungTu='{0}'  AND sSoChungTuChiTiet='{1}'",iID_MaChungTu, iID_MaChungTuChiTiet);

            _DuLieu.SoTien = Convert.ToDecimal(Connection.GetValue(SQL, 0));
            SQL = String.Format("SELECT Top 1 sTenNguoiThuChi,sDiaChi,sNoiDung,sGhiChu,iThangCT,iNgayCT,sSoChungTuChiTiet FROM KTTM_ChungTuChiTiet WHERE iTrangThai=1  AND iID_MaChungTu='{0}'  AND sSoChungTuChiTiet='{1}' ORDER BY iSTT,dNgayTao",iID_MaChungTu, iID_MaChungTuChiTiet);

               // SQL = String.Format("SELECT Top 1 sTenNguoiThuChi,sDiaChi,sNoiDung,sGhiChu,iThangCT,iNgayCT,sSoChungTuChiTiet FROM KTTM_ChungTuChiTiet WHERE iTrangThai=1 AND iID_MaTrangThaiDuyet={1} AND iID_MaChungTu='{0}' ORDER BY iSTT,dNgayTao", iID_MaChungTuChiTiet, LuongCongViecModel.Get_iID_MaTrangThaiDuyet_DaDuyet(PhanHeModels.iID_MaPhanHeKeToanTongHop));
            DataTable dt = Connection.GetDataTable(SQL);
            if (dt.Rows.Count > 0)
            {
                _DuLieu.TenNguoiNhan = Convert.ToString(dt.Rows[0]["sTenNguoiThuChi"]);
                _DuLieu.DiaChi = Convert.ToString(dt.Rows[0]["sDiaChi"]);
                _DuLieu.Lydo = Convert.ToString(dt.Rows[0]["sNoiDung"]);
                _DuLieu.NgayCT = Convert.ToString(dt.Rows[0]["iNgayCT"]);
                _DuLieu.ThangCT = Convert.ToString(dt.Rows[0]["iThangCT"]);
                _DuLieu.SoPT = Convert.ToString(dt.Rows[0]["sSoChungTuChiTiet"]);
                _DuLieu.GhiChu = Convert.ToString(dt.Rows[0]["sGhiChu"]);
            }
            else
            {
                _DuLieu.TenNguoiNhan = "";
                _DuLieu.DiaChi = "";
                _DuLieu.Lydo = "";
                _DuLieu.NgayCT = "";
                _DuLieu.ThangCT = "";
                _DuLieu.SoPT = "";
                _DuLieu.GhiChu = "";
            }

            SQL = "SELECT  iID_MaTaiKhoan_No AS TK,iID_MaDonVi_No AS DV,SUM(rSoTien) As rST  FROM KTTM_ChungTuChiTiet";
            //SQL += " WHERE iTrangThai=1 AND iID_MaTrangThaiDuyet={1} AND iID_MaChungTu='{0}'";
            SQL += " WHERE iTrangThai=1 AND iID_MaChungTu='{0}'  AND sSoChungTuChiTiet='{1}' ";
            SQL += " GROUP By sSoChungTuChiTiet,iID_MaTaiKhoan_No,iID_MaDonVi_No ";
            SQL = String.Format(SQL,iID_MaChungTu, iID_MaChungTuChiTiet);
            //SQL = String.Format(SQL, iID_MaChungTuChiTiet, LuongCongViecModel.Get_iID_MaTrangThaiDuyet_DaDuyet(PhanHeModels.iID_MaPhanHeKeToanTongHop));
            DataTable dtNo = Connection.GetDataTable(SQL);

            SQL = "SELECT  iID_MaTaiKhoan_Co AS TK,iID_MaDonVi_Co AS DV,SUM(rSoTien) As rST   FROM KTTM_ChungTuChiTiet";
               // SQL += " WHERE iTrangThai=1 AND iID_MaTrangThaiDuyet={1} AND iID_MaChungTu='{0}'";
            SQL += " WHERE iTrangThai=1 AND iID_MaChungTu='{0}'  AND sSoChungTuChiTiet='{1}' ";
            SQL += " GROUP By sSoChungTuChiTiet,iID_MaTaiKhoan_Co,iID_MaDonVi_Co";
            SQL = String.Format(SQL,iID_MaChungTu, iID_MaChungTuChiTiet);
            //SQL = String.Format(SQL, iID_MaChungTuChiTiet,LuongCongViecModel.Get_iID_MaTrangThaiDuyet_DaDuyet(PhanHeModels.iID_MaPhanHeKeToanTongHop));
            DataTable dtCo = Connection.GetDataTable(SQL);
            Boolean CoNhieuTK_No = false;
            for (int i = 0; i < dtNo.Rows.Count; i++)
            {
                String TK, TK1;
                TK =Convert.ToString(dtNo.Rows[0]["TK"]);
                TK1 = Convert.ToString(dtNo.Rows[i]["TK"]);
                if (TK != TK1)
                {
                    CoNhieuTK_No = true;
                }
            }
            Boolean CoNhieuTK_Co = false;
            for (int i = 0; i < dtCo.Rows.Count; i++)
            {
                String TK, TK1;
                TK = Convert.ToString(dtCo.Rows[0]["TK"]);
                TK1 = Convert.ToString(dtCo.Rows[i]["TK"]);
                if (TK != TK1)
                {
                    CoNhieuTK_Co = true;
                }
            }
            if (CoNhieuTK_No == false)
            {
                dtNo.Rows[0]["rST"] = _DuLieu.SoTien;
                for (int i = 1; i < dtNo.Rows.Count; i++)
                {
                    dtNo.Rows.RemoveAt(i);
                }
            }
            else if (CoNhieuTK_Co == false)
            {
                dtCo.Rows[0]["rST"] = _DuLieu.SoTien;
                for (int i = 1; i < dtCo.Rows.Count; i++)
                {
                    dtCo.Rows.RemoveAt(i);
                }
            }
            else
            {
                dtNo.Rows[0]["rST"] = 0;
                dtNo.Rows[0]["TK"] = "";
                dtNo.Rows[0]["DV"] = "";
                for (int i = 1; i < dtNo.Rows.Count; i++)
                {
                    dtNo.Rows.RemoveAt(i);
                }
                dtCo.Rows[0]["rST"] = 0;
                dtCo.Rows[0]["TK"] = "";
                dtCo.Rows[0]["DV"] = "";
                for (int i = 1; i < dtCo.Rows.Count; i++)
                {
                    dtCo.Rows.RemoveAt(i);
                }
            }
            _DuLieu.dtCo = dtCo;
            _DuLieu.dtNo = dtNo;

            return _DuLieu;
        }
Example #33
0
 public NVHoaDon()
 {
     dl = new DuLieu();
 }
Example #34
0
 public NVNhaCungCap()
 {
     dl = new DuLieu();
 }
Example #35
0
 //khoi tao lai du lieu
 public void CapNhatDuLieuBanco(DuLieu.DuLieuTuyChon tc)
 {
     DLBC.HinhBanCo=tc.HinhBanCo;
     DLBC.SoNguoichoi=tc.SoNguoiChoi;
 }
 private void FrmQLDangKyThi_Load(object sender, EventArgs e)
 {
     dl = new DuLieu();
     LoadChuaThi(0, 0);
 }
Example #37
0
 public NVNhanVien()
 {
     dl = new DuLieu();
 }