public DataTable load_KhuVuc(object parent_id)
{
DataTable re;
String lenh_3 = "select * from DIACHI where parent_id = " + parent_id;
re = XuLy.TaoBang(lenh_3);
return(re);
}
public DataTable load_Shipper(object parent_id)
{
DataTable re;
String lenh_4 = "select * from SHIPPER where KhuVucPhuTrach = " + parent_id;
re = XuLy.TaoBang(lenh_4);
return(re);
}
//private string maDH { get; set; }
//private string maNV { get; set; }
//private string tenKH { get; set; }
//private string sdt { get; set; }
//private string tinh { get; set; }
//private string huyen { get; set; }
//private string xa { get; set; }
//private string chiTiet { get; set; }
//private string ngayLap { get; set; }
//private string moTa { get; set; }
//private string tienHang { get; set; }
//private string phiShip { get; set; }
//private string shipper { get; set; }
//private string tongTien { get; set; }
public DataTable load_On()
{
DataTable re;
String lenh = "select * from DONHANG";
re = XuLy.TaoBang(lenh);
return(re);
}
public DataTable load_City()
{
DataTable re;
String lenh_2 = "select * from DIACHI where parent_id = 0";
re = XuLy.TaoBang(lenh_2);
return(re);
}
public DataTable load_KhuVuc(object KhuVuc)
{
DataTable re;
String lenh_3 = "Select TenShipper,MaDonHang,MaNhanVien,TenKhachHang,DONHANG.SDT,Tinh,Huyen,DCChiTiet,MoTa,TienHang,PhiShip,TongTienDonHang from DonHang join Shipper on DonHang.Shipper = Shipper.MaShipper where Huyen = N'" + KhuVuc + "' ";
re = XuLy.TaoBang(lenh_3);
return(re);
}
public DataTable Load_On()
{
DataTable re;
String lenh = "select * from SHIPPER";
re = XuLy.TaoBang(lenh);
return(re);
}
public DataTable load_DonHang(object MaShipper)
{
DataTable re;
String lenh_2 = "select TenShipper,Count(MaDonHang) as TongDonHang from DONHANG join SHIPPER on DONHANG.Shipper = SHIPPER.MaShipper where Shipper = " + MaShipper + " group by TenShipper ";
re = XuLy.TaoBang(lenh_2);
return(re);
}
public DataTable load_DoanhThu(object MaShipper)
{
DataTable re;
String lenh_1 = "select TenShipper,sum(PhiShip) as DoanhThu from DONHANG join SHIPPER on DONHANG.Shipper = SHIPPER.MaShipper where Shipper =" + MaShipper + " group by TenShipper ";
re = XuLy.TaoBang(lenh_1);
return(re);
}
public DataTable load_On_KhuVuc()
{
DataTable re;
String lenh_KhuVuc = "select * from DIACHI where parent_id != 0";
re = XuLy.TaoBang(lenh_KhuVuc);
return(re);
}
public DataTable load_On()
{
DataTable re;
String lenh_all = "select * from Shipper";
re = XuLy.TaoBang(lenh_all);
return(re);
}
public DataTable load_DoanhThu(object MaShipper)
{
DataTable re;
String lenh_1 = "Select TenShipper,MaDonHang,MaNhanVien,TenKhachHang,DONHANG.SDT,Tinh,Huyen,DCChiTiet,MoTa,TienHang,PhiShip,TongTienDonHang from DonHang join Shipper on DonHang.Shipper = Shipper.MaShipper where DonHang.Shipper = N'" + MaShipper + "' ";
re = XuLy.TaoBang(lenh_1);
return(re);
}