C# (CSharp) DataAccessLayer HelperDal.Load示例

示例#1

文件： ProductDal.cs 项目： maximfluieraru/MAP

 public static Product Load(UInt32 prd_id)
 {
     return(HelperDal <Product> .Load("SELECT * FROM product WHERE prd_id=" + prd_id));
 }

示例#2

 public static Supplier Load(UInt32 sup_id)
 {
     return(HelperDal <Supplier> .Load("SELECT * FROM supplier WHERE sup_id=" + sup_id));
 }

示例#3

文件： SiteSupplierDal.cs 项目： maximfluieraru/MAP

 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));
 }

示例#4

文件： DeliveryDetailDal.cs 项目： maximfluieraru/MAP

 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));
 }

示例#5

文件： PorderDetailDal.cs 项目： maximfluieraru/MAP

 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));
 }

示例#6

文件： DeliveryDal.cs 项目： maximfluieraru/MAP

 public static Delivery Load(UInt32 dlm_id)
 {
     return(HelperDal <Delivery> .Load("SELECT * FROM delivery WHERE dlm_id=" + dlm_id));
 }

示例#7

文件： PorderDal.cs 项目： maximfluieraru/MAP

 public static Porder Load(String pom_id)
 {
     return(HelperDal <Porder> .Load("SELECT * FROM porder WHERE pom_id=" + pom_id));
 }

示例#8

 public static Employee Load(String emp_login)
 {
     return(HelperDal <Employee> .Load("SELECT * FROM employee WHERE emp_login='******'"));
 }

示例#9

 public static Invoice Load(UInt32 inv_id)
 {
     return(HelperDal <Invoice> .Load("SELECT * FROM invoice WHERE inv_id=" + inv_id));
 }

示例#10

文件： DepartmentDal.cs 项目： maximfluieraru/MAP

 public static Department Load(UInt32 dep_id)
 {
     return(HelperDal <Department> .Load("SELECT * FROM department WHERE dep_id=" + dep_id));
 }

示例#11

 public static Log Load(UInt32 log_id)
 {
     return(HelperDal <Log> .Load("SELECT * FROM log WHERE inv_id=" + log_id));
 }

示例#12

 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));
 }

示例#13

 public static Employee Load(UInt32 emp_id)
 {
     return(HelperDal <Employee> .Load("SELECT * FROM employee WHERE emp_id=" + emp_id));
 }

示例#14

文件： StockoutDal.cs 项目： maximfluieraru/MAP

 public static Stockout Load(String som_id)
 {
     return(HelperDal <Stockout> .Load("SELECT * FROM stockout WHERE som_id=" + som_id));
 }

示例#15

文件： StockDal.cs 项目： maximfluieraru/MAP

 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));
 }

示例#16

文件： SiteDal.cs 项目： maximfluieraru/MAP

 public static Site Load(UInt32 sit_id)
 {
     return(HelperDal <Site> .Load("SELECT * FROM site WHERE sit_id=" + sit_id));
 }

示例#17

文件： RoleDal.cs 项目： maximfluieraru/MAP

 public static Role Load(UInt32 rol_id)
 {
     return(HelperDal <Role> .Load("SELECT * FROM role WHERE rol_id=" + rol_id));
 }