/// <summary>
 /// add ban ghi --------------------------------hungvv-----------------------------
 /// </summary>
 /// <param name="dgv"></param>
 public Entities.ChiTietHoaDonNhap[] LuuChiTietHoaDonNhap(DataGridView dgv, string hanhdong, string madondathang)
 {
     ArrayList arr = new ArrayList();
     int i = dgv.RowCount;
     Entities.ChiTietHoaDonNhap[] mangBanghi = null;
     if (i > 0)
     {
         for (int x = 0; x < i; x++)
         {
             Entities.ChiTietHoaDonNhap banghi = new Entities.ChiTietHoaDonNhap();
             banghi.Hanhdong = hanhdong;
             banghi.MaHoaDonNhap = madondathang.ToUpper();
             banghi.MaHangHoa = dgv.Rows[x].Cells[1].Value.ToString();
             banghi.SoLuong = System.Convert.ToInt32(dgv.Rows[x].Cells[3].Value.ToString());
             banghi.PhanTramChietKhau = dgv.Rows[x].Cells[5].Value.ToString();
             banghi.GhiChu = dgv.Rows[x].Cells[2].Value.ToString();
             banghi.Deleted = false;
             arr.Add(banghi);
         }
         int n = arr.Count;
         if (n == 0) { return null; }
         mangBanghi = new Entities.ChiTietHoaDonNhap[n];
         for (int j = 0; j < n; j++)
         {
             mangBanghi[j] = (Entities.ChiTietHoaDonNhap)arr[j];
         }
     }
     else
     {
         mangBanghi = null;
         mangBanghi = null;
     }
     return mangBanghi;
 }
        /// <summary>
        /// hungvv =======================giao tiep voi server===========================
        /// </summary>
        private void Select_ChiTietHoaDonNhap(string hanhdong)
        {
            Entities.HoaDonNhap pt = new Entities.HoaDonNhap();
            pt = new Entities.HoaDonNhap(hanhdong);
            Entities.ChiTietHoaDonNhap[] pt1 = new Entities.ChiTietHoaDonNhap[10];
            clientstrem = cl.SerializeObj(this.client, "ChiTietHoaDonNhap", pt);

            Binding((Entities.ChiTietHoaDonNhap[])cl.DeserializeHepper(clientstrem, pt1));
        }
示例#3
0
 public void LayChiTietHoaDonNhap()
 {
     Entities.ChiTietHoaDonNhap[] ctHDN1 = new Entities.ChiTietHoaDonNhap[0];
     ctHDN1 = new BizLogic.ChiTietHoaDonNhap().Select();
     if (ctHDN1 == null)
     {
         ctHDN = new Entities.ChiTietHoaDonNhap[0];
         return;
     }
     else
     {
         ctHDN = ctHDN1;
     }
 }
 public void LayChiTietHoaDonNhap()
 {
     cl          = new Server_Client.Client();
     this.client = cl.Connect(Luu.IP, Luu.Ports);
     Entities.CheckRefer ctxh = new Entities.CheckRefer("CTHDN", "");
     clientstrem = cl.SerializeObj(this.client, "Select", ctxh);
     Entities.ChiTietHoaDonNhap[] ctHDN1 = new Entities.ChiTietHoaDonNhap[0];
     ctHDN1 = (Entities.ChiTietHoaDonNhap[])cl.DeserializeHepper1(clientstrem, ctHDN1);
     if (ctHDN1 == null)
     {
         ctHDN = new Entities.ChiTietHoaDonNhap[0];
         return;
     }
     else
     {
         ctHDN = ctHDN1;
     }
 }
        /// <summary>
        /// add ban ghi --------------------------------hungvv-----------------------------
        /// </summary>
        /// <param name="dgv"></param>
        public Entities.ChiTietHoaDonNhap[] LuuChiTietHoaDonNhap(DataGridView dgv, string hanhdong, string madondathang)
        {
            ArrayList arr = new ArrayList();
            int       i   = dgv.RowCount;

            Entities.ChiTietHoaDonNhap[] mangBanghi = null;
            if (i > 0)
            {
                for (int x = 0; x < i; x++)
                {
                    Entities.ChiTietHoaDonNhap banghi = new Entities.ChiTietHoaDonNhap();
                    banghi.Hanhdong          = hanhdong;
                    banghi.MaHoaDonNhap      = madondathang.ToUpper();
                    banghi.MaHangHoa         = dgv.Rows[x].Cells[1].Value.ToString();
                    banghi.SoLuong           = System.Convert.ToInt32(dgv.Rows[x].Cells[3].Value.ToString());
                    banghi.PhanTramChietKhau = dgv.Rows[x].Cells[5].Value.ToString();
                    banghi.GhiChu            = dgv.Rows[x].Cells[2].Value.ToString();
                    banghi.Deleted           = false;
                    arr.Add(banghi);
                }
                int n = arr.Count;
                if (n == 0)
                {
                    return(null);
                }
                mangBanghi = new Entities.ChiTietHoaDonNhap[n];
                for (int j = 0; j < n; j++)
                {
                    mangBanghi[j] = (Entities.ChiTietHoaDonNhap)arr[j];
                }
            }
            else
            {
                mangBanghi = null;
                mangBanghi = null;
            }
            return(mangBanghi);
        }
