public List <TestPaperInfo> NewReadList(TestPaperInfo Model) { StringBuilder sql = new StringBuilder(); sql.Append("select * from [" + ShopMssqlHelper.TablePrefix + "TestPaper] "); List <TestPaperInfo> TempList = new List <TestPaperInfo>(); MssqlCondition mssqlCondition = new MssqlCondition(); this.PrepareCondition(mssqlCondition, Model); if (mssqlCondition.ToString() != string.Empty) { sql.Append("where " + mssqlCondition.ToString()); } if (Model.OrderByCondition == string.Empty) { sql.Append(" Order by TestPaperId desc"); } else { sql.Append(" Order by " + Model.OrderByCondition); } using (SqlDataReader dr = DbSQLHelper.ExecuteReader(sql.ToString())) { this.PrepareModel(dr, TempList); } return(TempList); }
public List <WorkingPostViewInfo> SearchWorkingPostViewList(WorkingPostSearchInfo workingPostSearch) { MssqlCondition mssqlCondition = new MssqlCondition(); this.PrepareCondition(mssqlCondition, workingPostSearch); List <WorkingPostViewInfo> workingPostViewList = new List <WorkingPostViewInfo>(); SqlParameter[] pt = new SqlParameter[] { new SqlParameter("@condition", SqlDbType.NVarChar) }; pt[0].Value = mssqlCondition.ToString(); using (SqlDataReader dr = ShopMssqlHelper.ExecuteReader(ShopMssqlHelper.TablePrefix + "SearchWorkingPostViewList", pt)) { while (dr.Read()) { WorkingPostViewInfo info = new WorkingPostViewInfo(); { info.PostId = int.Parse(dr["PostId"].ToString()); info.PostName = dr["PostName"].ToString(); info.KPIContent = dr["KPIContent"].ToString(); info.CompanyId = int.Parse(dr["CompanyId"].ToString()); } workingPostViewList.Add(info); } } return(workingPostViewList); }
public MssqlCondition PrepareCondition(CouponSearchInfo searchInfo) { MssqlCondition mssqlCondition = new MssqlCondition(); mssqlCondition.Add("[Name]", searchInfo.Name, ConditionType.Like); mssqlCondition.Add("[Id]", string.Join(",", searchInfo.InCouponIds), ConditionType.In); if (searchInfo.Type > 0) { mssqlCondition.Add("[Type]", searchInfo.Type, ConditionType.Equal); } if (searchInfo.CanUse == 1) { mssqlCondition.Add(" DATEDIFF(day,getdate(),[UseStartDate])<=0 and DATEDIFF(day,getdate(),[UseEndDate])>=0"); } //未开始 if (searchInfo.TimePeriod == 1) { mssqlCondition.Add(" DATEDIFF ( day , getdate(), [UseStartDate] )>0"); } //进行中 if (searchInfo.TimePeriod == 2) { mssqlCondition.Add(" DATEDIFF(day,getdate(),[UseStartDate])<=0 and DATEDIFF(day,getdate(),[UseEndDate])>=0"); } //已结束 if (searchInfo.TimePeriod == 3) { mssqlCondition.Add(" DATEDIFF(day,getdate(),[UseEndDate])<0"); } return(mssqlCondition); }
public List <PostPassInfo> ReadPostPassList(PostPassInfo Model, int num) { string sqlNumString = "*"; if (num > 0) { sqlNumString = "top " + num + " " + sqlNumString; } StringBuilder sql = new StringBuilder(); sql.Append("select " + sqlNumString + " from [" + ShopMssqlHelper.TablePrefix + "PassPost] "); List <PostPassInfo> TempList = new List <PostPassInfo>(); MssqlCondition mssqlCondition = new MssqlCondition(); this.PrepareCondition(mssqlCondition, Model); if (mssqlCondition.ToString() != string.Empty) { sql.Append("where " + mssqlCondition.ToString()); sql.Append(" Order By CreateDate desc"); using (SqlDataReader dr = DbSQLHelper.ExecuteReader(sql.ToString())) { this.PrepareModel(dr, TempList); } } return(TempList); }
/// <summary> /// 组合搜索条件 /// </summary> /// <param name="mssqlCondition"></param> /// <param name="emailSendRecordSearch">EmailSendRecordSearchInfo模型变量</param> public MssqlCondition PrepareCondition(EmailSendRecordSearchInfo emailSendRecordSearch) { MssqlCondition mssqlCondition = new MssqlCondition(); mssqlCondition.Add("[IsSystem]", emailSendRecordSearch.IsSystem, ConditionType.Equal); return(mssqlCondition); }
public void PrepareCondition(MssqlCondition mssqlCondition, KPISearchInfo kpiSearch) { mssqlCondition.Add("[Id]", kpiSearch.IdStr, ConditionType.In); mssqlCondition.Add("[ParentID]", kpiSearch.ParentId, ConditionType.In); mssqlCondition.Add("[Name]", kpiSearch.Name, ConditionType.Like); mssqlCondition.Add("[CompanyId]", kpiSearch.CompanyID, ConditionType.In); mssqlCondition.Add("[State]", kpiSearch.State, ConditionType.Equal); }
public void PrepareCondition(MssqlCondition mssqlCondition, UserCouponSearchInfo userCouponSearch) { mssqlCondition.Add("[CouponID]", userCouponSearch.CouponID, ConditionType.Equal); mssqlCondition.Add("[GetType]", userCouponSearch.GetType, ConditionType.Equal); mssqlCondition.Add("[Number]", userCouponSearch.Number, ConditionType.Like); mssqlCondition.Add("[IsUse]", userCouponSearch.IsUse, ConditionType.Equal); mssqlCondition.Add("[UserID]", userCouponSearch.UserID, ConditionType.Equal); }
public void PrepareCondition(MssqlCondition mssqlCondition, UserApplySearchInfo userApplySearch) { mssqlCondition.Add("[Number]", userApplySearch.Number, ConditionType.Like); mssqlCondition.Add("[Status]", userApplySearch.Status, ConditionType.Equal); mssqlCondition.Add("[ApplyDate]", userApplySearch.StartApplyDate, ConditionType.MoreOrEqual); mssqlCondition.Add("[ApplyDate]", userApplySearch.EndApplyDate, ConditionType.LessOrEqual); mssqlCondition.Add("[UserID]", userApplySearch.UserID, ConditionType.Equal); mssqlCondition.Add("[UserName]", userApplySearch.UserName, ConditionType.Like); }
public void PrepareCondition(MssqlCondition mssqlCondition, BookingProductSearchInfo bookingProductSearch) { mssqlCondition.Add("[ProductName]", bookingProductSearch.ProductName, ConditionType.Like); mssqlCondition.Add("[RelationUser]", bookingProductSearch.RelationUser, ConditionType.Like); mssqlCondition.Add("[Email]", bookingProductSearch.Email, ConditionType.Like); mssqlCondition.Add("[Tel]", bookingProductSearch.Tel, ConditionType.Like); mssqlCondition.Add("[IsHandler]", bookingProductSearch.IsHandler, ConditionType.Equal); mssqlCondition.Add("[UserID]", bookingProductSearch.UserID, ConditionType.Equal); }
public void PrepareCondition(MssqlCondition mssqlCondition, CourseCateInfo Model) { //mssqlCondition.Add("[CourseId]", Model.Condition, ConditionType.Like); //mssqlCondition.Add("[CompanyId]", Model.CateId, ConditionType.Equal); if (Model.Field != string.Empty) { mssqlCondition.Add("[" + Model.Field + "]", Model.Condition, ConditionType.In); } }
public void PrepareCondition(MssqlCondition mssqlCondition, UserRechargeSearchInfo userRechargeSearch) { mssqlCondition.Add("[Number]", userRechargeSearch.Number, ConditionType.Like); mssqlCondition.Add("[RechargeDate]", userRechargeSearch.StartRechargeDate, ConditionType.MoreOrEqual); mssqlCondition.Add("[RechargeDate]", userRechargeSearch.EndRechargeDate, ConditionType.LessOrEqual); mssqlCondition.Add("[IsFinish]", userRechargeSearch.IsFinish, ConditionType.Equal); mssqlCondition.Add("[UserID]", userRechargeSearch.UserID, ConditionType.Equal); mssqlCondition.Add("[UserName]", userRechargeSearch.UserName, ConditionType.Like); }
/// <summary> /// 组合搜索条件 /// </summary> /// <param name="mssqlCondition"></param> /// <param name="userMessageSearch">UserPifaSeachInfo模型变量</param> public MssqlCondition PrepareCondition(OtherDuihuanSearchInfo SearchInfo) { MssqlCondition mssqlCondition = new MssqlCondition(); mssqlCondition.Add("[truename]", SearchInfo.truename, ConditionType.Like); mssqlCondition.Add("[mobile]", SearchInfo.mobile, ConditionType.Like); return(mssqlCondition); }
public DataTable StatisticsUserStatus(UserSearchInfo userSearch) { MssqlCondition mssqlCondition = new MssqlCondition(); this.PrepareCondition(mssqlCondition, userSearch); SqlParameter[] pt = new SqlParameter[] { new SqlParameter("@condition", SqlDbType.NVarChar) }; pt[0].Value = mssqlCondition.ToString(); return(ShopMssqlHelper.ExecuteDataTable(ShopMssqlHelper.TablePrefix + "StatisticsUserStatus", pt)); }
/// <summary> /// 组合搜索条件 /// </summary> /// <param name="mssqlCondition"></param> /// <param name="voteItemSearch"></param> public void PrepareCondition(MssqlCondition mssqlCondition, VoteRecordSearchInfo searchInfo) { mssqlCondition.Add("[VoteID]", searchInfo.VoteID, ConditionType.Like); mssqlCondition.Add("[ItemID]", searchInfo.ItemID, ConditionType.Equal); mssqlCondition.Add("[UserIP]", searchInfo.UserIP, ConditionType.Equal); mssqlCondition.Add("[UserID]", searchInfo.UserID, ConditionType.Equal); mssqlCondition.Add("[UserName]", searchInfo.UserName, ConditionType.Like); mssqlCondition.Add("[AddDate]", searchInfo.AddDate, ConditionType.Equal); }
public MssqlCondition PrepareCondition(FavorableActivityGiftSearchInfo searchInfo) { MssqlCondition mssqlCondition = new MssqlCondition(); mssqlCondition.Add("[Name]", searchInfo.Name, ConditionType.Like); mssqlCondition.Add("[Id]", string.Join(",", searchInfo.InGiftIds), ConditionType.In); return(mssqlCondition); }
public void PrepareCondition(MssqlCondition mssqlCondition, WorkingPostSearchInfo workingPostSearch) { mssqlCondition.Add("[ParentId]", workingPostSearch.ParentId, ConditionType.In); mssqlCondition.Add("[CompanyId]", workingPostSearch.CompanyId, ConditionType.In); mssqlCondition.Add("[IsPost]", workingPostSearch.IsPost, ConditionType.Equal); mssqlCondition.Add("[State]", workingPostSearch.State, ConditionType.Equal); mssqlCondition.Add("[PostName]", workingPostSearch.PostName, ConditionType.Equal); mssqlCondition.Add(workingPostSearch.Condition); }
public DataTable StatisticsUserCount(UserSearchInfo userSearch, DateType dateType) { MssqlCondition mssqlCondition = new MssqlCondition(); this.PrepareCondition(mssqlCondition, userSearch); SqlParameter[] pt = new SqlParameter[] { new SqlParameter("@condition", SqlDbType.NVarChar), new SqlParameter("@dateType", SqlDbType.Int) }; pt[0].Value = mssqlCondition.ToString(); pt[1].Value = (int)dateType; return(ShopMssqlHelper.ExecuteDataTable(ShopMssqlHelper.TablePrefix + "StatisticsUserCount", pt)); }
public void AddKeyCondition(MssqlCondition mssqlCondition, string key) { string condition = string.Empty; if (key != string.Empty) { condition = (("([Name] LIKE '%" + StringHelper.SearchSafe(key) + "%' OR ") + "[Spelling] LIKE '%" + StringHelper.SearchSafe(key) + "%' OR ") + "[ProductNumber] LIKE '%" + StringHelper.SearchSafe(key) + "%')"; mssqlCondition.Add(condition); } }
public void PrepareCondition(MssqlCondition mssqlCondition, KPIEvaluateSearchInfo kpiEvaluateSearch) { mssqlCondition.Add("[KPIId]", kpiEvaluateSearch.KPIdStr, ConditionType.In); mssqlCondition.Add("[UserId]", kpiEvaluateSearch.UserId, ConditionType.In); mssqlCondition.Add("[EvaluateDate]", kpiEvaluateSearch.EvaluateDate, ConditionType.Equal); mssqlCondition.Add("[EvaluateNameId]", kpiEvaluateSearch.EvaluateNameId, ConditionType.Equal); mssqlCondition.Add("[EvaluateUserId]", kpiEvaluateSearch.EvaluateUserId, ConditionType.Equal); mssqlCondition.Add("[PostId]", kpiEvaluateSearch.PostId, ConditionType.In); mssqlCondition.Add(kpiEvaluateSearch.Condition); }
public void PrepareCondition(MssqlCondition mssqlCondition, UserSearchInfo userSearch) { mssqlCondition.Add("[UserName]", userSearch.UserName, ConditionType.Like); mssqlCondition.Add("[Email]", userSearch.Email, ConditionType.Like); mssqlCondition.Add("[Sex]", userSearch.Sex, ConditionType.Equal); mssqlCondition.Add("[RegisterDate]", userSearch.StartRegisterDate, ConditionType.MoreOrEqual); mssqlCondition.Add("[RegisterDate]", userSearch.EndRegisterDate, ConditionType.Less); mssqlCondition.Add("[Status]", userSearch.Status, ConditionType.Equal); mssqlCondition.Add("[ID]", userSearch.InUserID, ConditionType.In); }
public MssqlCondition PrepareCondition(ReceiveMessageSearchInfo searchEntity) { MssqlCondition mssqlCondition = new MssqlCondition(); mssqlCondition.Add("[Title]", searchEntity.Title, ConditionType.Like); mssqlCondition.Add("[UserID]", searchEntity.UserID, ConditionType.Equal); mssqlCondition.Add("[Date]", searchEntity.StartDate, ConditionType.MoreOrEqual); mssqlCondition.Add("[Date]", searchEntity.EndDate, ConditionType.LessOrEqual); mssqlCondition.Add("[IsRead]", searchEntity.IsRead, ConditionType.Equal); return(mssqlCondition); }
public void PrepareCondition(MssqlCondition mssqlCondition, OrderSearchInfo orderSearch, ProductSearchInfo productSearch) { mssqlCondition.Add("[OrderNumber]", orderSearch.OrderNumber, ConditionType.Like); mssqlCondition.Add("[AddDate]", orderSearch.StartAddDate, ConditionType.MoreOrEqual); mssqlCondition.Add("[AddDate]", orderSearch.EndAddDate, ConditionType.LessOrEqual); mssqlCondition.Add("[UserName]", orderSearch.UserName, ConditionType.Like); mssqlCondition.Add("[Name]", productSearch.Name, ConditionType.Like); //mssqlCondition.Add("[BrandID]", productSearch.BrandID, ConditionType.Equal); mssqlCondition.Add("[ClassID]", productSearch.ClassID, ConditionType.Like); mssqlCondition.Add("[ProductID]", productSearch.InProductID, ConditionType.In); }
public void PrepareCondition(MssqlCondition mssqlCondition, ProductCommentSearchInfo productCommentSearch) { mssqlCondition.Add("[Name]", productCommentSearch.ProductName, ConditionType.Like); mssqlCondition.Add("[Title]", productCommentSearch.Title, ConditionType.Like); mssqlCondition.Add("[Content]", productCommentSearch.Content, ConditionType.Like); mssqlCondition.Add("[UserIP]", productCommentSearch.UserIP, ConditionType.Like); mssqlCondition.Add("[PostDate]", productCommentSearch.StartPostDate, ConditionType.MoreOrEqual); mssqlCondition.Add("[PostDate]", productCommentSearch.EndPostDate, ConditionType.LessOrEqual); mssqlCondition.Add("[UserID]", productCommentSearch.UserID, ConditionType.Equal); mssqlCondition.Add("[Status]", productCommentSearch.Status, ConditionType.Equal); mssqlCondition.Add("[ProductID]", productCommentSearch.ProductID, ConditionType.Equal); }
public void PrepareCondition(MssqlCondition mssqlCondition, OrderSearchInfo orderSearch) { mssqlCondition.Add("[OrderNumber]", orderSearch.OrderNumber, ConditionType.Like); mssqlCondition.Add("[OrderStatus]", orderSearch.OrderStatus, ConditionType.Equal); mssqlCondition.Add("[Consignee]", orderSearch.Consignee, ConditionType.Like); mssqlCondition.Add("[RegionID]", orderSearch.RegionID, ConditionType.Like); mssqlCondition.Add("[ShippingID]", orderSearch.ShippingID, ConditionType.Equal); mssqlCondition.Add("[AddDate]", orderSearch.StartAddDate, ConditionType.MoreOrEqual); mssqlCondition.Add("[AddDate]", orderSearch.EndAddDate, ConditionType.LessOrEqual); mssqlCondition.Add("[UserID]", orderSearch.UserID, ConditionType.Equal); mssqlCondition.Add("[UserName]", orderSearch.UserName, ConditionType.Like); }
public MssqlCondition PrepareCondition(RebateSearchInfo searchModel) { MssqlCondition mssqlCondition = new MssqlCondition(); mssqlCondition.Add("[Distributor_Id]", searchModel.Distributor_Id, ConditionType.Equal); mssqlCondition.Add("[Time]", searchModel.StartTime, ConditionType.MoreOrEqual); mssqlCondition.Add("[Time]", searchModel.EndTtime, ConditionType.LessOrEqual); mssqlCondition.Add("[UserName]", searchModel.UserName, ConditionType.Like); mssqlCondition.Add("[RealName]", searchModel.RealName, ConditionType.Like); mssqlCondition.Add("[Mobile]", searchModel.Mobile, ConditionType.Like); return(mssqlCondition); }
public void PrepareCondition(MssqlCondition mssqlCondition, QuestionInfo Model) { mssqlCondition.Add("[CateId]", Model.IdCondition, ConditionType.In); mssqlCondition.Add("[Style]", Model.Style, ConditionType.Equal); //mssqlCondition.Add("[Checked]", Model.Checked, ConditionType.Equal); mssqlCondition.Add("[Question]", Model.Question, ConditionType.Like); mssqlCondition.Add("[CompanyId]", Model.CompanyId, ConditionType.NoEqual); if (Model.Field != string.Empty) { mssqlCondition.Add("[" + Model.Field + "]", Model.Condition, ConditionType.In); } }
public MssqlCondition PrepareCondition(UserCouponSearchInfo searchInfo) { MssqlCondition mssqlCondition = new MssqlCondition(); mssqlCondition.Add("[CouponId]", searchInfo.CouponId, ConditionType.Equal); mssqlCondition.Add("[GetType]", searchInfo.GetType, ConditionType.Equal); mssqlCondition.Add("[Number]", searchInfo.Number, ConditionType.Like); mssqlCondition.Add("[IsUse]", searchInfo.IsUse, ConditionType.Equal); mssqlCondition.Add("[UserId]", searchInfo.UserId, ConditionType.Equal); return(mssqlCondition); }
private MssqlCondition PrepareCondition(UserRechargeSearchInfo userRechargeSearch) { MssqlCondition mssqlCondition = new MssqlCondition(); mssqlCondition.Add("[Number]", userRechargeSearch.Number, ConditionType.Like); mssqlCondition.Add("[RechargeDate]", userRechargeSearch.StartRechargeDate, ConditionType.MoreOrEqual); mssqlCondition.Add("[RechargeDate]", userRechargeSearch.EndRechargeDate, ConditionType.LessOrEqual); mssqlCondition.Add("[IsFinish]", userRechargeSearch.IsFinish, ConditionType.Equal); mssqlCondition.Add("[UserId]", userRechargeSearch.InUserId, ConditionType.In); return(mssqlCondition); }
/// <summary> /// 组合搜索条件 /// </summary> /// <param name="mssqlCondition"></param> /// <param name="bookingProductSearch">BookingProductSearchInfo模型变量</param> public MssqlCondition PrepareCondition(BookingProductSearchInfo bookingProductSearch) { MssqlCondition mssqlCondition = new MssqlCondition(); mssqlCondition.Add("[ProductName]", bookingProductSearch.ProductName, ConditionType.Like); mssqlCondition.Add("[RelationUser]", bookingProductSearch.RelationUser, ConditionType.Like); mssqlCondition.Add("[Email]", bookingProductSearch.Email, ConditionType.Like); mssqlCondition.Add("[Tel]", bookingProductSearch.Tel, ConditionType.Like); mssqlCondition.Add("[IsHandler]", bookingProductSearch.IsHandler, ConditionType.Equal); mssqlCondition.Add("[UserID]", bookingProductSearch.UserID, ConditionType.Equal); return(mssqlCondition); }
/// <summary> /// 组合搜索条件 /// </summary> /// <param name="mssqlCondition"></param> /// <param name="search">BargainSearch模型变量</param> public MssqlCondition PrepareCondition(BargainSearch search) { MssqlCondition mssqlCondition = new MssqlCondition(); mssqlCondition.Add("[Name]", search.Name, ConditionType.Like); //mssqlCondition.Add("[StartDate]",search.StartDate,ConditionType.Like); //mssqlCondition.Add("[EndDate]",search.EndDate,ConditionType.Like); mssqlCondition.Add("[LimitCount]", search.LimitCount, ConditionType.Equal); mssqlCondition.Add("[NumberPeople]", search.NumberPeople, ConditionType.Equal); mssqlCondition.Add("[ActivityRules]", search.ActivityRules, ConditionType.Like); mssqlCondition.Add("[SuccessRate]", search.SuccessRate, ConditionType.Equal); return(mssqlCondition); }