MemberCenter/Member/MemberWeb/Controllers/mem_orderController.cs

using System;
using System.Collections.Generic;
using System.Data.SqlClient;
using System.Linq;
using System.Threading.Tasks;
using CoreEntity.DAL;
using CoreEntity.Entity;
using CoreEntity.ESEntity;
using JCSoft.WX.Framework.Api;
using Microsoft.AspNetCore.Mvc;
using Microsoft.Extensions.Caching.Memory;
using Newtonsoft.Json;
using PublicLibrary.Model;
using SupplierWeb.Commonss;

namespace SupplierWeb.Controllers
{
    [Route("web/mem_order")]
    public class mem_OrderController : BaseController
    {

        public mem_OrderController(IMemoryCache cache, IApiClient client) : base(cache, client)
        {

        }
        public IActionResult Index()
        {
            return View();
        }

        /// <summary>
        /// 会员中心列表
        /// </summary>
        /// <param name="data"></param>
        /// <param name="filters"></param>
        /// <returns></returns>
        [HttpPost]
        [Route("OrderByCode")]
        public ActionResult OrderByCode([FromBody]dynamic data, QueryFilter[] filters)
        {
            int start = 0;
            string OrdersCode = "";
            if (data != null)
            {
                OrdersCode = data.query[0];
                data = new { query = "select * from  mem_order where OrdersCode = '"+ OrdersCode + "'" };
            }
            //将参数转换成JSON数据
            var json = JsonConvert.SerializeObject(data);
            //通过传来的SQL语句，转换成DSL语句
            string sql = Util.ElasticQuery("_sql/translate?format=json", "POST", json);
            string from = "\"from\":" + start + ",";
            sql = sql.Insert(1, from);
            //通过转换的DSL语句，获取数据
            var str = Util.ElasticQuery("mem_order/_search?format=json", "POST", sql);
            //JSON转Root对象
            //Root stobj = FromJSON<Root>(str);
            Root<_source> stobj = EsCommon.FromJSON<Root<_source>>(str);
            //将Root对象中的子对象取出来
            List<_source> _source = new List<_source>();

            IList<Mem_Terminaldoc> terms = TerminalDAL.getTerms();
            IList<Mem_Payplatform> payterms = PayPlatFormDAL.getPayTerms();
            IList<Mem_DataDictory> SourcePlatForms = Mem_DataDictoryDAL.getDatas(" and parentid= '783' ");

            Dictionary<string, string> temsMap = new Dictionary<string, string>(terms.Count);
            Dictionary<string, string> payTermsMap = new Dictionary<string, string>(payterms.Count);
            Dictionary<string, string> sourcePlatFormsMap = new Dictionary<string, string>(SourcePlatForms.Count);

            foreach (var term in terms)
            {
                var label = term.TerminalName;
                var value = term.TerminalCode.ToString();
                temsMap.Add(value, label);
            }
            foreach (var term in payterms)
            {
                var label = term.PayPlatFormName;
                var value = term.PayPlatFormCode;
                payTermsMap.Add(value, label);
            }
            foreach (var term in SourcePlatForms)
            {
                var label = term.Text;
                var value = term.Value;
                sourcePlatFormsMap.Add(value, label);
            }

            //给filed额外的属性赋值
            stobj.hits.hits.ForEach(x =>
            {
                x._source._id = x._id;
                x.fields.OriginType[0] = x.fields.OriginType[0] != 0 ?
                temsMap[x.fields.OriginType[0].ToString()] : "";

                x.fields.InitSum[0] = x.fields.InitSum[0] > 0 ?
                x.fields.InitSum[0] / 100 : 0;
                x.fields.OrderStatus[0] = x.fields.OrderStatus[0].ToString();

                x.fields.PaymentType[0] = x.fields.PaymentType[0] != 0 ?
                payTermsMap[x.fields.PaymentType[0].ToString()] : "";

                x.fields.SourcePlatforms[0] = x.fields.SourcePlatforms[0] != 0 ?
                sourcePlatFormsMap[x.fields.SourcePlatforms[0].ToString()] : "";


                x.fields.Sum[0] = x.fields.Sum[0] > 0 ?
                x.fields.Sum[0] / 100 : 0;
            });
            //_source = stobj.hits.hits.Select(x => x._source).ToList();
            _source = stobj.hits.hits.Select(x => x.entity()).ToList();

            foreach (var item in _source)
            {            
                string[] phones = new string[1];
                phones[0] = item.MemPhone;
                var phones1 = CommonDAL.getPhoneDecrypt(phones);
                string phoneStars = phones1[0];
                if (phoneStars != null && phoneStars.Length > 8)
                {
                    string replaced = phoneStars.Substring(3, 4);
                    phoneStars = phoneStars.Replace(replaced, "****");
                } 
                item.MemPhone = phoneStars; 
            }


            var jsonData = JsonConvert.SerializeObject(_source);
            return Json(
                new
                {
                    items = JsonConvert.DeserializeObject(jsonData),
                    success = true
                });

        }





