Пример #1
0
        public void HDBanHang()
        {
            try
            {
                cl           = new Server_Client.Client();
                this.client1 = cl.Connect(Luu.IP, Luu.Ports);
                Entities.CheckRefer ctxh = new Entities.CheckRefer("HDBH");
                clientstrem = cl.SerializeObj(this.client1, "Select", ctxh);
                hdbanhang   = (Entities.HDBanHang[])cl.DeserializeHepper1(clientstrem, hdbanhang);
                if (hdbanhang == null)
                {
                    hdbanhang = new Entities.HDBanHang[0];
                    return;
                }
                int st = 0;
                Entities.HDBanHang[] temp = new Entities.HDBanHang[hdbanhang.Length];
                for (int i = 0; i < hdbanhang.Length; i++)
                {
                    temp[st] = hdbanhang[i];
                    st++;
                }
                hdbanhang = new Entities.HDBanHang[st];
                for (int i = 0; i < st; i++)
                {
                    hdbanhang[i] = temp[i];
                }
            }

            catch
            {
            }
        }
Пример #2
0
 /// <summary>
 /// selec bán lẻ
 /// </summary>
 public void SelectBanLe()
 {
     try
     {
         Entities.HDBanHang[] pt2 = new Entities.HDBanHang[buonle.Length];
         int sotang = 0;
         for (int j = 0; j < buonle.Length; j++)
         {
             string month1 = buonle[j].NgayBan.Month.ToString();
             string year1  = buonle[j].NgayBan.Year.ToString();
             if (buonle[j].LoaiHoaDon == true && buonle[j].Deleted == false)
             {
                 if (month == month1 && year == year1)
                 {
                     sl++;
                     pt2[sotang] = buonle[j];
                     sotang++;
                 }
             }
         }
         bl = new Entities.HDBanHang[sotang];
         if (sotang != 0)
         {
             for (int j = 0; j < sotang; j++)
             {
                 bl[j] = pt2[j];
             }
         }
         else
         {
             bl = new Entities.HDBanHang[0];
         }
     }
     catch { }
 }
Пример #3
0
        void SelectDate(DateTime batdau, DateTime ketthuc)
        {
            try
            {
                i = 0;
                dtgvbanbuon.RowHeadersVisible = false;
                cl = new Server_Client.Client();
                // gán TCPclient
                this.client1 = cl.Connect(Luu.IP, Luu.Ports);
                // khởi tạo biến truyền vào với hàm khởi tạo
                Entities.HDBanHang pt = new Entities.HDBanHang("Select");
                // khởi tạo mảng đối tượng để hứng giá trị
                pt1         = new Entities.HDBanHang[1];
                clientstrem = cl.SerializeObj(this.client1, "HDBanHang", pt);
                // đổ mảng đối tượng vào datagripview
                pt1 = (Entities.HDBanHang[])cl.DeserializeHepper1(clientstrem, pt1);
                if (pt1 == null)
                {
                    dtgvbanbuon.DataSource = new Entities.HDBanHang[0];
                    return;
                }

                Entities.HDBanHang[] pt2 = new Entities.HDBanHang[pt1.Length];
                int sotang = 0;
                foreach (Entities.HDBanHang item in pt1)
                {
                    if (!item.LoaiHoaDon && !item.Deleted && item.NgayBan.Date >= batdau.Date && item.NgayBan.Date <= ketthuc.Date && item.MaKho == makho)
                    {
                        pt2[sotang] = item;
                        sotang++;
                    }
                }
                hienthi = new Entities.HDBanHang[sotang];
                if (sotang != 0)
                {
                    for (int j = 0; j < sotang; j++)
                    {
                        hienthi[j] = pt2[j];
                        hienthi[j].TongTienThanhToan = new Common.Utilities().FormatMoney(double.Parse(hienthi[j].TongTienThanhToan));
                    }
                }
                else
                {
                    dtgvbanbuon.DataSource = new Entities.HDBanHang[0];
                    return;
                }
                dtgvbanbuon.DataSource = hienthi;
                //new Common.Utilities().CountDatagridview(dtgvbanbuon);
                dtgvbanbuon.Rows[0].Selected = true;
            }
            catch (Exception ex)
            {
                MessageBox.Show("Không kết nối được với server - thử lại sau");
                dtgvbanbuon.DataSource = new Entities.HDBanHang[0];
            }
            finally
            {
                fix();
            }
        }
