public ActionResult GetUserPages2(C_WxUserShowVM.Condition condition)
{
string where = StrWhere(condition);
PageJsonModel <C_WxUserShowVM> page = new PageJsonModel <C_WxUserShowVM>();
page.pageIndex = condition.pageIndex;
page.pageSize = condition.pageSize;
page.strForm = @"(select a.ID,a.UserName,a.IsValid,a.NickName,a.Mobile,a.Grade,a.TrueName,
a.WxNo,a.DatRegister,a.Email,a.PortraitUrl,wx.openid wx_openid,
wx.nickname wx_nickname,wx.sex wx_sex,wx.headimgurl wx_headimgurl,wx.remark wx_remark,
wx.groupid wx_groupid,wx.subscribe wx_subscribe,wx.subscribe_time wx_subscribe_time,
wx.country wx_country,wx.language wx_language
from C_WxUser as a left join C_UserWxInfo as wx on a.UserName=wx.C_UserName) as userwxvm";
page.strSelect = "*";
page.strWhere = where + " and Email<>''";
if (string.IsNullOrWhiteSpace(condition.orderby) == false)
{
page.strOrder = Common.FilteSQLStr(condition.orderby);
}
else
{
page.strOrder = "ID desc";
}
page.LoadList();
return(Json(page.pageResponse, JsonRequestBehavior.AllowGet));
}
/// <summary>
/// 导出
/// </summary>
/// <returns></returns>
public FileResult ExportExcel(C_WxUserShowVM.Condition condition)
{
StringBuilder where = new StringBuilder();
where.Append("select UserName,NickName,TrueName,Mobile from [C_WxUser] where 1=1 ");
where.Append(StrWhere(condition));
DataTable dt = ExportWay.ExcelDataTable(where.ToString());
string[] list = { "用户账号", "昵称", "姓名", "电话" };
return(File(ExportWay.GetExcel(dt, list), "application/vnd.ms-excel", "客户" + DateTime.Now.ToShortTimeString() + ".xls"));
}
private string StrWhere(C_WxUserShowVM.Condition condition)
{
string where = string.Empty;
//客户ID
if (!string.IsNullOrWhiteSpace(condition.UserName))
{
where += " and UserName like '%" + Common.Filter(condition.UserName) + "%' ";
}
//微信关注状态
if (!string.IsNullOrWhiteSpace(condition.wx_subscribeStat))
{
if (condition.wx_subscribeStat == "1")
{
where += " and wx_subscribe=1 ";
}
else if (condition.wx_subscribeStat == "0")
{
where += " and (wx_subscribe is null or wx_subscribe=0) ";
}
}
//客户微信昵称
if (!string.IsNullOrWhiteSpace(condition.wx_nickname))
{
condition.wx_nickname = Common.Filter(condition.wx_nickname);
where += " and (wx_nickname like '%" + condition.wx_nickname + "%' or NickName like '%" + condition.wx_nickname + "%') ";
}
//关键字搜索
if (!string.IsNullOrWhiteSpace(condition.keyword))
{
condition.keyword = Common.Filter(condition.keyword);
where += string.Format(@" and (wx_nickname like '%{0}%' or NickName like '%{0}%' or UserName like '%{0}%') ", condition.keyword);
}
if (!string.IsNullOrWhiteSpace(condition.DatCreateB))
{
where += string.Format(" and wx_subscribe_time >='{0} 00:00:00' ", Common.Filter(condition.DatCreateB));
}
if (!string.IsNullOrWhiteSpace(condition.DatCreateE))
{
where += string.Format(" and wx_subscribe_time <'{0} 23:59:59' ", Common.Filter(condition.DatCreateE));
}
return(where);
}