        ///// <summary>
        ///// JSON转对象
        ///// </summary>
        ///// <typeparam name="T"></typeparam>
        ///// <param name="input"></param>
        ///// <returns></returns>
        //public static T FromJSON<T>(string input)
        //{
        //    try
        //    {
        //        return JsonConvert.DeserializeObject<T>(input);
        //    }
        //    catch (Exception ex)
        //    {
        //        string a = ex.Message;
        //        return default(T);
        //    }
        //}



        //#region
 
        //public class _shards
        //{
        //    /// <summary>
        //    /// 
        //    /// </summary>
        //    public int total { get; set; }
        //    /// <summary>
        //    /// 
        //    /// </summary>
        //    public int successful { get; set; }
        //    /// <summary>
        //    /// 
        //    /// </summary>
        //    public int skipped { get; set; }
        //    /// <summary>
        //    /// 
        //    /// </summary>
        //    public int failed { get; set; }
        //}

        //public class Total
        //{
        //    /// <summary>
        //    /// 
        //    /// </summary>
        //    public int value { get; set; }
        //    /// <summary>
        //    /// 
        //    /// </summary>
        //    public string relation { get; set; }
        //}

        public class _source
        {
            public string _id { get; set; }//id
            public string OriginType  { get; set; }//下单平台终端
            public string InitSum     { get; set; }//下单金额 
            public string OrderStatus { get; set; }//订单状态
            public string PaymentType { get; set; }//支付方式
            public string SourcePlatforms { get; set; }//下单平台
            /// <summary>
            /// 
            /// </summary>
            public DateTime? OrderTime { get; set; }
            /// <summary>
            /// 
            /// </summary>
            public DateTime? InventoryAuditDate { get; set; }
            /// <summary>
            /// 
            /// </summary>
            public DateTime? CreationDate { get; set; }
            /// <summary>
            /// 
            /// </summary>
            public string AccountId { get; set; }
            /// <summary>
            /// 
            /// </summary>
            public string Invoice { get; set; }
            /// <summary>
            /// 
            /// </summary>
            public string VerificationCode { get; set; }
            /// <summary>
            /// 
            /// </summary>
            public string RegionCode { get; set; }
            /// <summary>
            /// 
            /// </summary>
            public string OrderNotes { get; set; }
            /// <summary>
            /// 
            /// </summary>
            public string Sex { get; set; }
            /// <summary>
            /// 
            /// </summary>
            public string CustomerDataId { get; set; }
            /// <summary>
            /// 
            /// </summary>
            public string IsToERP { get; set; }
            /// <summary>
            /// 
            /// </summary>
            public string SubProductLine { get; set; }
            /// <summary>
            /// 吉林省吉林市磐石市河南街牛心综合楼一单元601室
            /// </summary>
            public string ADeliveryAddress { get; set; }
            /// <summary>
            /// 
            /// </summary>
            public DateTime? LastModified { get; set; }
            /// <summary>
            /// 
            /// </summary>
            public string MemPhone { get; set; }
            /// <summary>
            /// 赵海霞
            /// </summary>
            public string Consignee { get; set; }
            /// <summary>
            /// 
            /// </summary>
            public string ReceiverPhone { get; set; }
            /// <summary>
            /// 
            /// </summary>
            public string LeverNumber { get; set; }
            /// <summary>
            /// 
            /// </summary>
            public string AConsigneePhone1 { get; set; }
            /// <summary>
            /// 
            /// </summary>
            public string DeliveryZipCode { get; set; }
            /// <summary>
            /// 
            /// </summary>
            public string Height { get; set; }
            /// <summary>
            /// 
            /// </summary>
            public string AConsigneePhone2 { get; set; }
            /// <summary>
            /// 
            /// </summary>
            public string CustomerName { get; set; }
            /// <summary>
            /// 
            /// </summary>
            public string ProductLine { get; set; }
            /// <summary>
            /// 
            /// </summary>
            public string BusinessId { get; set; }
            /// <summary>
            /// 
            /// </summary>
            public string InvoiceContent { get; set; }
            /// <summary>
            /// 
            /// </summary>
            public string ConfirmId { get; set; }
            /// <summary>
            /// 
            /// </summary>
            public string CashCouponCode { get; set; }
            /// <summary>
            /// 
            /// </summary>
            public string ShippingNo { get; set; }
            /// <summary>
            /// 
            /// </summary>
            public string DiseaseClassCode { get; set; }
            /// <summary>
            /// 
            /// </summary>
            public string AuditorId { get; set; }
            /// <summary>
            /// 
            /// </summary>
            public string ReceivingTime { get; set; }
            /// <summary>
            /// 
            /// </summary>
            public string CustomerCode { get; set; }
            /// <summary>
            /// 
            /// </summary>
            public string SyncStatus { get; set; }
            /// <summary>
            /// 
            /// </summary>
            public string InvoiceNo { get; set; }
            /// <summary>
            /// 
            /// </summary>
            public string DeptId { get; set; }
            /// <summary>
            /// 
            /// </summary>
            public string Weight { get; set; }
            /// <summary>
            /// 
            /// </summary>
            public DateTime? ShippingTime { get; set; }
            /// <summary>
            /// 
            /// </summary>
            public DateTime? AllocationTime { get; set; }
            /// <summary>
            /// 
            /// </summary>
            public string OtherNote { get; set; }
            /// <summary>
            /// 
            /// </summary>
            public string OrderProcessDate { get; set; }
            /// <summary>
            /// 
            /// </summary>
            public string MerchantNote { get; set; }
            /// <summary>
            /// 
            /// </summary>
            public string OperateID { get; set; }
            /// <summary>
            /// 
            /// </summary>
            public string DeptCode { get; set; }
            /// <summary>
            /// 
            /// </summary>
            public string OrdersCode { get; set; }
            /// <summary>
            /// 
            /// </summary>
            public string BuyUserId { get; set; }
            /// <summary>
            /// 
            /// </summary>
            public string AccountName { get; set; }
        }