Пример #4
0
 /// <summary>
 /// select bán buôn
 /// </summary>
 public void SelectBanBuon()
 {
     try
     {
         Entities.HDBanHang[] pt2 = new Entities.HDBanHang[buonle.Length];
         int sotang = 0;
         for (int j = 0; j < buonle.Length; j++)
         {
             string month1 = buonle[j].NgayBan.Month.ToString();
             string year1  = buonle[j].NgayBan.Year.ToString();
             if (buonle[j].LoaiHoaDon == false && buonle[j].Deleted == false)
             {
                 if (month == month1 && year == year1 && Convert.ToDouble(buonle[j].ThanhToanKhiLapPhieu) != 0)
                 {
                     sl++;
                     pt2[sotang] = buonle[j];
                     sotang++;
                 }
             }
         }
         bb = new Entities.HDBanHang[sotang];
         if (sotang != 0)
         {
             for (int j = 0; j < sotang; j++)
             {
                 bb[j] = pt2[j];
             }
         }
         else
         {
             bb = new Entities.HDBanHang[0];
         }
     }
     catch { }
 }
Пример #5
0
 /// <summary>
 /// select dữ liệu từ server
 /// </summary>
 public void SelectData()
 {
     try
     {
         dtgvKH.RowHeadersVisible = false;
         Server_Client.Client cl = new Server_Client.Client();
         // gán TCPclient
         this.client1 = cl.Connect(Luu.IP, Luu.Ports);
         // khởi tạo biến truyền vào với hàm khởi tạo
         Entities.HDBanHang kh = new Entities.HDBanHang("Select");
         // khởi tạo mảng đối tượng để hứng giá trị
         Entities.HDBanHang[] kh1 = new Entities.HDBanHang[1];
         clientstrem = cl.SerializeObj(this.client1, "HDBanHang", kh);
         // đổ mảng đối tượng vào datagripview
         kh1 = (Entities.HDBanHang[])cl.DeserializeHepper1(clientstrem, kh1);
         if (kh1 == null)
         {
             hienthi           = new Entities.HDBanHang[0];
             dtgvKH.DataSource = new Entities.HDBanHang[0];
             return;
         }
         Entities.HDBanHang[] kh2 = new Entities.HDBanHang[kh1.Length];
         int sotang = 0;
         for (int j = 0; j < kh1.Length; j++)
         {
             if (kh1[j].MaKhachHang == str1 && kh1[j].Deleted == false && kh1[j].LoaiHoaDon == false && !kh1[j].TongTienThanhToan.Equals(kh1[j].ThanhToanNgay) && !kh1[j].TongTienThanhToan.Equals(kh1[j].ThanhToanKhiLapPhieu))
             {
                 kh2[sotang] = kh1[j];
                 sotang++;
             }
         }
         hienthi = new Entities.HDBanHang[sotang];
         if (sotang != 0)
         {
             for (int j = 0; j < sotang; j++)
             {
                 hienthi[j] = kh2[j];
             }
         }
         else
         {
             hienthi           = new Entities.HDBanHang[0];
             dtgvKH.DataSource = new Entities.HDBanHang[0];
             return;
         }
         dtgvKH.DataSource       = hienthi;
         dtgvKH.Rows[0].Selected = true;
     }
     catch (Exception ex)
     {
         MessageBox.Show("Không kết nối được với server - thử lại sau");
     }
     finally
     {
         fix();
     }
 }
Пример #6
0
 public Entities.HDBanHang[] HDBanHang()
 {
     Entities.HDBanHang[] hdbanhang = new BizLogic.CheckRefer().HDBanHang();
     if (hdbanhang == null)
     {
         hdbanhang = new Entities.HDBanHang[0];
     }
     return(hdbanhang);
 }