示例#6
0
 public Entities.ChiTietHoaDonNhap[] LayChiTietHoaDonNhap_TheoMaHD(string maHDNhap)
 {
     if (ctHDN.Length == 0)
     {
         return(new Entities.ChiTietHoaDonNhap[0]);
     }
     else
     {
         int count = 0;
         for (int i = 0; i < ctHDN.Length; i++)
         {
             if (ctHDN[i].MaHoaDonNhap == maHDNhap)
             {
                 count++;
             }
         }
         Entities.ChiTietHoaDonNhap[] ctHDN1 = new Entities.ChiTietHoaDonNhap[count];
         count = 0;
         for (int i = 0; i < ctHDN.Length; i++)
         {
             if (ctHDN[i].MaHoaDonNhap == maHDNhap)
             {
                 ctHDN1[count] = ctHDN[i];
                 count++;
             }
         }
         if (ctHDN1.Length == 0)
         {
             return(new Entities.ChiTietHoaDonNhap[0]);
         }
         else
         {
             return(ctHDN1);
         }
     }
 }
        public void HienThiChiTiet(string maHDNhap, string makho)
        {
            try
            {
                cl = new Server_Client.Client();
                this.client1 = cl.Connect(Luu.IP, Luu.Ports);

                Entities.ChiTietHoaDonNhap[] kh = new Entities.ChiTietHoaDonNhap[1];
                kh[0] = new Entities.ChiTietHoaDonNhap("Select");
                clientstrem = cl.SerializeObj(this.client1, "ChiTietHoaDonNhap", kh);

                Entities.ChiTietHoaDonNhap[] kh1 = new Entities.ChiTietHoaDonNhap[1];
                kh1 = (Entities.ChiTietHoaDonNhap[])cl.DeserializeHepper1(clientstrem, kh1);
                if (kh1.Length > 0)
                {
                    int ctcount = 0;
                    foreach (Entities.ChiTietHoaDonNhap h in kh1)
                    {
                        if (h.MaHoaDonNhap == maHDNhap)
                        {
                            ctcount++;
                        }
                    }

                    Entities.ChiTietHoaDonNhap[] hdn = new Entities.ChiTietHoaDonNhap[ctcount];
                    ctcount = 0;
                    foreach (Entities.ChiTietHoaDonNhap h in kh1)
                    {
                        if (h.MaHoaDonNhap == maHDNhap)
                        {
                            hdn[ctcount] = new Entities.ChiTietHoaDonNhap();
                            hdn[ctcount].MaHangHoa = h.MaHangHoa;
                            hdn[ctcount].SoLuong = h.SoLuong;
                            ctcount++;
                        }
                    }

                    Server_Client.Client cl1 = new Server_Client.Client();
                    this.client1 = cl1.Connect(Luu.IP, Luu.Ports);

                    Entities.ChiTietKhoHangTheoHoaHonNhap[] kho = new Entities.ChiTietKhoHangTheoHoaHonNhap[1];
                    kho[0] = new Entities.ChiTietKhoHangTheoHoaHonNhap("Select");
                    clientstrem = cl.SerializeObj(this.client1, "ChiTietKho", kho);

                    Entities.ChiTietKhoHangTheoHoaHonNhap[] kho1 = new Entities.ChiTietKhoHangTheoHoaHonNhap[1];
                    kho1 = (Entities.ChiTietKhoHangTheoHoaHonNhap[])cl.DeserializeHepper1(clientstrem, kho1);

                    Entities.ChiTietPhieuDieuChuyenKho[] ctdck = new Entities.ChiTietPhieuDieuChuyenKho[ctcount];
                    for (int i = 0; i < ctdck.Length; i++)
                    {
                        ctdck[i] = new Entities.ChiTietPhieuDieuChuyenKho();
                        ctdck[i].MaHangHoa = hdn[i].MaHangHoa;
                        ctdck[i].SoLuong = hdn[i].SoLuong;
                        ctdck[i].MaPhieuDieuChuyenKho = txtSochungtu.Text;
                        if (kho1 != null)
                        {
                            for (int j = 0; j < kho1.Length; j++)
                            {
                                if (kho1[j].Makho == makho & kho1[j].Mahanghoa == hdn[i].MaHangHoa)
                                {
                                    ctdck[i].NgayHetHan = kho1[j].Ngayhethan;
                                    break;
                                }
                            }
                        }

                    }
                    for (int i = 0; i < ctcount; i++)
                    {
                        arr.Add(ctdck[i]);
                    }
                    arrct = new Entities.ChiTietPhieuDieuChuyenKho[ctcount];
                    for (int i = 0; i < ctcount; i++)
                    {
                        arrct[i] = ctdck[i];
                    }
                    LayBangHangHoa();
                    for (int i = 0; i < ctdck.Length; i++)
                    {
                        for (int j = 0; j < hanghoa.Length; j++)
                        {
                            if (hanghoa[j].MaHangHoa == ctdck[i].MaHangHoa)
                            {
                                ctdck[i].TenHangHoa = hanghoa[j].TenHangHoa;
                                break;
                            }
                        }
                    }
                    CtPdck_BaoCao = ctdck;
                    dgvInsertOrder.DataSource = ctdck;
                    FixDataGridView();
                }
            }
            catch
            {

            }
        }
 public Entities.ChiTietHoaDonNhap[] LayChiTietHoaDonNhap_TheoMaHD(string maHDNhap)
 {
     if (ctHDN.Length == 0)
     {
         return new Entities.ChiTietHoaDonNhap[0];
     }
     else
     {
         int count = 0;
         for (int i = 0; i < ctHDN.Length; i++)
         {
             if (ctHDN[i].MaHoaDonNhap == maHDNhap)
             {
                 count++;
             }
         }
         Entities.ChiTietHoaDonNhap[] ctHDN1 = new Entities.ChiTietHoaDonNhap[count];
         count = 0;
         for (int i = 0; i < ctHDN.Length; i++)
         {
             if (ctHDN[i].MaHoaDonNhap == maHDNhap)
             {
                 ctHDN1[count] = ctHDN[i];
                 count++;
             }
         }
         if (ctHDN1.Length == 0)
         {
             return new Entities.ChiTietHoaDonNhap[0];
         }
         else
             return ctHDN1;
     }
 }
 public void LayChiTietHoaDonNhap()
 {
     Entities.ChiTietHoaDonNhap[] ctHDN1 = new Entities.ChiTietHoaDonNhap[0];
     ctHDN1 = new BizLogic.ChiTietHoaDonNhap().Select();
     if (ctHDN1 == null)
     {
         ctHDN = new Entities.ChiTietHoaDonNhap[0];
         return;
     }
     else
         ctHDN = ctHDN1;
 }
        public Entities.BCNhapHangTheoNhomHang Select()
        {
            Entities.BCNhapHangTheoNhomHang list = null;
            try
            {
                list = new Entities.BCNhapHangTheoNhomHang();

                ////Lấy hóa đơn nhập
                //con = new Connection();
                //cn = con.openConnection();
                //List<Entities.HoaDonNhap> HoaDonNhap = new List<Entities.HoaDonNhap>();
                //cmd = new SqlCommand("exec sp_BCNhapHangTheoNhomHangFIX @ThaoTac", cn);
                //cmd.Parameters.Add("ThaoTac", SqlDbType.NVarChar).Value = "HoaDonNhap";
                //dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
                //while (dr.Read())
                //{
                //    Entities.HoaDonNhap row = new Entities.HoaDonNhap();
                //    row.MaHoaDonNhap = dr["MaHoaDonNhap"].ToString();
                //    row.NgayNhap = DateTime.Parse(dr["NgayNhap"].ToString());
                //    HoaDonNhap.Add(row);
                //}
                //list.HoaDonNhap = HoaDonNhap;
                //cmd.Connection.Dispose();
                //cn.Close();
                //con.closeConnection();

                //Lấy chi tiết hóa đơn nhập
                con = new Connection();
                cn  = con.openConnection();
                List <Entities.ChiTietHoaDonNhap> ChiTietHoaDonNhap = new List <Entities.ChiTietHoaDonNhap>();
                cmd = new SqlCommand("exec sp_BCNhapHangTheoNhomHangFIX @ThaoTac", cn);
                cmd.Parameters.Add("ThaoTac", SqlDbType.NVarChar).Value = "ChiTietHoaDonNhap";
                dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
                while (dr.Read())
                {
                    Entities.ChiTietHoaDonNhap row = new Entities.ChiTietHoaDonNhap();
                    row.MaHoaDonNhap = dr["MaHoaDonNhap"].ToString();
                    row.MaHangHoa    = dr["MaHangHoa"].ToString();
                    row.SoLuong      = int.Parse(dr["SoLuong"].ToString());
                    row.NgayNhap     = DateTime.Parse(dr["NgayNhap"].ToString());
                    ChiTietHoaDonNhap.Add(row);
                }
                list.ChiTietHoaDonNhap = ChiTietHoaDonNhap;
                cmd.Connection.Dispose();
                cn.Close();
                con.closeConnection();

                ////Lấy khách hàng trả lại
                //con = new Connection();
                //cn = con.openConnection();
                //List<Entities.KhachHangTraLai> KhachHangTraLai = new List<Entities.KhachHangTraLai>();
                //cmd = new SqlCommand("exec sp_BCNhapHangTheoNhomHangFIX @ThaoTac", cn);
                //cmd.Parameters.Add("ThaoTac", SqlDbType.NVarChar).Value = "KhachHangTraLai";
                //dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
                //while (dr.Read())
                //{
                //    Entities.KhachHangTraLai row = new Entities.KhachHangTraLai();
                //    row.MaKhachHangTraLai = dr["MaKhachHangTraLai"].ToString();
                //    row.NgayNhap = DateTime.Parse(dr["NgayNhap"].ToString());
                //    KhachHangTraLai.Add(row);
                //}
                //list.KhachHangTraLai = KhachHangTraLai;
                //cmd.Connection.Dispose();
                //cn.Close();
                //con.closeConnection();

                //Lấy chi tiết khách hàng trả lại
                con = new Connection();
                cn  = con.openConnection();
                List <Entities.ChiTietKhachHangTraLai> ChiTietKhachHangTraLai = new List <Entities.ChiTietKhachHangTraLai>();
                cmd = new SqlCommand("exec sp_BCNhapHangTheoNhomHangFIX @ThaoTac", cn);
                cmd.Parameters.Add("ThaoTac", SqlDbType.NVarChar).Value = "ChiTietKhachHangTraLai";
                dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
                while (dr.Read())
                {
                    Entities.ChiTietKhachHangTraLai row = new Entities.ChiTietKhachHangTraLai();
                    row.MaKhachHangTraLai = dr["MaKhachHangTraLai"].ToString();
                    row.MaHangHoa         = dr["MaHangHoa"].ToString();
                    row.SoLuong           = int.Parse(dr["SoLuong"].ToString());
                    row.NgayNhap          = DateTime.Parse(dr["NgayNhap"].ToString());
                    ChiTietKhachHangTraLai.Add(row);
                }
                list.ChiTietKhachHangTraLai = ChiTietKhachHangTraLai;
                cmd.Connection.Dispose();
                cn.Close();
                con.closeConnection();

                //Lấy hàng hóa nhóm hàng
                con = new Connection();
                cn  = con.openConnection();
                List <Entities.HangHoa> HangHoa = new List <Entities.HangHoa>();
                cmd = new SqlCommand("exec sp_BCNhapHangTheoNhomHangFIX @ThaoTac", cn);
                cmd.Parameters.Add("ThaoTac", SqlDbType.NVarChar).Value = "HangHoaNhomHang";
                dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
                while (dr.Read())
                {
                    Entities.HangHoa row = new Entities.HangHoa();
                    row.MaHangHoa      = dr["MaHangHoa"].ToString();
                    row.TenHangHoa     = dr["TenHangHoa"].ToString();
                    row.MaNhomHangHoa  = dr["MaNhomHang"].ToString();
                    row.TenNhomHangHoa = dr["TenNhomHang"].ToString();
                    HangHoa.Add(row);
                }
                list.HangHoa = HangHoa;
                cmd.Connection.Dispose();
                cn.Close();
                con.closeConnection();

                //Lấy nhóm hàng
                con = new Connection();
                cn  = con.openConnection();
                List <Entities.NhomHang> NhomHang = new List <Entities.NhomHang>();
                cmd = new SqlCommand("exec sp_BCNhapHangTheoNhomHangFIX @ThaoTac", cn);
                cmd.Parameters.Add("ThaoTac", SqlDbType.NVarChar).Value = "NhomHang";
                dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
                while (dr.Read())
                {
                    Entities.NhomHang row = new Entities.NhomHang();
                    row.MaNhomHang  = dr["MaNhomHang"].ToString();
                    row.TenNhomHang = dr["TenNhomHang"].ToString();
                    NhomHang.Add(row);
                }
                list.NhomHang = NhomHang;
                cmd.Connection.Dispose();
                cn.Close();
                con.closeConnection();

                //Lấy gói hàng
                con = new Connection();
                cn  = con.openConnection();
                List <Entities.GoiHang> GoiHang = new List <Entities.GoiHang>();
                cmd = new SqlCommand("exec sp_BCNhapHangTheoNhomHangFIX @ThaoTac", cn);
                cmd.Parameters.Add("ThaoTac", SqlDbType.NVarChar).Value = "GoiHang";
                dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
                while (dr.Read())
                {
                    Entities.GoiHang row = new Entities.GoiHang();
                    row.MaGoiHang = dr["MaGoiHang"].ToString();
                    GoiHang.Add(row);
                }
                list.GoiHang = GoiHang;
                cmd.Connection.Dispose();
                cn.Close();
                con.closeConnection();

                //Lấy chi tiết gói hàng
                con = new Connection();
                cn  = con.openConnection();
                List <Entities.ChiTietGoiHang> ChiTietGoiHang = new List <Entities.ChiTietGoiHang>();
                cmd = new SqlCommand("exec sp_BCNhapHangTheoNhomHangFIX @ThaoTac", cn);
                cmd.Parameters.Add("ThaoTac", SqlDbType.NVarChar).Value = "ChiTietGoiHang";
                dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
                while (dr.Read())
                {
                    Entities.ChiTietGoiHang row = new Entities.ChiTietGoiHang();
                    row.MaGoiHang = dr["MaGoiHang"].ToString();
                    row.MaHangHoa = dr["MaHangHoa"].ToString();
                    row.SoLuong   = int.Parse(dr["SoLuong"].ToString());
                    ChiTietGoiHang.Add(row);
                }
                list.ChiTietGoiHang = ChiTietGoiHang;
                cmd.Connection.Dispose();
                cn.Close();
                con.closeConnection();
            }
            catch { return(null); }
            finally
            {
                cmd.Connection.Dispose();
                cn.Close();
                con.closeConnection();
            }
            return(list);
        }
        public void HienThiChiTiet(string maHDNhap, string makho)
        {
            cl           = new Server_Client.Client();
            this.client1 = cl.Connect(Luu.IP, Luu.Ports);

            Entities.ChiTietHoaDonNhap[] kh = new Entities.ChiTietHoaDonNhap[1];
            kh[0]       = new Entities.ChiTietHoaDonNhap("Select");
            clientstrem = cl.SerializeObj(this.client1, "ChiTietHoaDonNhap", kh);

            Entities.ChiTietHoaDonNhap[] kh1 = new Entities.ChiTietHoaDonNhap[1];
            kh1 = (Entities.ChiTietHoaDonNhap[])cl.DeserializeHepper1(clientstrem, kh1);
            if (kh1.Length > 0)
            {
                int ctcount = 0;
                foreach (Entities.ChiTietHoaDonNhap h in kh1)
                {
                    if (h.MaHoaDonNhap == maHDNhap)
                    {
                        ctcount++;
                    }
                }

                Entities.ChiTietHoaDonNhap[] hdn = new Entities.ChiTietHoaDonNhap[ctcount];
                ctcount = 0;
                foreach (Entities.ChiTietHoaDonNhap h in kh1)
                {
                    if (h.MaHoaDonNhap == maHDNhap)
                    {
                        hdn[ctcount]            = new Entities.ChiTietHoaDonNhap();
                        hdn[ctcount].MaHangHoa  = h.MaHangHoa;
                        hdn[ctcount].TenHangHoa = h.TenHangHoa;
                        hdn[ctcount].SoLuong    = h.SoLuong;
                        ctcount++;
                    }
                }

                Server_Client.Client cl1 = new Server_Client.Client();
                this.client1 = cl1.Connect(Luu.IP, Luu.Ports);

                Entities.ChiTietKhoHangTheoHoaHonNhap[] ctkh = new Entities.ChiTietKhoHangTheoHoaHonNhap[1];
                ctkh[0]     = new Entities.ChiTietKhoHangTheoHoaHonNhap("Select");
                clientstrem = cl1.SerializeObj(this.client1, "ChiTietKho", ctkh);

                Entities.ChiTietKhoHangTheoHoaHonNhap[] ctkh1 = new Entities.ChiTietKhoHangTheoHoaHonNhap[1];
                ctkh1 = (Entities.ChiTietKhoHangTheoHoaHonNhap[])cl1.DeserializeHepper1(clientstrem, kh1);


                Entities.ChiTietPhieuDieuChuyenKho[] ctdck = new Entities.ChiTietPhieuDieuChuyenKho[ctcount];
                for (int i = 0; i < ctdck.Length; i++)
                {
                    ctdck[i]                      = new Entities.ChiTietPhieuDieuChuyenKho();
                    ctdck[i].MaHangHoa            = hdn[i].MaHangHoa;
                    ctdck[i].TenHangHoa           = hdn[i].TenHangHoa;
                    ctdck[i].SoLuong              = hdn[i].SoLuong;
                    ctdck[i].MaPhieuDieuChuyenKho = txtSochungtu.Text;
                    if (ctkh1 != null)
                    {
                        for (int j = 0; j < ctkh1.Length; j++)
                        {
                            if (ctkh1[j].Makho == makho && hdn[i].MaHangHoa == ctkh1[j].Mahanghoa)
                            {
                                ctdck[i].NgayHetHan = ctkh1[i].Ngayhethan;
                            }
                        }
                    }
                }
                dgvInsertOrder.DataSource = ctdck;
                FixDataGridView();
            }
        }
        public Entities.BCNhapHangTheoNhomHang Select()
        {
            Entities.BCNhapHangTheoNhomHang list = null;
            try
            {
                list = new Entities.BCNhapHangTheoNhomHang();

                ////Lấy hóa đơn nhập
                //con = new Connection();
                //cn = con.openConnection();
                //List<Entities.HoaDonNhap> HoaDonNhap = new List<Entities.HoaDonNhap>();
                //cmd = new SqlCommand("exec sp_BCNhapHangTheoNhomHangFIX @ThaoTac", cn);
                //cmd.Parameters.Add("ThaoTac", SqlDbType.NVarChar).Value = "HoaDonNhap";
                //dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
                //while (dr.Read())
                //{
                //    Entities.HoaDonNhap row = new Entities.HoaDonNhap();
                //    row.MaHoaDonNhap = dr["MaHoaDonNhap"].ToString();
                //    row.NgayNhap = DateTime.Parse(dr["NgayNhap"].ToString());
                //    HoaDonNhap.Add(row);
                //}
                //list.HoaDonNhap = HoaDonNhap;
                //cmd.Connection.Dispose();
                //cn.Close();
                //con.closeConnection();

                //Lấy chi tiết hóa đơn nhập
                con = new Connection();
                cn = con.openConnection();
                List<Entities.ChiTietHoaDonNhap> ChiTietHoaDonNhap = new List<Entities.ChiTietHoaDonNhap>();
                cmd = new SqlCommand("exec sp_BCNhapHangTheoNhomHangFIX @ThaoTac", cn);
                cmd.Parameters.Add("ThaoTac", SqlDbType.NVarChar).Value = "ChiTietHoaDonNhap";
                dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
                while (dr.Read())
                {
                    Entities.ChiTietHoaDonNhap row = new Entities.ChiTietHoaDonNhap();
                    row.MaHoaDonNhap = dr["MaHoaDonNhap"].ToString();
                    row.MaHangHoa = dr["MaHangHoa"].ToString();
                    row.SoLuong = int.Parse(dr["SoLuong"].ToString());
                    row.NgayNhap = DateTime.Parse(dr["NgayNhap"].ToString());
                    ChiTietHoaDonNhap.Add(row);
                }
                list.ChiTietHoaDonNhap = ChiTietHoaDonNhap;
                cmd.Connection.Dispose();
                cn.Close();
                con.closeConnection();

                ////Lấy khách hàng trả lại
                //con = new Connection();
                //cn = con.openConnection();
                //List<Entities.KhachHangTraLai> KhachHangTraLai = new List<Entities.KhachHangTraLai>();
                //cmd = new SqlCommand("exec sp_BCNhapHangTheoNhomHangFIX @ThaoTac", cn);
                //cmd.Parameters.Add("ThaoTac", SqlDbType.NVarChar).Value = "KhachHangTraLai";
                //dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
                //while (dr.Read())
                //{
                //    Entities.KhachHangTraLai row = new Entities.KhachHangTraLai();
                //    row.MaKhachHangTraLai = dr["MaKhachHangTraLai"].ToString();
                //    row.NgayNhap = DateTime.Parse(dr["NgayNhap"].ToString());
                //    KhachHangTraLai.Add(row);
                //}
                //list.KhachHangTraLai = KhachHangTraLai;
                //cmd.Connection.Dispose();
                //cn.Close();
                //con.closeConnection();

                //Lấy chi tiết khách hàng trả lại
                con = new Connection();
                cn = con.openConnection();
                List<Entities.ChiTietKhachHangTraLai> ChiTietKhachHangTraLai = new List<Entities.ChiTietKhachHangTraLai>();
                cmd = new SqlCommand("exec sp_BCNhapHangTheoNhomHangFIX @ThaoTac", cn);
                cmd.Parameters.Add("ThaoTac", SqlDbType.NVarChar).Value = "ChiTietKhachHangTraLai";
                dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
                while (dr.Read())
                {
                    Entities.ChiTietKhachHangTraLai row = new Entities.ChiTietKhachHangTraLai();
                    row.MaKhachHangTraLai = dr["MaKhachHangTraLai"].ToString();
                    row.MaHangHoa = dr["MaHangHoa"].ToString();
                    row.SoLuong = int.Parse(dr["SoLuong"].ToString());
                    row.NgayNhap = DateTime.Parse(dr["NgayNhap"].ToString());
                    ChiTietKhachHangTraLai.Add(row);
                }
                list.ChiTietKhachHangTraLai = ChiTietKhachHangTraLai;
                cmd.Connection.Dispose();
                cn.Close();
                con.closeConnection();

                //Lấy hàng hóa nhóm hàng
                con = new Connection();
                cn = con.openConnection();
                List<Entities.HangHoa> HangHoa = new List<Entities.HangHoa>();
                cmd = new SqlCommand("exec sp_BCNhapHangTheoNhomHangFIX @ThaoTac", cn);
                cmd.Parameters.Add("ThaoTac", SqlDbType.NVarChar).Value = "HangHoaNhomHang";
                dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
                while (dr.Read())
                {
                    Entities.HangHoa row = new Entities.HangHoa();
                    row.MaHangHoa = dr["MaHangHoa"].ToString();
                    row.TenHangHoa = dr["TenHangHoa"].ToString();
                    row.MaNhomHangHoa = dr["MaNhomHang"].ToString();
                    row.TenNhomHangHoa = dr["TenNhomHang"].ToString();
                    HangHoa.Add(row);
                }
                list.HangHoa = HangHoa;
                cmd.Connection.Dispose();
                cn.Close();
                con.closeConnection();

                //Lấy nhóm hàng
                con = new Connection();
                cn = con.openConnection();
                List<Entities.NhomHang> NhomHang = new List<Entities.NhomHang>();
                cmd = new SqlCommand("exec sp_BCNhapHangTheoNhomHangFIX @ThaoTac", cn);
                cmd.Parameters.Add("ThaoTac", SqlDbType.NVarChar).Value = "NhomHang";
                dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
                while (dr.Read())
                {
                    Entities.NhomHang row = new Entities.NhomHang();
                    row.MaNhomHang = dr["MaNhomHang"].ToString();
                    row.TenNhomHang = dr["TenNhomHang"].ToString();
                    NhomHang.Add(row);
                }
                list.NhomHang = NhomHang;
                cmd.Connection.Dispose();
                cn.Close();
                con.closeConnection();

                //Lấy gói hàng
                con = new Connection();
                cn = con.openConnection();
                List<Entities.GoiHang> GoiHang = new List<Entities.GoiHang>();
                cmd = new SqlCommand("exec sp_BCNhapHangTheoNhomHangFIX @ThaoTac", cn);
                cmd.Parameters.Add("ThaoTac", SqlDbType.NVarChar).Value = "GoiHang";
                dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
                while (dr.Read())
                {
                    Entities.GoiHang row = new Entities.GoiHang();
                    row.MaGoiHang = dr["MaGoiHang"].ToString();
                    GoiHang.Add(row);
                }
                list.GoiHang = GoiHang;
                cmd.Connection.Dispose();
                cn.Close();
                con.closeConnection();

                //Lấy chi tiết gói hàng
                con = new Connection();
                cn = con.openConnection();
                List<Entities.ChiTietGoiHang> ChiTietGoiHang = new List<Entities.ChiTietGoiHang>();
                cmd = new SqlCommand("exec sp_BCNhapHangTheoNhomHangFIX @ThaoTac", cn);
                cmd.Parameters.Add("ThaoTac", SqlDbType.NVarChar).Value = "ChiTietGoiHang";
                dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
                while (dr.Read())
                {
                    Entities.ChiTietGoiHang row = new Entities.ChiTietGoiHang();
                    row.MaGoiHang = dr["MaGoiHang"].ToString();
                    row.MaHangHoa = dr["MaHangHoa"].ToString();
                    row.SoLuong = int.Parse(dr["SoLuong"].ToString());
                    ChiTietGoiHang.Add(row);
                }
                list.ChiTietGoiHang = ChiTietGoiHang;
                cmd.Connection.Dispose();
                cn.Close();
                con.closeConnection();

            }
            catch { return null; }
            finally
            {
                cmd.Connection.Dispose();
                cn.Close();
                con.closeConnection();
            }
            return list;
        }
        /// <summary>
        /// hungvv =======================giao tiep voi server===========================
        /// </summary>
        private void Select_ChiTietHoaDonNhap(string hanhdong)
        {
            Entities.HoaDonNhap pt = new Entities.HoaDonNhap();
            pt = new Entities.HoaDonNhap(hanhdong);
            Entities.ChiTietHoaDonNhap[] pt1 = new Entities.ChiTietHoaDonNhap[10];
            clientstrem = cl.SerializeObj(this.client, "ChiTietHoaDonNhap", pt);

            Binding((Entities.ChiTietHoaDonNhap[])cl.DeserializeHepper(clientstrem, pt1));
        }
 public void LayChiTietHoaDonNhap()
 {
     cl = new Server_Client.Client();
     this.client = cl.Connect(Luu.IP, Luu.Ports);
     Entities.CheckRefer ctxh = new Entities.CheckRefer("CTHDN", "");
     clientstrem = cl.SerializeObj(this.client, "Select", ctxh);
     Entities.ChiTietHoaDonNhap[] ctHDN1 = new Entities.ChiTietHoaDonNhap[0];
     ctHDN1 = (Entities.ChiTietHoaDonNhap[])cl.DeserializeHepper1(clientstrem, ctHDN1);
     if (ctHDN1 == null)
     {
         ctHDN = new Entities.ChiTietHoaDonNhap[0];
         return;
     }
     else
         ctHDN = ctHDN1;
 }