        public class Fields
        {
            /// <summary>
            /// 
            /// </summary>
            public List<string> IsPayByCard { get; set; }
            /// <summary>
            /// 
            /// </summary>
            public List<int> IntegralValue { get; set; }
            /// <summary>
            /// 
            /// </summary>
            public List<string> IsDrug { get; set; }
            /// <summary>
            /// 
            /// </summary>
            public List<int> HealthPrice { get; set; }
            /// <summary>
            /// 
            /// </summary>
            public List<int> WarehouseCode { get; set; }
            /// <summary>
            /// 
            /// </summary>
            public List<string> IsNeedReceipt { get; set; }
            /// <summary>
            /// 
            /// </summary>
            public List<string> AllocationFlag { get; set; }
            /// <summary>
            /// 
            /// </summary>
            public List<int> TransportCosts { get; set; }
            /// <summary>
            /// 
            /// </summary>
            public List<string> BonusDate { get; set; }
            /// <summary>
            /// 
            /// </summary>
            public List<int> DeliveryType { get; set; }
            /// <summary>
            /// 
            /// </summary>
            public List<int> InitSum { get; set; }
            /// <summary>
            /// 
            /// </summary>
            public List<int> OriginType { get; set; }
            /// <summary>
            /// 
            /// </summary>
            public List<int> CouponValue { get; set; }
            /// <summary>
            /// 
            /// </summary>
            public List<int> Discountprice { get; set; }
            /// <summary>
            /// 
            /// </summary>
            public List<string> IsEmailmark { get; set; }
            /// <summary>
            /// 
            /// </summary>
            public List<int> Sum { get; set; }
            /// <summary>
            /// 
            /// </summary>
            public List<int> OrdersType { get; set; }
            /// <summary>
            /// 
            /// </summary>
            public List<int> DeviceType { get; set; }
            /// <summary>
            /// 
            /// </summary>
            public List<int> AdvanceSum { get; set; }
            /// <summary>
            /// 
            /// </summary>
            public List<int> InvoiceSum { get; set; }
            /// <summary>
            /// 
            /// </summary>
            public List<string> IsRxDrug { get; set; }
            /// <summary>
            /// 
            /// </summary>
            public List<string> Ispayment { get; set; }
            /// <summary>
            /// 
            /// </summary>
            public List<int> ProductCost { get; set; }
            /// <summary>
            /// 
            /// </summary>
            public List<string> IsNewOrder { get; set; }
            /// <summary>
            /// 
            /// </summary>
            public List<string> IsDealWith { get; set; }
            /// <summary>
            /// 
            /// </summary>
            public List<int> ErrorCount { get; set; }
            /// <summary>
            /// 
            /// </summary>
            public List<int> MemKey { get; set; }
            /// <summary>
            /// 
            /// </summary>
            public List<string> IsReturn { get; set; }
            /// <summary>
            /// 
            /// </summary>
            public List<string> IsReward { get; set; }
            /// <summary>
            /// 
            /// </summary>
            public List<int> HuaWuOriginType { get; set; }
            /// <summary>
            /// 
            /// </summary>
            public List<int> OrderStatus { get; set; }
            /// <summary>
            /// 
            /// </summary>
            public List<int> AgainOrderCount { get; set; }
            /// <summary>
            /// 
            /// </summary>
            public List<string> IsO2O { get; set; }
            /// <summary>
            /// 
            /// </summary>
            public List<string> IsAutomaticSigned { get; set; }
            /// <summary>
            /// 
            /// </summary>
            public List<int> PaymentType { get; set; }
            /// <summary>
            /// 
            /// </summary>
            public List<string> PreferentialRate { get; set; }
            /// <summary>
            /// 
            /// </summary>
            public List<string> Age { get; set; }
            /// <summary>
            /// 
            /// </summary>
            public List<int> InvoiceContentType { get; set; }
            /// <summary>
            /// 
            /// </summary>
            public List<int> OrdersIntegral { get; set; }
            /// <summary>
            /// 
            /// </summary>
            public List<int> ConfimLevel { get; set; }
            /// <summary>
            /// 
            /// </summary>
            public List<int> ConsigneeType { get; set; }
            /// <summary>
            /// 
            /// </summary>
            public List<int> AdvancePayType { get; set; }
            /// <summary>
            /// 
            /// </summary>
            public List<int> CouponCode { get; set; }
            /// <summary>
            /// 
            /// </summary>
            public List<int> CashCouponValue { get; set; }
            /// <summary>
            /// 
            /// </summary>
            public List<int> Reducing { get; set; }
            /// <summary>
            /// 
            /// </summary>
            public List<string> IsVisible { get; set; }
            /// <summary>
            /// 
            /// </summary>
            public List<int> SourcePlatforms { get; set; }
        }

