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