ConsumerOrdersController.cs 5.3 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677
  1. using System;
  2. using System.Collections.Generic;
  3. using System.Linq;
  4. using System.Data;
  5. using Microsoft.AspNetCore.Mvc;
  6. using Microsoft.AspNetCore.Http;
  7. using Microsoft.Extensions.Logging;
  8. using Microsoft.Extensions.Options;
  9. using Microsoft.AspNetCore.Authorization;
  10. using MySystem.MainModels;
  11. using LitJson;
  12. using Library;
  13. using System.Security.Cryptography;
  14. using System.Text;
  15. namespace MySystem.Areas.Api.Controllers.v1
  16. {
  17. [Area("Api")]
  18. [Route("/v1/QrCodePlateMain/[controller]/[action]")]
  19. public class ConsumerOrdersController : ConsumersController
  20. {
  21. public ConsumerOrdersController(IHttpContextAccessor accessor, ILogger<BaseController> logger, IOptions<Setting> setting) : base(accessor, logger, setting)
  22. {
  23. }
  24. #region 我的-我的订单-列表
  25. [Authorize]
  26. public JsonResult List(string value)
  27. {
  28. value = DesDecrypt(value);
  29. JsonData data = JsonMapper.ToObject(value);
  30. Dictionary<string, object> Other = new Dictionary<string, object>();
  31. List<Dictionary<string, object>> dataList = ListDo(value, out Other);
  32. return Json(new AppResultJson() { Status = "1", Info = "", Data = dataList, Other = Other });
  33. }
  34. private List<Dictionary<string, object>> ListDo(string value, out Dictionary<string, object> Other)
  35. // public List<Dictionary<string, object>> ListDo(string value)
  36. {
  37. JsonData data = JsonMapper.ToObject(value);
  38. int ConsumerId = int.Parse(function.CheckInt(data["ConsumerId"].ToString())); //用户Id
  39. int Kind = int.Parse(function.CheckInt(data["Kind"].ToString())); //类型(1 支付宝 2 微信)
  40. int pageSize = int.Parse(function.CheckInt(data["page_size"].ToString()));
  41. int pageNum = int.Parse(function.CheckInt(data["page_num"].ToString()));
  42. string condition = " WHERE 1=1";
  43. string limitString = " LIMIT " + pageSize;
  44. if (pageNum > 1)
  45. {
  46. int skipNum = pageSize * (pageNum - 1);
  47. limitString = " LIMIT " + skipNum + "," + pageSize;
  48. }
  49. condition += limitString;
  50. List<Dictionary<string, object>> dataList = new List<Dictionary<string, object>>();
  51. var aa = "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;
  52. 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);
  53. foreach (DataRow dr in dt.Rows)
  54. {
  55. Dictionary<string, object> curData = new Dictionary<string, object>();
  56. curData.Add("Id", int.Parse(dr["Id"].ToString())); //Id
  57. curData.Add("Kind", int.Parse(dr["Kind"].ToString())); //商户类型(1 直连 2 银联)
  58. curData.Add("OrderNo", dr["OrderNo"].ToString()); //订单号
  59. curData.Add("PayMoney", decimal.Parse(dr["PayMoney"].ToString())); //支付金额
  60. curData.Add("ReturnMoney", decimal.Parse(dr["CurDivi"].ToString())); //已返金额
  61. curData.Add("Status", int.Parse(dr["Status"].ToString())); //状态
  62. curData.Add("CreateDate", DateTime.Parse(dr["UpdateDate"].ToString()).ToString("yyyy-MM-dd HH:mm:ss")); //创建时间
  63. curData.Add("MerchantName", dr["CertMerchantName"].ToString()); //商户名称
  64. dataList.Add(curData);
  65. }
  66. Other = new Dictionary<string, object>();
  67. Other.Add("count", dt.Rows.Count);
  68. return dataList;
  69. }
  70. #endregion
  71. }
  72. }