public List <UserAccountRecordInfo> ReadUserAccountRecordList(int currentPage, int pageSize, ref int count, int userID, int accountType) { List <UserAccountRecordInfo> userAccountRecordList = new List <UserAccountRecordInfo>(); ShopMssqlPagerClass class2 = new ShopMssqlPagerClass(); class2.TableName = ShopMssqlHelper.TablePrefix + "UserAccountRecord"; class2.Fields = "[ID],[Money],[Point],[Date],[IP],[Note],[UserID],[UserName]"; class2.CurrentPage = currentPage; class2.PageSize = pageSize; class2.OrderField = "[ID]"; class2.OrderType = OrderType.Asc; class2.MssqlCondition.Add("[UserID]", userID, ConditionType.Equal); if (accountType == 1) { class2.MssqlCondition.Add("[Money]!=0"); } else { class2.MssqlCondition.Add("[Point]!=0"); } class2.Count = count; count = class2.Count; using (SqlDataReader reader = class2.ExecuteReader()) { this.PrepareUserAccountRecordModel(reader, userAccountRecordList); } return(userAccountRecordList); }
public List <ProductInfo> SearchProductList(int currentPage, int pageSize, ProductSearchInfo productSearch, ref int count) { List <ProductInfo> productList = new List <ProductInfo>(); ShopMssqlPagerClass class2 = new ShopMssqlPagerClass(); class2.TableName = ShopMssqlHelper.TablePrefix + "Product"; class2.Fields = "[ID],[Name],[Spelling],[Color],[FontStyle],[ProductNumber],[ClassID],[BrandID],[MarketPrice],[Weight],[SendPoint],[Photo],[Keywords],[Summary],[IsSpecial],[IsNew],[IsHot],[IsSale],[IsTop],[Accessory],[RelationProduct],[RelationArticle],[ViewCount],[AllowComment],[CommentCount],[SumPoint],[PerPoint],[PhotoCount],[CollectCount],[TotalStorageCount],[OrderCount],[SendCount],[ImportActualStorageCount],[ImportVirtualStorageCount],[LowerCount],[UpperCount],[AttributeClassID],[StandardType],[AddDate],[CompanyID],[Sort],[Editor],[Introduction]"; class2.CurrentPage = currentPage; class2.PageSize = pageSize; if (string.IsNullOrEmpty(productSearch.OrderField)) { class2.OrderField = "[ID]"; } else { class2.OrderField = productSearch.OrderField; } if (productSearch.ProductOrderType != string.Empty) { string productOrderType = productSearch.ProductOrderType; if (productOrderType != null) { if (!(productOrderType == "CommentCount")) { if (productOrderType == "PerPoint") { class2.OrderField = "[PerPoint],[ID]"; } else if (productOrderType == "CollectCount") { class2.OrderField = "[CollectCount],[ID]"; } else if (productOrderType == "ViewCount") { class2.OrderField = "[ViewCount],[ID]"; } } else { class2.OrderField = "[CommentCount],[ID]"; } } } class2.OrderType = productSearch.OrderType; this.PrepareCondition(class2.MssqlCondition, productSearch); class2.Count = count; count = class2.Count; using (SqlDataReader reader = class2.ExecuteReader()) { this.PrepareProductModel(reader, productList); } return(productList); }
public List<AdInfo> ReadAdList(int classID, int currentPage, int pageSize, ref int count) { List<AdInfo> adList = new List<AdInfo>(); ShopMssqlPagerClass class2 = new ShopMssqlPagerClass(); class2.TableName = ShopMssqlHelper.TablePrefix + "Ad"; class2.Fields = "[ID],[Title],[Introduction],[AdClass],[Display],[Width],[Height],[Url],[StartDate],[EndDate],[Remark],[ClickCount],[IsEnabled]"; class2.CurrentPage = currentPage; class2.PageSize = pageSize; class2.OrderField = "[ID]"; class2.OrderType = OrderType.Desc; class2.MssqlCondition.Add("[AdClass]", classID, ConditionType.Equal); count = class2.Count; using (SqlDataReader reader = class2.ExecuteReader()) { this.PrepareAdModel(reader, adList); } return adList; }
public List<UserApplyInfo> SearchUserApplyList(int currentPage, int pageSize, UserApplySearchInfo userApplySearch, ref int count) { List<UserApplyInfo> userApplyList = new List<UserApplyInfo>(); ShopMssqlPagerClass class2 = new ShopMssqlPagerClass(); class2.TableName = ShopMssqlHelper.TablePrefix + "UserApply"; class2.Fields = "[ID],[Number],[Money],[UserNote],[Status],[ApplyDate],[ApplyIP],[AdminNote],[UpdateDate],[UpdateAdminID],[UpdateAdminName],[UserID],[UserName]"; class2.CurrentPage = currentPage; class2.PageSize = pageSize; class2.OrderField = "[ID]"; class2.OrderType = OrderType.Desc; this.PrepareCondition(class2.MssqlCondition, userApplySearch); class2.Count = count; count = class2.Count; using (SqlDataReader reader = class2.ExecuteReader()) { this.PrepareUserApplyModel(reader, userApplyList); } return userApplyList; }
public List <GiftPackInfo> ReadGiftPackList(int currentPage, int pageSize, ref int count) { List <GiftPackInfo> giftPackList = new List <GiftPackInfo>(); ShopMssqlPagerClass class2 = new ShopMssqlPagerClass(); class2.TableName = ShopMssqlHelper.TablePrefix + "GiftPack"; class2.Fields = "[ID],[Name],[Photo],[StartDate],[EndDate],[Price],[GiftGroup]"; class2.CurrentPage = currentPage; class2.PageSize = pageSize; class2.OrderField = "[ID]"; class2.OrderType = OrderType.Desc; class2.Count = count; count = class2.Count; using (SqlDataReader reader = class2.ExecuteReader()) { this.PrepareGiftPackModel(reader, giftPackList); } return(giftPackList); }
public List <AdminInfo> ReadAdminList(int currentPage, int pageSize, ref int count) { List <AdminInfo> adminList = new List <AdminInfo>(); ShopMssqlPagerClass class2 = new ShopMssqlPagerClass(); class2.TableName = ShopMssqlHelper.TablePrefix + "Admin"; class2.Fields = "[ID],[Name],[Email],[GroupID],[Password],[LastLoginIP],[LastLoginDate],[LoginTimes],[NoteBook],[IsCreate]"; class2.CurrentPage = currentPage; class2.PageSize = pageSize; class2.OrderField = "[ID]"; class2.OrderType = OrderType.Desc; class2.Count = count; count = class2.Count; using (SqlDataReader reader = class2.ExecuteReader()) { this.PrepareAdminModel(reader, adminList); } return(adminList); }
public List <FlashInfo> ReadFlashList(int currentPage, int pageSize, ref int count) { List <FlashInfo> flashList = new List <FlashInfo>(); ShopMssqlPagerClass class2 = new ShopMssqlPagerClass(); class2.TableName = ShopMssqlHelper.TablePrefix + "Flash"; class2.Fields = "[ID],[Title],[Introduce],[Width],[Height],[PhotoCount]"; class2.CurrentPage = currentPage; class2.PageSize = pageSize; class2.OrderField = "[ID]"; class2.OrderType = OrderType.Desc; class2.Count = count; count = class2.Count; using (SqlDataReader reader = class2.ExecuteReader()) { this.PrepareFlashModel(reader, flashList); } return(flashList); }
public List <VoteInfo> ReadVoteList(int currentPage, int pageSize, ref int count) { List <VoteInfo> voteList = new List <VoteInfo>(); ShopMssqlPagerClass class2 = new ShopMssqlPagerClass(); class2.TableName = ShopMssqlHelper.TablePrefix + "Vote"; class2.Fields = "[ID],[Title],[ItemCount],[VoteType],[Note]"; class2.CurrentPage = currentPage; class2.PageSize = pageSize; class2.OrderField = "[ID]"; class2.OrderType = OrderType.Desc; class2.Count = count; count = class2.Count; using (SqlDataReader reader = class2.ExecuteReader()) { this.PrepareVoteModel(reader, voteList); } return(voteList); }
public List<GiftInfo> SearchGiftList(int currentPage, int pageSize, GiftSearchInfo giftSearch, ref int count) { List<GiftInfo> giftList = new List<GiftInfo>(); ShopMssqlPagerClass class2 = new ShopMssqlPagerClass(); class2.TableName = ShopMssqlHelper.TablePrefix + "Gift"; class2.Fields = "[ID],[Name],[Photo],[Description]"; class2.CurrentPage = currentPage; class2.PageSize = pageSize; class2.OrderField = "[ID]"; class2.OrderType = OrderType.Desc; this.PrepareCondition(class2.MssqlCondition, giftSearch); class2.Count = count; count = class2.Count; using (SqlDataReader reader = class2.ExecuteReader()) { this.PrepareGiftModel(reader, giftList); } return giftList; }
public List <FavorableActivityInfo> ReadFavorableActivityList(int currentPage, int pageSize, ref int count) { List <FavorableActivityInfo> favorableActivityList = new List <FavorableActivityInfo>(); ShopMssqlPagerClass class2 = new ShopMssqlPagerClass(); class2.TableName = ShopMssqlHelper.TablePrefix + "FavorableActivity"; class2.Fields = "[ID],[Name],[Photo],[Content],[StartDate],[EndDate],[UserGrade],[OrderProductMoney],[RegionID],[ShippingWay],[ReduceWay],[ReduceMoney],[ReduceDiscount],[GiftID]"; class2.CurrentPage = currentPage; class2.PageSize = pageSize; class2.OrderField = "[ID]"; class2.OrderType = OrderType.Desc; class2.Count = count; count = class2.Count; using (SqlDataReader reader = class2.ExecuteReader()) { this.PrepareFavorableActivityModel(reader, favorableActivityList); } return(favorableActivityList); }
public List <CourseInfo> ReadList(int currentPage, int pageSize, ref int count) { List <CourseInfo> TempList = new List <CourseInfo>(); ShopMssqlPagerClass class2 = new ShopMssqlPagerClass(); class2.TableName = "[" + ShopMssqlHelper.TablePrefix + "Course]"; class2.Fields = "*"; class2.CurrentPage = currentPage; class2.PageSize = pageSize; class2.OrderField = "[CourseId]"; class2.OrderType = OrderType.Desc; class2.Count = count; count = class2.Count; using (SqlDataReader reader = class2.ExecuteReader()) { this.PrepareModel(reader, TempList); } return(TempList); }
public List <ThemeActivityInfo> ReadThemeActivityList(int currentPage, int pageSize, ref int count) { List <ThemeActivityInfo> themeActivityList = new List <ThemeActivityInfo>(); ShopMssqlPagerClass class2 = new ShopMssqlPagerClass(); class2.TableName = ShopMssqlHelper.TablePrefix + "ThemeActivity"; class2.Fields = "[ID],[Name],[Photo],[Description],[Css],[ProductGroup],[Style]"; class2.CurrentPage = currentPage; class2.PageSize = pageSize; class2.OrderField = "[ID]"; class2.OrderType = OrderType.Desc; class2.Count = count; count = class2.Count; using (SqlDataReader reader = class2.ExecuteReader()) { this.PrepareThemeActivityModel(reader, themeActivityList); } return(themeActivityList); }
public List <AdRecordInfo> ReadAdRecordList(int currentPage, int pageSize, ref int count, int userID) { List <AdRecordInfo> adRecordList = new List <AdRecordInfo>(); ShopMssqlPagerClass class2 = new ShopMssqlPagerClass(); class2.TableName = ShopMssqlHelper.TablePrefix + "AdRecord"; class2.Fields = "[ID],[AdID],[IP],[Date],[Page],[UserID],[UserName]"; class2.CurrentPage = currentPage; class2.PageSize = pageSize; class2.OrderField = "[ID]"; class2.OrderType = OrderType.Desc; class2.MssqlCondition.Add("[UserID]", userID, ConditionType.Equal); class2.Count = count; count = class2.Count; using (SqlDataReader reader = class2.ExecuteReader()) { this.PrepareAdRecordModel(reader, adRecordList); } return(adRecordList); }
public List <ArticleInfo> SearchArticleList(int currentPage, int pageSize, ArticleSearchInfo articleSearch, ref int count) { List <ArticleInfo> articleList = new List <ArticleInfo>(); ShopMssqlPagerClass class2 = new ShopMssqlPagerClass(); class2.TableName = ShopMssqlHelper.TablePrefix + "Article"; class2.Fields = "[ID],[Title],[ClassID],[IsTop],[Author],[Resource],[Keywords],[Url],[Photo],[Summary],[Content],[Date]"; class2.CurrentPage = currentPage; class2.PageSize = pageSize; class2.OrderField = "[ID]"; class2.OrderType = OrderType.Desc; this.PrepareCondition(class2.MssqlCondition, articleSearch); class2.Count = count; count = class2.Count; using (SqlDataReader reader = class2.ExecuteReader()) { this.PrepareArticleModel(reader, articleList); } return(articleList); }
public List <EmailSendRecordInfo> SearchEmailSendRecordList(int currentPage, int pageSize, EmailSendRecordSearchInfo emailSendRecordSearch, ref int count) { List <EmailSendRecordInfo> emailSendRecordList = new List <EmailSendRecordInfo>(); ShopMssqlPagerClass class2 = new ShopMssqlPagerClass(); class2.TableName = ShopMssqlHelper.TablePrefix + "EmailSendRecord"; class2.Fields = "[ID],[Title],[Content],[IsSystem],[EmailList],[OpenEmailList],[IsStatisticsOpendEmail],[SendStatus],[Note],[AddDate],[SendDate]"; class2.CurrentPage = currentPage; class2.PageSize = pageSize; class2.OrderField = "[ID]"; class2.OrderType = OrderType.Desc; this.PrepareCondition(class2.MssqlCondition, emailSendRecordSearch); class2.Count = count; count = class2.Count; using (SqlDataReader reader = class2.ExecuteReader()) { this.PrepareEmailSendRecordModel(reader, emailSendRecordList); } return(emailSendRecordList); }
public List <PostPassInfo> ReadPostPassList(PostPassInfo postpassSearch, int currentPage, int pageSize, ref int count) { List <PostPassInfo> TempList = new List <PostPassInfo>(); ShopMssqlPagerClass class2 = new ShopMssqlPagerClass(); class2.TableName = "[" + ShopMssqlHelper.TablePrefix + "PassPost]"; class2.Fields = "*"; class2.CurrentPage = currentPage; class2.PageSize = pageSize; class2.OrderField = "[CreateDate]"; class2.OrderType = OrderType.Desc; this.PrepareCondition(class2.MssqlCondition, postpassSearch); class2.Count = count; count = class2.Count; using (SqlDataReader dr = class2.ExecuteReader()) { this.PrepareModel(dr, TempList); } return(TempList); }
public List <UserInfo> SearchUserList(int currentPage, int pageSize, UserSearchInfo userSearch, ref int count) { List <UserInfo> userList = new List <UserInfo>(); ShopMssqlPagerClass class2 = new ShopMssqlPagerClass(); class2.TableName = "[" + ShopMssqlHelper.TablePrefix + "User]"; class2.Fields = "[ID],[UserName],[UserPassword],[Email],[Sex],[Introduce],[Photo],[MSN],[QQ],[Tel],[Mobile],[RegionID],[Address],[Birthday],[RegisterIP],[RegisterDate],[LastLoginIP],[LastLoginDate],[LoginTimes],[SafeCode],[FindDate],[Status],[OpenID],[GroupID],[RealName],[CompanyID],[WorkingPostID],[StudyPostID],[WorkingPostName],[Department],[IDCard],[PostStartDate],[EntryDate]"; class2.CurrentPage = currentPage; class2.PageSize = pageSize; class2.OrderField = "[ID]"; class2.OrderType = OrderType.Desc; this.PrepareCondition(class2.MssqlCondition, userSearch); class2.Count = count; count = class2.Count; using (SqlDataReader reader = class2.ExecuteReader()) { this.PrepareUserModel(reader, userList); } return(userList); }
/// <summary> /// 查询公司变化记录 带分页 /// </summary> /// <param name="currentPage"></param> /// <param name="pageSize"></param> /// <param name="RecordSearch"></param> /// <param name="count"></param> /// <returns></returns> public List <ProRecordInfo> UserRecordList(int currentPage, int pageSize, ProRecordInfo RecordSearch, ref int count) { List <ProRecordInfo> RecordList = new List <ProRecordInfo>(); ShopMssqlPagerClass class2 = new ShopMssqlPagerClass(); class2.TableName = ShopMssqlHelper.TablePrefix + "ProRecord"; class2.Fields = "[Id],[UserID],[ChangeNum],[Reason],[CreateDate]"; class2.CurrentPage = currentPage; class2.PageSize = pageSize; class2.OrderField = "[CreateDate]"; class2.OrderType = OrderType.Desc; this.PrepareCondition(class2.MssqlCondition, RecordSearch); class2.Count = count; count = class2.Count; using (SqlDataReader reader = class2.ExecuteReader()) { this.PrepareUserModel(reader, RecordList); } return(RecordList); }
/// <summary> /// 查询公司变化记录 带分页 /// </summary> /// <param name="currentPage"></param> /// <param name="pageSize"></param> /// <param name="RecordSearch"></param> /// <param name="count"></param> /// <returns></returns> public List <CompanyRuleInfo> CompanyRuleList(int currentPage, int pageSize, CompanyRuleInfo RuleSearch, ref int count) { List <CompanyRuleInfo> RuleList = new List <CompanyRuleInfo>(); ShopMssqlPagerClass class2 = new ShopMssqlPagerClass(); class2.TableName = ShopMssqlHelper.TablePrefix + "CompanyRule"; class2.Fields = "*"; class2.CurrentPage = currentPage; class2.PageSize = pageSize; class2.OrderField = "[Id]"; class2.OrderType = OrderType.Desc; this.PrepareCondition(class2.MssqlCondition, RuleSearch); class2.Count = count; count = class2.Count; using (SqlDataReader reader = class2.ExecuteReader()) { this.PrepareModel(reader, RuleList); } return(RuleList); }
/// <summary> /// 读取实体的列表 /// </summary> /// <typeparam name="T"></typeparam> /// <param name="t">查询条件类</param> /// <param name="currentPage"></param> /// <param name="pageSize"></param> /// <param name="count"></param> /// <returns></returns> //public List<T> ReadList<T>(T t, int currentPage, int pageSize, ref int count) where T : BaseModel public List <T> ReadList <S>(S s, int currentPage, int pageSize, ref int count) { //Type type = typeof(T); ShopMssqlPagerClass class2 = new ShopMssqlPagerClass(); class2.TableName = string.Concat("[", ShopMssqlHelper.TablePrefix, tableName, "]"); class2.Fields = GetFieldString(type); class2.CurrentPage = currentPage; class2.PageSize = pageSize; class2.OrderField = "[ID]"; class2.OrderType = OrderType.Desc; this.PrepareCondition(class2.MssqlCondition, s); class2.Count = count; count = class2.Count; using (SqlDataReader reader = class2.ExecuteReader()) { return(this.PrepareList(reader)); } }
public List <ProductReplyInfo> ReadProductReplyList(int currentPage, int pageSize, ref int count, int userID) { List <ProductReplyInfo> productReplyList = new List <ProductReplyInfo>(); ShopMssqlPagerClass class2 = new ShopMssqlPagerClass(); class2.TableName = ShopMssqlHelper.TablePrefix + "ProductReply"; class2.Fields = "[ID],[ProductID],[CommentID],[Content],[UserIP],[PostDate],[UserID],[UserName]"; class2.CurrentPage = currentPage; class2.PageSize = pageSize; class2.OrderField = "[ID]"; class2.OrderType = OrderType.Desc; class2.MssqlCondition.Add("[UserID]", userID, ConditionType.Equal); class2.Count = count; count = class2.Count; using (SqlDataReader reader = class2.ExecuteReader()) { this.PrepareProductReplyModel(reader, productReplyList); } return(productReplyList); }
public List <ProductCommentInfo> SearchProductCommentList(int currentPage, int pageSize, ProductCommentSearchInfo productCommentSearch, ref int count) { List <ProductCommentInfo> productCommentList = new List <ProductCommentInfo>(); ShopMssqlPagerClass class2 = new ShopMssqlPagerClass(); class2.TableName = ShopMssqlHelper.TablePrefix + "ProductComment"; class2.Fields = "[ID],[ProductID],[Title],[Content],[UserIP],[PostDate],[Support],[Against],[Status],[Rank],[ReplyCount],[AdminReplyContent],[AdminReplyDate],[UserID],[UserName]"; class2.CurrentPage = currentPage; class2.PageSize = pageSize; class2.OrderField = "[ID]"; class2.OrderType = OrderType.Desc; this.PrepareCondition(class2.MssqlCondition, productCommentSearch); class2.Count = count; count = class2.Count; using (SqlDataReader reader = class2.ExecuteReader()) { this.PrepareProductCommentModel(reader, productCommentList); } return(productCommentList); }
public List <WorkingPostInfo> SearchWorkingPostList(WorkingPostSearchInfo workingPostSearch, int currentPage, int pageSize, ref int count) { List <WorkingPostInfo> workingPostList = new List <WorkingPostInfo>(); ShopMssqlPagerClass class2 = new ShopMssqlPagerClass(); class2.TableName = ShopMssqlHelper.TablePrefix + "WorkingPost"; class2.Fields = "*"; class2.CurrentPage = currentPage; class2.PageSize = pageSize; class2.OrderField = "[Id]"; class2.OrderType = OrderType.Asc; this.PrepareCondition(class2.MssqlCondition, workingPostSearch); class2.Count = count; count = class2.Count; using (SqlDataReader dr = class2.ExecuteReader()) { this.PrepareModel(dr, workingPostList); } return(workingPostList); }
public List <EvaluateNameInfo> SearchEvaluateNameList(EvaluateNameInfo evaluateName, int currentPage, int pageSize, ref int count) { List <EvaluateNameInfo> evaluateNameList = new List <EvaluateNameInfo>(); ShopMssqlPagerClass class2 = new ShopMssqlPagerClass(); class2.TableName = ShopMssqlHelper.TablePrefix + "EvaluateName"; class2.Fields = "[Id],[EvaluateName],CONVERT(varchar(100), [StartDate], 23) as [StartDate],CONVERT(varchar(100), [EndDate], 23) as [EndDate],CONVERT(varchar(100), [Date], 23) as [Date],[CompanyId],[State]"; class2.CurrentPage = currentPage; class2.PageSize = pageSize; class2.OrderField = "[ID]"; class2.OrderType = OrderType.Desc; this.PrepareCondition(class2.MssqlCondition, evaluateName); class2.Count = count; count = class2.Count; using (SqlDataReader dr = class2.ExecuteReader()) { this.PrepareModel(dr, evaluateNameList); } return(evaluateNameList); }
public List <CouponInfo> SearchCouponList(int currentPage, int pageSize, CouponSearchInfo couponSearch, ref int count) { List <CouponInfo> couponList = new List <CouponInfo>(); ShopMssqlPagerClass class2 = new ShopMssqlPagerClass(); class2.TableName = ShopMssqlHelper.TablePrefix + "Coupon"; class2.Fields = "[ID],[Name],[Money],[UseMinAmount],[UseStartDate],[UseEndDate]"; class2.CurrentPage = currentPage; class2.PageSize = pageSize; class2.OrderField = "[ID]"; class2.OrderType = OrderType.Desc; this.PrepareCondition(class2.MssqlCondition, couponSearch); class2.Count = count; count = class2.Count; using (SqlDataReader reader = class2.ExecuteReader()) { this.PrepareCouponModel(reader, couponList); } return(couponList); }
public List <UserMessageInfo> SearchUserMessageList(int currentPage, int pageSize, UserMessageSeachInfo userMessageSearch, ref int count) { List <UserMessageInfo> userMessageList = new List <UserMessageInfo>(); ShopMssqlPagerClass class2 = new ShopMssqlPagerClass(); class2.TableName = ShopMssqlHelper.TablePrefix + "UserMessage"; class2.Fields = "[ID],[MessageClass],[Title],[Content],[UserIP],[PostDate],[IsHandler],[AdminReplyContent],[AdminReplyDate],[UserID],[UserName],[Mobile],[IsChecked]"; class2.CurrentPage = currentPage; class2.PageSize = pageSize; class2.OrderField = "[ID]"; class2.OrderType = OrderType.Desc; this.PrepareCondition(class2.MssqlCondition, userMessageSearch); class2.Count = count; count = class2.Count; using (SqlDataReader reader = class2.ExecuteReader()) { this.PrepareUserMessageModel(reader, userMessageList); } return(userMessageList); }
public List <PostKPISettingInfo> SearchPostKPISettingList(PostKPISettingInfo info, int currentPage, int pageSize, ref int count) { List <PostKPISettingInfo> postKPISettingList = new List <PostKPISettingInfo>(); ShopMssqlPagerClass class2 = new ShopMssqlPagerClass(); class2.TableName = ShopMssqlHelper.TablePrefix + "PostKPISetting"; class2.Fields = "*"; class2.CurrentPage = currentPage; class2.PageSize = pageSize; class2.OrderField = "[Id]"; class2.OrderType = OrderType.Asc; this.PrepareCondition(class2.MssqlCondition, info); class2.Count = count; count = class2.Count; using (SqlDataReader dr = class2.ExecuteReader()) { this.PrepareModel(dr, postKPISettingList); } return(postKPISettingList); }
public List <KPIInfo> SearchKPIList(KPISearchInfo kpiSearch, int currentPage, int pageSize, ref int count) { List <KPIInfo> kpiList = new List <KPIInfo>(); ShopMssqlPagerClass class2 = new ShopMssqlPagerClass(); class2.TableName = ShopMssqlHelper.TablePrefix + "KPI"; class2.Fields = "*"; class2.CurrentPage = currentPage; class2.PageSize = pageSize; class2.OrderField = "[ID]"; class2.OrderType = OrderType.Desc; this.PrepareCondition(class2.MssqlCondition, kpiSearch); class2.Count = count; count = class2.Count; using (SqlDataReader dr = class2.ExecuteReader()) { this.PrepareModel(dr, kpiList); } return(kpiList); }
public List <ReceiveMessageInfo> SearchReceiveMessageList(int currentPage, int pageSize, ReceiveMessageSearchInfo receiveMessageSearch, ref int count) { List <ReceiveMessageInfo> receiveMessageList = new List <ReceiveMessageInfo>(); ShopMssqlPagerClass class2 = new ShopMssqlPagerClass(); class2.TableName = ShopMssqlHelper.TablePrefix + "ReceiveMessage"; class2.Fields = "[ID],[Title],[Content],[Date],[IsRead],[IsAdmin],[FromUserID],[FromUserName],[UserID],[UserName]"; class2.CurrentPage = currentPage; class2.PageSize = pageSize; class2.OrderField = "[ID]"; class2.OrderType = OrderType.Desc; this.PrepareCondition(class2.MssqlCondition, receiveMessageSearch); class2.Count = count; count = class2.Count; using (SqlDataReader reader = class2.ExecuteReader()) { this.PrepareReceiveMessageModel(reader, receiveMessageList); } return(receiveMessageList); }
public List <BookingProductInfo> SearchBookingProductList(int currentPage, int pageSize, BookingProductSearchInfo bookingProductSearch, ref int count) { List <BookingProductInfo> bookingProductList = new List <BookingProductInfo>(); ShopMssqlPagerClass class2 = new ShopMssqlPagerClass();; class2.TableName = ShopMssqlHelper.TablePrefix + "BookingProduct"; class2.Fields = "[ID],[ProductID],[ProductName],[RelationUser],[Email],[Tel],[UserNote],[BookingDate],[BookingIP],[IsHandler],[HandlerDate],[HandlerAdminID],[HandlerAdminName],[HandlerNote],[UserID],[UserName]"; class2.CurrentPage = currentPage; class2.PageSize = pageSize; class2.OrderField = "[ID]"; class2.OrderType = OrderType.Desc; this.PrepareCondition(class2.MssqlCondition, bookingProductSearch); class2.Count = count; count = class2.Count; using (SqlDataReader reader = class2.ExecuteReader()) { this.PrepareBookingProductModel(reader, bookingProductList); } return(bookingProductList); }