public ActionResult GoodsList(int pageIndex, jf_GoodsSearch condition)
{
string where = string.Empty;
if (condition != null)
{
if (!string.IsNullOrWhiteSpace(condition.keyword))
{
string keyword = Common.Filter(condition.keyword);
where += string.Format(" and GoodsName like '%{0}%'", keyword);
}
}
PageJsonModel <jf_Goods> page = new PageJsonModel <jf_Goods>();
page.pageIndex = pageIndex;
page.strForm = "jf_Goods";
page.strSelect = "*";
page.strWhere = " and PublishStat='已上架' " + where;
page.strOrder = " ID desc";
page.LoadListNoCnt();
if (page.pageResponse != null && page.pageResponse.RtnList != null && page.pageResponse.RtnList.Count > 0)
{
return(Json(page.pageResponse, JsonRequestBehavior.AllowGet));
}
return(Json("", JsonRequestBehavior.AllowGet));
}
public ActionResult GetMyAddresss(int pageIndex)
{
PageJsonModel <jf_UserMail> page = new PageJsonModel <jf_UserMail>();
page.pageIndex = pageIndex;
page.strForm = " jf_UserMail ";
page.strSelect = "*";
page.strWhere = string.Format(" and UserName='******'", CurrentUser.UserName);
page.strOrder = " IsDefault desc,ID desc";
page.LoadListNoCnt();
if (page.pageResponse != null && page.pageResponse.RtnList != null && page.pageResponse.RtnList.Count > 0)
{
return(Json(page.pageResponse, JsonRequestBehavior.AllowGet));
}
return(Json("", JsonRequestBehavior.AllowGet));
}
public ActionResult rank1(int pageIndex, int pageSize)
{
PageJsonModel <C_Consumer> page = new PageJsonModel <C_Consumer>();
page.pageIndex = 1;
page.pageSize = 10;
page.strForm = " C_Consumer left join C_UserWxInfo on C_Consumer.UserName=C_UserWxInfo.C_ConsumerUserName ";
page.strSelect = " C_Consumer.UserName,SUM(jf)as jf,C_UserWxInfo.headimgurl";
page.strWhere = " and C_Consumer.Type='促销员' group by C_Consumer.UserName,C_UserWxInfo.headimgurl ";
page.strOrder = " SUM(jf) desc";
page.LoadListNoCnt();
if (page.pageResponse != null && page.pageResponse.RtnList != null && page.pageResponse.RtnList.Count > 0)
{
return(Json(page.pageResponse, JsonRequestBehavior.AllowGet));
}
return(Json("", JsonRequestBehavior.AllowGet));
}
public ActionResult Getlingqurecord(int pageIndex)
{
PageJsonModel <j_jflog> page = new PageJsonModel <j_jflog>();
page.pageIndex = pageIndex;
page.strForm = "j_jflog";
page.strSelect = "*";
page.strWhere = string.Format(" and Type='领取' and UserName='******'", CurrentUser.UserName);
page.strOrder = " j_jflog.ID desc";
page.LoadListNoCnt();
if (page.pageResponse != null && page.pageResponse.RtnList != null && page.pageResponse.RtnList.Count > 0)
{
return(Json(page.pageResponse, JsonRequestBehavior.AllowGet));
}
return(Json("", JsonRequestBehavior.AllowGet));
}
//public ActionResult cha(string SN)
//{
// B_bd cnt = B_bd.cha(SN);
// if (cnt == null)
// {
// return Content("SN码不存在");
// }
// return Content("OK|"+cnt.phone);
//}
//产品维修列表
public ActionResult xiuList(C_UserAdvice condition, string dh)
{
PageJsonModel <C_UserAdvice> page = new PageJsonModel <C_UserAdvice>();
page.pageIndex = condition.pageIndex;
page.pageSize = condition.pageSize;
page.strForm = "C_UserAdvice";
page.strSelect = "*";
page.strWhere = " and Phone=" + dh + "";
page.strOrder = " ID desc";
page.LoadListNoCnt();
if (page.pageResponse != null && page.pageResponse.RtnList != null && page.pageResponse.RtnList.Count > 0)
{
return(Json(page.pageResponse, JsonRequestBehavior.AllowGet));
}
return(Json("", JsonRequestBehavior.AllowGet));
}
public ActionResult GetMyOrders(int pageIndex, string state)
{
PageJsonModel <jf_lpOrder> page = new PageJsonModel <jf_lpOrder>();
page.pageIndex = pageIndex;
page.strForm = "jf_lpOrder left join j_OrderPost on jf_lpOrder.OrderNo=j_OrderPost.orderNo";
page.strSelect = "jf_lpOrder.*,j_OrderPost.PostName,j_OrderPost.PostNo";
page.strWhere = string.Format(" and UserName='******'", CurrentUser.UserName);
page.strOrder = " jf_lpOrder.ID desc";
if (!string.IsNullOrWhiteSpace(state))
{
page.strWhere += string.Format(" and OrderState='{0}'", state);
}
page.LoadListNoCnt();
if (page.pageResponse != null && page.pageResponse.RtnList != null && page.pageResponse.RtnList.Count > 0)
{
return(Json(page.pageResponse, JsonRequestBehavior.AllowGet));
}
return(Json("", JsonRequestBehavior.AllowGet));
}
