public virtual RBACUserGroupInfo GetRBACUserGroupByID(int ID) { RBACUserGroupInfo entity = null; SqlDataReader RdrList = null; try { string SqlList; SqlList = "SELECT * FROM RBAC_UserGroup WHERE RBAC_UserGroup_ID = " + ID; RdrList = DBHelper.ExecuteReader(SqlList); if (RdrList.Read()) { entity = new RBACUserGroupInfo(); entity.RBAC_UserGroup_ID = Tools.NullInt(RdrList["RBAC_UserGroup_ID"]); entity.RBAC_UserGroup_Name = Tools.NullStr(RdrList["RBAC_UserGroup_Name"]); entity.RBAC_UserGroup_ParentID = Tools.NullInt(RdrList["RBAC_UserGroup_ParentID"]); entity.RBAC_UserGroup_Site = Tools.NullStr(RdrList["RBAC_UserGroup_Site"]); } return(entity); } catch (Exception ex) { throw ex; } finally { if (RdrList != null) { RdrList.Close(); RdrList = null; } } }
public virtual OrdersLogInfo GetOrdersLogByID(int ID) { OrdersLogInfo entity = null; SqlDataReader RdrList = null; try { string SqlList; SqlList = "SELECT * FROM Orders_Log WHERE Orders_Log_ID = " + ID; RdrList = DBHelper.ExecuteReader(SqlList); if (RdrList.Read()) { entity = new OrdersLogInfo(); entity.Orders_Log_ID = Tools.NullInt(RdrList["Orders_Log_ID"]); entity.Orders_Log_OrdersID = Tools.NullInt(RdrList["Orders_Log_OrdersID"]); entity.Orders_Log_Addtime = Tools.NullDate(RdrList["Orders_Log_Addtime"]); entity.Orders_Log_Operator = Tools.NullStr(RdrList["Orders_Log_Operator"]); entity.Orders_Log_Remark = Tools.NullStr(RdrList["Orders_Log_Remark"]); entity.Orders_Log_Action = Tools.NullStr(RdrList["Orders_Log_Action"]); entity.Orders_Log_Result = Tools.NullStr(RdrList["Orders_Log_Result"]); } return(entity); } catch (Exception ex) { throw ex; } finally { if (RdrList != null) { RdrList.Close(); RdrList = null; } } }
public virtual ProductPriceInfo GetProductPriceByID(int ID) { ProductPriceInfo entity = null; SqlDataReader RdrList = null; try { string SqlList; SqlList = "SELECT * FROM Product_Price WHERE Product_Price_ID = " + ID; RdrList = DBHelper.ExecuteReader(SqlList); if (RdrList.Read()) { entity = new ProductPriceInfo(); entity.Product_Price_ID = Tools.NullInt(RdrList["Product_Price_ID"]); entity.Product_Price_ProcutID = Tools.NullInt(RdrList["Product_Price_ProcutID"]); entity.Product_Price_MemberGradeID = Tools.NullInt(RdrList["Product_Price_MemberGradeID"]); entity.Product_Price_Price = Tools.NullDbl(RdrList["Product_Price_Price"]); } return(entity); } catch (Exception ex) { throw ex; } finally { if (RdrList != null) { RdrList.Close(); RdrList = null; } } }
public virtual RBACPrivilegeInfo GetRBACPrivilegeByID(string ID) { RBACPrivilegeInfo entity = null; SqlDataReader RdrList = null; try { string SqlList; SqlList = "SELECT * FROM RBAC_Privilege WHERE RBAC_Privilege_ID = '" + ID + "'"; RdrList = DBHelper.ExecuteReader(SqlList); if (RdrList.Read()) { entity = new RBACPrivilegeInfo(); entity.RBAC_Privilege_ID = Tools.NullStr(RdrList["RBAC_Privilege_ID"]); entity.RBAC_Privilege_ResourceID = Tools.NullInt(RdrList["RBAC_Privilege_ResourceID"]); entity.RBAC_Privilege_Name = Tools.NullStr(RdrList["RBAC_Privilege_Name"]); entity.RBAC_Privilege_IsActive = Tools.NullInt(RdrList["RBAC_Privilege_IsActive"]); entity.RBAC_Privilege_Addtime = Tools.NullDate(RdrList["RBAC_Privilege_Addtime"]); } return(entity); } catch (Exception ex) { throw ex; } finally { if (RdrList != null) { RdrList.Close(); RdrList = null; } } }
public virtual PayWayInfo GetPayWayByID(int ID) { PayWayInfo entity = null; SqlDataReader RdrList = null; try { string SqlList; SqlList = "SELECT * FROM Pay_Way WHERE Pay_Way_ID = " + ID; RdrList = DBHelper.ExecuteReader(SqlList); if (RdrList.Read()) { entity = new PayWayInfo(); entity.Pay_Way_ID = Tools.NullInt(RdrList["Pay_Way_ID"]); entity.Pay_Way_Type = Tools.NullInt(RdrList["Pay_Way_Type"]); entity.Pay_Way_Name = Tools.NullStr(RdrList["Pay_Way_Name"]); entity.Pay_Way_Sort = Tools.NullInt(RdrList["Pay_Way_Sort"]); entity.Pay_Way_Status = Tools.NullInt(RdrList["Pay_Way_Status"]); entity.Pay_Way_Cod = Tools.NullInt(RdrList["Pay_Way_Cod"]); entity.Pay_Way_Img = Tools.NullStr(RdrList["Pay_Way_Img"]); entity.Pay_Way_Intro = Tools.NullStr(RdrList["Pay_Way_Intro"]); entity.Pay_Way_Site = Tools.NullStr(RdrList["Pay_Way_Site"]); } return(entity); } catch (Exception ex) { throw ex; } finally { if (RdrList != null) { RdrList.Close(); RdrList = null; } } }
public virtual OrdersBackApplyProductInfo GetOrdersBackApplyProductByID(int ID) { OrdersBackApplyProductInfo entity = null; SqlDataReader RdrList = null; try { string SqlList; SqlList = "SELECT * FROM Orders_BackApply_Product WHERE Orders_BackApply_Product_ID = " + ID; RdrList = DBHelper.ExecuteReader(SqlList); if (RdrList.Read()) { entity = new OrdersBackApplyProductInfo(); entity.Orders_BackApply_Product_ID = Tools.NullInt(RdrList["Orders_BackApply_Product_ID"]); entity.Orders_BackApply_Product_ProductID = Tools.NullInt(RdrList["Orders_BackApply_Product_ProductID"]); entity.Orders_BackApply_Product_ApplyID = Tools.NullInt(RdrList["Orders_BackApply_Product_ApplyID"]); entity.Orders_BackApply_Product_ApplyAmount = Tools.NullInt(RdrList["Orders_BackApply_Product_ApplyAmount"]); } return(entity); } catch (Exception ex) { throw ex; } finally { if (RdrList != null) { RdrList.Close(); RdrList = null; } } }
public virtual SourcesInfo GetSourcesByID(int ID) { SourcesInfo entity = null; SqlDataReader RdrList = null; try { string SqlList; SqlList = "SELECT * FROM Sources WHERE Sources_ID = " + ID; RdrList = DBHelper.ExecuteReader(SqlList); if (RdrList.Read()) { entity = new SourcesInfo(); entity.Sources_ID = Tools.NullInt(RdrList["Sources_ID"]); entity.Sources_Name = Tools.NullStr(RdrList["Sources_Name"]); entity.Sources_Code = Tools.NullStr(RdrList["Sources_Code"]); entity.Sources_Site = Tools.NullStr(RdrList["Sources_Site"]); } return(entity); } catch (Exception ex) { throw ex; } finally { if (RdrList != null) { RdrList.Close(); RdrList = null; } } }
public virtual MemberGradeInfo GetMemberGradeByID(int ID) { MemberGradeInfo entity = null; SqlDataReader RdrList = null; try { string SqlList; SqlList = "SELECT * FROM Member_Grade WHERE Member_Grade_ID = " + ID; RdrList = DBHelper.ExecuteReader(SqlList); if (RdrList.Read()) { entity = new MemberGradeInfo(); entity.Member_Grade_ID = Tools.NullInt(RdrList["Member_Grade_ID"]); entity.Member_Grade_Name = Tools.NullStr(RdrList["Member_Grade_Name"]); entity.Member_Grade_Percent = Tools.NullInt(RdrList["Member_Grade_Percent"]); entity.Member_Grade_Default = Tools.NullInt(RdrList["Member_Grade_Default"]); entity.Member_Grade_RequiredCoin = Tools.NullInt(RdrList["Member_Grade_RequiredCoin"]); entity.Member_Grade_CoinRate = Tools.NullDbl(RdrList["Member_Grade_CoinRate"]); entity.Member_Grade_Addtime = Tools.NullDate(RdrList["Member_Grade_Addtime"]); entity.Member_Grade_Site = Tools.NullStr(RdrList["Member_Grade_Site"]); } return(entity); } catch (Exception ex) { throw ex; } finally { if (RdrList != null) { RdrList.Close(); RdrList = null; } } }
public virtual ProductAuditReasonInfo GetProductAuditReasonByID(int ID) { ProductAuditReasonInfo entity = null; SqlDataReader RdrList = null; try { string SqlList; SqlList = "SELECT * FROM Product_Audit_Reason WHERE Product_Audit_Reason_ID = " + ID; RdrList = DBHelper.ExecuteReader(SqlList); if (RdrList.Read()) { entity = new ProductAuditReasonInfo(); entity.Product_Audit_Reason_ID = Tools.NullInt(RdrList["Product_Audit_Reason_ID"]); entity.Product_Audit_Reason_Note = Tools.NullStr(RdrList["Product_Audit_Reason_Note"]); } return(entity); } catch (Exception ex) { throw ex; } finally { if (RdrList != null) { RdrList.Close(); RdrList = null; } } }
public virtual OrdersGoodsTmpInfo GetOrdersGoodsTmpByID(int ID) { OrdersGoodsTmpInfo entity = null; SqlDataReader RdrList = null; try { string SqlList; SqlList = "SELECT * FROM Orders_Goods_tmp WHERE Orders_Goods_ID = " + ID; RdrList = DBHelper.ExecuteReader(SqlList); if (RdrList.Read()) { entity = new OrdersGoodsTmpInfo(); entity.Orders_Goods_ID = Tools.NullInt(RdrList["Orders_Goods_ID"]); entity.Orders_Goods_Type = Tools.NullInt(RdrList["Orders_Goods_Type"]); entity.Orders_Goods_BuyerID = Tools.NullInt(RdrList["Orders_Goods_BuyerID"]); entity.Orders_Goods_SessionID = Tools.NullStr(RdrList["Orders_Goods_SessionID"]); entity.Orders_Goods_ParentID = Tools.NullInt(RdrList["Orders_Goods_ParentID"]); entity.Orders_Goods_Product_ID = Tools.NullInt(RdrList["Orders_Goods_Product_ID"]); entity.Orders_Goods_Product_SupplierID = Tools.NullInt(RdrList["Orders_Goods_Product_SupplierID"]); entity.Orders_Goods_Product_Code = Tools.NullStr(RdrList["Orders_Goods_Product_Code"]); entity.Orders_Goods_Product_CateID = Tools.NullInt(RdrList["Orders_Goods_Product_CateID"]); entity.Orders_Goods_Product_BrandID = Tools.NullInt(RdrList["Orders_Goods_Product_BrandID"]); entity.Orders_Goods_Product_Name = Tools.NullStr(RdrList["Orders_Goods_Product_Name"]); entity.Orders_Goods_Product_Img = Tools.NullStr(RdrList["Orders_Goods_Product_Img"]); entity.Orders_Goods_Product_Price = Tools.NullDbl(RdrList["Orders_Goods_Product_Price"]); entity.Orders_Goods_Product_MKTPrice = Tools.NullDbl(RdrList["Orders_Goods_Product_MKTPrice"]); entity.Orders_Goods_Product_Maker = Tools.NullStr(RdrList["Orders_Goods_Product_Maker"]); entity.Orders_Goods_Product_Spec = Tools.NullStr(RdrList["Orders_Goods_Product_Spec"]); entity.Orders_Goods_Product_DeliveryDate = Tools.NullStr(RdrList["Orders_Goods_Product_DeliveryDate"]); entity.Orders_Goods_Product_AuthorizeCode = Tools.NullStr(RdrList["Orders_Goods_Product_AuthorizeCode"]); entity.Orders_Goods_Product_brokerage = Tools.NullDbl(RdrList["Orders_Goods_Product_brokerage"]); entity.Orders_Goods_Product_SalePrice = Tools.NullDbl(RdrList["Orders_Goods_Product_SalePrice"]); entity.Orders_Goods_Product_PurchasingPrice = Tools.NullDbl(RdrList["Orders_Goods_Product_PurchasingPrice"]); entity.Orders_Goods_Product_Coin = Tools.NullInt(RdrList["Orders_Goods_Product_Coin"]); entity.Orders_Goods_Product_IsFavor = Tools.NullInt(RdrList["Orders_Goods_Product_IsFavor"]); entity.Orders_Goods_Product_UseCoin = Tools.NullInt(RdrList["Orders_Goods_Product_UseCoin"]); entity.Orders_Goods_Amount = Tools.NullInt(RdrList["Orders_Goods_Amount"]); entity.Orders_Goods_Addtime = Tools.NullDate(RdrList["Orders_Goods_Addtime"]); entity.Orders_Goods_OrdersID = Tools.NullInt(RdrList["Orders_Goods_OrdersID"]); } return(entity); } catch (Exception ex) { throw ex; } finally { if (RdrList != null) { RdrList.Close(); RdrList = null; } } }
public virtual SupplierLogisticsInfo GetSupplierLogisticsByID(int ID) { SupplierLogisticsInfo entity = null; SqlDataReader RdrList = null; try { string SqlList; SqlList = "SELECT * FROM Supplier_Logistics WHERE Supplier_Logistics_ID = " + ID; RdrList = DBHelper.ExecuteReader(SqlList); if (RdrList.Read()) { entity = new SupplierLogisticsInfo(); entity.Supplier_Logistics_ID = Tools.NullInt(RdrList["Supplier_Logistics_ID"]); entity.Supplier_SupplierID = Tools.NullInt(RdrList["Supplier_SupplierID"]); entity.Supplier_OrdersID = Tools.NullInt(RdrList["Supplier_OrdersID"]); entity.Supplier_LogisticsID = Tools.NullInt(RdrList["Supplier_LogisticsID"]); entity.Supplier_Status = Tools.NullInt(RdrList["Supplier_Status"]); entity.Supplier_Orders_Address_Country = Tools.NullStr(RdrList["Supplier_Orders_Address_Country"]); entity.Supplier_Orders_Address_State = Tools.NullStr(RdrList["Supplier_Orders_Address_State"]); entity.Supplier_Orders_Address_City = Tools.NullStr(RdrList["Supplier_Orders_Address_City"]); entity.Supplier_Orders_Address_County = Tools.NullStr(RdrList["Supplier_Orders_Address_County"]); entity.Supplier_Orders_Address_StreetAddress = Tools.NullStr(RdrList["Supplier_Orders_Address_StreetAddress"]); entity.Supplier_Address_Country = Tools.NullStr(RdrList["Supplier_Address_Country"]); entity.Supplier_Address_State = Tools.NullStr(RdrList["Supplier_Address_State"]); entity.Supplier_Address_City = Tools.NullStr(RdrList["Supplier_Address_City"]); entity.Supplier_Address_County = Tools.NullStr(RdrList["Supplier_Address_County"]); entity.Supplier_Address_StreetAddress = Tools.NullStr(RdrList["Supplier_Address_StreetAddress"]); entity.Supplier_Logistics_Name = Tools.NullStr(RdrList["Supplier_Logistics_Name"]); entity.Supplier_Logistics_Number = Tools.NullStr(RdrList["Supplier_Logistics_Number"]); entity.Supplier_Logistics_DeliveryTime = Tools.NullDate(RdrList["Supplier_Logistics_DeliveryTime"]); entity.Supplier_Logistics_IsAudit = Tools.NullInt(RdrList["Supplier_Logistics_IsAudit"]); entity.Supplier_Logistics_AuditTime = Tools.NullDate(RdrList["Supplier_Logistics_AuditTime"]); entity.Supplier_Logistics_AuditRemarks = Tools.NullStr(RdrList["Supplier_Logistics_AuditRemarks"]); entity.Supplier_Logistics_FinishTime = Tools.NullDate(RdrList["Supplier_Logistics_FinishTime"]); entity.Supplier_Logistics_TenderID = Tools.NullInt(RdrList["Supplier_Logistics_TenderID"]); entity.Supplier_Logistics_Price = Tools.NullDbl(RdrList["Supplier_Logistics_Price"]); } return(entity); } catch (Exception ex) { throw ex; } finally { if (RdrList != null) { RdrList.Close(); RdrList = null; } } }
public virtual SupplierShopApplyInfo GetSupplierShopApplyByID(int ID) { SupplierShopApplyInfo entity = null; SqlDataReader RdrList = null; try { string SqlList; SqlList = "SELECT * FROM Supplier_Shop_Apply WHERE Shop_Apply_ID = " + ID; RdrList = DBHelper.ExecuteReader(SqlList); if (RdrList.Read()) { entity = new SupplierShopApplyInfo(); entity.Shop_Apply_ID = Tools.NullInt(RdrList["Shop_Apply_ID"]); entity.Shop_Apply_SupplierID = Tools.NullInt(RdrList["Shop_Apply_SupplierID"]); entity.Shop_Apply_ShopType = Tools.NullInt(RdrList["Shop_Apply_ShopType"]); entity.Shop_Apply_Name = Tools.NullStr(RdrList["Shop_Apply_Name"]); entity.Shop_Apply_PINCode = Tools.NullStr(RdrList["Shop_Apply_PINCode"]); entity.Shop_Apply_Mobile = Tools.NullStr(RdrList["Shop_Apply_Mobile"]); entity.Shop_Apply_ShopName = Tools.NullStr(RdrList["Shop_Apply_ShopName"]); entity.Shop_Apply_CompanyType = Tools.NullStr(RdrList["Shop_Apply_CompanyType"]); entity.Shop_Apply_Lawman = Tools.NullStr(RdrList["Shop_Apply_Lawman"]); entity.Shop_Apply_CertCode = Tools.NullStr(RdrList["Shop_Apply_CertCode"]); entity.Shop_Apply_CertAddress = Tools.NullStr(RdrList["Shop_Apply_CertAddress"]); entity.Shop_Apply_CompanyAddress = Tools.NullStr(RdrList["Shop_Apply_CompanyAddress"]); entity.Shop_Apply_CompanyPhone = Tools.NullStr(RdrList["Shop_Apply_CompanyPhone"]); entity.Shop_Apply_Certification1 = Tools.NullStr(RdrList["Shop_Apply_Certification1"]); entity.Shop_Apply_Certification2 = Tools.NullStr(RdrList["Shop_Apply_Certification2"]); entity.Shop_Apply_Certification3 = Tools.NullStr(RdrList["Shop_Apply_Certification3"]); entity.Shop_Apply_Certification4 = Tools.NullStr(RdrList["Shop_Apply_Certification4"]); entity.Shop_Apply_Certification5 = Tools.NullStr(RdrList["Shop_Apply_Certification5"]); entity.Shop_Apply_MainBrand = Tools.NullStr(RdrList["Shop_Apply_MainBrand"]); entity.Shop_Apply_Status = Tools.NullInt(RdrList["Shop_Apply_Status"]); entity.Shop_Apply_Note = Tools.NullStr(RdrList["Shop_Apply_Note"]); entity.Shop_Apply_Addtime = Tools.NullDate(RdrList["Shop_Apply_Addtime"]); } return(entity); } catch (Exception ex) { throw ex; } finally { if (RdrList != null) { RdrList.Close(); RdrList = null; } } }
public virtual SupplierPurchaseInfo GetSupplierPurchaseByID(int ID) { SupplierPurchaseInfo entity = null; SqlDataReader RdrList = null; try { string SqlList; SqlList = "SELECT * FROM Supplier_Purchase WHERE Purchase_ID = " + ID; RdrList = DBHelper.ExecuteReader(SqlList); if (RdrList.Read()) { entity = new SupplierPurchaseInfo(); entity.Purchase_ID = Tools.NullInt(RdrList["Purchase_ID"]); entity.Purchase_TypeID = Tools.NullInt(RdrList["Purchase_TypeID"]); entity.Purchase_SupplierID = Tools.NullInt(RdrList["Purchase_SupplierID"]); entity.Purchase_Title = Tools.NullStr(RdrList["Purchase_Title"]); entity.Purchase_DeliveryTime = Tools.NullDate(RdrList["Purchase_DeliveryTime"]); entity.Purchase_State = Tools.NullStr(RdrList["Purchase_State"]); entity.Purchase_City = Tools.NullStr(RdrList["Purchase_City"]); entity.Purchase_County = Tools.NullStr(RdrList["Purchase_County"]); entity.Purchase_Address = Tools.NullStr(RdrList["Purchase_Address"]); entity.Purchase_Intro = Tools.NullStr(RdrList["Purchase_Intro"]); entity.Purchase_Addtime = Tools.NullDate(RdrList["Purchase_Addtime"]); entity.Purchase_Status = Tools.NullInt(RdrList["Purchase_Status"]); entity.Purchase_IsActive = Tools.NullInt(RdrList["Purchase_IsActive"]); entity.Purchase_ActiveReason = Tools.NullStr(RdrList["Purchase_ActiveReason"]); entity.Purchase_Trash = Tools.NullInt(RdrList["Purchase_Trash"]); entity.Purchase_ValidDate = Tools.NullDate(RdrList["Purchase_ValidDate"]); entity.Purchase_Attachment = Tools.NullStr(RdrList["Purchase_Attachment"]); entity.Purchase_Site = Tools.NullStr(RdrList["Purchase_Site"]); entity.Purchase_IsRecommend = Tools.NullInt(RdrList["Purchase_IsRecommend"]); entity.Purchase_IsPublic = Tools.NullInt(RdrList["Purchase_IsPublic"]); entity.Purchase_CateID = Tools.NullInt(RdrList["Purchase_CateID"]); entity.Purchase_SysUserID = Tools.NullInt(RdrList["Purchase_SysUserID"]); } return(entity); } catch (Exception ex) { throw ex; } finally { if (RdrList != null) { RdrList.Close(); RdrList = null; } } }
public virtual FeedBackInfo GetFeedBackByID(int ID) { FeedBackInfo entity = null; SqlDataReader RdrList = null; try { string SqlList; SqlList = "SELECT * FROM Feedback WHERE Feedback_ID = " + ID; RdrList = DBHelper.ExecuteReader(SqlList); if (RdrList.Read()) { entity = new FeedBackInfo(); entity.Feedback_ID = Tools.NullInt(RdrList["Feedback_ID"]); entity.Feedback_Type = Tools.NullInt(RdrList["Feedback_Type"]); entity.Feedback_SupplierID = Tools.NullInt(RdrList["Feedback_SupplierID"]); entity.Feedback_MemberID = Tools.NullInt(RdrList["Feedback_MemberID"]); entity.Feedback_Name = Tools.NullStr(RdrList["Feedback_Name"]); entity.Feedback_Tel = Tools.NullStr(RdrList["Feedback_Tel"]); entity.Feedback_Email = Tools.NullStr(RdrList["Feedback_Email"]); entity.Feedback_CompanyName = Tools.NullStr(RdrList["Feedback_CompanyName"]); entity.Feedback_Content = Tools.NullStr(RdrList["Feedback_Content"]); entity.Feedback_Attachment = Tools.NullStr(RdrList["Feedback_Attachment"]); entity.Feedback_Addtime = Tools.NullDate(RdrList["Feedback_Addtime"]); entity.Feedback_IsRead = Tools.NullInt(RdrList["Feedback_IsRead"]); entity.Feedback_Reply_IsRead = Tools.NullInt(RdrList["Feedback_Reply_IsRead"]); entity.Feedback_Reply_Content = Tools.NullStr(RdrList["Feedback_Reply_Content"]); entity.Feedback_Reply_Addtime = Tools.NullDate(RdrList["Feedback_Reply_Addtime"]); entity.Feedback_Site = Tools.NullStr(RdrList["Feedback_Site"]); entity.Feedback_Address = Tools.NullStr(RdrList["Feedback_Address"]); entity.Feedback_Amount = Tools.NullDbl(RdrList["Feedback_Amount"]); entity.Feedback_Note = Tools.NullStr(RdrList["Feedback_Note"]); } return(entity); } catch (Exception ex) { throw ex; } finally { if (RdrList != null) { RdrList.Close(); RdrList = null; } } }
public virtual MemberInvoiceInfo GetMemberInvoiceByID(int ID) { MemberInvoiceInfo entity = null; SqlDataReader RdrList = null; try { string SqlList; SqlList = "SELECT * FROM Member_Invoice WHERE Invoice_ID = " + ID; RdrList = DBHelper.ExecuteReader(SqlList); if (RdrList.Read()) { entity = new MemberInvoiceInfo(); entity.Invoice_ID = Tools.NullInt(RdrList["Invoice_ID"]); entity.Invoice_MemberID = Tools.NullInt(RdrList["Invoice_MemberID"]); entity.Invoice_Type = Tools.NullInt(RdrList["Invoice_Type"]); entity.Invoice_Title = Tools.NullStr(RdrList["Invoice_Title"]); entity.Invoice_Details = Tools.NullInt(RdrList["Invoice_Details"]); entity.Invoice_FirmName = Tools.NullStr(RdrList["Invoice_FirmName"]); entity.Invoice_VAT_FirmName = Tools.NullStr(RdrList["Invoice_VAT_FirmName"]); entity.Invoice_VAT_Code = Tools.NullStr(RdrList["Invoice_VAT_Code"]); entity.Invoice_VAT_RegAddr = Tools.NullStr(RdrList["Invoice_VAT_RegAddr"]); entity.Invoice_VAT_RegTel = Tools.NullStr(RdrList["Invoice_VAT_RegTel"]); entity.Invoice_VAT_Bank = Tools.NullStr(RdrList["Invoice_VAT_Bank"]); entity.Invoice_VAT_BankAccount = Tools.NullStr(RdrList["Invoice_VAT_BankAccount"]); entity.Invoice_VAT_Content = Tools.NullStr(RdrList["Invoice_VAT_Content"]); entity.Invoice_Address = Tools.NullStr(RdrList["Invoice_Address"]); entity.Invoice_Name = Tools.NullStr(RdrList["Invoice_Name"]); entity.Invoice_ZipCode = Tools.NullStr(RdrList["Invoice_ZipCode"]); entity.Invoice_Tel = Tools.NullStr(RdrList["Invoice_Tel"]); entity.Invoice_PersonelName = Tools.NullStr(RdrList["Invoice_PersonelName"]); entity.Invoice_PersonelCard = Tools.NullStr(RdrList["Invoice_PersonelCard"]); entity.Invoice_VAT_Cert = Tools.NullStr(RdrList["Invoice_VAT_Cert"]); } return(entity); } catch (Exception ex) { throw ex; } finally { if (RdrList != null) { RdrList.Close(); RdrList = null; } } }
private int GetLastUserID(string strName) { int Role_ID = 0; SqlDataReader rdr = DBHelper.ExecuteReader("SELECT RBAC_User_ID FROM RBAC_User WHERE RBAC_User_Name = '" + strName + "'"); if (rdr.Read()) { Role_ID = Tools.NullInt(rdr[0]); } rdr.Close(); rdr = null; return(Role_ID); }
public virtual ContractInfo GetContractByID(int ID) { ContractInfo entity = null; SqlDataReader RdrList = null; try { string SqlList; SqlList = "SELECT * FROM Contract WHERE Contract_ID = " + ID; RdrList = DBHelper.ExecuteReader(SqlList); if (RdrList.Read()) { entity = new ContractInfo(); entity.Contract_ID = Tools.NullInt(RdrList["Contract_ID"]); entity.Contract_Type = Tools.NullInt(RdrList["Contract_Type"]); entity.Contract_BuyerID = Tools.NullInt(RdrList["Contract_BuyerID"]); entity.Contract_BuyerName = Tools.NullStr(RdrList["Contract_BuyerName"]); entity.Contract_SupplierID = Tools.NullInt(RdrList["Contract_SupplierID"]); entity.Contract_SupplierName = Tools.NullStr(RdrList["Contract_SupplierName"]); entity.Contract_SN = Tools.NullStr(RdrList["Contract_SN"]); entity.Contract_Name = Tools.NullStr(RdrList["Contract_Name"]); entity.Contract_Status = Tools.NullInt(RdrList["Contract_Status"]); entity.Contract_Confirm_Status = Tools.NullInt(RdrList["Contract_Confirm_Status"]); entity.Contract_Payment_Status = Tools.NullInt(RdrList["Contract_Payment_Status"]); entity.Contract_Delivery_Status = Tools.NullInt(RdrList["Contract_Delivery_Status"]); entity.Contract_AllPrice = Tools.NullDbl(RdrList["Contract_AllPrice"]); entity.Contract_Price = Tools.NullDbl(RdrList["Contract_Price"]); entity.Contract_Freight = Tools.NullDbl(RdrList["Contract_Freight"]); entity.Contract_ServiceFee = Tools.NullDbl(RdrList["Contract_ServiceFee"]); entity.Contract_Discount = Tools.NullDbl(RdrList["Contract_Discount"]); entity.Contract_Delivery_ID = Tools.NullInt(RdrList["Contract_Delivery_ID"]); entity.Contract_Delivery_Name = Tools.NullStr(RdrList["Contract_Delivery_Name"]); entity.Contract_Payway_ID = Tools.NullInt(RdrList["Contract_Payway_ID"]); entity.Contract_Payway_Name = Tools.NullStr(RdrList["Contract_Payway_Name"]); entity.Contract_Note = Tools.NullStr(RdrList["Contract_Note"]); entity.Contract_Template = Tools.NullStr(RdrList["Contract_Template"]); entity.Contract_Addtime = Tools.NullDate(RdrList["Contract_Addtime"]); entity.Contract_Site = Tools.NullStr(RdrList["Contract_Site"]); entity.Contract_Source = Tools.NullInt(RdrList["Contract_Source"]); entity.Contract_IsEvaluate = Tools.NullInt(RdrList["Contract_IsEvaluate"]); } return(entity); } catch (Exception ex) { throw ex; } finally { if (RdrList != null) { RdrList.Close(); RdrList = null; } } }
public virtual OrdersBackApplyInfo GetOrdersBackApplyByID(int ID) { OrdersBackApplyInfo entity = null; SqlDataReader RdrList = null; try { string SqlList; SqlList = "SELECT * FROM Orders_BackApply WHERE Orders_BackApply_ID = " + ID; RdrList = DBHelper.ExecuteReader(SqlList); if (RdrList.Read()) { entity = new OrdersBackApplyInfo(); entity.Orders_BackApply_ID = Tools.NullInt(RdrList["Orders_BackApply_ID"]); entity.Orders_BackApply_OrdersCode = Tools.NullStr(RdrList["Orders_BackApply_OrdersCode"]); entity.Orders_BackApply_MemberID = Tools.NullInt(RdrList["Orders_BackApply_MemberID"]); entity.Orders_BackApply_Name = Tools.NullStr(RdrList["Orders_BackApply_Name"]); entity.Orders_BackApply_Type = Tools.NullInt(RdrList["Orders_BackApply_Type"]); entity.Orders_BackApply_DeliveryWay = Tools.NullInt(RdrList["Orders_BackApply_DeliveryWay"]); entity.Orders_BackApply_AmountBackType = Tools.NullInt(RdrList["Orders_BackApply_AmountBackType"]); entity.Orders_BackApply_Amount = Tools.NullDbl(RdrList["Orders_BackApply_Amount"]); entity.Orders_BackApply_Note = Tools.NullStr(RdrList["Orders_BackApply_Note"]); entity.Orders_BackApply_Account = Tools.NullStr(RdrList["Orders_BackApply_Account"]); entity.Orders_BackApply_AdminNote = Tools.NullStr(RdrList["Orders_BackApply_AdminNote"]); entity.Orders_BackApply_SupplierNote = Tools.NullStr(RdrList["Orders_BackApply_SupplierNote"]); entity.Orders_BackApply_SupplierTime = Tools.NullDate(RdrList["Orders_BackApply_SupplierTime"]); entity.Orders_BackApply_AdminTime = Tools.NullDate(RdrList["Orders_BackApply_AdminTime"]); entity.Orders_BackApply_Status = Tools.NullInt(RdrList["Orders_BackApply_Status"]); entity.Orders_BackApply_Addtime = Tools.NullDate(RdrList["Orders_BackApply_Addtime"]); entity.Orders_BackApply_Site = Tools.NullStr(RdrList["Orders_BackApply_Site"]); } return(entity); } catch (Exception ex) { throw ex; } finally { if (RdrList != null) { RdrList.Close(); RdrList = null; } } }
public virtual ProductReviewInfo GetProductReviewByID(int ID) { ProductReviewInfo entity = null; SqlDataReader RdrList = null; try { string SqlList; SqlList = "SELECT * FROM Product_Review WHERE Product_Review_ID = " + ID; RdrList = DBHelper.ExecuteReader(SqlList); if (RdrList.Read()) { entity = new ProductReviewInfo(); entity.Product_Review_ID = Tools.NullInt(RdrList["Product_Review_ID"]); entity.Product_Review_ProductID = Tools.NullInt(RdrList["Product_Review_ProductID"]); entity.Product_Review_MemberID = Tools.NullInt(RdrList["Product_Review_MemberID"]); entity.Product_Review_Star = Tools.NullInt(RdrList["Product_Review_Star"]); entity.Product_Review_Subject = Tools.NullStr(RdrList["Product_Review_Subject"]); entity.Product_Review_Content = Tools.NullStr(RdrList["Product_Review_Content"]); entity.Product_Review_Useful = Tools.NullInt(RdrList["Product_Review_Useful"]); entity.Product_Review_Useless = Tools.NullInt(RdrList["Product_Review_Useless"]); entity.Product_Review_Addtime = Tools.NullDate(RdrList["Product_Review_Addtime"]); entity.Product_Review_IsShow = Tools.NullInt(RdrList["Product_Review_IsShow"]); entity.Product_Review_IsBuy = Tools.NullInt(RdrList["Product_Review_IsBuy"]); entity.Product_Review_IsGift = Tools.NullInt(RdrList["Product_Review_IsGift"]); entity.Product_Review_IsView = Tools.NullInt(RdrList["Product_Review_IsView"]); entity.Product_Review_IsRecommend = Tools.NullInt(RdrList["Product_Review_IsRecommend"]); entity.Product_Review_Site = Tools.NullStr(RdrList["Product_Review_Site"]); } return(entity); } catch (Exception ex) { throw ex; } finally { if (RdrList != null) { RdrList.Close(); RdrList = null; } } }
public virtual PackageInfo GetPackageByID(int ID) { PackageInfo entity = null; SqlDataReader RdrList = null; try { string SqlList; SqlList = "SELECT * FROM Package WHERE Package_ID = " + ID; RdrList = DBHelper.ExecuteReader(SqlList); if (RdrList.Read()) { entity = new PackageInfo(); entity.Package_ID = Tools.NullInt(RdrList["Package_ID"]); entity.Package_Name = Tools.NullStr(RdrList["Package_Name"]); entity.Package_IsInsale = Tools.NullInt(RdrList["Package_IsInsale"]); entity.Package_StockAmount = Tools.NullInt(RdrList["Package_StockAmount"]); entity.Package_Weight = Tools.NullInt(RdrList["Package_Weight"]); entity.Package_Price = Tools.NullDbl(RdrList["Package_Price"]); entity.Package_Sort = Tools.NullInt(RdrList["Package_Sort"]); entity.Package_Addtime = Tools.NullDate(RdrList["Package_Addtime"]); entity.Package_Site = Tools.NullStr(RdrList["Package_Site"]); entity.Package_SupplierID = Tools.NullInt(RdrList["Package_SupplierID"]); entity.PackageProductInfos = null; } RdrList.Close(); RdrList = null; if (entity != null) { entity.PackageProductInfos = GetProductListByPackage(entity.Package_ID); } return(entity); } catch (Exception ex) { throw ex; } finally { if (RdrList != null) { RdrList.Close(); RdrList = null; } } }
public virtual MemberAddressInfo GetMemberAddressByID(int ID) { MemberAddressInfo entity = null; SqlDataReader RdrList = null; try { string SqlList; SqlList = "SELECT * FROM Member_Address WHERE Member_Address_ID = " + ID; RdrList = DBHelper.ExecuteReader(SqlList); if (RdrList.Read()) { entity = new MemberAddressInfo(); entity.Member_Address_ID = Tools.NullInt(RdrList["Member_Address_ID"]); entity.Member_Address_MemberID = Tools.NullInt(RdrList["Member_Address_MemberID"]); entity.Member_Address_Country = Tools.NullStr(RdrList["Member_Address_Country"]); entity.Member_Address_State = Tools.NullStr(RdrList["Member_Address_State"]); entity.Member_Address_City = Tools.NullStr(RdrList["Member_Address_City"]); entity.Member_Address_County = Tools.NullStr(RdrList["Member_Address_County"]); entity.Member_Address_StreetAddress = Tools.NullStr(RdrList["Member_Address_StreetAddress"]); entity.Member_Address_Zip = Tools.NullStr(RdrList["Member_Address_Zip"]); entity.Member_Address_Name = Tools.NullStr(RdrList["Member_Address_Name"]); entity.Member_Address_Phone_Countrycode = Tools.NullStr(RdrList["Member_Address_Phone_Countrycode"]); entity.Member_Address_Phone_Areacode = Tools.NullStr(RdrList["Member_Address_Phone_Areacode"]); entity.Member_Address_Phone_Number = Tools.NullStr(RdrList["Member_Address_Phone_Number"]); entity.Member_Address_Mobile = Tools.NullStr(RdrList["Member_Address_Mobile"]); entity.Member_Address_IsDefault = Tools.NullInt(RdrList["Member_Address_IsDefault"]); entity.Member_Address_Site = Tools.NullStr(RdrList["Member_Address_Site"]); } return(entity); } catch (Exception ex) { throw ex; } finally { if (RdrList != null) { RdrList.Close(); RdrList = null; } } }
public virtual CategoryInfo GetCategoryByID(int Cate_ID) { CategoryInfo Entity = null; SqlDataReader RdrList = null; try { string SqlList; SqlList = "SELECT * FROM Category WHERE Cate_ID = " + Cate_ID; RdrList = SQLHelper.ExecuteReader(SqlList); if (RdrList.Read()) { Entity = new CategoryInfo(); Entity.Cate_ID = Tools.NullInt(RdrList["Cate_ID"]); Entity.Cate_ParentID = Tools.NullInt(RdrList["Cate_ParentID"]); Entity.Cate_Name = Tools.NullStr(RdrList["Cate_Name"]); Entity.Cate_TypeID = Tools.NullInt(RdrList["Cate_TypeID"]); Entity.Cate_Img = Tools.NullStr(RdrList["Cate_Img"]); Entity.Cate_ProductTypeID = Tools.NullInt(RdrList["Cate_ProductTypeID"]); Entity.Cate_Sort = Tools.NullInt(RdrList["Cate_Sort"]); Entity.Cate_IsFrequently = Tools.NullInt(RdrList["Cate_IsFrequently"]); Entity.Cate_IsActive = Tools.NullInt(RdrList["Cate_IsActive"]); Entity.Cate_Count_Brand = Tools.NullInt(RdrList["Cate_Count_Brand"]); Entity.Cate_Count_Product = Tools.NullInt(RdrList["Cate_Count_Product"]); Entity.Cate_SEO_Path = Tools.NullStr(RdrList["Cate_SEO_Path"]); Entity.Cate_SEO_Title = Tools.NullStr(RdrList["Cate_SEO_Title"]); Entity.Cate_SEO_Keyword = Tools.NullStr(RdrList["Cate_SEO_Keyword"]); Entity.Cate_SEO_Description = Tools.NullStr(RdrList["Cate_SEO_Description"]); Entity.Cate_Site = Tools.NullStr(RdrList["Cate_Site"]); } return(Entity); } catch (Exception ex) { throw ex; } finally { if (RdrList != null) { RdrList.Close(); RdrList = null; } } }
public virtual ShoppingAskInfo GetShoppingAskByID(int ID) { ShoppingAskInfo entity = null; SqlDataReader RdrList = null; try { string SqlList; SqlList = "SELECT * FROM Shopping_Ask WHERE Ask_ID = " + ID; RdrList = DBHelper.ExecuteReader(SqlList); if (RdrList.Read()) { entity = new ShoppingAskInfo(); entity.Ask_ID = Tools.NullInt(RdrList["Ask_ID"]); entity.Ask_Type = Tools.NullInt(RdrList["Ask_Type"]); entity.Ask_Contact = Tools.NullStr(RdrList["Ask_Contact"]); entity.Ask_Content = Tools.NullStr(RdrList["Ask_Content"]); entity.Ask_Reply = Tools.NullStr(RdrList["Ask_Reply"]); entity.Ask_Addtime = Tools.NullDate(RdrList["Ask_Addtime"]); entity.Ask_SupplierID = Tools.NullInt(RdrList["Ask_SupplierID"]); entity.Ask_MemberID = Tools.NullInt(RdrList["Ask_MemberID"]); entity.Ask_ProductID = Tools.NullInt(RdrList["Ask_ProductID"]); entity.Ask_Pleasurenum = Tools.NullInt(RdrList["Ask_Pleasurenum"]); entity.Ask_Displeasure = Tools.NullInt(RdrList["Ask_Displeasure"]); entity.Ask_Isreply = Tools.NullInt(RdrList["Ask_Isreply"]); entity.Ask_IsCheck = Tools.NullInt(RdrList["Ask_IsCheck"]); entity.Ask_Site = Tools.NullStr(RdrList["Ask_Site"]); } return(entity); } catch (Exception ex) { throw ex; } finally { if (RdrList != null) { RdrList.Close(); RdrList = null; } } }
public virtual SysMenuInfo GetSysMenuByID(int ID) { SysMenuInfo entity = null; SqlDataReader RdrList = null; try { string SqlList; SqlList = "SELECT * FROM Sys_Menu WHERE Sys_Menu_ID = " + ID; RdrList = DBHelper.ExecuteReader(SqlList); if (RdrList.Read()) { entity = new SysMenuInfo(); entity.Sys_Menu_ID = Tools.NullInt(RdrList["Sys_Menu_ID"]); entity.Sys_Menu_Channel = Tools.NullInt(RdrList["Sys_Menu_Channel"]); entity.Sys_Menu_Name = Tools.NullStr(RdrList["Sys_Menu_Name"]); entity.Sys_Menu_ParentID = Tools.NullInt(RdrList["Sys_Menu_ParentID"]); entity.Sys_Menu_Privilege = Tools.NullStr(RdrList["Sys_Menu_Privilege"]); entity.Sys_Menu_Icon = Tools.NullStr(RdrList["Sys_Menu_Icon"]); entity.Sys_Menu_Url = Tools.NullStr(RdrList["Sys_Menu_Url"]); entity.Sys_Menu_Target = Tools.NullInt(RdrList["Sys_Menu_Target"]); entity.Sys_Menu_IsSystem = Tools.NullInt(RdrList["Sys_Menu_IsSystem"]); entity.Sys_Menu_IsDefault = Tools.NullInt(RdrList["Sys_Menu_IsDefault"]); entity.Sys_Menu_IsCommon = Tools.NullInt(RdrList["Sys_Menu_IsCommon"]); entity.Sys_Menu_IsActive = Tools.NullInt(RdrList["Sys_Menu_IsActive"]); entity.Sys_Menu_Sort = Tools.NullInt(RdrList["Sys_Menu_Sort"]); entity.Sys_Menu_Site = Tools.NullStr(RdrList["Sys_Menu_Site"]); } return(entity); } catch (Exception ex) { throw ex; } finally { if (RdrList != null) { RdrList.Close(); RdrList = null; } } }
public virtual SupplierPriceAskInfo GetSupplierPriceAskByID(int ID) { SupplierPriceAskInfo entity = null; SqlDataReader RdrList = null; try { string SqlList; SqlList = "SELECT * FROM Supplier_PriceAsk WHERE PriceAsk_ID = " + ID; RdrList = DBHelper.ExecuteReader(SqlList); if (RdrList.Read()) { entity = new SupplierPriceAskInfo(); entity.PriceAsk_ID = Tools.NullInt(RdrList["PriceAsk_ID"]); entity.PriceAsk_ProductID = Tools.NullInt(RdrList["PriceAsk_ProductID"]); entity.PriceAsk_MemberID = Tools.NullInt(RdrList["PriceAsk_MemberID"]); entity.PriceAsk_Title = Tools.NullStr(RdrList["PriceAsk_Title"]); entity.PriceAsk_Name = Tools.NullStr(RdrList["PriceAsk_Name"]); entity.PriceAsk_Phone = Tools.NullStr(RdrList["PriceAsk_Phone"]); entity.PriceAsk_Quantity = Tools.NullInt(RdrList["PriceAsk_Quantity"]); entity.PriceAsk_Price = Tools.NullDbl(RdrList["PriceAsk_Price"]); entity.PriceAsk_DeliveryDate = Tools.NullDate(RdrList["PriceAsk_DeliveryDate"]); entity.PriceAsk_Content = Tools.NullStr(RdrList["PriceAsk_Content"]); entity.PriceAsk_AddTime = Tools.NullDate(RdrList["PriceAsk_AddTime"]); entity.PriceAsk_ReplyContent = Tools.NullStr(RdrList["PriceAsk_ReplyContent"]); entity.PriceAsk_ReplyTime = Tools.NullDate(RdrList["PriceAsk_ReplyTime"]); entity.PriceAsk_IsReply = Tools.NullInt(RdrList["PriceAsk_IsReply"]); } return(entity); } catch (Exception ex) { throw ex; } finally { if (RdrList != null) { RdrList.Close(); RdrList = null; } } }
public virtual SupplierSubAccountInfo GetSupplierSubAccountByName(string name) { SupplierSubAccountInfo entity = null; SqlDataReader RdrList = null; try { string SqlList; SqlList = "SELECT * FROM Supplier_SubAccount WHERE Supplier_SubAccount_Name = '" + name + "' OR Supplier_SubAccount_Mobile = '" + name + "' OR Supplier_SubAccount_Email = '" + name + "'"; RdrList = DBHelper.ExecuteReader(SqlList); if (RdrList.Read()) { entity = new SupplierSubAccountInfo(); entity.Supplier_SubAccount_ID = Tools.NullInt(RdrList["Supplier_SubAccount_ID"]); entity.Supplier_SubAccount_SupplierID = Tools.NullInt(RdrList["Supplier_SubAccount_SupplierID"]); entity.Supplier_SubAccount_Name = Tools.NullStr(RdrList["Supplier_SubAccount_Name"]); entity.Supplier_SubAccount_Password = Tools.NullStr(RdrList["Supplier_SubAccount_Password"]); entity.Supplier_SubAccount_TrueName = Tools.NullStr(RdrList["Supplier_SubAccount_TrueName"]); entity.Supplier_SubAccount_Department = Tools.NullStr(RdrList["Supplier_SubAccount_Department"]); entity.Supplier_SubAccount_Tel = Tools.NullStr(RdrList["Supplier_SubAccount_Tel"]); entity.Supplier_SubAccount_Mobile = Tools.NullStr(RdrList["Supplier_SubAccount_Mobile"]); entity.Supplier_SubAccount_Email = Tools.NullStr(RdrList["Supplier_SubAccount_Email"]); entity.Supplier_SubAccount_ExpireTime = Tools.NullDate(RdrList["Supplier_SubAccount_ExpireTime"]); entity.Supplier_SubAccount_AddTime = Tools.NullDate(RdrList["Supplier_SubAccount_AddTime"]); entity.Supplier_SubAccount_lastLoginTime = Tools.NullDate(RdrList["Supplier_SubAccount_lastLoginTime"]); entity.Supplier_SubAccount_IsActive = Tools.NullInt(RdrList["Supplier_SubAccount_IsActive"]); entity.Supplier_SubAccount_Privilege = Tools.NullStr(RdrList["Supplier_SubAccount_Privilege"]); } return(entity); } catch (Exception ex) { throw ex; } finally { if (RdrList != null) { RdrList.Close(); RdrList = null; } } }
public virtual SupplierShopEvaluateInfo GetSupplierShopEvaluateByID(int ID) { SupplierShopEvaluateInfo entity = null; SqlDataReader RdrList = null; try { string SqlList; SqlList = "SELECT * FROM Supplier_Shop_Evaluate WHERE Shop_Evaluate_ID = " + ID; RdrList = DBHelper.ExecuteReader(SqlList); if (RdrList.Read()) { entity = new SupplierShopEvaluateInfo(); entity.Shop_Evaluate_ID = Tools.NullInt(RdrList["Shop_Evaluate_ID"]); entity.Shop_Evaluate_SupplierID = Tools.NullInt(RdrList["Shop_Evaluate_SupplierID"]); entity.Shop_Evaluate_ContractID = Tools.NullInt(RdrList["Shop_Evaluate_ContractID"]); entity.Shop_Evaluate_Productid = Tools.NullInt(RdrList["Shop_Evaluate_Productid"]); entity.Shop_Evaluate_MemberID = Tools.NullInt(RdrList["Shop_Evaluate_MemberId"]); entity.Shop_Evaluate_Product = Tools.NullInt(RdrList["Shop_Evaluate_Product"]); entity.Shop_Evaluate_Service = Tools.NullInt(RdrList["Shop_Evaluate_Service"]); entity.Shop_Evaluate_Delivery = Tools.NullInt(RdrList["Shop_Evaluate_Delivery"]); entity.Shop_Evaluate_Note = Tools.NullStr(RdrList["Shop_Evaluate_Note"]); entity.Shop_Evaluate_Ischeck = Tools.NullInt(RdrList["Shop_Evaluate_Ischeck"]); entity.Shop_Evaluate_Recommend = Tools.NullInt(RdrList["Shop_Evaluate_Recommend"]); entity.Shop_Evaluate_IsGift = Tools.NullInt(RdrList["Shop_Evaluate_IsGift"]); entity.Shop_Evaluate_Addtime = Tools.NullDate(RdrList["Shop_Evaluate_Addtime"]); entity.Shop_Evaluate_Site = Tools.NullStr(RdrList["Shop_Evaluate_Site"]); } return(entity); } catch (Exception ex) { throw ex; } finally { if (RdrList != null) { RdrList.Close(); RdrList = null; } } }
public virtual OrdersInvoiceInfo GetOrdersInvoiceByID(int ID) { OrdersInvoiceInfo entity = null; SqlDataReader RdrList = null; try { string SqlList; SqlList = "SELECT * FROM Orders_Invoice WHERE Invoice_ID = " + ID; RdrList = DBHelper.ExecuteReader(SqlList); if (RdrList.Read()) { entity = new OrdersInvoiceInfo(); entity.Invoice_ID = Tools.NullInt(RdrList["Invoice_ID"]); entity.Invoice_OrdersID = Tools.NullInt(RdrList["Invoice_OrdersID"]); entity.Invoice_Type = Tools.NullInt(RdrList["Invoice_Type"]); entity.Invoice_Title = Tools.NullStr(RdrList["Invoice_Title"]); entity.Invoice_Content = Tools.NullInt(RdrList["Invoice_Content"]); entity.Invoice_FirmName = Tools.NullStr(RdrList["Invoice_FirmName"]); entity.Invoice_VAT_FirmName = Tools.NullStr(RdrList["Invoice_VAT_FirmName"]); entity.Invoice_VAT_Code = Tools.NullStr(RdrList["Invoice_VAT_Code"]); entity.Invoice_VAT_RegAddr = Tools.NullStr(RdrList["Invoice_VAT_RegAddr"]); entity.Invoice_VAT_RegTel = Tools.NullStr(RdrList["Invoice_VAT_RegTel"]); entity.Invoice_VAT_Bank = Tools.NullStr(RdrList["Invoice_VAT_Bank"]); entity.Invoice_VAT_BankAcount = Tools.NullStr(RdrList["Invoice_VAT_BankAcount"]); entity.Invoice_VAT_Content = Tools.NullStr(RdrList["Invoice_VAT_Content"]); } return(entity); } catch (Exception ex) { throw ex; } finally { if (RdrList != null) { RdrList.Close(); RdrList = null; } } }
public virtual DeliveryWayInfo GetDeliveryWayByID(int ID) { DeliveryWayInfo entity = null; SqlDataReader RdrList = null; try { string SqlList; SqlList = "SELECT * FROM Delivery_Way WHERE Delivery_Way_ID = " + ID; RdrList = DBHelper.ExecuteReader(SqlList); if (RdrList.Read()) { entity = new DeliveryWayInfo(); entity.Delivery_Way_ID = Tools.NullInt(RdrList["Delivery_Way_ID"]); entity.Delivery_Way_SupplierID = Tools.NullInt(RdrList["Delivery_Way_SupplierID"]); entity.Delivery_Way_Name = Tools.NullStr(RdrList["Delivery_Way_Name"]); entity.Delivery_Way_Sort = Tools.NullInt(RdrList["Delivery_Way_Sort"]); entity.Delivery_Way_InitialWeight = Tools.NullInt(RdrList["Delivery_Way_InitialWeight"]); entity.Delivery_Way_UpWeight = Tools.NullInt(RdrList["Delivery_Way_UpWeight"]); entity.Delivery_Way_FeeType = Tools.NullInt(RdrList["Delivery_Way_FeeType"]); entity.Delivery_Way_Fee = Tools.NullDbl(RdrList["Delivery_Way_Fee"]); entity.Delivery_Way_InitialFee = Tools.NullDbl(RdrList["Delivery_Way_InitialFee"]); entity.Delivery_Way_UpFee = Tools.NullDbl(RdrList["Delivery_Way_UpFee"]); entity.Delivery_Way_Status = Tools.NullInt(RdrList["Delivery_Way_Status"]); entity.Delivery_Way_Cod = Tools.NullInt(RdrList["Delivery_Way_Cod"]); entity.Delivery_Way_Img = Tools.NullStr(RdrList["Delivery_Way_Img"]); entity.Delivery_Way_Url = Tools.NullStr(RdrList["Delivery_Way_Url"]); entity.Delivery_Way_Intro = Tools.NullStr(RdrList["Delivery_Way_Intro"]); entity.Delivery_Way_Site = Tools.NullStr(RdrList["Delivery_Way_Site"]); } return(entity); } catch (Exception ex) { throw ex; } finally { if (RdrList != null) { RdrList.Close(); RdrList = null; } } }
public virtual ProductTypeExtendInfo GetProductTypeExtendByID(int ProductType_Extend_ID) { ProductTypeExtendInfo entity = null; SqlDataReader RdrList = null; try { string SqlList; SqlList = "SELECT * FROM ProductType_Extend WHERE ProductType_Extend_ID = " + ProductType_Extend_ID; RdrList = DBHelper.ExecuteReader(SqlList); if (RdrList.Read()) { entity = new ProductTypeExtendInfo(); entity.ProductType_Extend_ID = Tools.NullInt(RdrList["ProductType_Extend_ID"]); entity.ProductType_Extend_ProductTypeID = Tools.NullInt(RdrList["ProductType_Extend_ProductTypeID"]); entity.ProductType_Extend_Name = Tools.NullStr(RdrList["ProductType_Extend_Name"]); entity.ProductType_Extend_Display = Tools.NullStr(RdrList["ProductType_Extend_Display"]); entity.ProductType_Extend_IsSearch = Tools.NullInt(RdrList["ProductType_Extend_IsSearch"]); entity.ProductType_Extend_Options = Tools.NullInt(RdrList["ProductType_Extend_Options"]); entity.ProductType_Extend_Default = Tools.NullStr(RdrList["ProductType_Extend_Default"]); entity.ProductType_Extend_IsActive = Tools.NullInt(RdrList["ProductType_Extend_IsActive"]); entity.ProductType_Extend_Gather = Tools.NullInt(RdrList["ProductType_Extend_Gather"]); entity.ProductType_Extend_DisplayForm = Tools.NullInt(RdrList["ProductType_Extend_DisplayForm"]); entity.ProductType_Extend_Sort = Tools.NullInt(RdrList["ProductType_Extend_Sort"]); entity.ProductType_Extend_Site = Tools.NullStr(RdrList["ProductType_Extend_Site"]); } return(entity); } catch (Exception ex) { throw ex; } finally { if (RdrList != null) { RdrList.Close(); RdrList = null; } } }