public static Product Load(UInt32 prd_id)
{
return(HelperDal <Product> .Load("SELECT * FROM product WHERE prd_id=" + prd_id));
}
public static Supplier Load(UInt32 sup_id)
{
return(HelperDal <Supplier> .Load("SELECT * FROM supplier WHERE sup_id=" + sup_id));
}
public static SiteSupplier Load(UInt32 sit_id, UInt32 sup_id)
{
return(HelperDal <SiteSupplier> .Load("SELECT * FROM site_supplier WHERE sit_id=" + sit_id + " AND sup_id=" + sup_id));
}
public static DeliveryDetail Load(UInt32 dlm_id, UInt32 prd_id)
{
return(HelperDal <DeliveryDetail> .Load("SELECT * FROM delivery_detail WHERE dlm_id=" + dlm_id + " AND prd_id=" + prd_id));
}
public static PorderDetail Load(UInt32 pom_id, UInt32 prd_id)
{
return(HelperDal <PorderDetail> .Load("SELECT * FROM porder_detail WHERE pom_id=" + pom_id + " AND prd_id=" + prd_id));
}
public static Delivery Load(UInt32 dlm_id)
{
return(HelperDal <Delivery> .Load("SELECT * FROM delivery WHERE dlm_id=" + dlm_id));
}
public static Porder Load(String pom_id)
{
return(HelperDal <Porder> .Load("SELECT * FROM porder WHERE pom_id=" + pom_id));
}
public static Employee Load(String emp_login)
{
return(HelperDal <Employee> .Load("SELECT * FROM employee WHERE emp_login='******'"));
}
public static Invoice Load(UInt32 inv_id)
{
return(HelperDal <Invoice> .Load("SELECT * FROM invoice WHERE inv_id=" + inv_id));
}
public static Department Load(UInt32 dep_id)
{
return(HelperDal <Department> .Load("SELECT * FROM department WHERE dep_id=" + dep_id));
}
public static Log Load(UInt32 log_id)
{
return(HelperDal <Log> .Load("SELECT * FROM log WHERE inv_id=" + log_id));
}
public static StockoutDetail Load(UInt32 som_id, UInt32 prd_id)
{
return(HelperDal <StockoutDetail> .Load("SELECT * FROM stockout_detail WHERE som_id=" + som_id + " AND prd_id=" + prd_id));
}
public static Employee Load(UInt32 emp_id)
{
return(HelperDal <Employee> .Load("SELECT * FROM employee WHERE emp_id=" + emp_id));
}
public static Stockout Load(String som_id)
{
return(HelperDal <Stockout> .Load("SELECT * FROM stockout WHERE som_id=" + som_id));
}
public static Stock Load(UInt32 sit_id, UInt32 prd_id)
{
return(HelperDal <Stock> .Load("SELECT * FROM stock WHERE sit_id=" + sit_id + " AND prd_id=" + prd_id));
}
public static Site Load(UInt32 sit_id)
{
return(HelperDal <Site> .Load("SELECT * FROM site WHERE sit_id=" + sit_id));
}
public static Role Load(UInt32 rol_id)
{
return(HelperDal <Role> .Load("SELECT * FROM role WHERE rol_id=" + rol_id));
}