public static int KTHoaDon_Temp(string IDHoaDon)
{
int r1 = 0, r2 = 0;
string sTruyVan1 = string.Format(@"SELECT * FROM [CF_ChiTietHoaDon_Temp] WHERE IDHoaDon = '" + IDHoaDon + "'");
string sTruyVan2 = string.Format(@"SELECT * FROM [CF_ChiTietGio] WHERE IDHoaDon = '" + IDHoaDon + "'");
DataTable data1 = new DataTable();
data1 = DataProvider.TruyVanLayDuLieu(sTruyVan1);
if (data1.Rows.Count > 0)
{
r1 = 1;
}
DataTable data2 = new DataTable();
data2 = DataProvider.TruyVanLayDuLieu(sTruyVan2);
if (data2.Rows.Count > 0)
{
r2 = 1;
}
if (r1 == 1 && r2 == 1)
{
return(0);
}
else if (r1 == 1)
{
return(1);
}
else
{
return(2);
}
}
/// <summary>
/// Thông tin của hàng
/// </summary>
/// <returns></returns>
public static DataTable ThongTinCuaHang(string IDChiNhanh)
{
string sTruyVan = string.Format(@"SELECT * FROM [CF_ChiNhanh] WHERE ID = '" + IDChiNhanh + "'");
DataTable data = new DataTable();
return(data = DataProvider.TruyVanLayDuLieu(sTruyVan));
}
public static DataTable DanhSachNhomHang()
{
string sTruyVan = string.Format(@"SELECT * FROM [CF_NhomHangHoa] ");
DataTable data = new DataTable();
data = DataProvider.TruyVanLayDuLieu(sTruyVan);
return(data);
}
public static DataTable ThongTinNhanVien(string TenDangNhap, string MatKhau)
{
string sTryVan = string.Format(@"SELECT * FROM [CF_NguoiDung] WHERE [TenDangNhap] = N'{0}' AND [DAXOA] = 0 AND [MatKhau] =N'{1}'", TenDangNhap, MatKhau);
DataTable data = new DataTable();
data = DataProvider.TruyVanLayDuLieu(sTryVan);
return(data);
}
public static DataTable DanhSachTuChon_ID(int IDnguyenLieu)
{
string sTruyVan = string.Format(@"SELECT [CF_NguyenLieu].*,[CF_DonViTinh].TenDonViTinh FROM [CF_NguyenLieu],[CF_DonViTinh] WHERE [CF_DonViTinh].ID = [CF_NguyenLieu].IDDonViTinh AND [CF_NguyenLieu].ID = {0}", IDnguyenLieu);
DataTable data = new DataTable();
data = DataProvider.TruyVanLayDuLieu(sTruyVan);
return(data);
}
public static DataTable DanhSachTuChon()
{
string sTruyVan = string.Format(@"SELECT * FROM [CF_NguyenLieu] WHERE DaXoa = 0 AND TrangThai = 1");
DataTable data = new DataTable();
data = DataProvider.TruyVanLayDuLieu(sTruyVan);
return(data);
}
public static DataTable DanhSachHangHoaTimKiem(string TenHangHoa, string IDChiNhanh)
{
string sTruyVan = string.Format(@"SELECT * FROM [CF_HangHoa] WHERE TenHangHoa LIKE N'%" + TenHangHoa + "%' AND DaXoa = 0 AND [IDChiNhanh] = '" + IDChiNhanh + "' ORDER BY TenHangHoa ASC");
DataTable data = new DataTable();
data = DataProvider.TruyVanLayDuLieu(sTruyVan);
return(data);
}
public static DataTable DanhSachHangHoa(string IDNhomHang)
{
string sTruyVan = string.Format(@"SELECT * FROM [CF_HangHoa] WHERE [IDNhomHang] = {0}", IDNhomHang);
DataTable data = new DataTable();
data = DataProvider.TruyVanLayDuLieu(sTruyVan);
return(data);
}
/// <summary>
/// Danh sach hàng hóa cho lis
/// </summary>
/// <param name="IDNhomHang"></param>
/// <returns></returns>
///
public static DataTable DanhSachHangHoa_Full2(string IDChiNhanh)
{
string sTruyVan = string.Format(@"SELECT [CF_HangHoa].*,[CF_DonViTinh].[TenDonViTinh] as DVT FROM [CF_HangHoa],[CF_DonViTinh] WHERE [CF_HangHoa].IDDonViTinh = [CF_DonViTinh].ID AND [CF_HangHoa].DaXoa = 0 AND [CF_HangHoa].IDChiNhanh = '" + IDChiNhanh + "' ORDER BY [CF_HangHoa].TenHangHoa ASC");
DataTable data = new DataTable();
data = DataProvider.TruyVanLayDuLieu(sTruyVan);
return(data);
}
public static DataTable DanhSachBan(string IDKhuVuc)
{
string sTruyVan = string.Format(@"SELECT * FROM [CF_Ban] WHERE IDKhuVuc = {0} ", IDKhuVuc);
DataTable data = new DataTable();
data = DataProvider.TruyVanLayDuLieu(sTruyVan);
return(data);
}
public static int ThongKeBan(string IDChiNhanh, int TrangThai)
{
string sTruyVan = string.Format(@"SELECT * FROM [CF_Ban] WHERE IDChiNhanh = {0} AND [TrangThai] = {1}", IDChiNhanh, TrangThai);
DataTable data = new DataTable();
data = DataProvider.TruyVanLayDuLieu(sTruyVan);
return(data.Rows.Count);
}
public static DataTable DanhSachKhuVuc(string IDChiNhanh)
{
string sTruyVan = string.Format(@"SELECT * FROM [CF_KhuVuc] WHERE IDChiNhanh = {0} AND DAXOA = 0", IDChiNhanh);
DataTable data = new DataTable();
data = DataProvider.TruyVanLayDuLieu(sTruyVan);
return(data);
}
public static DataTable DanhSachMonAnBanChay()
{
string sTruyVan = string.Format(@" SELECT TOP 16 SUM([CF_ChiTietHoaDon].SoLuong) as SL, [CF_ChiTietHoaDon].IDHangHoa,[CF_HangHoa].TenHangHoa FROM [CF_ChiTietHoaDon],[CF_HangHoa] WHERE [CF_ChiTietHoaDon].TrongLuong = 0 AND [CF_HangHoa].ID = [CF_ChiTietHoaDon].IDHangHoa GROUP BY [CF_ChiTietHoaDon].IDHangHoa,[CF_HangHoa].TenHangHoa ORDER BY SL DESC");
DataTable data = new DataTable();
data = DataProvider.TruyVanLayDuLieu(sTruyVan);
return(data);
}
public static bool KiemTraHangHoa(int IDHoaDon, int IDHangHoa, int IDBan)
{
string sTruyVan = string.Format(@"SELECT * FROM [CF_ChiTietHoaDon] WHERE IDBan = {0} AND IDHangHoa = {1} AND [IDHoaDon] = {2}", IDBan, IDHangHoa, IDHoaDon);
DataTable data = new DataTable();
data = DataProvider.TruyVanLayDuLieu(sTruyVan);
if (data.Rows.Count > 0)
{
return(true);
}
return(false);
}
public static int KiemTraSDTKhachHang(string SDT)
{
string sTruyVan = string.Format(@"SELECT * FROM [GPM_KHACHHANG] WHERE DienThoai = '{0}'", SDT);
DataTable data = new DataTable();
data = DataProvider.TruyVanLayDuLieu(sTruyVan);
if (data.Rows.Count == 0)
{
return(0);
}
return(1);
}
public static bool KiemTraHangHoa(int IDHoaDon, int IDHangHoa, int IDBan, float TrongLuong, string IDChiNhanh)
{
string sTruyVan = string.Format(@"SELECT * FROM [CF_ChiTietHoaDon_Temp] WHERE IDBan = {0} AND IDHangHoa = {1} AND [IDHoaDon] = {2} AND TrongLuong = {3} AND [IDChiNhanh] = '" + IDChiNhanh + "'", IDBan, IDHangHoa, IDHoaDon, TrongLuong);
DataTable data = new DataTable();
data = DataProvider.TruyVanLayDuLieu(sTruyVan);
if (data.Rows.Count > 0)
{
return(true);
}
return(false);
}
public static float TongTienGio(int IDHoaDon)
{
string sTruyVan = string.Format(@"SELECT TienGio FROM [CF_HoaDon] WHERE ID = {0} ", IDHoaDon);
DataTable data = new DataTable();
data = DataProvider.TruyVanLayDuLieu(sTruyVan);
if (data.Rows.Count > 0)
{
DataRow dr = data.Rows[0];
return(float.Parse(dr["TienGio"].ToString()));
}
return(0);
}
public static float LayGiaTheoKhuVuc(int IDKhuVuc)
{
string sTruyVan = string.Format(@"SELECT GiaKhuVuc FROM [CF_KhuVuc] WHERE [ID] = {0} ", IDKhuVuc);
DataTable data = new DataTable();
data = DataProvider.TruyVanLayDuLieu(sTruyVan);
if (data.Rows.Count > 0)
{
DataRow dr = data.Rows[0];
return(float.Parse(dr["GiaKhuVuc"].ToString()));
}
return(0);
}
/// <summary>
/// lấy giá bán tự chọn
/// </summary>
/// <param name="IDHangHoa"></param>
/// <param name="IDBangGia"></param>
/// <returns></returns>
public static float LayGiaBanTuChon(string IDNguyenLieu)
{
string sTruyVan = string.Format(@"SELECT GiaBan FROM [CF_NguyenLieu] WHERE ID = {0}", IDNguyenLieu);
DataTable data = new DataTable();
data = DataProvider.TruyVanLayDuLieu(sTruyVan);
if (data.Rows.Count > 0)
{
DataRow dr = data.Rows[0];
return(float.Parse(dr["GiaBan"].ToString()));
}
return(-1);
}
public static int IDHoaDon(int IDBan)
{
string sTruyVan = string.Format(@"SELECT ID FROM [CF_HoaDon] WHERE IDBan = {0} AND [TrangThai] = 0", IDBan);
DataTable data = new DataTable();
data = DataProvider.TruyVanLayDuLieu(sTruyVan);
if (data.Rows.Count > 0)
{
DataRow dr = data.Rows[0];
return(Int32.Parse(dr["ID"].ToString()));
}
return(0);
}
public static DateTime GioVao_IDBan(int IDBan)
{
string sTruyVan = string.Format(@"SELECT GioVao FROM [CF_HoaDon] WHERE IDBan = {0} AND [TrangThai] = 0", IDBan);
DataTable data = new DataTable();
data = DataProvider.TruyVanLayDuLieu(sTruyVan);
if (data.Rows.Count > 0)
{
DataRow dr = data.Rows[0];
return(DateTime.Parse(dr["GioVao"].ToString()));
}
return(DateTime.Parse(DateTime.Now.ToString("yyyy-MM-dd H:mm:ss")));
}
public static DateTime GioBatDauBiDa(int IDBan, int IDHoaDon)
{
string sTruyVan = string.Format(@"SELECT GioBatDau FROM [CF_ChiTietGio] WHERE IDBan = {0} AND [TrangThai] = 0 AND [IDHoaDon] = {1}", IDBan, IDHoaDon);
DataTable data = new DataTable();
data = DataProvider.TruyVanLayDuLieu(sTruyVan);
if (data.Rows.Count > 0)
{
DataRow dr = data.Rows[0];
return(DateTime.Parse(dr["GioBatDau"].ToString()));
}
return(DateTime.Parse(DateTime.Now.ToString("yyyy-MM-dd H:mm")));
}
/// <summary>
/// lấy giá bán theo bảng giá
/// </summary>
/// <param name="IDBan"></param>
/// <returns></returns>
public static float LayGiaBan(int IDHangHoa, int IDBangGia)
{
string sTruyVan = string.Format(@"SELECT GiaMoi FROM [CF_ChiTietBangGia] WHERE IDBangGia = {0} AND IDHangHoa = {1}", IDBangGia, IDHangHoa);
DataTable data = new DataTable();
data = DataProvider.TruyVanLayDuLieu(sTruyVan);
if (data.Rows.Count > 0)
{
DataRow dr = data.Rows[0];
return(float.Parse(dr["GiaMoi"].ToString()));
}
return(-1);
}
/// <summary>
/// truyền IDKhuVuc
/// </summary>
/// <param name="IDKhuVuc"></param>
/// <returns></returns>
public static string LayTenKhuVuc(int IDKhuVuc)
{
string sTruyVan = string.Format(@"SELECT TenKhuVuc FROM [CF_KhuVuc] WHERE [ID] = {0} ", IDKhuVuc);
DataTable data = new DataTable();
data = DataProvider.TruyVanLayDuLieu(sTruyVan);
if (data.Rows.Count > 0)
{
DataRow dr = data.Rows[0];
return(dr["TenKhuVuc"].ToString());
}
return(null);
}
public static int LayIDKhuVuc(int IDBan)
{
string sTruyVan = string.Format(@"SELECT IDKhuVuc FROM [CF_Ban] WHERE [ID] = {0} ", IDBan);
DataTable data = new DataTable();
data = DataProvider.TruyVanLayDuLieu(sTruyVan);
if (data.Rows.Count > 0)
{
DataRow dr = data.Rows[0];
return(Int32.Parse(dr["IDKhuVuc"].ToString()));
}
return(-1);
}
public static string TenBan(int IDBan)
{
string sTruyVan = string.Format(@"SELECT * FROM [CF_Ban] WHERE ID = {0} ", IDBan);
DataTable data = new DataTable();
data = DataProvider.TruyVanLayDuLieu(sTruyVan);
if (data.Rows.Count > 0)
{
DataRow dr = data.Rows[0];
return(dr["TenBan"].ToString());
}
return(null);
}
public static int LayTyLe(string GioVao)
{
string sTruyVan = string.Format(@"SELECT TyLe FROM [CF_Gio] WHERE '{0}' BETWEEN GioBatDau AND GioKetThuc", GioVao);
DataTable data = new DataTable();
data = DataProvider.TruyVanLayDuLieu(sTruyVan);
if (data.Rows.Count > 0)
{
DataRow dr = data.Rows[0];
return(Int32.Parse(dr["TyLe"].ToString()));
}
return(0);
}
public static float GiamGia(int IDHoaDon, string IDChiNhanh)
{
string sTruyVan = string.Format(@"SELECT TyLeGiamGia FROM [CF_HoaDon] WHERE ID = {0} AND [IDChiNhanh] = '" + IDChiNhanh + "'", IDHoaDon);
DataTable data = new DataTable();
data = DataProvider.TruyVanLayDuLieu(sTruyVan);
if (data.Rows.Count > 0)
{
DataRow dr = data.Rows[0];
return(float.Parse(dr["TyLeGiamGia"].ToString()));
}
return(0);
}
public static string HinhThucGiamGia(int IDHoaDon, string IDChiNhanh)
{
string sTruyVan = string.Format(@"SELECT HinhThucGiamGia FROM [CF_HoaDon] WHERE ID = {0} AND [IDChiNhanh] = '{1}' ", IDHoaDon, IDChiNhanh);
DataTable data = new DataTable();
data = DataProvider.TruyVanLayDuLieu(sTruyVan);
if (data.Rows.Count > 0)
{
DataRow dr = data.Rows[0];
return(dr["HinhThucGiamGia"].ToString());
}
return("$");
}
public static float LayTienQuyDoiDiem()
{
string sTruyVan = string.Format(@"SELECT SoTienTichLuy FROM [GPM_Setting] ");
DataTable data = new DataTable();
data = DataProvider.TruyVanLayDuLieu(sTruyVan);
if (data.Rows.Count > 0)
{
DataRow dr = data.Rows[0];
return(float.Parse(dr["SoTienTichLuy"].ToString()));
}
return(0);
}