using Newtonsoft.Json;
using Newtonsoft.Json.Linq;
using System;
using System.Collections;
using System.Collections.Generic;
using System.Data;
using System.Drawing;
using System.IO;
using System.IO.Ports;
using System.Linq;
using System.Net;
using System.Net.Sockets;
using System.Runtime.InteropServices;
using System.Security.Cryptography;
using System.Text;
using System.Windows;
using System.Windows.Controls;
using System.Windows.Data;
using System.Windows.Documents;
using System.Windows.Input;
using System.Windows.Media;
using System.Windows.Media.Imaging;
using System.Windows.Navigation;
using System.Windows.Shapes;
using ZXing;
using ZXing.Common;
using ZXing.QrCode;
using Lib = ESSupport.Lib;

namespace PosSystemConfig
{
    /// <summary>
    /// MainWindow.xaml 的交互逻辑
    /// </summary>
    public partial class MainWindow : Window
    {
        EncodingOptions options = null;
        BarcodeWriter writer = null;

        public MainWindow()
        {
            InitializeComponent();
        }
        /// <summary>
        /// 中文空白字符，用于替换空格
        /// </summary>
        private static string ChineseSpace = "　";

        /// <summary>
        /// 汉字转区位码方法
        /// </summary>
        /// <param name="character">汉字</param>
        /// <returns>区位码</returns>
        public static string ChineseToCoding(string character)
        {
            string coding = string.Empty;

            //空格处理（如不用可以注释）
            character = character.Replace(" ", ChineseSpace);

            try
            {
                for (int i = 0; i < character.Length; i++)
                {
                    byte[] bytes = Encoding.GetEncoding("GB2312").GetBytes(character.Substring(i, 1));
                    if (bytes.Length == 2)
                    {
                        string lowCode = System.Convert.ToString(bytes[0] - 160, 10);
                        if (lowCode.Length == 1)
                            lowCode = "0" + lowCode;
                        string hightCode = System.Convert.ToString(bytes[1] - 160, 10);
                        if (hightCode.Length == 1)
                            hightCode = "0" + hightCode;
                        coding += (lowCode + hightCode);
                    }
                    else
                    {
                        string lowCode = System.Convert.ToString(bytes[0], 16);
                        if (lowCode.Length == 1)
                            lowCode = "0" + lowCode;
                        coding += (lowCode);
                    }
                }
                return coding;
            }
            catch
            {
                return null;
            }
        }

