public virtual IList <ContractDeliveryInfo> GetContractDeliverys(QueryInfo Query)
{
int PageSize;
int CurrentPage;
IList <ContractDeliveryInfo> entitys = null;
ContractDeliveryInfo entity = null;
string SqlList, SqlField, SqlOrder, SqlParam, SqlTable;
SqlDataReader RdrList = null;
try
{
CurrentPage = Query.CurrentPage;
PageSize = Query.PageSize;
SqlTable = "Contract_Delivery";
SqlField = "*";
SqlParam = DBHelper.GetSqlParam(Query.ParamInfos);
SqlOrder = DBHelper.GetSqlOrder(Query.OrderInfos);
SqlList = DBHelper.GetSqlPage(SqlTable, SqlField, SqlParam, SqlOrder, CurrentPage, PageSize);
RdrList = DBHelper.ExecuteReader(SqlList);
if (RdrList.HasRows)
{
entitys = new List <ContractDeliveryInfo>();
while (RdrList.Read())
{
entity = new ContractDeliveryInfo();
entity.Contract_Delivery_ID = Tools.NullInt(RdrList["Contract_Delivery_ID"]);
entity.Contract_Delivery_ContractID = Tools.NullInt(RdrList["Contract_Delivery_ContractID"]);
entity.Contract_Delivery_DeliveryStatus = Tools.NullInt(RdrList["Contract_Delivery_DeliveryStatus"]);
entity.Contract_Delivery_SysUserID = Tools.NullInt(RdrList["Contract_Delivery_SysUserID"]);
entity.Contract_Delivery_DocNo = Tools.NullStr(RdrList["Contract_Delivery_DocNo"]);
entity.Contract_Delivery_Name = Tools.NullStr(RdrList["Contract_Delivery_Name"]);
entity.Contract_Delivery_CompanyName = Tools.NullStr(RdrList["Contract_Delivery_CompanyName"]);
entity.Contract_Delivery_Code = Tools.NullStr(RdrList["Contract_Delivery_Code"]);
entity.Contract_Delivery_Amount = Tools.NullDbl(RdrList["Contract_Delivery_Amount"]);
entity.Contract_Delivery_Note = Tools.NullStr(RdrList["Contract_Delivery_Note"]);
entity.Contract_Delivery_AccpetNote = Tools.NullStr(RdrList["Contract_Delivery_AccpetNote"]);
entity.Contract_Delivery_Addtime = Tools.NullDate(RdrList["Contract_Delivery_Addtime"]);
entity.Contract_Delivery_Site = Tools.NullStr(RdrList["Contract_Delivery_Site"]);
entitys.Add(entity);
entity = null;
}
}
return(entitys);
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (RdrList != null)
{
RdrList.Close();
RdrList = null;
}
}
}
public virtual IList <KeywordBiddingInfo> GetKeywordBiddings(QueryInfo Query)
{
int PageSize;
int CurrentPage;
IList <KeywordBiddingInfo> entitys = null;
KeywordBiddingInfo entity = null;
string SqlList, SqlField, SqlOrder, SqlParam, SqlTable;
SqlDataReader RdrList = null;
try
{
CurrentPage = Query.CurrentPage;
PageSize = Query.PageSize;
SqlTable = "KeywordBidding";
SqlField = "*";
SqlParam = DBHelper.GetSqlParam(Query.ParamInfos);
SqlOrder = DBHelper.GetSqlOrder(Query.OrderInfos);
SqlList = DBHelper.GetSqlPage(SqlTable, SqlField, SqlParam, SqlOrder, CurrentPage, PageSize);
RdrList = DBHelper.ExecuteReader(SqlList);
if (RdrList.HasRows)
{
entitys = new List <KeywordBiddingInfo>();
while (RdrList.Read())
{
entity = new KeywordBiddingInfo();
entity.KeywordBidding_ID = Tools.NullInt(RdrList["KeywordBidding_ID"]);
entity.KeywordBidding_SupplierID = Tools.NullInt(RdrList["KeywordBidding_SupplierID"]);
entity.KeywordBidding_ProductID = Tools.NullInt(RdrList["KeywordBidding_ProductID"]);
entity.KeywordBidding_KeywordID = Tools.NullInt(RdrList["KeywordBidding_KeywordID"]);
entity.KeywordBidding_Price = Tools.NullDbl(RdrList["KeywordBidding_Price"]);
entity.KeywordBidding_StartDate = Tools.NullDate(RdrList["KeywordBidding_StartDate"]);
entity.KeywordBidding_EndDate = Tools.NullDate(RdrList["KeywordBidding_EndDate"]);
entity.KeywordBidding_ShowTimes = Tools.NullInt(RdrList["KeywordBidding_ShowTimes"]);
entity.KeywordBidding_Hits = Tools.NullInt(RdrList["KeywordBidding_Hits"]);
entity.KeywordBidding_Audit = Tools.NullInt(RdrList["KeywordBidding_Audit"]);
entity.KeywordBidding_Site = Tools.NullStr(RdrList["KeywordBidding_Site"]);
entitys.Add(entity);
entity = null;
}
}
return(entitys);
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (RdrList != null)
{
RdrList.Close();
RdrList = null;
}
}
}
public virtual IList <MemberAddressInfo> GetMemberAddresss(QueryInfo Query)
{
int PageSize;
int CurrentPage;
IList <MemberAddressInfo> entitys = null;
MemberAddressInfo entity = null;
string SqlList, SqlField, SqlOrder, SqlParam, SqlTable;
SqlDataReader RdrList = null;
try
{
CurrentPage = Query.CurrentPage;
PageSize = Query.PageSize;
SqlTable = "Member_Address";
SqlField = "*";
SqlParam = DBHelper.GetSqlParam(Query.ParamInfos);
SqlOrder = DBHelper.GetSqlOrder(Query.OrderInfos);
SqlList = DBHelper.GetSqlPage(SqlTable, SqlField, SqlParam, SqlOrder, CurrentPage, PageSize);
RdrList = DBHelper.ExecuteReader(SqlList);
if (RdrList.HasRows)
{
entitys = new List <MemberAddressInfo>();
while (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"]);
entitys.Add(entity);
entity = null;
}
}
return(entitys);
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (RdrList != null)
{
RdrList.Close();
RdrList = null;
}
}
}
public virtual IList <CategoryInfo> GetCategorys(QueryInfo Query)
{
int PageSize;
int CurrentPage;
IList <CategoryInfo> entitys = null;
CategoryInfo entity = null;
string SqlList, SqlField, SqlOrder, SqlParam, SqlTable;
SqlDataReader RdrList = null;
try
{
CurrentPage = Query.CurrentPage;
PageSize = Query.PageSize;
SqlTable = "Category";
SqlField = "*";
SqlParam = SQLHelper.GetSqlParam(Query.ParamInfos);
SqlOrder = SQLHelper.GetSqlOrder(Query.OrderInfos);
SqlList = SQLHelper.GetSqlPage(SqlTable, SqlField, SqlParam, SqlOrder, CurrentPage, PageSize);
RdrList = SQLHelper.ExecuteReader(SqlList);
if (RdrList.HasRows)
{
entitys = new List <CategoryInfo>();
while (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"]);
entitys.Add(entity);
entity = null;
}
}
return(entitys);
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (RdrList != null)
{
RdrList.Close();
RdrList = null;
}
}
}
public virtual IList <ProductReviewInfo> GetProductReviews(QueryInfo Query)
{
int PageSize;
int CurrentPage;
IList <ProductReviewInfo> entitys = null;
ProductReviewInfo entity = null;
string SqlList, SqlField, SqlOrder, SqlParam, SqlTable;
SqlDataReader RdrList = null;
try
{
CurrentPage = Query.CurrentPage;
PageSize = Query.PageSize;
SqlTable = "Product_Review";
SqlField = "*";
SqlParam = DBHelper.GetSqlParam(Query.ParamInfos);
SqlOrder = DBHelper.GetSqlOrder(Query.OrderInfos);
SqlList = DBHelper.GetSqlPage(SqlTable, SqlField, SqlParam, SqlOrder, CurrentPage, PageSize);
RdrList = DBHelper.ExecuteReader(SqlList);
if (RdrList.HasRows)
{
entitys = new List <ProductReviewInfo>();
while (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"]);
entitys.Add(entity);
entity = null;
}
}
return(entitys);
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (RdrList != null)
{
RdrList.Close();
RdrList = null;
}
}
}
public virtual IList <SupplierSubAccountInfo> GetSupplierSubAccounts(QueryInfo Query)
{
int PageSize;
int CurrentPage;
IList <SupplierSubAccountInfo> entitys = null;
SupplierSubAccountInfo entity = null;
string SqlList, SqlField, SqlOrder, SqlParam, SqlTable;
SqlDataReader RdrList = null;
try
{
CurrentPage = Query.CurrentPage;
PageSize = Query.PageSize;
SqlTable = "Supplier_SubAccount";
SqlField = "*";
SqlParam = DBHelper.GetSqlParam(Query.ParamInfos);
SqlOrder = DBHelper.GetSqlOrder(Query.OrderInfos);
SqlList = DBHelper.GetSqlPage(SqlTable, SqlField, SqlParam, SqlOrder, CurrentPage, PageSize);
RdrList = DBHelper.ExecuteReader(SqlList);
if (RdrList.HasRows)
{
entitys = new List <SupplierSubAccountInfo>();
while (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"]);
entitys.Add(entity);
entity = null;
}
}
return(entitys);
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (RdrList != null)
{
RdrList.Close();
RdrList = null;
}
}
}
public virtual IList <SysMenuInfo> GetSysMenus(QueryInfo Query)
{
int PageSize;
int CurrentPage;
IList <SysMenuInfo> entitys = null;
SysMenuInfo entity = null;
string SqlList, SqlField, SqlOrder, SqlParam, SqlTable;
SqlDataReader RdrList = null;
try
{
CurrentPage = Query.CurrentPage;
PageSize = Query.PageSize;
SqlTable = "Sys_Menu";
SqlField = "*";
SqlParam = DBHelper.GetSqlParam(Query.ParamInfos);
SqlOrder = DBHelper.GetSqlOrder(Query.OrderInfos);
SqlList = DBHelper.GetSqlPage(SqlTable, SqlField, SqlParam, SqlOrder, CurrentPage, PageSize);
RdrList = DBHelper.ExecuteReader(SqlList);
if (RdrList.HasRows)
{
entitys = new List <SysMenuInfo>();
while (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"]);
entitys.Add(entity);
entity = null;
}
}
return(entitys);
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (RdrList != null)
{
RdrList.Close();
RdrList = null;
}
}
}
public virtual IList <PackageInfo> GetPackages(QueryInfo Query)
{
int PageSize;
int CurrentPage;
IList <PackageInfo> entitys = null;
PackageInfo entity = null;
string SqlList, SqlField, SqlOrder, SqlParam, SqlTable;
SqlDataReader RdrList = null;
try {
CurrentPage = Query.CurrentPage;
PageSize = Query.PageSize;
SqlTable = "Package";
SqlField = "*";
SqlParam = DBHelper.GetSqlParam(Query.ParamInfos);
SqlOrder = DBHelper.GetSqlOrder(Query.OrderInfos);
SqlList = DBHelper.GetSqlPage(SqlTable, SqlField, SqlParam, SqlOrder, CurrentPage, PageSize);
RdrList = DBHelper.ExecuteReader(SqlList);
if (RdrList.HasRows)
{
entitys = new List <PackageInfo>();
while (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;
entitys.Add(entity);
entity = null;
}
}
if (entitys != null)
{
foreach (PackageInfo obj in entitys)
{
obj.PackageProductInfos = GetProductListByPackage(obj.Package_ID);
}
}
return(entitys);
}
catch (Exception ex) {
throw ex;
}
finally {
if (RdrList != null)
{
RdrList.Close();
RdrList = null;
}
}
}
public virtual IList <ShoppingAskInfo> GetShoppingAsks(QueryInfo Query)
{
int PageSize;
int CurrentPage;
IList <ShoppingAskInfo> entitys = null;
ShoppingAskInfo entity = null;
string SqlList, SqlField, SqlOrder, SqlParam, SqlTable;
SqlDataReader RdrList = null;
try
{
CurrentPage = Query.CurrentPage;
PageSize = Query.PageSize;
SqlTable = "Shopping_Ask";
SqlField = "*";
SqlParam = DBHelper.GetSqlParam(Query.ParamInfos);
SqlOrder = DBHelper.GetSqlOrder(Query.OrderInfos);
SqlList = DBHelper.GetSqlPage(SqlTable, SqlField, SqlParam, SqlOrder, CurrentPage, PageSize);
RdrList = DBHelper.ExecuteReader(SqlList);
if (RdrList.HasRows)
{
entitys = new List <ShoppingAskInfo>();
while (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"]);
entitys.Add(entity);
entity = null;
}
}
return(entitys);
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (RdrList != null)
{
RdrList.Close();
RdrList = null;
}
}
}
public virtual IList <SupplierPriceAskInfo> GetSupplierPriceAsks(QueryInfo Query)
{
int PageSize;
int CurrentPage;
IList <SupplierPriceAskInfo> entitys = null;
SupplierPriceAskInfo entity = null;
string SqlList, SqlField, SqlOrder, SqlParam, SqlTable;
SqlDataReader RdrList = null;
try
{
CurrentPage = Query.CurrentPage;
PageSize = Query.PageSize;
SqlTable = "Supplier_PriceAsk";
SqlField = "*";
SqlParam = DBHelper.GetSqlParam(Query.ParamInfos);
SqlOrder = DBHelper.GetSqlOrder(Query.OrderInfos);
SqlList = DBHelper.GetSqlPage(SqlTable, SqlField, SqlParam, SqlOrder, CurrentPage, PageSize);
RdrList = DBHelper.ExecuteReader(SqlList);
if (RdrList.HasRows)
{
entitys = new List <SupplierPriceAskInfo>();
while (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"]);
entitys.Add(entity);
entity = null;
}
}
return(entitys);
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (RdrList != null)
{
RdrList.Close();
RdrList = null;
}
}
}
public virtual IList <SupplierShopEvaluateInfo> GetSupplierShopEvaluates(QueryInfo Query)
{
int PageSize;
int CurrentPage;
IList <SupplierShopEvaluateInfo> entitys = null;
SupplierShopEvaluateInfo entity = null;
string SqlList, SqlField, SqlOrder, SqlParam, SqlTable;
SqlDataReader RdrList = null;
try
{
CurrentPage = Query.CurrentPage;
PageSize = Query.PageSize;
SqlTable = "Supplier_Shop_Evaluate";
SqlField = "*";
SqlParam = DBHelper.GetSqlParam(Query.ParamInfos);
SqlOrder = DBHelper.GetSqlOrder(Query.OrderInfos);
SqlList = DBHelper.GetSqlPage(SqlTable, SqlField, SqlParam, SqlOrder, CurrentPage, PageSize);
RdrList = DBHelper.ExecuteReader(SqlList);
if (RdrList.HasRows)
{
entitys = new List <SupplierShopEvaluateInfo>();
while (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"]);
entitys.Add(entity);
entity = null;
}
}
return(entitys);
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (RdrList != null)
{
RdrList.Close();
RdrList = null;
}
}
}
public virtual IList <RBACUserInfo> GetRBACUsers(QueryInfo Query)
{
int PageSize;
int CurrentPage;
IList <RBACUserInfo> entitys = null;
RBACUserInfo entity = null;
string SqlList, SqlField, SqlOrder, SqlParam, SqlTable;
SqlDataReader RdrList = null;
try
{
CurrentPage = Query.CurrentPage;
PageSize = Query.PageSize;
SqlTable = "RBAC_User";
SqlField = "*";
SqlParam = DBHelper.GetSqlParam(Query.ParamInfos);
SqlOrder = DBHelper.GetSqlOrder(Query.OrderInfos);
SqlList = DBHelper.GetSqlPage(SqlTable, SqlField, SqlParam, SqlOrder, CurrentPage, PageSize);
RdrList = DBHelper.ExecuteReader(SqlList);
if (RdrList.HasRows)
{
entitys = new List <RBACUserInfo>();
while (RdrList.Read())
{
entity = new RBACUserInfo();
entity.RBAC_User_ID = Tools.NullInt(RdrList["RBAC_User_ID"]);
entity.RBAC_User_GroupID = Tools.NullInt(RdrList["RBAC_User_GroupID"]);
entity.RBAC_User_Name = Tools.NullStr(RdrList["RBAC_User_Name"]);
entity.RBAC_User_Password = Tools.NullStr(RdrList["RBAC_User_Password"]);
entity.RBAC_User_LastLogin = Tools.NullDate(RdrList["RBAC_User_LastLogin"]);
entity.RBAC_User_LastLoginIP = Tools.NullStr(RdrList["RBAC_User_LastLoginIP"]);
entity.RBAC_User_Addtime = Tools.NullDate(RdrList["RBAC_User_Addtime"]);
entity.RBAC_User_Site = Tools.NullStr(RdrList["RBAC_User_Site"]);
entity.RBACRoleInfos = null;
entitys.Add(entity);
entity = null;
}
}
RdrList.Close();
RdrList = null;
if (entitys != null)
{
foreach (RBACUserInfo UserInfo in entitys)
{
UserInfo.RBACRoleInfos = GetRoleListByUser(UserInfo.RBAC_User_ID);
}
}
}
catch (Exception ex) { throw ex; }
finally { if (RdrList != null)
{
RdrList.Close(); RdrList = null;
}
}
return(entitys);
}
public virtual IList <OrdersInvoiceInfo> GetOrdersInvoices(QueryInfo Query)
{
int PageSize;
int CurrentPage;
IList <OrdersInvoiceInfo> entitys = null;
OrdersInvoiceInfo entity = null;
string SqlList, SqlField, SqlOrder, SqlParam, SqlTable;
SqlDataReader RdrList = null;
try
{
CurrentPage = Query.CurrentPage;
PageSize = Query.PageSize;
SqlTable = "Orders_Invoice";
SqlField = "*";
SqlParam = DBHelper.GetSqlParam(Query.ParamInfos);
SqlOrder = DBHelper.GetSqlOrder(Query.OrderInfos);
SqlList = DBHelper.GetSqlPage(SqlTable, SqlField, SqlParam, SqlOrder, CurrentPage, PageSize);
RdrList = DBHelper.ExecuteReader(SqlList);
if (RdrList.HasRows)
{
entitys = new List <OrdersInvoiceInfo>();
while (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"]);
entitys.Add(entity);
entity = null;
}
}
return(entitys);
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (RdrList != null)
{
RdrList.Close();
RdrList = null;
}
}
}
public virtual IList <ProductTypeInfo> GetProductTypes(QueryInfo Query)
{
int PageSize;
int CurrentPage;
IList <ProductTypeInfo> entitys = null;
ProductTypeInfo entity = null;
string SqlList, SqlField, SqlOrder, SqlParam, SqlTable;
SqlDataReader RdrList = null;
try
{
CurrentPage = Query.CurrentPage;
PageSize = Query.PageSize;
SqlTable = "ProductType";
SqlField = "*";
SqlParam = DBHelper.GetSqlParam(Query.ParamInfos);
SqlOrder = DBHelper.GetSqlOrder(Query.OrderInfos);
SqlList = DBHelper.GetSqlPage(SqlTable, SqlField, SqlParam, SqlOrder, CurrentPage, PageSize);
RdrList = DBHelper.ExecuteReader(SqlList);
if (RdrList.HasRows)
{
entitys = new List <ProductTypeInfo>();
while (RdrList.Read())
{
entity = new ProductTypeInfo();
entity.ProductType_ID = Tools.NullInt(RdrList["ProductType_ID"]);
entity.ProductType_Name = Tools.NullStr(RdrList["ProductType_Name"]);
entity.ProductType_Sort = Tools.NullInt(RdrList["ProductType_Sort"]);
entity.ProductType_IsActive = Tools.NullInt(RdrList["ProductType_IsActive"]);
entity.ProductType_Site = Tools.NullStr(RdrList["ProductType_Site"]);
entitys.Add(entity);
entity = null;
}
}
RdrList.Close();
RdrList = null;
if (entitys != null)
{
foreach (ProductTypeInfo obj in entitys)
{
obj.BrandInfos = GetProductBrands(obj.ProductType_ID);
}
}
return(entitys);
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (RdrList != null)
{
RdrList.Close();
RdrList = null;
}
}
}
public virtual IList <DeliveryWayInfo> GetDeliveryWays(QueryInfo Query)
{
int PageSize;
int CurrentPage;
IList <DeliveryWayInfo> entitys = null;
DeliveryWayInfo entity = null;
string SqlList, SqlField, SqlOrder, SqlParam, SqlTable;
SqlDataReader RdrList = null;
try
{
CurrentPage = Query.CurrentPage;
PageSize = Query.PageSize;
SqlTable = "Delivery_Way";
SqlField = "*";
SqlParam = DBHelper.GetSqlParam(Query.ParamInfos);
SqlOrder = DBHelper.GetSqlOrder(Query.OrderInfos);
SqlList = DBHelper.GetSqlPage(SqlTable, SqlField, SqlParam, SqlOrder, CurrentPage, PageSize);
RdrList = DBHelper.ExecuteReader(SqlList);
if (RdrList.HasRows)
{
entitys = new List <DeliveryWayInfo>();
while (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"]);
entitys.Add(entity);
entity = null;
}
}
return(entitys);
}
catch (Exception ex) {
throw ex;
}
finally {
if (RdrList != null)
{
RdrList.Close();
RdrList = null;
}
}
}
public virtual IList <PaymentInformationInfo> GetPaymentInformations(QueryInfo Query)
{
int PageSize;
int CurrentPage;
IList <PaymentInformationInfo> entitys = null;
PaymentInformationInfo entity = null;
string SqlList, SqlField, SqlOrder, SqlParam, SqlTable;
SqlDataReader RdrList = null;
try
{
CurrentPage = Query.CurrentPage;
PageSize = Query.PageSize;
SqlTable = "Payment_Information";
SqlField = "*";
SqlParam = DBHelper.GetSqlParam(Query.ParamInfos);
SqlOrder = DBHelper.GetSqlOrder(Query.OrderInfos);
SqlList = DBHelper.GetSqlPage(SqlTable, SqlField, SqlParam, SqlOrder, CurrentPage, PageSize);
RdrList = DBHelper.ExecuteReader(SqlList);
if (RdrList.HasRows)
{
entitys = new List <PaymentInformationInfo>();
while (RdrList.Read())
{
entity = new PaymentInformationInfo();
entity.Payment_ID = Tools.NullInt(RdrList["Payment_ID"]);
entity.Payment_PayingTeller = Tools.NullStr(RdrList["Payment_PayingTeller"]);
entity.Payment_Account = Tools.NullStr(RdrList["Payment_Account"]);
entity.Payment_Receivable = Tools.NullStr(RdrList["Payment_Receivable"]);
entity.Payment_Account_Receivable = Tools.NullStr(RdrList["Payment_Account_Receivable"]);
entity.Payment_Type = Tools.NullInt(RdrList["Payment_Type"]);
entity.Payment_Amount = Tools.NullDbl(RdrList["Payment_Amount"]);
entity.Payment_Remarks = Tools.NullStr(RdrList["Payment_Remarks"]);
entity.Payment_Account_Time = Tools.NullDate(RdrList["Payment_Account_Time"]);
entity.Payment_Status = Tools.NullInt(RdrList["Payment_Status"]);
entity.Payment_Flow = Tools.NullStr(RdrList["Payment_Flow"]);
entity.Payment_Remarks1 = Tools.NullStr(RdrList["Payment_Remarks1"]);
entitys.Add(entity);
entity = null;
}
}
return(entitys);
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (RdrList != null)
{
RdrList.Close();
RdrList = null;
}
}
}
public virtual IList <ZhongXinInfo> GetZhongXins(QueryInfo Query)
{
int PageSize;
int CurrentPage;
IList <ZhongXinInfo> entitys = null;
ZhongXinInfo entity = null;
string SqlList, SqlField, SqlOrder, SqlParam, SqlTable;
SqlDataReader RdrList = null;
try
{
CurrentPage = Query.CurrentPage;
PageSize = Query.PageSize;
SqlTable = "ZhongXin";
SqlField = "*";
SqlParam = DBHelper.GetSqlParam(Query.ParamInfos);
SqlOrder = DBHelper.GetSqlOrder(Query.OrderInfos);
SqlList = DBHelper.GetSqlPage(SqlTable, SqlField, SqlParam, SqlOrder, CurrentPage, PageSize);
RdrList = DBHelper.ExecuteReader(SqlList);
if (RdrList.HasRows)
{
entitys = new List <ZhongXinInfo>();
while (RdrList.Read())
{
entity = new ZhongXinInfo();
entity.ID = Tools.NullInt(RdrList["ID"]);
entity.SupplierID = Tools.NullInt(RdrList["SupplierID"]);
entity.CompanyName = Tools.NullStr(RdrList["CompanyName"]);
entity.ReceiptAccount = Tools.NullStr(RdrList["ReceiptAccount"]);
entity.ReceiptBank = Tools.NullStr(RdrList["ReceiptBank"]);
entity.BankCode = Tools.NullStr(RdrList["BankCode"]);
entity.BankName = Tools.NullStr(RdrList["BankName"]);
entity.OpenAccountName = Tools.NullStr(RdrList["OpenAccountName"]);
entity.SubAccount = Tools.NullStr(RdrList["SubAccount"]);
entity.Audit = Tools.NullInt(RdrList["Audit"]);
entity.Register = Tools.NullInt(RdrList["Register"]);
entity.Addtime = Tools.NullDate(RdrList["Addtime"]);
entitys.Add(entity);
entity = null;
}
}
return(entitys);
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (RdrList != null)
{
RdrList.Close();
RdrList = null;
}
}
}
public virtual IList <RBACRoleInfo> GetRBACRoles(QueryInfo Query)
{
int PageSize;
int CurrentPage;
IList <RBACRoleInfo> entitys = null;
RBACRoleInfo entity = null;
string SqlList, SqlField, SqlOrder, SqlParam, SqlTable;
SqlDataReader RdrList = null;
try
{
CurrentPage = Query.CurrentPage;
PageSize = Query.PageSize;
SqlTable = "RBAC_Role";
SqlField = "*";
SqlParam = DBHelper.GetSqlParam(Query.ParamInfos);
SqlOrder = DBHelper.GetSqlOrder(Query.OrderInfos);
SqlList = DBHelper.GetSqlPage(SqlTable, SqlField, SqlParam, SqlOrder, CurrentPage, PageSize);
RdrList = DBHelper.ExecuteReader(SqlList);
if (RdrList.HasRows)
{
entitys = new List <RBACRoleInfo>();
while (RdrList.Read())
{
entity = new RBACRoleInfo();
entity.RBAC_Role_ID = Tools.NullInt(RdrList["RBAC_Role_ID"]);
entity.RBAC_Role_Name = Tools.NullStr(RdrList["RBAC_Role_Name"]);
entity.RBAC_Role_Description = Tools.NullStr(RdrList["RBAC_Role_Description"]);
entity.RBAC_Role_IsSystem = Tools.NullInt(RdrList["RBAC_Role_IsSystem"]);
entity.RBAC_Role_Site = Tools.NullStr(RdrList["RBAC_Role_Site"]);
entity.RBACPrivilegeInfos = null;
entitys.Add(entity);
entity = null;
}
}
if (entitys != null)
{
foreach (RBACRoleInfo RoleInfo in entitys)
{
RoleInfo.RBACPrivilegeInfos = GetPrivilegeListByRole(RoleInfo.RBAC_Role_ID);
}
}
return(entitys);
}
catch (Exception ex) {
throw ex;
}
finally {
if (RdrList != null)
{
RdrList.Close();
RdrList = null;
}
}
}
public virtual IList <MemberSubAccountInfo> GetMemberSubAccounts(QueryInfo Query)
{
int PageSize;
int CurrentPage;
IList <MemberSubAccountInfo> entitys = null;
MemberSubAccountInfo entity = null;
string SqlList, SqlField, SqlOrder, SqlParam, SqlTable;
SqlDataReader RdrList = null;
try
{
CurrentPage = Query.CurrentPage;
PageSize = Query.PageSize;
SqlTable = "Member_SubAccount";
SqlField = "*";
SqlParam = DBHelper.GetSqlParam(Query.ParamInfos);
SqlOrder = DBHelper.GetSqlOrder(Query.OrderInfos);
SqlList = DBHelper.GetSqlPage(SqlTable, SqlField, SqlParam, SqlOrder, CurrentPage, PageSize);
RdrList = DBHelper.ExecuteReader(SqlList);
if (RdrList.HasRows)
{
entitys = new List <MemberSubAccountInfo>();
while (RdrList.Read())
{
entity = new MemberSubAccountInfo();
entity.ID = Tools.NullInt(RdrList["ID"]);
entity.MemberID = Tools.NullInt(RdrList["MemberID"]);
entity.AccountName = Tools.NullStr(RdrList["AccountName"]);
entity.Password = Tools.NullStr(RdrList["Password"]);
entity.Name = Tools.NullStr(RdrList["Name"]);
entity.Mobile = Tools.NullStr(RdrList["Mobile"]);
entity.Email = Tools.NullStr(RdrList["Email"]);
entity.Addtime = Tools.NullDate(RdrList["Addtime"]);
entity.LastLoginTime = Tools.NullDate(RdrList["LastLoginTime"]);
entity.IsActive = Tools.NullInt(RdrList["IsActive"]);
entity.Privilege = Tools.NullStr(RdrList["Privilege"]);
entitys.Add(entity);
entity = null;
}
}
return(entitys);
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (RdrList != null)
{
RdrList.Close();
RdrList = null;
}
}
}
public virtual IList <OrdersAccompanyingInfo> GetOrdersAccompanyings(QueryInfo Query)
{
int PageSize;
int CurrentPage;
IList <OrdersAccompanyingInfo> entitys = null;
OrdersAccompanyingInfo entity = null;
string SqlList, SqlField, SqlOrder, SqlParam, SqlTable;
SqlDataReader RdrList = null;
try
{
CurrentPage = Query.CurrentPage;
PageSize = Query.PageSize;
SqlTable = "Orders_Accompanying";
SqlField = "*";
SqlParam = DBHelper.GetSqlParam(Query.ParamInfos);
SqlOrder = DBHelper.GetSqlOrder(Query.OrderInfos);
SqlList = DBHelper.GetSqlPage(SqlTable, SqlField, SqlParam, SqlOrder, CurrentPage, PageSize);
RdrList = DBHelper.ExecuteReader(SqlList);
if (RdrList.HasRows)
{
entitys = new List <OrdersAccompanyingInfo>();
while (RdrList.Read())
{
entity = new OrdersAccompanyingInfo();
entity.Accompanying_ID = Tools.NullInt(RdrList["Accompanying_ID"]);
entity.Accompanying_OrdersID = Tools.NullInt(RdrList["Accompanying_OrdersID"]);
entity.Accompanying_DeliveryID = Tools.NullInt(RdrList["Accompanying_DeliveryID"]);
entity.Accompanying_SN = Tools.NullStr(RdrList["Accompanying_SN"]);
entity.Accompanying_Name = Tools.NullStr(RdrList["Accompanying_Name"]);
entity.Accompanying_Amount = Tools.NullDbl(RdrList["Accompanying_Amount"]);
entity.Accompanying_Unit = Tools.NullStr(RdrList["Accompanying_Unit"]);
entity.Accompanying_Price = Tools.NullDbl(RdrList["Accompanying_Price"]);
entity.Accompanying_Status = Tools.NullInt(RdrList["Accompanying_Status"]);
entity.Accompanying_Addtime = Tools.NullDate(RdrList["Accompanying_Addtime"]);
entity.Accompanying_Site = Tools.NullStr(RdrList["Accompanying_Site"]);
entitys.Add(entity);
entity = null;
}
}
return(entitys);
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (RdrList != null)
{
RdrList.Close();
RdrList = null;
}
}
}
public virtual IList <SupplierShopPagesInfo> GetSupplierShopPagess(QueryInfo Query)
{
int PageSize;
int CurrentPage;
IList <SupplierShopPagesInfo> entitys = null;
SupplierShopPagesInfo entity = null;
string SqlList, SqlField, SqlOrder, SqlParam, SqlTable;
SqlDataReader RdrList = null;
try
{
CurrentPage = Query.CurrentPage;
PageSize = Query.PageSize;
SqlTable = "Supplier_Shop_Pages";
SqlField = "*";
SqlParam = DBHelper.GetSqlParam(Query.ParamInfos);
SqlOrder = DBHelper.GetSqlOrder(Query.OrderInfos);
SqlList = DBHelper.GetSqlPage(SqlTable, SqlField, SqlParam, SqlOrder, CurrentPage, PageSize);
RdrList = DBHelper.ExecuteReader(SqlList);
if (RdrList.HasRows)
{
entitys = new List <SupplierShopPagesInfo>();
while (RdrList.Read())
{
entity = new SupplierShopPagesInfo();
entity.Shop_Pages_ID = Tools.NullInt(RdrList["Shop_Pages_ID"]);
entity.Shop_Pages_Title = Tools.NullStr(RdrList["Shop_Pages_Title"]);
entity.Shop_Pages_SupplierID = Tools.NullInt(RdrList["Shop_Pages_SupplierID"]);
entity.Shop_Pages_Sign = Tools.NullStr(RdrList["Shop_Pages_Sign"]);
entity.Shop_Pages_Content = Tools.NullStr(RdrList["Shop_Pages_Content"]);
entity.Shop_Pages_Ischeck = Tools.NullInt(RdrList["Shop_Pages_Ischeck"]);
entity.Shop_Pages_IsActive = Tools.NullInt(RdrList["Shop_Pages_IsActive"]);
entity.Shop_Pages_Sort = Tools.NullInt(RdrList["Shop_Pages_Sort"]);
entity.Shop_Pages_Addtime = Tools.NullDate(RdrList["Shop_Pages_Addtime"]);
entity.Shop_Pages_Site = Tools.NullStr(RdrList["Shop_Pages_Site"]);
entitys.Add(entity);
entity = null;
}
}
return(entitys);
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (RdrList != null)
{
RdrList.Close();
RdrList = null;
}
}
}
public virtual IList <SupplierPayBackApplyInfo> GetSupplierPayBackApplys(QueryInfo Query)
{
int PageSize;
int CurrentPage;
IList <SupplierPayBackApplyInfo> entitys = null;
SupplierPayBackApplyInfo entity = null;
string SqlList, SqlField, SqlOrder, SqlParam, SqlTable;
SqlDataReader RdrList = null;
try
{
CurrentPage = Query.CurrentPage;
PageSize = Query.PageSize;
SqlTable = "Supplier_PayBack_Apply";
SqlField = "*";
SqlParam = DBHelper.GetSqlParam(Query.ParamInfos);
SqlOrder = DBHelper.GetSqlOrder(Query.OrderInfos);
SqlList = DBHelper.GetSqlPage(SqlTable, SqlField, SqlParam, SqlOrder, CurrentPage, PageSize);
RdrList = DBHelper.ExecuteReader(SqlList);
if (RdrList.HasRows)
{
entitys = new List <SupplierPayBackApplyInfo>();
while (RdrList.Read())
{
entity = new SupplierPayBackApplyInfo();
entity.Supplier_PayBack_Apply_ID = Tools.NullInt(RdrList["Supplier_PayBack_Apply_ID"]);
entity.Supplier_PayBack_Apply_SupplierID = Tools.NullInt(RdrList["Supplier_PayBack_Apply_SupplierID"]);
entity.Supplier_PayBack_Apply_Type = Tools.NullInt(RdrList["Supplier_PayBack_Apply_Type"]);
entity.Supplier_PayBack_Apply_Amount = Tools.NullDbl(RdrList["Supplier_PayBack_Apply_Amount"]);
entity.Supplier_PayBack_Apply_Note = Tools.NullStr(RdrList["Supplier_PayBack_Apply_Note"]);
entity.Supplier_PayBack_Apply_Addtime = Tools.NullDate(RdrList["Supplier_PayBack_Apply_Addtime"]);
entity.Supplier_PayBack_Apply_Status = Tools.NullInt(RdrList["Supplier_PayBack_Apply_Status"]);
entity.Supplier_PayBack_Apply_AdminAmount = Tools.NullDbl(RdrList["Supplier_PayBack_Apply_AdminAmount"]);
entity.Supplier_PayBack_Apply_AdminNote = Tools.NullStr(RdrList["Supplier_PayBack_Apply_AdminNote"]);
entity.Supplier_PayBack_Apply_AdminTime = Tools.NullDate(RdrList["Supplier_PayBack_Apply_AdminTime"]);
entity.Supplier_PayBack_Apply_Site = Tools.NullStr(RdrList["Supplier_PayBack_Apply_Site"]);
entitys.Add(entity);
entity = null;
}
}
return(entitys);
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (RdrList != null)
{
RdrList.Close();
RdrList = null;
}
}
}
public virtual IList <LogisticsLineInfo> GetLogisticsLines(QueryInfo Query)
{
int PageSize;
int CurrentPage;
IList <LogisticsLineInfo> entitys = null;
LogisticsLineInfo entity = null;
string SqlList, SqlField, SqlOrder, SqlParam, SqlTable;
SqlDataReader RdrList = null;
try
{
CurrentPage = Query.CurrentPage;
PageSize = Query.PageSize;
SqlTable = "Logistics_Line";
SqlField = "*";
SqlParam = DBHelper.GetSqlParam(Query.ParamInfos);
SqlOrder = DBHelper.GetSqlOrder(Query.OrderInfos);
SqlList = DBHelper.GetSqlPage(SqlTable, SqlField, SqlParam, SqlOrder, CurrentPage, PageSize);
RdrList = DBHelper.ExecuteReader(SqlList);
if (RdrList.HasRows)
{
entitys = new List <LogisticsLineInfo>();
while (RdrList.Read())
{
entity = new LogisticsLineInfo();
entity.Logistics_Line_ID = Tools.NullInt(RdrList["Logistics_Line_ID"]);
entity.Logistics_Line_Contact = Tools.NullStr(RdrList["Logistics_Line_Contact"]);
entity.Logistics_Line_CarType = Tools.NullStr(RdrList["Logistics_Line_CarType"]);
entity.Logistics_Line_Delivery_Address = Tools.NullStr(RdrList["Logistics_Line_Delivery_Address"]);
entity.Logistics_Line_Receiving_Address = Tools.NullStr(RdrList["Logistics_Line_Receiving_Address"]);
entity.Logistics_Line_DeliverTime = Tools.NullDate(RdrList["Logistics_Line_DeliverTime"]);
entity.Logistics_Line_Deliver_Price = Tools.NullDbl(RdrList["Logistics_Line_Deliver_Price"]);
entity.Logistics_Line_Note = Tools.NullStr(RdrList["Logistics_Line_Note"]);
entity.Logistics_ID = Tools.NullInt(RdrList["Logistics_ID"]);
entitys.Add(entity);
entity = null;
}
}
return(entitys);
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (RdrList != null)
{
RdrList.Close();
RdrList = null;
}
}
}
public virtual IList <OrdersPaymentInfo> GetOrdersPayments(QueryInfo Query)
{
int PageSize;
int CurrentPage;
IList <OrdersPaymentInfo> entitys = null;
OrdersPaymentInfo entity = null;
string SqlList, SqlField, SqlOrder, SqlParam, SqlTable;
SqlDataReader RdrList = null;
try {
CurrentPage = Query.CurrentPage;
PageSize = Query.PageSize;
SqlTable = "Orders_Payment";
SqlField = "*";
SqlParam = DBHelper.GetSqlParam(Query.ParamInfos);
SqlOrder = DBHelper.GetSqlOrder(Query.OrderInfos);
SqlList = DBHelper.GetSqlPage(SqlTable, SqlField, SqlParam, SqlOrder, CurrentPage, PageSize);
RdrList = DBHelper.ExecuteReader(SqlList);
if (RdrList.HasRows)
{
entitys = new List <OrdersPaymentInfo>();
while (RdrList.Read())
{
entity = new OrdersPaymentInfo();
entity.Orders_Payment_ID = Tools.NullInt(RdrList["Orders_Payment_ID"]);
entity.Orders_Payment_OrdersID = Tools.NullInt(RdrList["Orders_Payment_OrdersID"]);
entity.Orders_Payment_MemberID = Tools.NullInt(RdrList["Orders_Payment_MemberID"]);
entity.Orders_Payment_PaymentStatus = Tools.NullInt(RdrList["Orders_Payment_PaymentStatus"]);
entity.Orders_Payment_SysUserID = Tools.NullInt(RdrList["Orders_Payment_SysUserID"]);
entity.Orders_Payment_DocNo = Tools.NullStr(RdrList["Orders_Payment_DocNo"]);
entity.Orders_Payment_Name = Tools.NullStr(RdrList["Orders_Payment_Name"]);
entity.Orders_Payment_ApplyAmount = Tools.NullDbl(RdrList["Orders_Payment_ApplyAmount"]);
entity.Orders_Payment_Amount = Tools.NullDbl(RdrList["Orders_Payment_Amount"]);
entity.Orders_Payment_Status = Tools.NullInt(RdrList["Orders_Payment_Status"]);
entity.Orders_Payment_Note = Tools.NullStr(RdrList["Orders_Payment_Note"]);
entity.Orders_Payment_Addtime = Tools.NullDate(RdrList["Orders_Payment_Addtime"]);
entity.Orders_Payment_Site = Tools.NullStr(RdrList["Orders_Payment_Site"]);
entitys.Add(entity);
entity = null;
}
}
return(entitys);
}
catch (Exception ex) {
throw ex;
}
finally {
if (RdrList != null)
{
RdrList.Close();
RdrList = null;
}
}
}
public virtual IList <LogisticsInfo> GetLogisticss(QueryInfo Query)
{
int PageSize;
int CurrentPage;
IList <LogisticsInfo> entitys = null;
LogisticsInfo entity = null;
string SqlList, SqlField, SqlOrder, SqlParam, SqlTable;
SqlDataReader RdrList = null;
try
{
CurrentPage = Query.CurrentPage;
PageSize = Query.PageSize;
SqlTable = "Logistics";
SqlField = "*";
SqlParam = DBHelper.GetSqlParam(Query.ParamInfos);
SqlOrder = DBHelper.GetSqlOrder(Query.OrderInfos);
SqlList = DBHelper.GetSqlPage(SqlTable, SqlField, SqlParam, SqlOrder, CurrentPage, PageSize);
RdrList = DBHelper.ExecuteReader(SqlList);
if (RdrList.HasRows)
{
entitys = new List <LogisticsInfo>();
while (RdrList.Read())
{
entity = new LogisticsInfo();
entity.Logistics_ID = Tools.NullInt(RdrList["Logistics_ID"]);
entity.Logistics_NickName = Tools.NullStr(RdrList["Logistics_NickName"]);
entity.Logistics_Password = Tools.NullStr(RdrList["Logistics_Password"]);
entity.Logistics_CompanyName = Tools.NullStr(RdrList["Logistics_CompanyName"]);
entity.Logistics_Name = Tools.NullStr(RdrList["Logistics_Name"]);
entity.Logistics_Tel = Tools.NullStr(RdrList["Logistics_Tel"]);
entity.Logistics_Status = Tools.NullInt(RdrList["Logistics_Status"]);
entity.Logistics_Addtime = Tools.NullDate(RdrList["Logistics_Addtime"]);
entity.Logistics_Lastlogin_Time = Tools.NullDate(RdrList["Logistics_Lastlogin_Time"]);
entitys.Add(entity);
entity = null;
}
}
return(entitys);
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (RdrList != null)
{
RdrList.Close();
RdrList = null;
}
}
}
public virtual IList <StockoutBookingInfo> GetStockoutBookings(QueryInfo Query)
{
int PageSize;
int CurrentPage;
IList <StockoutBookingInfo> entitys = null;
StockoutBookingInfo entity = null;
string SqlList, SqlField, SqlOrder, SqlParam, SqlTable;
SqlDataReader RdrList = null;
try
{
CurrentPage = Query.CurrentPage;
PageSize = Query.PageSize;
SqlTable = "Stockout_Booking";
SqlField = "*";
SqlParam = DBHelper.GetSqlParam(Query.ParamInfos);
SqlOrder = DBHelper.GetSqlOrder(Query.OrderInfos);
SqlList = DBHelper.GetSqlPage(SqlTable, SqlField, SqlParam, SqlOrder, CurrentPage, PageSize);
RdrList = DBHelper.ExecuteReader(SqlList);
if (RdrList.HasRows)
{
entitys = new List <StockoutBookingInfo>();
while (RdrList.Read())
{
entity = new StockoutBookingInfo();
entity.Stockout_ID = Tools.NullInt(RdrList["Stockout_ID"]);
entity.Stockout_Product_Name = Tools.NullStr(RdrList["Stockout_Product_Name"]);
entity.Stockout_Product_Describe = Tools.NullStr(RdrList["Stockout_Product_Describe"]);
entity.Stockout_Member_Name = Tools.NullStr(RdrList["Stockout_Member_Name"]);
entity.Stockout_Member_Tel = Tools.NullStr(RdrList["Stockout_Member_Tel"]);
entity.Stockout_Member_Email = Tools.NullStr(RdrList["Stockout_Member_Email"]);
entity.Stockout_IsRead = Tools.NullInt(RdrList["Stockout_IsRead"]);
entity.Stockout_Addtime = Tools.NullDate(RdrList["Stockout_Addtime"]);
entity.Stockout_Site = Tools.NullStr(RdrList["Stockout_Site"]);
entitys.Add(entity);
entity = null;
}
}
return(entitys);
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (RdrList != null)
{
RdrList.Close();
RdrList = null;
}
}
}
public virtual IList <SysMessageInfo> GetSysMessages(QueryInfo Query)
{
int PageSize;
int CurrentPage;
IList <SysMessageInfo> entitys = null;
SysMessageInfo entity = null;
string SqlList, SqlField, SqlOrder, SqlParam, SqlTable;
SqlDataReader RdrList = null;
try
{
CurrentPage = Query.CurrentPage;
PageSize = Query.PageSize;
SqlTable = "Sys_Message";
SqlField = "*";
SqlParam = DBHelper.GetSqlParam(Query.ParamInfos);
SqlOrder = DBHelper.GetSqlOrder(Query.OrderInfos);
SqlList = DBHelper.GetSqlPage(SqlTable, SqlField, SqlParam, SqlOrder, CurrentPage, PageSize);
RdrList = DBHelper.ExecuteReader(SqlList);
if (RdrList.HasRows)
{
entitys = new List <SysMessageInfo>();
while (RdrList.Read())
{
entity = new SysMessageInfo();
entity.Message_ID = Tools.NullInt(RdrList["Message_ID"]);
entity.Message_Type = Tools.NullInt(RdrList["Message_Type"]);
entity.Message_UserType = Tools.NullInt(RdrList["Message_UserType"]);
entity.Message_ReceiveID = Tools.NullInt(RdrList["Message_ReceiveID"]);
entity.Message_SendID = Tools.NullInt(RdrList["Message_SendID"]);
entity.Message_Content = Tools.NullStr(RdrList["Message_Content"]);
entity.Message_Addtime = Tools.NullDate(RdrList["Message_Addtime"]);
entity.Message_Status = Tools.NullInt(RdrList["Message_Status"]);
entity.Message_Site = Tools.NullStr(RdrList["Message_Site"]);
entity.Message_IsHidden = Tools.NullInt(RdrList["Message_IsHidden"]);
entitys.Add(entity);
entity = null;
}
}
return(entitys);
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (RdrList != null)
{
RdrList.Close();
RdrList = null;
}
}
}
public virtual IList <HomeLeftCateInfo> GetHomeLeftCates(QueryInfo Query)
{
int PageSize;
int CurrentPage;
IList <HomeLeftCateInfo> entitys = null;
HomeLeftCateInfo entity = null;
string SqlList, SqlField, SqlOrder, SqlParam, SqlTable;
SqlDataReader RdrList = null;
try
{
CurrentPage = Query.CurrentPage;
PageSize = Query.PageSize;
SqlTable = "Home_Left_Cate";
SqlField = "*";
SqlParam = DBHelper.GetSqlParam(Query.ParamInfos);
SqlOrder = DBHelper.GetSqlOrder(Query.OrderInfos);
SqlList = DBHelper.GetSqlPage(SqlTable, SqlField, SqlParam, SqlOrder, CurrentPage, PageSize);
RdrList = DBHelper.ExecuteReader(SqlList);
if (RdrList.HasRows)
{
entitys = new List <HomeLeftCateInfo>();
while (RdrList.Read())
{
entity = new HomeLeftCateInfo();
entity.Home_Left_Cate_ID = Tools.NullInt(RdrList["Home_Left_Cate_ID"]);
entity.Home_Left_Cate_ParentID = Tools.NullInt(RdrList["Home_Left_Cate_ParentID"]);
entity.Home_Left_Cate_CateID = Tools.NullInt(RdrList["Home_Left_Cate_CateID"]);
entity.Home_Left_Cate_Name = Tools.NullStr(RdrList["Home_Left_Cate_Name"]);
entity.Home_Left_Cate_URL = Tools.NullStr(RdrList["Home_Left_Cate_URL"]);
entity.Home_Left_Cate_Img = Tools.NullStr(RdrList["Home_Left_Cate_Img"]);
entity.Home_Left_Cate_Sort = Tools.NullInt(RdrList["Home_Left_Cate_Sort"]);
entity.Home_Left_Cate_Active = Tools.NullInt(RdrList["Home_Left_Cate_Active"]);
entity.Home_Left_Cate_Site = Tools.NullStr(RdrList["Home_Left_Cate_Site"]);
entitys.Add(entity);
entity = null;
}
}
return(entitys);
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (RdrList != null)
{
RdrList.Close();
RdrList = null;
}
}
}
public virtual IList <ProductNotifyInfo> GetProductNotifys(QueryInfo Query)
{
int PageSize;
int CurrentPage;
IList <ProductNotifyInfo> entitys = null;
ProductNotifyInfo entity = null;
string SqlList, SqlField, SqlOrder, SqlParam, SqlTable;
SqlDataReader RdrList = null;
try
{
CurrentPage = Query.CurrentPage;
PageSize = Query.PageSize;
SqlTable = "Product_Notify";
SqlField = "*";
SqlParam = DBHelper.GetSqlParam(Query.ParamInfos);
SqlOrder = DBHelper.GetSqlOrder(Query.OrderInfos);
SqlList = DBHelper.GetSqlPage(SqlTable, SqlField, SqlParam, SqlOrder, CurrentPage, PageSize);
RdrList = DBHelper.ExecuteReader(SqlList);
if (RdrList.HasRows)
{
entitys = new List <ProductNotifyInfo>();
while (RdrList.Read())
{
entity = new ProductNotifyInfo();
entity.Product_Notify_ID = Tools.NullInt(RdrList["Product_Notify_ID"]);
entity.Product_Notify_MemberID = Tools.NullInt(RdrList["Product_Notify_MemberID"]);
entity.Product_Notify_Email = Tools.NullStr(RdrList["Product_Notify_Email"]);
entity.Product_Notify_ProductID = Tools.NullInt(RdrList["Product_Notify_ProductID"]);
entity.Product_Notify_IsNotify = Tools.NullInt(RdrList["Product_Notify_IsNotify"]);
entity.Product_Notify_Addtime = Tools.NullDate(RdrList["Product_Notify_Addtime"]);
entity.Product_Notify_Site = Tools.NullStr(RdrList["Product_Notify_Site"]);
entitys.Add(entity);
entity = null;
}
}
return(entitys);
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (RdrList != null)
{
RdrList.Close();
RdrList = null;
}
}
}
public virtual IList <LogisticsTenderInfo> GetLogisticsTenders(QueryInfo Query)
{
int PageSize;
int CurrentPage;
IList <LogisticsTenderInfo> entitys = null;
LogisticsTenderInfo entity = null;
string SqlList, SqlField, SqlOrder, SqlParam, SqlTable;
SqlDataReader RdrList = null;
try
{
CurrentPage = Query.CurrentPage;
PageSize = Query.PageSize;
SqlTable = "Logistics_Tender";
SqlField = "*";
SqlParam = DBHelper.GetSqlParam(Query.ParamInfos);
SqlOrder = DBHelper.GetSqlOrder(Query.OrderInfos);
SqlList = DBHelper.GetSqlPage(SqlTable, SqlField, SqlParam, SqlOrder, CurrentPage, PageSize);
RdrList = DBHelper.ExecuteReader(SqlList);
if (RdrList.HasRows)
{
entitys = new List <LogisticsTenderInfo>();
while (RdrList.Read())
{
entity = new LogisticsTenderInfo();
entity.Logistics_Tender_ID = Tools.NullInt(RdrList["Logistics_Tender_ID"]);
entity.Logistics_Tender_LogisticsID = Tools.NullInt(RdrList["Logistics_Tender_LogisticsID"]);
entity.Logistics_Tender_SupplierLogisticsID = Tools.NullInt(RdrList["Logistics_Tender_SupplierLogisticsID"]);
entity.Logistics_Tender_OrderID = Tools.NullInt(RdrList["Logistics_Tender_OrderID"]);
entity.Logistics_Tender_Price = Tools.NullDbl(RdrList["Logistics_Tender_Price"]);
entity.Logistics_Tender_AddTime = Tools.NullDate(RdrList["Logistics_Tender_AddTime"]);
entity.Logistics_Tender_IsWin = Tools.NullInt(RdrList["Logistics_Tender_IsWin"]);
entity.Logistics_Tender_FinishTime = Tools.NullDate(RdrList["Logistics_Tender_FinishTime"]);
entitys.Add(entity);
entity = null;
}
}
return(entitys);
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (RdrList != null)
{
RdrList.Close();
RdrList = null;
}
}
}