/// <summary> /// 订单列表 /// </summary> /// <returns></returns> public ActionResult OrderList() { #region 获取信息 JMP.BLL.jmp_paymode paymodebll = new JMP.BLL.jmp_paymode(); List <JMP.MDL.jmp_paymode> paymodeList = paymodebll.GetModelList("1=1 and p_state='1' ");//支付类型 ViewBag.paymodeList = paymodeList; #endregion #region 查询 int pageIndexs = string.IsNullOrEmpty(Request["pageIndexs"]) ? 1 : Int32.Parse(Request["pageIndexs"]); //当前页 int PageSize = string.IsNullOrEmpty(Request["PageSize"]) ? 20 : Int32.Parse(Request["PageSize"]); //每页显示数量 int searchType = string.IsNullOrEmpty(Request["searchType"]) ? 0 : Int32.Parse(Request["searchType"]); //查询条件选择 string searchname = string.IsNullOrEmpty(Request["searchname"]) ? "" : Request["searchname"]; //查询类容 string stime = string.IsNullOrEmpty(Request["stime"]) ? DateTime.Now.ToString("yyyy-MM-dd") : Request["stime"]; //开始时间 string etime = string.IsNullOrEmpty(Request["etime"]) ? DateTime.Now.ToString("yyyy-MM-dd") : Request["etime"]; //结束时间 int paymode = string.IsNullOrEmpty(Request["paymode"]) ? 0 : Int32.Parse(Request["paymode"]); //支付类型 string paymentstate = string.IsNullOrEmpty(Request["paymentstate"]) ? "1" : Request["paymentstate"]; //支付状态 string noticestate = string.IsNullOrEmpty(Request["noticestate"]) ? "" : Request["noticestate"]; //通知状态 int relationtype = string.IsNullOrEmpty(Request["relationtype"]) ? 0 : Int32.Parse(Request["relationtype"]); //商户类型 int userid = UserInfo.UserId; var list = _OrderService.FindPagedListByBP(userid, relationtype, "", searchType, searchname, stime, etime, paymode, paymentstate, noticestate, null, pageIndexs, PageSize); var gridModel = new DataSource <jmp_order>(list) { Data = list.Select(x => x).ToList() }; ViewBag.searchname = searchname; ViewBag.searchType = searchType; ViewBag.stime = stime; ViewBag.etime = etime; ViewBag.relationtype = relationtype; ViewBag.paymode = paymode; ViewBag.paymentstate = paymentstate; ViewBag.noticestate = noticestate; ViewBag.pageIndexs = pageIndexs; ViewBag.PageSize = PageSize; ViewBag.list = gridModel.Data; ViewBag.pageCount = gridModel.Pagination.TotalCount; #endregion return(View()); }
public ActionResult OrderList() { #region 获取信息 JMP.BLL.jmp_paymode paymodebll = new JMP.BLL.jmp_paymode(); List <JMP.MDL.jmp_paymode> paymodeList = paymodebll.GetModelList("1=1 and p_state='1' ");//支付类型 ViewBag.paymodeList = paymodeList; #endregion #region 查询 string sql = ""; string sql1 = ""; //组装查询条件 string TableName = ""; //表名 string order = "o_ptime "; //排序字段 int pageCount = 0; int pageIndexs = string.IsNullOrEmpty(Request["pageIndexs"]) ? 1 : Int32.Parse(Request["pageIndexs"]); //当前页 int PageSize = string.IsNullOrEmpty(Request["PageSize"]) ? 20 : Int32.Parse(Request["PageSize"]); //每页显示数量 int searchType = string.IsNullOrEmpty(Request["searchType"]) ? 0 : Int32.Parse(Request["searchType"]); //查询条件选择 string searchname = string.IsNullOrEmpty(Request["searchname"]) ? "" : Request["searchname"]; //查询类容 string stime = string.IsNullOrEmpty(Request["stime"]) ? DateTime.Now.ToString("yyyy-MM-dd") : Request["stime"]; //开始时间 string etime = string.IsNullOrEmpty(Request["etime"]) ? DateTime.Now.ToString("yyyy-MM-dd") : Request["etime"]; //结束时间 int paymode = string.IsNullOrEmpty(Request["paymode"]) ? 0 : Int32.Parse(Request["paymode"]); //支付类型 string paymentstate = string.IsNullOrEmpty(Request["paymentstate"]) ? "1" : Request["paymentstate"]; //支付状态 string noticestate = string.IsNullOrEmpty(Request["noticestate"]) ? "" : Request["noticestate"]; //通知状态 int platformid = string.IsNullOrEmpty(Request["platformid"]) ? 0 : Int32.Parse(Request["platformid"]); //关联平台 int relationtype = string.IsNullOrEmpty(Request["relationtype"]) ? -1 : Int32.Parse(Request["relationtype"]); //商户类型 ViewBag.platformid = platformid; ArrayList sjfw = JMP.TOOL.WeekDateTime.WeekMonday(DateTime.Parse(stime), DateTime.Parse(etime));//根据时间返回获取每周周一组装查询语句 for (int i = 0; i < sjfw.Count; i++) { TableName = "jmp_order_" + DateTime.Parse(sjfw[i].ToString()).ToString("yyyyMMdd"); // TableName = "jmp_order_20161107"; sql += " SELECT o_id,o_code,o_bizcode,o_tradeno,o_paymode_id,o_app_id,o_goodsname,o_term_key,o_price,o_payuser,o_ctime,o_ptime,o_state,o_times,o_address,o_noticestate,o_noticetimes,o_privateinfo,o_interface_id, o_showaddress FROM " + TableName + " where 1=1 "; if (!string.IsNullOrEmpty(stime) && !string.IsNullOrEmpty(etime)) { sql += " and convert(varchar(10),o_ptime,120)>='" + stime + "' and convert(varchar(10),o_ptime,120)<='" + etime + "' "; } if (paymode > 0) { sql += " and o_paymode_id='" + paymode + "' "; } if (!string.IsNullOrEmpty(paymentstate)) { sql += " and o_state='" + paymentstate + "' "; } if (!string.IsNullOrEmpty(noticestate)) { sql += " and o_noticestate='" + noticestate + "' "; } sql += " UNION ALL "; } string where = "where 1=1";//组装查询条件 if (searchType > 0 && !string.IsNullOrEmpty(searchname)) { switch (searchType) { case 1: where += " and a.o_code='" + searchname + "' "; break; case 2: where += " and b.a_name='" + searchname + "' "; break; case 3: where += " and a.o_goodsname='" + searchname + "' "; break; case 4: where += " and e.u_realname like '%" + searchname + "%' "; break; case 5: where += " and a.o_tradeno= '" + searchname + "' "; break; case 6: where += " and a.o_bizcode= '" + searchname + "' "; break; case 7: where += " and inn.l_corporatename like '%" + searchname + "%' "; break; } } if (platformid > 0) { where += " and b.a_platform_id=" + platformid; } if (relationtype > -1) { where += " and e.relation_type=" + relationtype; } //组装时时表数据 sql1 = "SELECT o_id,o_code,o_bizcode,o_tradeno,o_paymode_id,o_app_id,o_goodsname,o_term_key,o_price,o_payuser,o_ctime,o_ptime,o_state,o_times,o_address,o_noticestate,o_noticetimes,o_privateinfo,o_interface_id, o_showaddress FROM jmp_order where 1=1"; if (!string.IsNullOrEmpty(stime) && !string.IsNullOrEmpty(etime)) { sql1 += " and convert(varchar(10),o_ptime,120)>='" + stime + "' and convert(varchar(10),o_ptime,120)<='" + etime + "' "; } if (paymode > 0) { sql1 += " and o_paymode_id='" + paymode + "' "; } if (!string.IsNullOrEmpty(paymentstate)) { sql1 += " and o_state='" + paymentstate + "' "; } if (!string.IsNullOrEmpty(noticestate)) { sql1 += " and o_noticestate='" + noticestate + "' "; } sql = sql + sql1; ViewBag.searchname = searchname; ViewBag.searchType = searchType; ViewBag.stime = stime; ViewBag.etime = etime; ViewBag.paymode = paymode; ViewBag.paymentstate = paymentstate; ViewBag.noticestate = noticestate; List <JMP.MDL.jmp_order> list = new List <JMP.MDL.jmp_order>(); JMP.BLL.jmp_order orderbll = new JMP.BLL.jmp_order(); list = orderbll.SelectPager(where, sql, order, pageIndexs, PageSize, out pageCount); ViewBag.pageIndexs = pageIndexs; ViewBag.PageSize = PageSize; ViewBag.pageCount = pageCount; ViewBag.list = list; ViewBag.relationtype = relationtype; #endregion return(View()); }
/// <summary> /// 订单列表 /// </summary> /// <returns></returns> public ActionResult OrderList() { #region 获取用户实名认证状态信息 JMP.BLL.jmp_user sm_bll = new JMP.BLL.jmp_user(); JMP.MDL.jmp_user sm_model = new JMP.MDL.jmp_user(); int u_ids = UserInfo.Uid; //查询登录信息 sm_model = sm_bll.GetModel(u_ids); ViewBag.auditstate = sm_model.u_auditstate; ViewBag.linkEmail = sm_model.u_email; #endregion #region 获取信息 JMP.BLL.jmp_paymode paymodebll = new JMP.BLL.jmp_paymode(); List <JMP.MDL.jmp_paymode> paymodeList = paymodebll.GetModelList("1=1 and p_state='1' ");//支付类型 ViewBag.paymodeList = paymodeList; #endregion #region 查询 //string sql = " select o_id,o_code,o_bizcode,o_tradeno,o_paymode_id,o_app_id,o_goods_id,o_term_key,o_price,o_payuser,o_ctime,o_ptime,o_state,o_times,o_address,o_noticestate,o_noticetimes,o_privateinfo,o_interface_id,o_showaddress,b.a_key,b.a_name,c.p_name,d.g_name from ( ";//组装查询条件 string sql = ""; string sql1 = ""; string TableName = ""; //表名 string order = "o_ptime"; //排序字段 int pageCount = 0; int pageIndexs = string.IsNullOrEmpty(Request["pageIndexs"]) ? 1 : Int32.Parse(Request["pageIndexs"]); //当前页 int PageSize = string.IsNullOrEmpty(Request["PageSize"]) ? 20 : Int32.Parse(Request["PageSize"]); //每页显示数量 int searchType = string.IsNullOrEmpty(Request["searchType"]) ? 0 : Int32.Parse(Request["searchType"]); //查询条件选择 string searchname = string.IsNullOrEmpty(Request["searchname"]) ? "" : Request["searchname"]; //查询类容 string stime = string.IsNullOrEmpty(Request["stime"]) ? DateTime.Now.ToString("yyyy-MM-dd") : Request["stime"]; //开始时间 string etime = string.IsNullOrEmpty(Request["etime"]) ? DateTime.Now.ToString("yyyy-MM-dd") : Request["etime"]; //结束时间 int paymode = string.IsNullOrEmpty(Request["paymode"]) ? 0 : Int32.Parse(Request["paymode"]); //支付类型 string paymentstate = string.IsNullOrEmpty(Request["paymentstate"]) ? "1" : Request["paymentstate"]; //支付状态 string noticestate = string.IsNullOrEmpty(Request["noticestate"]) ? "" : Request["noticestate"]; //通知状态 ArrayList sjfw = JMP.TOOL.WeekDateTime.WeekMonday(DateTime.Parse(stime), DateTime.Parse(etime)); //根据时间返回获取每周周一组装查询语句 string where = "where 1=1"; for (int i = 0; i < sjfw.Count; i++) { TableName = "jmp_order_" + DateTime.Parse(sjfw[i].ToString()).ToString("yyyyMMdd"); // TableName = "jmp_order_20161107"; sql += " SELECT o_id,o_code,o_bizcode,o_tradeno,o_paymode_id,o_app_id,o_goodsname,o_term_key,o_price,o_payuser,o_ctime,o_ptime,o_state,o_times,o_address,o_noticestate,o_noticetimes,o_privateinfo,o_interface_id,o_showaddress FROM " + TableName + " where 1=1 "; if (!string.IsNullOrEmpty(stime) && !string.IsNullOrEmpty(etime)) { sql += " and convert(varchar(10),o_ptime,120)>='" + stime + "' and convert(varchar(10),o_ptime,120)<='" + etime + "' "; } if (paymode > 0) { sql += " and o_paymode_id='" + paymode + "' "; } if (!string.IsNullOrEmpty(paymentstate)) { sql += " and o_state='" + paymentstate + "' "; } if (!string.IsNullOrEmpty(noticestate)) { sql += " and o_noticestate='" + noticestate + "' "; } sql += " UNION ALL "; } if (searchType > 0 && !string.IsNullOrEmpty(searchname)) { switch (searchType) { case 1: where += " and a.o_code='" + searchname + "' "; break; case 2: where += " and b.a_name='" + searchname + "' "; break; case 3: where += " and a.o_goodsname='" + searchname + "' "; break; case 4: where += " and a.o_tradeno= '" + searchname + "' "; break; case 5: where += " and a.o_bizcode like '%" + searchname + "%' "; break; } } where += "and b.a_user_id='" + UserInfo.UserId + "'"; //sql = sql.Remove(sql.Length - 10);//去掉最后一个UNION ALL //sql += " ) a left join jmp_app b on a.o_app_id=b.a_id left join jmp_paymode c on c.p_id=a.o_paymode_id left join jmp_goods d on d.g_id=a.o_goods_id and d.g_app_id=b.a_id and d.g_app_id=a.o_app_id where 1=1 and " + where; //组装时时表数据 sql1 = "SELECT o_id,o_code,o_bizcode,o_tradeno,o_paymode_id,o_app_id,o_goodsname,o_term_key,o_price,o_payuser,o_ctime,o_ptime,o_state,o_times,o_address,o_noticestate,o_noticetimes,o_privateinfo,o_interface_id, o_showaddress FROM jmp_order where 1=1"; if (!string.IsNullOrEmpty(stime) && !string.IsNullOrEmpty(etime)) { sql1 += " and convert(varchar(10),o_ptime,120)>='" + stime + "' and convert(varchar(10),o_ptime,120)<='" + etime + "' "; } if (paymode > 0) { sql1 += " and o_paymode_id='" + paymode + "' "; } if (!string.IsNullOrEmpty(paymentstate)) { sql1 += " and o_state='" + paymentstate + "' "; } if (!string.IsNullOrEmpty(noticestate)) { sql1 += " and o_noticestate='" + noticestate + "' "; } sql = sql + sql1; ViewBag.searchname = searchname; ViewBag.searchType = searchType; ViewBag.stime = stime; ViewBag.etime = etime; ViewBag.paymode = paymode; ViewBag.paymentstate = paymentstate; ViewBag.noticestate = noticestate; List <JMP.MDL.jmp_order> list = new List <JMP.MDL.jmp_order>(); JMP.BLL.jmp_order orderbll = new JMP.BLL.jmp_order(); list = orderbll.SelectPager(where, sql, order, pageIndexs, PageSize, out pageCount); ViewBag.pageIndexs = pageIndexs; ViewBag.PageSize = PageSize; ViewBag.pageCount = pageCount; ViewBag.list = list; #endregion return(View()); }