Exemple #1
0
        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;
                }
            }
        }
Exemple #2
0
        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;
                }
            }
        }
Exemple #3
0
        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;
                }
            }
        }
Exemple #4
0
        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;
                }
            }
        }
Exemple #5
0
        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;
                }
            }
        }
Exemple #6
0
        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;
                }
            }
        }
Exemple #7
0
        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;
                }
            }
        }
Exemple #8
0
        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;
                }
            }
        }
Exemple #9
0
        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;
                }
            }
        }
Exemple #10
0
        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;
                }
            }
        }
Exemple #11
0
        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;
                }
            }
        }
Exemple #12
0
        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);
        }
Exemple #13
0
        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;
                }
            }
        }
Exemple #14
0
        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;
                }
            }
        }
Exemple #15
0
        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;
                }
            }
        }
Exemple #16
0
        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;
                }
            }
        }
Exemple #17
0
        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;
                }
            }
        }
Exemple #18
0
        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;
                }
            }
        }
Exemple #19
0
        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;
                }
            }
        }
Exemple #20
0
        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;
                }
            }
        }
Exemple #21
0
        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;
                }
            }
        }
Exemple #23
0
        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;
                }
            }
        }
Exemple #24
0
        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;
                }
            }
        }
Exemple #25
0
        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;
                }
            }
        }
Exemple #26
0
        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;
                }
            }
        }
Exemple #27
0
        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;
                }
            }
        }
Exemple #28
0
        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;
                }
            }
        }
Exemple #29
0
        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;
                }
            }
        }
Exemple #30
0
        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;
                }
            }
        }