public ActionResult GetSentOrders(jf_lpOrderSearch condition)
{
string where = string.Empty;
//订单号
if (!string.IsNullOrWhiteSpace(condition.OrderNo))
{
where += " and OrderNo like '%" + Common.Filter(condition.OrderNo) + "%' ";
}
if (!string.IsNullOrWhiteSpace(condition.keyword))
{
where += string.Format(@" and (jf_lpOrder.OrderNo like '%{0}%' or jf_lpOrder.OrderName like '%{0}%'
or OrderMan like '%{0}%' or OrderMobile like '%{0}%'
or [Address] like '%{0}%' or [PostName] like '%{0}%' or [PostNo] like '%{0}%') ", condition.keyword);
}
PageJsonModel <jf_lpOrderShowVM> page = new PageJsonModel <jf_lpOrderShowVM>();
page.pageIndex = condition.pageIndex;
page.pageSize = condition.pageSize;
page.strForm = " jf_lpOrder left join j_OrderPost on j_OrderPost.OrderNo=jf_lpOrder.OrderNo ";
page.strSelect = @" jf_lpOrder.*,
ISNULL(j_OrderPost.PostName,'') PostName,ISNULL(j_OrderPost.PostNo,'') PostNo,ISNULL(j_OrderPost.Dat,0) PostDat ";
page.strWhere = " and j_OrderPost.PostNo is not null " + where;
page.strOrder = " j_OrderPost.Dat Desc";
page.LoadList();
return(Json(page.pageResponse, JsonRequestBehavior.AllowGet));
}
public ActionResult GetNoSendOrders(jf_lpOrderSearch condition)
{
string where = string.Empty;
//订单号
if (!string.IsNullOrWhiteSpace(condition.OrderNo))
{
where += " and OrderNo like '%" + Common.Filter(condition.OrderNo) + "%' ";
}
if (!string.IsNullOrWhiteSpace(condition.keyword))
{
where += string.Format(" and (OrderNo like '%{0}%' or OrderName like '%{0}%' or OrderMan like '%{0}%' or OrderMobile like '%{0}%' or [Address] like '%{0}%') ", condition.keyword);
}
where += string.Format(" and OrderState='待发货' and PayState='已支付' and AuditState='已审核'");
PageJsonModel <jf_lpOrderShowVM> page = new PageJsonModel <jf_lpOrderShowVM>();
page.pageIndex = condition.pageIndex;
page.pageSize = condition.pageSize;
page.strForm = " jf_lpOrder ";
page.strSelect = @" * ";
page.strWhere = where;
page.strOrder = " DatPay Asc";
page.LoadList();
return(Json(page.pageResponse, JsonRequestBehavior.AllowGet));
}
public ActionResult ExportExcel(jf_lpOrderSearch condition)
{
StringBuilder where = new StringBuilder();
where.Append("select OrderNo,OrderName,SumIntegral,OrderMan,OrderMobile,Remark from [jf_lpOrder] where 1=1 ");
where.Append(jf_lpOrderSearch.StrWhere(condition));
DataTable dt = ExportWay.ExcelDataTable(where.ToString());
string[] list = { "订单单号", "订单名称", "总积分", "收货人", "电话", "备注" };
return(File(ExportWay.GetExcel(dt, list), "application/vnd.ms-excel", "订单" + DateTime.Now.ToShortTimeString() + ".xls"));
}
public ActionResult GetOrders(jf_lpOrderSearch condition)
{
string where = jf_lpOrderSearch.StrWhere(condition);
PageJsonModel <jf_lpOrder> page = new PageJsonModel <jf_lpOrder>();
page.pageIndex = condition.pageIndex;
page.strForm = " jf_lpOrder ";
page.strSelect = " * ";
page.pageSize = condition.pageSize;
page.strWhere = where;
page.strOrder = " ID Desc";
page.LoadList();
return(Json(page.pageResponse, JsonRequestBehavior.AllowGet));
}