        //public class HitsItem
        //{
        //    /// <summary>
        //    /// 
        //    /// </summary>
        //    public string _index { get; set; }
        //    /// <summary>
        //    /// 
        //    /// </summary>
        //    public string _type { get; set; }
        //    /// <summary>
        //    /// 
        //    /// </summary>
        //    public string _id { get; set; }
        //    /// <summary>
        //    /// 
        //    /// </summary>
        //    public string _score { get; set; }
        //    /// <summary>
        //    /// 
        //    /// </summary>
        //    public string _routing { get; set; }
        //    /// <summary>
        //    /// 
        //    /// </summary>
        //    public _source _source { get; set; }
        //    /// <summary>
        //    /// 
        //    /// </summary>
        //    public Fields fields { get; set; }
        //    /// <summary>
        //    /// 
        //    /// </summary>
        //    public List<int> sort { get; set; }
        //}

        //public class Hits
        //{
        //    /// <summary>
        //    /// 
        //    /// </summary>
        //    public Total total { get; set; }
        //    /// <summary>
        //    /// 
        //    /// </summary>
        //    public string max_score { get; set; }
        //    /// <summary>
        //    /// 
        //    /// </summary>
        //    public List<HitsItem> hits { get; set; }
        //}

        //public class Root
        //{
        //    /// <summary>
        //    /// 
        //    /// </summary>
        //    public int took { get; set; }
        //    /// <summary>
        //    /// 
        //    /// </summary>
        //    public string timed_out { get; set; }
        //    /// <summary>
        //    /// 
        //    /// </summary>
        //    public _shards _shards { get; set; }
        //    /// <summary>
        //    /// 
        //    /// </summary>
        //    public Hits hits { get; set; }
        //}
        //#endregion
    }
}