Пример #7
0
 /// <summary>
 /// xử lý khi tìm kiếm
 /// </summary>
 /// <param name="sender"></param>
 /// <param name="e"></param>
 private void txttimkiem_TextChanged(object sender, EventArgs e)
 {
     try
     {
         if (rdbtimkiem3.Checked == true)
         {
             return;
         }
         if (txttimkiem.Text.Length == 0)
         {
             dtgvbanbuon.DataSource = new Entities.HDBanHang[0];
             return;
         }
         int soluong = 0;
         if (hienthi != null)
         {
             if (rdbtimkiem2.Checked == true)
             {
                 for (int i = 0; i < hienthi.Length; i++)
                 {
                     int kiemtra = hienthi[i].MaHDBanHang.ToString().ToUpper().IndexOf(txttimkiem.Text.ToUpper());
                     if (kiemtra >= 0)
                     {
                         soluong++;
                     }
                 }
                 if (soluong == 0)
                 {
                     dtgvbanbuon.DataSource = new Entities.HDBanHang[0];
                     return;
                 }
                 Entities.HDBanHang[] hienthitheoma = new Entities.HDBanHang[soluong];
                 soluong = 0;
                 for (int i = 0; i < hienthi.Length; i++)
                 {
                     int kiemtra = hienthi[i].MaHDBanHang.ToString().ToUpper().IndexOf(txttimkiem.Text.ToUpper());
                     if (kiemtra >= 0)
                     {
                         hienthitheoma[soluong] = hienthi[i];
                         soluong++;
                     }
                 }
                 dtgvbanbuon.DataSource = hienthitheoma;
             }
             if (soluong != 0)
             {
             }
         }
     }
     finally
     {
         fix();
     }
 }
Пример #8
0
        public void LayHDBanHang()
        {
            try
            {
                cl          = new Server_Client.Client();
                this.client = cl.Connect(Luu.IP, Luu.Ports);
                Entities.HDBanHang ctxh = new Entities.HDBanHang("Select");
                clientstrem = cl.SerializeObj(this.client, "HDBanHang", ctxh);
                Entities.HDBanHang[] HDBanHang1 = new Entities.HDBanHang[0];
                HDBanHang1 = (Entities.HDBanHang[])cl.DeserializeHepper1(clientstrem, HDBanHang1);
                if (HDBanHang1 == null)
                {
                    HDBanHang1 = new Entities.HDBanHang[0];
                    return;
                }

                int count = 0;
                for (int i = 0; i < HDBanHang1.Length; i++)
                {
                    DateTime ngayban = HDBanHang1[i].NgayBan;
                    if (ngayban >= BatDau && ngayban <= KetThuc)
                    {
                        count++;
                    }
                }
                HDBanHang = new Entities.HDBanHang[count];
                count     = 0;
                for (int i = 0; i < HDBanHang1.Length; i++)
                {
                    DateTime ngayban = HDBanHang1[i].NgayBan;
                    if (ngayban >= BatDau && ngayban <= KetThuc)
                    {
                        HDBanHang[count] = HDBanHang1[i];
                        count++;
                    }
                }
            }
            catch
            {
            }
        }
 /// <summary>
 /// select bán buôn - bán lẻ
 /// </summary>
 public void SelectBanBuonLe()
 {
     try
     {
         i = 0;
         if (bb == null || bb.Length == 0)
         {
             bb = new Entities.HDBanHang[0];
             return;
         }
         Entities.HDBanHang[] pt2 = new Entities.HDBanHang[bb.Length];
         int sotang = 0;
         for (int j = 0; j < bb.Length; j++)
         {
             DateTime hientai = bb[j].NgayBan;
             if (bb[j].LoaiHoaDon == false && bb[j].Deleted == false && hientai.Date >= Convert.ToDateTime(batdau).Date&& hientai.Date < Convert.ToDateTime(ketthuc).Date)
             {
                 pt2[sotang] = bb[j];
                 sotang++;
             }
         }
         bb = new Entities.HDBanHang[sotang];
         if (sotang != 0)
         {
             for (int j = 0; j < sotang; j++)
             {
                 bb[j] = pt2[j];
             }
         }
         else
         {
             bb = new Entities.HDBanHang[0];
         }
     }
     catch
     {
     }
     finally
     {
     }
 }
