public ActionResult WeChatAutoReplyKeyWordsList(int?id, ParaMkWeixinKeywords para)
{
//当前用户自己对应分销商
if (CurrentUser.IsBindDealer)
{
int DealerSysNo = CurrentUser.Dealer.SysNo;
para.DealerSysNo = DealerSysNo;
para.IsBindDealer = CurrentUser.IsBindDealer;
}
//是否绑定所有经销商
para.IsBindAllDealer = CurrentUser.IsBindAllDealer;
para.DealerCreatedBy = CurrentUser.Base.SysNo;
var dic = WeChatBo.Instance.QueryKeyWords(para, id ?? 1);
var model = new PagedList <CBMkWeixinKeywords>
{
TData = dic.Any() ? dic.First().Value : null,
CurrentPageIndex = id ?? 1,
TotalItemCount = dic.Any() ? dic.First().Key : 0
};
if (Request.IsAjaxRequest())
{
return(PartialView("pAjaxPager_WeChatAutoReplyWordsList", model));
}
return(View(model));
}
/// <summary>
/// query 微信关键字列表
/// </summary>
/// <param name="para">MkWeixinKeywords</param>
/// <param name="id">page index</param>
/// <param name="pageSize">page size</param>
/// <returns>list of MkWeixinKeywords</returns>
/// <remarks>2013-10-25 hw created</remarks>
public override Dictionary <int, List <CBMkWeixinKeywords> > QueryKeyWords(ParaMkWeixinKeywords para, int id = 1,
int pageSize = 10)
{
string sqlWhere = " and 1=1";
//判断是否绑定所有分销商
if (!para.IsBindAllDealer)
{
//判断是否绑定分销商
if (para.IsBindDealer)
{
sqlWhere += " and dea.SysNo = " + para.DealerSysNo;
}
else
{
sqlWhere += " and dea.CreatedBy = " + para.DealerCreatedBy;
}
}
if (para.SelectedAgentSysNo != -1)
{
if (para.SelectedDealerSysNo != -1)
{
sqlWhere += " and dea.SysNo = " + para.SelectedDealerSysNo;
}
else
{
sqlWhere += " and dea.CreatedBy = " + para.SelectedAgentSysNo;
}
}
string sqlSelect = @"a.*,dea.DealerName",
sqlFrom = @"MkWeixinKeywords a left join DsDealer dea on a.DealerSysNo = dea.SysNo",
//关键词进行查找
//sqlCondition = @"(:keyWords is null or a.keyWords=:keyWords)";
//sqlCondition = @"(:keyWords is null)";
sqlCondition = string.Format(@"(@keyWords is null
or keywords like '{0}' -- single
or keywords like '{0};%' --starts with
or keywords like '%;{0}'--ends with
or keywords like '%;{0};'--ends with
or keywords like '%;{0};%'--in the middle
)", para.Keywords);
sqlCondition += sqlWhere;
using (IDbContext context = Context.UseSharedConnection(true))
{
List <CBMkWeixinKeywords> lstResult = context.Select <CBMkWeixinKeywords>(sqlSelect)
.From(sqlFrom)
.AndWhere(sqlCondition)
.Parameter("keyWords", para.Keywords)
.Paging(id, pageSize) //index从1开始
.OrderBy("a.sysno desc")
.QueryMany();
int count = context.Select <int>(@"count(*)")
.From(sqlFrom)
.AndWhere(sqlCondition)
.Parameter("keyWords", para.Keywords)
.QuerySingle();
return(new Dictionary <int, List <CBMkWeixinKeywords> > {
{ count, lstResult }
});
}
}
/// <summary>
/// query 微信关键字列表
/// </summary>
/// <param name="para">MkWeixinKeywords</param>
/// <param name="id">page index</param>
/// <param name="pageSize">page size</param>
/// <returns>list of MkWeixinKeywords</returns>
/// <remarks>2013-10-25 hw created</remarks>
public Dictionary <int, List <CBMkWeixinKeywords> > QueryKeyWords(ParaMkWeixinKeywords para, int id = 1,
int pageSize = 10)
{
return(IWeChatDao.Instance.QueryKeyWords(para, id, pageSize));
}
/// <summary> /// query 微信关键字列表 /// </summary> /// <param name="para">MkWeixinKeywords</param> /// <param name="id">page index</param> /// <param name="pageSize">page size</param> /// <returns>list of MkWeixinKeywords</returns> /// <remarks>2013-10-25 hw created</remarks> public abstract Dictionary <int, List <CBMkWeixinKeywords> > QueryKeyWords(ParaMkWeixinKeywords para, int id = 1, int pageSize = 10);
