public static DataTable getData()
{
return(GenericDAL.getData("sp_GetAllChatLieu", Conn));
}
public static DataTable XuatMatHangHDB(string soHDB)
{
SqlParameter[] sqlP = new SqlParameter[1];
sqlP[0] = new SqlParameter("@SoHDB", soHDB);
return(GenericDAL.getData("sp_XuatMatHangHDB", sqlP, Conn));
}
public static DataTable getData()
{
return(GenericDAL.getData("sp_GetAllNhomHang", Conn));
}
public static DataTable getYearHDB()
{
return(GenericDAL.getData("sp_getYearHDB", Conn));
}
// EXCEL QUES
public static DataTable GetBillBan(string soHDB)
{
SqlParameter[] sqlP = new SqlParameter[1];
sqlP[0] = new SqlParameter("@SoHDB", soHDB);
return(GenericDAL.getData("sp_XuatHoaDonBan", sqlP, Conn));
}
public static DataTable getData()
{
return(GenericDAL.getData("sp_GetAllHDBan", Conn));
}
public static DataTable GetBillNhap(string soHDN)
{
SqlParameter[] sqlP = new SqlParameter[1];
sqlP[0] = new SqlParameter("@SoHDN", soHDN);
return(GenericDAL.getData("sp_XuatHoaDonNhap", sqlP, Conn));
}
public static DataTable getDataForSearch()
{
return(GenericDAL.getData("sp_GetAllHDNhap_WithSearch", Conn));
}
public static DataTable GetInfoAccount(string userName)
{
SqlParameter[] sqlP = new SqlParameter[1];
sqlP[0] = new SqlParameter("@userName", userName);
return(GenericDAL.getData("sp_GetInfoAccount", sqlP, Conn));
}
public static DataTable getData()
{
return(GenericDAL.getData("sp_GetAllDonViTinh", Conn));
}