Пример #10
0
        public void LayHDBanHang()
        {
            try
            {
                Entities.HDBanHang[] HDBanHang1 = new Entities.HDBanHang[0];
                HDBanHang1 = new BizLogic.HDBanHang().Select();
                if (HDBanHang1 == null)
                {
                    HDBanHang1 = new Entities.HDBanHang[0];
                    return;
                }

                int count = 0;
                for (int i = 0; i < HDBanHang1.Length; i++)
                {
                    DateTime ngayban = HDBanHang1[i].NgayBan;
                    if (ngayban >= BatDau && ngayban <= KetThuc)
                    {
                        count++;
                    }
                }
                HDBanHang = new Entities.HDBanHang[count];
                count     = 0;
                for (int i = 0; i < HDBanHang1.Length; i++)
                {
                    DateTime ngayban = HDBanHang1[i].NgayBan;
                    if (ngayban >= BatDau && ngayban <= KetThuc)
                    {
                        HDBanHang[count] = HDBanHang1[i];
                        count++;
                    }
                }
            }
            catch
            {
            }
        }
Пример #11
0
 public Entities.HDBanHang[] HDBanHang()
 {
     Entities.HDBanHang[] hdbanhang = new BizLogic.CheckRefer().HDBanHang();
     if (hdbanhang == null)
         hdbanhang = new Entities.HDBanHang[0];
     return hdbanhang;
 }
        /// <summary>
        /// select bán buôn
        /// </summary>
        public void SelectBanBuon()
        {
            try
            {
                Entities.HDBanHang[] pt2 = new Entities.HDBanHang[buonle.Length];
                int sotang = 0;
                for (int j = 0; j < buonle.Length; j++)
                {
                    if (buonle[j].LoaiHoaDon == false && buonle[j].Deleted == false)
                    {
                        if (batDau <= buonle[j].NgayBan && buonle[j].NgayBan <= ketThuc && Convert.ToDouble(buonle[j].ThanhToanKhiLapPhieu) != 0)
                        {
                            sl++;
                            pt2[sotang] = buonle[j];
                            sotang++;
                        }
                    }
                }
                bb = new Entities.HDBanHang[sotang];
                if (sotang != 0)
                {

                    for (int j = 0; j < sotang; j++)
                    {
                        bb[j] = pt2[j];
                    }
                }
                else
                    bb = new Entities.HDBanHang[0];
            }
            catch (Exception ex)
            {

            }
        }
Пример #13
0
        //Entities.HDBanHang[] hienthi;
        public void SelectData1()
        {
            try
            {
                double duNoHoaDon = 0;
                DateTime dateServer = DateServer.Date();
                cl = new Server_Client.Client();
                // gán TCPclient
                this.client1 = cl.Connect(Luu.IP, Luu.Ports);
                // khởi tạo biến truyền vào với hàm khởi tạo
                Entities.HDBanHang pt = new Entities.HDBanHang("Select");
                // khởi tạo mảng đối tượng để hứng giá trị
                pt1 = new Entities.HDBanHang[1];
                clientstrem = cl.SerializeObj(this.client1, "HDBanHang", pt);
                // đổ mảng đối tượng vào datagripview
                pt1 = (Entities.HDBanHang[])cl.DeserializeHepper1(clientstrem, pt1);
                if (pt1 == null)
                    pt1 = new Entities.HDBanHang[0];
                List<Entities.HDBanHang> hdBanHanList = new List<Entities.HDBanHang>();

                for (int j = 0; j < pt1.Length; j++)
                {
                    int YY = dateServer.Year;
                    int MM = dateServer.Month;
                    int DD = dateServer.Day;
                    if (pt1[j].MaKhachHang == makh)
                    {
                        double thanhToanNgay = 0;
                        double thanToanKhiLapPhieu = 0;
                        double tongTienThanhToan = 0;

                        if (!string.IsNullOrEmpty(pt1[j].ThanhToanNgay))
                            thanhToanNgay = double.Parse(pt1[j].ThanhToanNgay);

                        if (!string.IsNullOrEmpty(pt1[j].ThanhToanKhiLapPhieu))
                            thanToanKhiLapPhieu = double.Parse(pt1[j].ThanhToanKhiLapPhieu);

                        if (!string.IsNullOrEmpty(pt1[j].TongTienThanhToan))
                            tongTienThanhToan = double.Parse(pt1[j].TongTienThanhToan);

                        duNoHoaDon = thanhToanNgay + thanToanKhiLapPhieu - tongTienThanhToan;

                        DateTime hanthanhtoan = pt1[j].HanThanhToam;
                        if (YY == hanthanhtoan.Year && MM == hanthanhtoan.Month && (hanthanhtoan.Day - DD) <= 3 && (hanthanhtoan.Day - DD) >= 0 && duNoHoaDon != 0)
                        {
                            hdBanHanList.Add(pt1[j]);
                        }
                    }
                }

                int tem = 32;
                Entities.HDBanHang hdTem = null;
                foreach (Entities.HDBanHang item in hdBanHanList)
                {
                    int DD = item.HanThanhToam.Day;
                    if (tem > DD)
                    {
                        tem = DD;
                        hdTem = new Entities.HDBanHang();
                        hdTem = item;
                    }
                }

                if (tem != 0 && hdTem != null && !string.IsNullOrEmpty(hdTem.MaHDBanHang))
                    label3.Text = "Sắp tới hạn thanh toán của khách hàng " + hdTem.HanThanhToam.ToString("dd/MM/yyyy");
            }
            catch { }
        }
