using Newtonsoft.Json.Linq;
using PTMedicalInsurance.Business;
using PTMedicalInsurance.Helper;
using PTMedicalInsurance.Variables;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace PTMedicalInsurance.Forms.SettlementWithNopwdApplys
{
    /// <summary>
    /// 无密码结算业务类
    /// </summary>
    class NopwdBusiness
    {
        private MIIrisServices mIS = new MIIrisServices();
        private InvokeHelper invoker = new InvokeHelper();
        private XmlHelper xmler = new XmlHelper();
        //查询登记信息 
        public int QueryRegInfo(JObject jo, out string errMsg)
        {
            errMsg = "";
            string name = JsonHelper.getDestValue(jo, "PatientName");
            string beginDate = JsonHelper.getDestValue(jo, "BeginDate");
            string endDate = JsonHelper.getDestValue(jo, "EndDate");
            string insuRegID = JsonHelper.getDestValue(jo, "InsuRegID");

            string sqlStr = $"SELECT * FROM SQLUser.BS_MedInsuRegisterInfo WHERE Hospital_Dr = {Global.inf.hospitalDr} AND Interface_Dr = {Global.inf.interfaceDr} AND OccurTime >'{beginDate}' AND OccurTime <'{endDate}' ";
            if (!string.IsNullOrEmpty(name))
            {
                sqlStr = sqlStr + $"AND PatientName = '{name}'";
            }

            if (!string.IsNullOrEmpty(insuRegID))
            {
                sqlStr = sqlStr + $"AND InsuRegID = '{insuRegID}'";
            }
            JObject joSqlstr = new JObject();
            joSqlstr.Add("sqlStr", sqlStr);

            JObject joRtn = mIS.DynamicQuery(joSqlstr,"查询登记信息");
            if (JsonHelper.parseIrisRtnValue(joRtn, out errMsg) != 0)
            {
                return -1;
            }
            else 
            {
                if (JsonHelper.getDestValue(joRtn, "result.total") == "0")
                {
                    errMsg = "未查询到登记信息！";
                    return -1;
                }
                errMsg = joRtn.ToString();
                return 0;
            }

            
        }

        //查询中心申请信息
        public int QueryCenterApplyedInfo(JObject jo, out string errMsg)
        {
            if (invoker.invokeYHCom("96Q", jo, out errMsg) != 0)
            {
                return -1;
            }
            else
            {
                JObject joRtn = JObject.Parse(xmler.ToJSON(errMsg));
                if (JsonHelper.getDestValue(joRtn, "output.recordcount") == "0")
                {

                    errMsg = "未查询到申请信息";
                    return -1;
                }
                else
                {
                    errMsg = joRtn.ToString();
                    return 0;
                }
                    
            }
        }

        //申请
        public int Apply(JObject jo, out string errMsg)
        {
            if (invoker.invokeYHCom("96", jo, out errMsg) != 0)
            {
                return -1;
            }
            else
            {
                JObject joRtn = JObject.Parse(xmler.ToJSON(errMsg));
                JObject joDetailRtn = JObject.Parse(JsonHelper.getDestValue(joRtn, "output.sqldata.row[0]"));
                if (JsonHelper.getDestValue(joDetailRtn, "succ_FLAG") != "1")
                {

                    errMsg = JsonHelper.getDestValue(joDetailRtn, "prmmsg");
                    return -1;
                }
                else
                    return 0;
            }
        }

    }
}