示例#1
0
 void SelectChiTietPhieuTTNCC()
 {
     try
     {
         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.ChiTietPhieuTTNCC pt = new Entities.ChiTietPhieuTTNCC("SelectAll");
         // khởi tạo mảng đối tượng để hứng giá trị
         Entities.ChiTietPhieuTTNCC[] pt1 = new Entities.ChiTietPhieuTTNCC[1];
         clientstrem = cl.SerializeObj(this.client1, "ChiTietPhieuTTNCC", pt);
         // đổ mảng đối tượng vào datagripview
         pt1 = (Entities.ChiTietPhieuTTNCC[])cl.DeserializeHepper1(clientstrem, pt1);
         if (pt1 == null)
         {
             ctpttncc = new Entities.ChiTietPhieuTTNCC[0];
             return;
         }
         ctpttncc = new Entities.ChiTietPhieuTTNCC[pt1.Length];
         for (int i = 0; i < pt1.Length; i++)
         {
             ctpttncc[i] = pt1[i];
         }
     }
     catch { ctpttncc = new Entities.ChiTietPhieuTTNCC[0]; }
 }
示例#2
0
 public Entities.ChiTietPhieuTTNCC[] ChiTietPhieuTTNCC()
 {
     Entities.ChiTietPhieuTTNCC[] ctpttncc1 = new BizLogic.ChiTietPhieuTTNCC().Select();
     if (ctpttncc1 == null)
     {
         ctpttncc1 = new Entities.ChiTietPhieuTTNCC[0];
     }
     return(ctpttncc1);
 }
        private void SelectChiTietPhieuTTNCC()
        {
            try
            {
                if (chitietphieuttncc == null || chitietphieuttncc.Length == 0)
                {
                    chitietphieuttncc = new Entities.ChiTietPhieuTTNCC[0];
                    return;
                }

                Entities.ChiTietPhieuTTNCC[] pt2 = new Entities.ChiTietPhieuTTNCC[chitietphieuttncc.Length];
                int sotang = 0;
                for (int j = 0; j < chitietphieuttncc.Length; j++)
                {
                    if (chitietphieuttncc[j].Deleted == false)
                    {
                        pt2[sotang] = chitietphieuttncc[j];
                        sotang++;
                    }
                }
                chitietphieuttncc = new Entities.ChiTietPhieuTTNCC[sotang];
                if (sotang != 0)
                {
                    for (int j = 0; j < sotang; j++)
                    {
                        chitietphieuttncc[j] = pt2[j];
                    }
                }
                else
                {
                    chitietphieuttncc = new Entities.ChiTietPhieuTTNCC[0];
                }
            }
            catch
            {
            }
            finally
            {
            }
        }
        /// <summary>
        /// select dữ liệu từ server
        /// </summary>
        public void SelectData(string maphieuncc)
        {
            try
            {
                dtgvNCC.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.ChiTietPhieuTTNCC ptpttncc = new Entities.ChiTietPhieuTTNCC("Select", maphieuncc);
                // khởi tạo mảng đối tượng để hứng giá trị
                Entities.ChiTietPhieuTTNCC[] ptpttncc1 = new Entities.ChiTietPhieuTTNCC[1];
                clientstrem = cl.SerializeObj(this.client1, "ChiTietPhieuTTNCC", ptpttncc);
                // đổ mảng đối tượng vào datagripview
                ptpttncc1 = (Entities.ChiTietPhieuTTNCC[])cl.DeserializeHepper1(clientstrem, ptpttncc1);

                if (ptpttncc1 == null)
                {
                    dtgvNCC.DataSource = new Entities.HDThanhToanKH[0];
                    return;
                }

                Entities.HDThanhToanKH[] hhht = new Entities.HDThanhToanKH[ptpttncc1.Length];

                for (int j = 0; j < ptpttncc1.Length; j++)
                {
                    string mahd = ptpttncc1[j].MaHoaDonNhap;
                    string tongtien = ptpttncc1[j].TongTien;//LayTongTien(mahd);
                    string soNo = ptpttncc1[j].TienNo;
                    string thanhtoanngay = ptpttncc1[j].ThanhToan.ToString();//LayThanhToanNgay(mahd);
                    string thanhtoanngaysaukhilapphieu = LayThanhToanNgaySauKhiLapPhieu(mahd);
                    string conphaitra = (Convert.ToDouble(tongtien) - Convert.ToDouble(thanhtoanngay)).ToString();
                    hhht[j] = new Entities.HDThanhToanKH(mahd, new Common.Utilities().FormatMoney(Convert.ToDouble(tongtien)),  new Common.Utilities().FormatMoney(Convert.ToDouble(soNo)),  new Common.Utilities().FormatMoney(Convert.ToDouble(ptpttncc1[j].ThanhToan)));
                }
                dtgvNCC.DataSource = hhht;
            }
            catch (Exception ex)
            {

            }
            finally
            {
                fix();
            }
        }
        /// <summary>
        /// kiểm tra dtgv trước khi insert
        /// </summary>
        /// <param name="dgv"></param>
        public bool CheckDataGridInsert(DataGridView dgv)
        {
            bool kkt = false;
            try
            {
                if (dgv.RowCount != 0)
                {
                    Entities.ChiTietPhieuTTNCC[] ctxh2 = new Entities.ChiTietPhieuTTNCC[dgv.RowCount];
                    for (int j = 0; j < ctxh2.Length; j++)
                    {
                        ctxh2[j] = new Entities.ChiTietPhieuTTNCC("Insert", dgv["MaHDBanHang", j].Value.ToString(), txtsochungtu.Text, float.Parse(dgv["ThanhToan", j].Value.ToString()), true, "", false, dgv["TongTienThanhToan", j].Value.ToString(), dgv["SoNo", j].Value.ToString());
                    }
                   kkt= InsertMang(ctxh2);
                   return kkt;
                }
                return kkt;
            }
            catch (Exception ex)
            {

                return false;
            }
        }
        private void SelectChiTietPhieuTTNCC()
        {
            try
            {
                if (chitietphieuttncc == null || chitietphieuttncc.Length == 0)
                {
                    chitietphieuttncc = new Entities.ChiTietPhieuTTNCC[0];
                    return;
                }

                Entities.ChiTietPhieuTTNCC[] pt2 = new Entities.ChiTietPhieuTTNCC[chitietphieuttncc.Length];
                int sotang = 0;
                for (int j = 0; j < chitietphieuttncc.Length; j++)
                {
                    if (chitietphieuttncc[j].Deleted == false)
                    {
                        pt2[sotang] = chitietphieuttncc[j];
                        sotang++;
                    }
                }
                chitietphieuttncc = new Entities.ChiTietPhieuTTNCC[sotang];
                if (sotang != 0)
                {

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

            }
        }
示例#7
0
 void SelectChiTietPhieuTTNCC()
 {
     try
     {
         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.ChiTietPhieuTTNCC pt = new Entities.ChiTietPhieuTTNCC("SelectAll");
         // khởi tạo mảng đối tượng để hứng giá trị
         Entities.ChiTietPhieuTTNCC[] pt1 = new Entities.ChiTietPhieuTTNCC[1];
         clientstrem = cl.SerializeObj(this.client1, "ChiTietPhieuTTNCC", pt);
         // đổ mảng đối tượng vào datagripview
         pt1 = (Entities.ChiTietPhieuTTNCC[])cl.DeserializeHepper1(clientstrem, pt1);
         if (pt1 == null)
         {
             ctpttncc = new Entities.ChiTietPhieuTTNCC[0];
             return;
         }
         ctpttncc = new Entities.ChiTietPhieuTTNCC[pt1.Length];
         for (int i = 0; i < pt1.Length; i++)
         {
             ctpttncc[i] = pt1[i];
         }
     }
     catch { ctpttncc = new Entities.ChiTietPhieuTTNCC[0]; }
 }
示例#8
0
 public Entities.ChiTietPhieuTTNCC[] ChiTietPhieuTTNCC()
 {
     Entities.ChiTietPhieuTTNCC[] ctpttncc1 = new BizLogic.ChiTietPhieuTTNCC().Select();
     if (ctpttncc1 == null)
         ctpttncc1 = new Entities.ChiTietPhieuTTNCC[0];
     return ctpttncc1;
 }