public static Mall_AmountRule[] GetMall_AmountRuleByAmount(decimal Amount, int AmountType = 1, int UserID = 0)
{
if (UserID <= 0)
{
return(new Mall_AmountRule[] { });
}
List <string> conditions = new List <string>();
List <SqlParameter> parameters = new List <SqlParameter>();
List <int> ProjectIDList = Project.GetParentProjectIDListByAPPUserID(UserID);
if (ProjectIDList.Count > 0)
{
conditions.Add("([IsUseForALLProject]=1 or [ID] in (select [Mall_AmountRuleID] from [Mall_AmountRuleProject] where [ProjectID] in (" + string.Join(",", ProjectIDList.ToArray()) + ")))");
}
else
{
conditions.Add("[IsUseForALLProject]=1");
}
conditions.Add("[AmountType]=@AmountType");
parameters.Add(new SqlParameter("@AmountType", AmountType));
conditions.Add("[IsActive]=1");
conditions.Add("[StartAmount]<=@Amount");
conditions.Add("[EndAmount]>=@Amount");
parameters.Add(new SqlParameter("@Amount", Amount));
return(GetList <Mall_AmountRule>("select * from [Mall_AmountRule] where " + string.Join(" and ", conditions.ToArray()), parameters).ToArray());
}
public static Wechat_Survey[] GetWechat_SurveyListByUserID(int UserID)
{
if (UserID == 0)
{
return(new Wechat_Survey[] { });
}
var ProjectIDList = Project.GetParentProjectIDListByAPPUserID(UserID);
if (ProjectIDList.Count == 0)
{
return(new Wechat_Survey[] { });
}
List <SqlParameter> parameters = new List <SqlParameter>();
List <string> conditions = new List <string>();
conditions.Add("[ID] in (select [Wechat_SurveyID] from [Wechat_SurveyProject] where [ProjectID] in (" + string.Join(",", ProjectIDList.ToArray()) + "))");
return(GetList <Wechat_Survey>("select * from [Wechat_Survey] where [SurveyType]=3 and " + string.Join(" and ", conditions.ToArray()) + " order by [AddTime] desc", parameters).ToArray());
}