Пример #14
0
        public void LayHDBanHang()
        {
            try
            {
                Entities.HDBanHang[] HDBanHang1 = new Entities.HDBanHang[0];
                HDBanHang1 = new BizLogic.HDBanHang().Select();
                if (HDBanHang1 == null)
                {
                    HDBanHang1 = new Entities.HDBanHang[0];
                    return;
                }

                int count = 0;
                for (int i = 0; i < HDBanHang1.Length; i++)
                {
                    DateTime ngayban = HDBanHang1[i].NgayBan;
                    if (ngayban >= BatDau && ngayban <= KetThuc)
                    {
                        count++;
                    }
                }
                HDBanHang = new Entities.HDBanHang[count];
                count = 0;
                for (int i = 0; i < HDBanHang1.Length; i++)
                {
                    DateTime ngayban = HDBanHang1[i].NgayBan;
                    if (ngayban >= BatDau && ngayban <= KetThuc)
                    {
                        HDBanHang[count] = HDBanHang1[i];
                        count++;
                    }
                }

            }
            catch
            {
            }
        }
Пример #15
0
        /// <summary>
        /// select dữ liệu từ server
        /// </summary>
        public void SelectData()
        {
            try
            {
                dtgvKH.RowHeadersVisible = false;
                Server_Client.Client cl = new Server_Client.Client();
                // gán TCPclient
                this.client1 = cl.Connect(Luu.IP, Luu.Ports);
                // khởi tạo biến truyền vào với hàm khởi tạo
                Entities.HDBanHang kh = new Entities.HDBanHang("Select");
                // khởi tạo mảng đối tượng để hứng giá trị
                Entities.HDBanHang[] kh1 = new Entities.HDBanHang[1];
                clientstrem = cl.SerializeObj(this.client1, "HDBanHang", kh);
                // đổ mảng đối tượng vào datagripview
                kh1 = (Entities.HDBanHang[])cl.DeserializeHepper1(clientstrem, kh1);
                if (kh1 == null)
                {
                    hienthi = new Entities.HDBanHang[0];
                    dtgvKH.DataSource = new Entities.HDBanHang[0];
                    return;
                }
                Entities.HDBanHang[] kh2 = new Entities.HDBanHang[kh1.Length];
                int sotang = 0;
                for (int j = 0; j < kh1.Length; j++)
                {
                    if (kh1[j].MaKhachHang == str1 && kh1[j].Deleted == false && kh1[j].LoaiHoaDon == false && !kh1[j].TongTienThanhToan.Equals(kh1[j].ThanhToanNgay) && !kh1[j].TongTienThanhToan.Equals(kh1[j].ThanhToanKhiLapPhieu))
                    {
                        kh2[sotang] = kh1[j];
                        sotang++;
                    }
                }
                hienthi = new Entities.HDBanHang[sotang];
                if (sotang != 0)
                {
                    for (int j = 0; j < sotang; j++)
                    {
                        hienthi[j] = kh2[j];
                    }
                }
                else
                {
                    hienthi = new Entities.HDBanHang[0];
                    dtgvKH.DataSource = new Entities.HDBanHang[0];
                    return;
                }
                dtgvKH.DataSource = hienthi;
                dtgvKH.Rows[0].Selected = true;
            }
            catch (Exception ex)
            {
                MessageBox.Show("Không kết nối được với server - thử lại sau");
            }
            finally
            {

                fix();

            }
        }