        /// <summary>
        /// 区位码转汉字方法
        /// </summary>
        /// <param name="coding">区位码</param>
        /// <returns>汉字</returns>
        public static string CodingToChinese(string coding)
        {
            string characters = string.Empty;
            if (coding.Length % 4 != 0)//编码为16进制,必须为4的倍数。
            {
                throw new System.Exception("编码格式不正确");
            }
            for (int i = 0; i < coding.Length / 4; i++)
            {
                byte[] bytes = new byte[2];
                int j = i * 4;
                string lowCode = coding.Substring(j, 2); //取出低字节,并以16进制进制转换
                bytes[0] = System.Convert.ToByte(lowCode, 16);
                string highCode = coding.Substring(j + 2, 2); //取出高字节,并以16进制进行转换
                bytes[1] = System.Convert.ToByte(highCode, 16);
                string character = Encoding.GetEncoding("GB2312").GetString(bytes);
                characters += character;
            }

            //空格复原（将中文空白字符转换普通空格）
            characters = characters.Replace(ChineseSpace, " ");

            return characters;
        }
        static void sc_DataReceived(object sender, SerialDataReceivedEventArgs e, byte[] bits)
        {
            //Console.WriteLine(BitConverter.ToString(bits));
            string[] _strScale = BitConverter.ToString(bits).Split('-');
            if (_strScale.Length >= 7)
            {
                //Console.WriteLine(_strScale[2].Substring(1) + _strScale[3].Substring(1) + _strScale[4].Substring(1) + _strScale[5].Substring(1) + _strScale[6].Substring(1));
                Console.WriteLine(decimal.Parse(_strScale[2].Substring(1) + _strScale[3].Substring(1) + _strScale[4].Substring(1) + _strScale[5].Substring(1) + _strScale[6].Substring(1)) / 1000);
            }
        }
        static Lib.SerialClass sc;
        int i = 0;
        public static string ParamSign(Dictionary<string, string> signParm, string MD5code, string MD5Key)
        {
            var list = signParm.OrderBy(s => s.Key);
            string str = "";
            foreach (var ss in list)
            {
                if (!string.IsNullOrWhiteSpace(ss.Value))
                    str += (string.IsNullOrWhiteSpace(str) ? "" : "&") + ss.Key + "=" + ss.Value;
            }
            //str = signParm.OrderBy(p => p.Key).Select(pair => pair.Key + "=" + pair.Value.ToString()).DefaultIfEmpty("").Aggregate((a, b) => a + "&" + b);
            if (!string.IsNullOrEmpty(MD5code))
            {
                str += "&code=" + MD5code;
            }
            if (!string.IsNullOrEmpty(MD5Key))
            {
                str += "&key=" + MD5Key;
            }

            str = BitConverter.ToString(MD5.Create().ComputeHash(Encoding.UTF8.GetBytes(str))).Replace("-", "").ToUpper();
            return str;
        }
        private void Button_Click(object sender, RoutedEventArgs e)
        {
            string text = com.ccb.wlpt.RequestProcess.initFileCert("", "", "", "", "");
            //Dictionary<string, string> parm = new Dictionary<string, string>();
            //parm.Add("TicketCode", "33000502201020190904174800");//商户订单号
            //parm.Add("time_stamp", Convert.ToInt32((DateTime.Now -
            //    new DateTime(1970, 1, 1, 0, 0, 0)).TotalSeconds).ToString());    //时间戳
            //                                                         //parm.Add("PlatformCode", "");//平台订单号
            //                                                         //添加签名信息
            //parm.Add("sign", ParamSign(parm, "330005022010", "4E65EFCB223C7089F32C0D5E18442995"));

            //string _strServiceURL = $"http://192.168.11.190:7082/service.asmx";
            //Hashtable hashtable = new Hashtable
            //{
            //    { "url", $"http://183.129.232.104:7000/Service.asmx" },
            //    { "methodName",  "OrderQuery"},
            //    {
            //        "parameter",
            //        JsonConvert.SerializeObject(new Hashtable
            //        {
            //            { "code", "330005022010" },
            //            { "jsonString", JsonConvert.SerializeObject(parm) }
            //        })
            //    }
            //};
            ////调用代理接口转发支付请求并接收结果
            //string retString = ESSupport.Lib.SoapWSHelper.QuerySoapWebServiceString(_strServiceURL, "ProxyInterface", hashtable);
            //// Common.PosControl.MemberPayResult memberPayResult = JsonConvert.DeserializeObject<Common.PosControl.MemberPayResult>(retString);
            //return;
            //System.Net.NetworkInformation.Ping _Ping = new System.Net.NetworkInformation.Ping();
            //while (true)
            //{
            //    try
            //    {
            //        System.Net.NetworkInformation.PingReply reply = _Ping.Send("192.168.11.255", 120);
            //        Console.WriteLine(reply.Status + "(" + reply.RoundtripTime + ")");
            //    }
            //    catch (Exception ex) { }
            //}
            GetQRCode();
            return;
            //string c = "";
            //using (RFSupport.RFCard _RFCard = new RFSupport.RFCard())
            //{
            //    c = _RFCard.ReadCardCode();
            //}
            //MessageBox.Show(c);
            //return;
            //StringBuilder stringBuilder = new StringBuilder(512);
            byte[] stringBuilder = new byte[512];
            //IntPtr stringBuilder = new IntPtr(512);
            string _configPath = System.IO.Path.Combine(AppDomain.CurrentDomain.BaseDirectory, "config.ini");
            string req = "";
            req += "com.pax.pay.xwappt".PadRight(30, ' ');  //不足 30 位，右补空格 
            req += "02";
            req += "0";
            req += "2".PadLeft(12, '0');  //金额分单位，不足 12 位，左补 0 
            req += "".PadLeft(6, '0');  //无，不足 6 位，左补 0 
            req += "".PadLeft(12, ' ');  //无，不足 12 位，右补空格 
            req += "".PadRight(4, ' ');   //无，不足 4 位，右补空格 
            req += "".PadRight(6, ' ');  //无，不足 6 位，右补空格 
            req += (DateTime.Now.ToString("yyyyMMddHHmmss") + "0001").PadRight(20, ' ');  //不足 20 位，右补空格 
            req += "".PadRight(40, ' ');  //不足 40 位，右补空格 
            req += "".PadLeft(2, '0');  //无，不足 2 位，左补 0

            int re = BankPay.PAXPAY_Trans(_configPath, req, stringBuilder);
            //string _Result = Marshal.PtrToStringAnsi(stringBuilder);
            string _Result = Encoding.Default.GetString(stringBuilder);
            byte[] _b = new byte[40];
            Array.Copy(stringBuilder, 128, _b, 0, 40);
            string _r = Encoding.Default.GetString(_b);
            MessageBox.Show(re + "\n" + _configPath + "\n" + req + "\n" + _Result);

            int s = stringBuilder.Length;

            MessageBox.Show("1.wmv|" + Lib.FileHelper.GetMD5ByHashAlgorithm(@"F:\EShangTech\99_工作报表\试播内容\试播1227.wmv"));
            //MessageBox.Show("2.mpg|" + Lib.FileHelper.GetMD5ByHashAlgorithm(@"F:\EShangTech\99_工作报表\试播内容\杭州禁毒公益广告.mp4"));
            //MessageBox.Show("3.mp4|" + Lib.FileHelper.GetMD5ByHashAlgorithm(@"F:\EShangTech\99_工作报表\试播内容\十二茶涧.mp4"));
            if (String.IsNullOrWhiteSpace(txtIP.Text.Trim()))
            {
                MessageBox.Show("服务器IP不能为空", "系统提示");
                txtIP.Focus();
                txtIP.SelectAll();
                return;
            }
            if (String.IsNullOrWhiteSpace(txtPort.Text.Trim()))
            {
                MessageBox.Show("服务器端口不能为空", "系统提示");
                txtPort.Focus();
                txtPort.SelectAll();
                return;
            }
            if (String.IsNullOrWhiteSpace(txtConName.Text.Trim()))
            {
                MessageBox.Show("数据库实例名不能为空", "系统提示");
                txtConName.Focus();
                txtConName.SelectAll();
                return;
            }
            if (String.IsNullOrWhiteSpace(txtDbName.Text.Trim()))
            {
                MessageBox.Show("数据库用户名不能为空", "系统提示");
                txtDbName.Focus();
                txtDbName.SelectAll();
                return;
            }
            if (String.IsNullOrWhiteSpace(txtDbUser.Text.Trim()))
            {
                MessageBox.Show("数据库登录名不能为空", "系统提示");
                txtDbUser.Focus();
                txtDbUser.SelectAll();
                return;
            }
            if (String.IsNullOrWhiteSpace(txtDbPass.Text.Trim()))
            {
                MessageBox.Show("数据库密码不能为空", "系统提示");
                txtDbPass.Focus();
                txtDbPass.SelectAll();
                return;
            }
            if (String.IsNullOrWhiteSpace(txtServerPart.Text.Trim()))
            {
                MessageBox.Show("服务区编码不能为空", "系统提示");
                txtServerPart.Focus();
                txtServerPart.SelectAll();
                return;
            }
            if (String.IsNullOrWhiteSpace(txtShop.Text.Trim()))
            {
                MessageBox.Show("门店编码不能为空", "系统提示");
                txtShop.Focus();
                txtShop.SelectAll();
                return;
            }
            if (String.IsNullOrWhiteSpace(txtMachine.Text.Trim()))
            {
                MessageBox.Show("收银机号不能为空", "系统提示");
                txtMachine.Focus();
                txtMachine.SelectAll();
                return;
            }
            string _strConfig = String.Format("数据库IP:{0}\n数据库端口:{1}\n数据库实例:{2}\n数据库用户名:{3}" +
                "\n数据库登录名:{4}\n数据库密码:{5}\n服务区编码:{6}\n门店编码:{7}\n收银机号:{8}",
                txtIP.Text.Trim(), txtPort.Text.Trim(), txtConName.Text.Trim(), txtDbName.Text.Trim(), txtDbUser.Text.Trim(),
                txtDbPass.Text.Trim(), txtServerPart.Text.Trim(), txtShop.Text.Trim(), txtMachine.Text.Trim());
            if (MessageBox.Show(_strConfig + "\n确认配置无误并生成配置二维码?", "系统提示", MessageBoxButton.YesNo,
                MessageBoxImage.Question, MessageBoxResult.Yes, MessageBoxOptions.None) == MessageBoxResult.Yes)
            {
                GetQRCode();
            }
        }
        private void GetQRCode()
        {
            //'serverpartcode','shopcode','machinecode','server_ip','service_port'
            DataSet _DataSet = new DataSet();
            DataTable _DataTable = new DataTable();
            _DataTable.TableName = "Configuration";
            _DataTable.Columns.Add("k", typeof(string));
            _DataTable.Columns.Add("v", typeof(string));
            //_DataTable.Rows.Add("server_ip", "171.221.201.162");
            //_DataTable.Rows.Add("MobilePayOperators", "1005");
            //_DataTable.Rows.Add("service_port", "7081");//1521
            //_DataTable.Rows.Add("service_port2", "7080");
            //_DataTable.Rows.Add("server_ip", txtIP.Text.Trim());
            //_DataTable.Rows.Add("server_dbport", txtPort.Text.Trim());//1521
            //_DataTable.Rows.Add("server_conname", txtConName.Text.Trim());//orcl
            //_DataTable.Rows.Add("server_dbname", txtDbName.Text.Trim());//highway_exchange
            //_DataTable.Rows.Add("server_dbuser", txtDbUser.Text.Trim());//highway_exchange
            //_DataTable.Rows.Add("server_dbpass", txtDbPass.Text.Trim());//qrwl
            //_DataTable.Rows.Add("serverpartcode", txtServerPart.Text.Trim());
            //_DataTable.Rows.Add("shopcode", txtShop.Text.Trim());
            //_DataTable.Rows.Add("machinecode", txtMachine.Text.Trim());
            //_DataTable.Rows.Add("member_ip", "183.129.232.100");
            //_DataTable.Rows.Add("member_port", "8010");
            //_DataTable.Rows.Add("quick_sale", "0");
            _DataTable.Rows.Add("CommoditySaleURL", "http://cloud.eshangtech.com/ScanUpdate/CommoditySale.html");
            _DataTable.Rows.Add("EndAccountURL", "http://cloud.eshangtech.com/ScanUpdate/EndAccount.html");
            _DataTable.Rows.Add("ScanAuditURL", "http://cloud.eshangtech.com/ScanUpdate/ScanAudit.html");
            //_DataTable.Rows.Add("USING_TYPE", "1000");
            //_DataTable.Rows.Add("expirydate", softerdate.SelectedDate.Value.ToString("yyyy/MM/dd HH:mm:ss"));
            //_DataTable.Rows.Add("syncdtime", "2019/09/12 14:28:53");
            //List<object> _Config = new List<object>();
            //_Config.Add(new { k = "CommoditySaleURL", v = "http://60.12.57.14:6060/ScanUpdate/CommoditySale.html" });
            //_Config.Add(new { k = "EndAccountURL", v = "http://60.12.57.14:6060/ScanUpdate/EndAccount.html" });
            //_Config.Add(new { k = "ScanAuditURL", v = "http://60.12.57.14:6060/ScanUpdate/ScanAudit.html" });
            _DataSet.Tables.Add(_DataTable);
            options = new QrCodeEncodingOptions
            {
                DisableECI = true,
                CharacterSet = "UTF-8",
                Width = (int)picQRCode.Height,
                Height = (int)picQRCode.Width
            };
            writer = new BarcodeWriter
            {
                Format = BarcodeFormat.QR_CODE,
                Options = options
            };
            Bitmap bitmap = writer.Write(Lib.JsonHelper.ToJson(_DataTable, "Configuration"));
            //Bitmap bitmap = writer.Write(Newtonsoft.Json.JsonConvert.SerializeObject(_DataSet));
            picQRCode.Source = BitmapToBitmapImage(bitmap);
        }
        private BitmapImage BitmapToBitmapImage(Bitmap bitmap)
        {
            BitmapImage bitmapImage = new BitmapImage();
            using (MemoryStream ms = new MemoryStream())
            {
                bitmap.Save(ms, System.Drawing.Imaging.ImageFormat.Bmp);
                bitmapImage.BeginInit();
                bitmapImage.StreamSource = ms;
                bitmapImage.CacheOption = BitmapCacheOption.OnLoad;
                bitmapImage.EndInit();
                bitmapImage.Freeze();
            }
            return bitmapImage;
        }

