public static DataTable QuanLyKho()
{
string query = "USP_QuanLyKho";
DataTable data = SqlServerHelper.ExecuteQuery(query);
return(data);
}
public static DataTable ThongKe(DateTime fromday, DateTime today)
{
string query = "USP_ThongKe @fromday , @today ";
DataTable data = SqlServerHelper.ExecuteQuery(query, new object[] { fromday, today });
return(data);
}
public static DataTable HienThiHoaDon(int idtable)
{
string query = "HienThiHoaDon @idtable ";
DataTable data = SqlServerHelper.ExecuteQuery(query, new object[] { idtable });
return(data);
}
public static List <BanAnDTO> DanhSachBanAnList()
{
DataTable ans = new DataTable();
string query = "SELECT * FROM BANAN";
ans = SqlServerHelper.ExecuteQuery(query);
List <BanAnDTO> ketqua = new List <BanAnDTO>();
ketqua.Clear();
foreach (DataRow row in ans.Rows)
{
BanAnDTO banan = new BanAnDTO(row);
ketqua.Add(banan);
}
return(ketqua);
}
public static void XoaBanAn(int MaBA)
{
string query = "DELETE FROM BANAN WHERE MABA = @MABA";
SqlServerHelper.ExecuteQuery(query, new object[] { MaBA });
}
public static DataTable DanhSachBanTrong()
{
string query = "select * from BANAN where TRANGTHAI = 0";
return(SqlServerHelper.ExecuteQuery(query));
}
public static DataTable DanhSachBanAn()
{
string query = "SELECT * FROM BANAN";
return(SqlServerHelper.ExecuteQuery(query));
}