Пример #16
0
        /// <summary>
        /// xử lý khi tìm kiếm
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void txttimkiem_TextChanged(object sender, EventArgs e)
        {
            try
            {
                if (rdbtimkiem3.Checked == true)
                {
                    return;
                }
                if (txttimkiem.Text.Length == 0)
                {
                    dtgvKH.DataSource = new Entities.HDBanHang[0];
                    return;
                }
                int soluong = 0;
                if (rdbtimkiem2.Checked == true)
                {
                    for (int i = 0; i < hienthi.Length; i++)
                    {
                        int kiemtra = hienthi[i].MaHDBanHang.ToString().ToUpper().IndexOf(txttimkiem.Text.ToUpper());
                        if (kiemtra >= 0)
                        {
                            soluong++;
                        }
                    }
                    if (soluong == 0)
                    {
                        dtgvKH.DataSource = new Entities.HDBanHang[0];
                        return;
                    }
                    Entities.HDBanHang[] hienthitheoma = new Entities.HDBanHang[soluong];
                    soluong = 0;
                    for (int i = 0; i < hienthi.Length; i++)
                    {
                        int kiemtra = hienthi[i].MaHDBanHang.ToString().ToUpper().IndexOf(txttimkiem.Text.ToUpper());
                        if (kiemtra >= 0)
                        {
                            hienthitheoma[soluong] = hienthi[i];
                            soluong++;
                        }
                    }
                    dtgvKH.DataSource = hienthitheoma;
                }
            }
            finally
            {

                fix();
            }
        }
        /// <summary>
        /// selec bán lẻ
        /// </summary>
        public void SelectBanLe()
        {
            try
            {
                Entities.HDBanHang[] pt2 = new Entities.HDBanHang[buonle.Length];
                int sotang = 0;
                for (int j = 0; j < buonle.Length; j++)
                {
                    if (buonle[j].LoaiHoaDon == true && buonle[j].Deleted == false)
                    {
                        if (batDau <= buonle[j].NgayBan && buonle[j].NgayBan <= ketThuc)
                        {
                            sl++;
                            pt2[sotang] = buonle[j];
                            sotang++;
                        }
                    }
                }
                bl = new Entities.HDBanHang[sotang];
                if (sotang != 0)
                {

                    for (int j = 0; j < sotang; j++)
                    {
                        bl[j] = pt2[j];
                    }
                }
                else
                    bl = new Entities.HDBanHang[0];
            }
            catch (Exception ex)
            {

            }
        }
