public void BCNhapHangTheoNhomHang()
{
try
{
cl = new Server_Client.Client();
this.client1 = cl.Connect(Luu.IP, Luu.Ports);
clientstrem = cl.SerializeObj(this.client1, "Select_sp_BCNhapHangTheoNhomHangFIX", null);
DATA = (Entities.BCNhapHangTheoNhomHang)cl.DeserializeHepper(clientstrem, DATA);
if (DATA == null)
{
return;
}
}
catch { }
}
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 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 BCNhapHangTheoNhomHang()
{
try
{
cl = new Server_Client.Client();
this.client1 = cl.Connect(Luu.IP, Luu.Ports);
clientstrem = cl.SerializeObj(this.client1, "Select_sp_BCNhapHangTheoNhomHangFIX", null);
DATA = (Entities.BCNhapHangTheoNhomHang)cl.DeserializeHepper(clientstrem, DATA);
if (DATA == null) { return; }
}
catch { }
}
