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)); }