        private void Button_Click_1(object sender, RoutedEventArgs e)
        {
        }
        private bool CerSale(string endaccountCode, string serverPartCode, string shopCode,
            string machineCode, string sellWorkerCode, DateTime startDate, DateTime endDate, int workerNumber)
        {
            int _Maxid = 0;
            try
            {
                _Maxid = ((int)Lib.SyBaseHelper.QueryOdbc(
                    @"SELECT MAX(COMMODITYSALE_ID) FROM T_COMMODITYSALE_NEW").Tables[0].Rows[0][0]) + 1;
            }
            catch
            {
                _Maxid = 1;
            }
            string _SaleSql = string.Format(
                @"SELECT A.COMMODITY_CODE,A.COMMODITY_BARCODE,
                        A.COMMODITY_TYPE,A.COMMODITY_NAME,A.COMMODITY_SYMBOL,
                        COUNT(A.SELLMASTER_CODE) AS TICKTE_COUNT,
                        ISNULL(SUM(A.SELLDETAILS_COUNT), 0) AS TOTAL_COUNT,
                        ISNULL(SUM(A.SELLDETAILS_AMOUNT), 0) AS TOTAL_AMOUNT,
                        ISNULL(SUM(A.SELLDETAILS_OFFPRICE), 0) AS TOTAL_OFFAMOUNT 
                    FROM T_SELLDETAILS A,T_SELLMASTER B 
                    WHERE A.SELLMASTER_CODE = B.SELLMASTER_CODE AND B.SELLWORKER_CODE='{5}' AND 
                        B.SERVERPARTCODE = '{0}' AND B.SHOPCODE='{1}' AND B.MACHINECODE='{2}' AND 
                        B.SELLMASTER_DATE BETWEEN DATETIME('{3}') AND DATETIME('{4}') 
                    GROUP BY A.COMMODITY_CODE,A.COMMODITY_NAME,
                        A.COMMODITY_BARCODE,A.COMMODITY_TYPE,A.COMMODITY_SYMBOL",
                serverPartCode, shopCode, machineCode, startDate.ToString("yyyy/MM/dd HH:mm:ss"),
                endDate.ToString("yyyy/MM/dd HH:mm:ss"), sellWorkerCode);
            DataTable _DataTable = Lib.SyBaseHelper.QueryOdbc(_SaleSql).Tables[0];
            List<string> _InsertList = new List<string>();
            for (int i = 0; i < _DataTable.Rows.Count; i++)
            {
                _InsertList.Add("INSERT INTO T_COMMODITYSALE_NEW (COMMODITYSALE_ID,ENDACCOUNT_CODE,COMMODITY_TYPE," +
                    "COMMODITY_CODE,COMMODITY_BARCODE,COMMODITY_NAME,TICKTE_COUNT,TOTAL_COUNT,TOTAL_AMOUNT," +
                    "TOTAL_OFFAMOUNT,WOKER_NUMBER,TRANSFER_STATE,CREATE_DATE,COMMODITY_SYMBOL) " +
                    "VALUES (" + (_Maxid + i) + ",'" + endaccountCode + "','" + _DataTable.Rows[i]["COMMODITY_TYPE"].ToString() +
                    "','" + _DataTable.Rows[i]["COMMODITY_CODE"].ToString() + "','" + _DataTable.Rows[i]["COMMODITY_BARCODE"].ToString() +
                    "','" + _DataTable.Rows[i]["COMMODITY_NAME"].ToString() + "'," + _DataTable.Rows[i]["TICKTE_COUNT"].ToString() +
                    "," + _DataTable.Rows[i]["TOTAL_COUNT"].ToString() + "," + _DataTable.Rows[i]["TOTAL_AMOUNT"].ToString() +
                    "," + _DataTable.Rows[i]["TOTAL_OFFAMOUNT"].ToString() + "," + workerNumber +
                    ",0,DATETIME('" + endDate.ToString("yyyy/MM/dd HH:mm:ss") + "'),'" + _DataTable.Rows[i]["COMMODITY_SYMBOL"].ToString() + "')");
            }
            return true;
        }
    }
}