using System; using System.Collections.Generic; using System.Linq; using System.Data; using Microsoft.AspNetCore.Mvc; using Microsoft.AspNetCore.Http; using Microsoft.Extensions.Logging; using Microsoft.Extensions.Options; using Microsoft.AspNetCore.Authorization; using MySystem.MainModels; using LitJson; using Library; using System.Security.Cryptography; using System.Text; namespace MySystem.Areas.Api.Controllers.v1 { [Area("Api")] [Route("/v1/QrCodePlateMain/[controller]/[action]")] public class ConsumerOrdersController : ConsumersController { public ConsumerOrdersController(IHttpContextAccessor accessor, ILogger logger, IOptions setting) : base(accessor, logger, setting) { } #region 我的-我的订单-列表 [Authorize] public JsonResult List(string value) { value = DesDecrypt(value); JsonData data = JsonMapper.ToObject(value); Dictionary Other = new Dictionary(); List> dataList = ListDo(value, out Other); return Json(new AppResultJson() { Status = "1", Info = "", Data = dataList, Other = Other }); } private List> ListDo(string value, out Dictionary Other) // public List> ListDo(string value) { JsonData data = JsonMapper.ToObject(value); int ConsumerId = int.Parse(function.CheckInt(data["ConsumerId"].ToString())); //用户Id string OpenId = data["OpenId"].ToString(); //用户OpenId int Kind = int.Parse(function.CheckInt(data["Kind"].ToString())); //类型(1 支付宝 2 微信) int pageSize = int.Parse(function.CheckInt(data["page_size"].ToString())); int pageNum = int.Parse(function.CheckInt(data["page_num"].ToString())); string condition = " WHERE 1=1 ORDER BY UpdateDate DESC"; string limitString = " LIMIT " + pageSize; if (pageNum > 1) { int skipNum = pageSize * (pageNum - 1); limitString = " LIMIT " + skipNum + "," + pageSize; } condition += limitString; List> dataList = new List>(); // DataTable dt = CustomerSqlConn.dtable("SELECT * FROM(SELECT a.*,b.CertMerchantName FROM(SELECT Id,1 Kind,MerchantId,UpdateDate,OrderNo,ConsumerId,PayMoney,CurDivi,Status FROM QrCodePlateMainServer.ConsumerOrders WHERE ConsumerId IN(SELECT Id FROM QrCodePlateMainServer.Consumers WHERE Id='" + ConsumerId + "') AND Status>0 AND PayMode=" + Kind + ")a LEFT JOIN (SELECT Id,CertMerchantName FROM QrCodePlateMainServer.MerchantAddInfo WHERE Status=2 OR QueryCount=2)b ON a.MerchantId=b.Id UNION ALL SELECT a.*,b.CertMerchantName FROM (SELECT Id,2 Kind,MerchantId,UpdateDate,OrderNo,ConsumerId,PayMoney,CurDivi,Status FROM QrCodePlateMainServer2.ConsumerOrders WHERE ConsumerId IN(SELECT Id FROM QrCodePlateMainServer.Consumers WHERE Id='" + ConsumerId + "') AND Status>0 AND PayMode=" + Kind + ")a LEFT JOIN (SELECT Id,CertMerchantName FROM QrCodePlateMainServer2.MerchantAddInfo WHERE Status=2 OR QueryCount=2)b ON a.MerchantId=b.Id)aa" + condition, AppConfig.Base.SqlConnStr); DataTable dt = CustomerSqlConn.dtable("SELECT * FROM(SELECT a.*,b.CertMerchantName FROM(SELECT Id,1 Kind,MerchantId,UpdateDate,OrderNo,ConsumerId,PayMoney,CurDivi,Status FROM QrCodePlateMainServer.ConsumerOrders WHERE ConsumerId IN(SELECT Id FROM QrCodePlateMainServer.Consumers WHERE WechatOpenId='" + OpenId + "') AND Status>0 AND PayMode=" + Kind + ")a LEFT JOIN (SELECT Id,CertMerchantName FROM QrCodePlateMainServer.MerchantAddInfo WHERE Status=2 OR QueryCount=2)b ON a.MerchantId=b.Id UNION ALL SELECT a.*,b.CertMerchantName FROM (SELECT Id,2 Kind,MerchantId,UpdateDate,OrderNo,ConsumerId,PayMoney,CurDivi,Status FROM QrCodePlateMainServer2.ConsumerOrders WHERE ConsumerId IN(SELECT Id FROM QrCodePlateMainServer2.Consumers WHERE WechatOpenId='" + OpenId + "') AND Status>0 AND PayMode=" + Kind + ")a LEFT JOIN (SELECT Id,CertMerchantName FROM QrCodePlateMainServer2.MerchantAddInfo WHERE Status=2 OR QueryCount=2)b ON a.MerchantId=b.Id)aa" + condition, AppConfig.Base.SqlConnStr); foreach (DataRow dr in dt.Rows) { Dictionary curData = new Dictionary(); curData.Add("Id", int.Parse(dr["Id"].ToString())); //Id curData.Add("Kind", int.Parse(dr["Kind"].ToString())); //商户类型(1 直连 2 银联) curData.Add("OrderNo", dr["OrderNo"].ToString()); //订单号 curData.Add("PayMoney", decimal.Parse(dr["PayMoney"].ToString())); //支付金额 curData.Add("ReturnMoney", decimal.Parse(dr["CurDivi"].ToString())); //已返金额 curData.Add("Status", int.Parse(dr["Status"].ToString())); //状态 curData.Add("CreateDate", DateTime.Parse(dr["UpdateDate"].ToString()).ToString("yyyy-MM-dd HH:mm:ss")); //创建时间 curData.Add("MerchantName", dr["CertMerchantName"].ToString()); //商户名称 dataList.Add(curData); } Other = new Dictionary(); Other.Add("count", dt.Rows.Count); return dataList; } #endregion } }