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