Пример #18
0
        void SelectDate(DateTime batdau, DateTime ketthuc)
        {
            try
            {
                i = 0;
                dtgvbanbuon.RowHeadersVisible = false;
                cl = new Server_Client.Client();
                // gán TCPclient
                this.client1 = cl.Connect(Luu.IP, Luu.Ports);
                // khởi tạo biến truyền vào với hàm khởi tạo
                Entities.HDBanHang pt = new Entities.HDBanHang("Select");
                // khởi tạo mảng đối tượng để hứng giá trị
                pt1 = new Entities.HDBanHang[1];
                clientstrem = cl.SerializeObj(this.client1, "HDBanHang", pt);
                // đổ mảng đối tượng vào datagripview
                pt1 = (Entities.HDBanHang[])cl.DeserializeHepper1(clientstrem, pt1);
                if (pt1 == null)
                {
                    dtgvbanbuon.DataSource = new Entities.HDBanHang[0];
                    return;
                }

                Entities.HDBanHang[] pt2 = new Entities.HDBanHang[pt1.Length];
                int sotang = 0;
                foreach (Entities.HDBanHang item in pt1)
                {
                    if (!item.LoaiHoaDon && !item.Deleted && item.NgayBan.Date >= batdau.Date && item.NgayBan.Date <= ketthuc.Date && item.MaKho == makho)
                    {
                        pt2[sotang] = item;
                        sotang++;
                    }
                }
                hienthi = new Entities.HDBanHang[sotang];
                if (sotang != 0)
                {
                    for (int j = 0; j < sotang; j++)
                    {
                        hienthi[j] = pt2[j];
                        hienthi[j].TongTienThanhToan = new Common.Utilities().FormatMoney(double.Parse(hienthi[j].TongTienThanhToan));
                    }
                }
                else
                {
                    dtgvbanbuon.DataSource = new Entities.HDBanHang[0];
                    return;
                }
                dtgvbanbuon.DataSource = hienthi;
                //new Common.Utilities().CountDatagridview(dtgvbanbuon);
                dtgvbanbuon.Rows[0].Selected = true;
            }
            catch (Exception ex)
            {
                MessageBox.Show("Không kết nối được với server - thử lại sau");
                dtgvbanbuon.DataSource = new Entities.HDBanHang[0];
            }
            finally
            {
                fix();
            }
        }
Пример #19
0
        /// <summary>
        /// select bán buôn
        /// </summary>
        public void SelectBanBuon()
        {
            try
            {
                Entities.HDBanHang[] pt2 = new Entities.HDBanHang[buonle.Length];
                int sotang = 0;
                for (int j = 0; j < buonle.Length; j++)
                {
                    string month1 = buonle[j].NgayBan.Month.ToString();
                    string year1 = buonle[j].NgayBan.Year.ToString();
                    if (buonle[j].LoaiHoaDon == false && buonle[j].Deleted == false)
                    {
                        if (month == month1 && year == year1 && Convert.ToDouble(buonle[j].ThanhToanKhiLapPhieu) != 0)
                        {
                            sl++;
                            pt2[sotang] = buonle[j];
                            sotang++;
                        }
                    }
                }
                bb = new Entities.HDBanHang[sotang];
                if (sotang != 0)
                {

                    for (int j = 0; j < sotang; j++)
                    {
                        bb[j] = pt2[j];
                    }
                }
                else
                    bb = new Entities.HDBanHang[0];
            }
            catch { }
        }
Пример #20
0
        /// <summary>
        /// selec bán lẻ
        /// </summary>
        public void SelectBanLe()
        {
            try
            {
                Entities.HDBanHang[] pt2 = new Entities.HDBanHang[buonle.Length];
                int sotang = 0;
                for (int j = 0; j < buonle.Length; j++)
                {
                    string month1 = buonle[j].NgayBan.Month.ToString();
                    string year1 = buonle[j].NgayBan.Year.ToString();
                    if (buonle[j].LoaiHoaDon == true && buonle[j].Deleted == false)
                    {
                        if (month == month1 && year == year1)
                        {
                            sl++;
                            pt2[sotang] = buonle[j];
                            sotang++;
                        }
                    }
                }
                bl = new Entities.HDBanHang[sotang];
                if (sotang != 0)
                {

                    for (int j = 0; j < sotang; j++)
                    {
                        bl[j] = pt2[j];
                    }
                }
                else
                    bl = new Entities.HDBanHang[0];
            }
            catch { }
        }
Пример #21
0
        /// <summary>
        /// select bán buôn - bán lẻ
        /// </summary>
        public void SelectBanBuonLe()
        {
            try
            {
                i = 0;
                if (bb == null || bb.Length == 0)
                {
                    bb = new Entities.HDBanHang[0];
                    return;
                }
                Entities.HDBanHang[] pt2 = new Entities.HDBanHang[bb.Length];
                int sotang = 0;
                for (int j = 0; j < bb.Length; j++)
                {
                    DateTime hientai = bb[j].NgayBan;
                    if (bb[j].LoaiHoaDon == false && bb[j].Deleted == false && hientai.Date >= Convert.ToDateTime(batdau).Date && hientai.Date < Convert.ToDateTime(ketthuc).Date)
                    {
                        pt2[sotang] = bb[j];
                        sotang++;
                    }
                }
                bb = new Entities.HDBanHang[sotang];
                if (sotang != 0)
                {

                    for (int j = 0; j < sotang; j++)
                    {
                        bb[j] = pt2[j];
                    }
                }
                else
                    bb = new Entities.HDBanHang[0];
            }
            catch
            {
            }
            finally
            {

            }
        }
Пример #22
0
        /// select bán buôn - bán lẻ
        /// </summary>
        public void SelectBanBuonLe()
        {
            try
            {
                if (bb == null || bb.Length == 0)
                {
                    bb = new Entities.HDBanHang[0];
                    return;
                }
                Entities.HDBanHang[] pt2 = new Entities.HDBanHang[bb.Length];
                int sotang = 0;
                for (int j = 0; j < bb.Length; j++)
                {
                    string month1 = bb[j].NgayBan.Month.ToString();
                    string year1 = bb[j].NgayBan.Year.ToString();
                    if (bb[j].LoaiHoaDon == false && bb[j].Deleted == false && month == month1 && year1 == year)
                    {
                        pt2[sotang] = bb[j];
                        sotang++;
                    }
                }
                bb = new Entities.HDBanHang[sotang];
                if (sotang != 0)
                {

                    for (int j = 0; j < sotang; j++)
                    {
                        bb[j] = pt2[j];
                    }
                }
                else
                    bb = new Entities.HDBanHang[0];
            }
            catch { }
        }
Пример #23
0
        public void LayHDBanHang()
        {
            try
            {

                cl = new Server_Client.Client();
                this.client = cl.Connect(Luu.IP, Luu.Ports);
                Entities.HDBanHang ctxh = new Entities.HDBanHang("Select");
                clientstrem = cl.SerializeObj(this.client, "HDBanHang", ctxh);
                Entities.HDBanHang[] HDBanHang1 = new Entities.HDBanHang[0];
                HDBanHang1 = (Entities.HDBanHang[])cl.DeserializeHepper1(clientstrem, HDBanHang1);
                if (HDBanHang1 == null)
                {
                    HDBanHang1 = new Entities.HDBanHang[0];
                    return;
                }

                int count = 0;
                for (int i = 0; i < HDBanHang1.Length; i++)
                {
                    DateTime ngayban = HDBanHang1[i].NgayBan;
                    if (ngayban >= BatDau && ngayban <= KetThuc)
                    {
                        count++;
                    }
                }
                HDBanHang = new Entities.HDBanHang[count];
                count = 0;
                for (int i = 0; i < HDBanHang1.Length; i++)
                {
                    DateTime ngayban = HDBanHang1[i].NgayBan;
                    if (ngayban >= BatDau && ngayban <= KetThuc)
                    {
                        HDBanHang[count] = HDBanHang1[i];
                        count++;
                    }
                }

            }
            catch
            {
            }
        }
Пример #24
0
        public void HDBanHang()
        {
            try
            {
                cl = new Server_Client.Client();
                this.client1 = cl.Connect(Luu.IP, Luu.Ports);
                Entities.CheckRefer ctxh = new Entities.CheckRefer("HDBH");
                clientstrem = cl.SerializeObj(this.client1, "Select", ctxh);
                hdbanhang = (Entities.HDBanHang[])cl.DeserializeHepper1(clientstrem, hdbanhang);
                if (hdbanhang == null)
                {
                    hdbanhang = new Entities.HDBanHang[0];
                    return;
                }
                int st = 0;
                Entities.HDBanHang[] temp = new Entities.HDBanHang[hdbanhang.Length];
                for (int i = 0; i < hdbanhang.Length; i++)
                {
                    temp[st] = hdbanhang[i];
                    st++;
                }
                hdbanhang = new Entities.HDBanHang[st];
                for (int i = 0; i < st; i++)
                {
                    hdbanhang[i] = temp[i];
                }

            }

            catch
            {
            }
        }