MedicalInsurance/Forms/Clearing/MainForm.cs

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
using PTMedicalInsurance.Common;
using PTMedicalInsurance.Helper;
using Newtonsoft.Json.Linq;
using PTMedicalInsurance.FormSetter;
using System.IO;
using System.IO.Compression;
using PTMedicalInsurance.Business;
using Sunny.UI;
using Newtonsoft.Json;
using System.Collections;
using PTMedicalInsurance.Variables;

namespace PTMedicalInsurance.Forms.Clearings
{
    public partial class MainForm : Form
    {
        private string txtPath;
        private string txtName;
        private string finalAchPath;
        private string fileDir;
        private UIDataGridViewFooter dgvHisSettlRecFooter = new Sunny.UI.UIDataGridViewFooter();
        JObject jo9102Rtn = new JObject();
        #region 初始化
        public MainForm()
        {
            InitializeComponent();

            //初始化界面
            InitForm();

            //添加转院备案
            AddForm(this.tpOutOfAreaClearing, new OutOfAreaClearing(this));

        }

        private void InitForm()
        {
            this.StartPosition = FormStartPosition.CenterParent;

            ComboxSetter cbxSetter = new ComboxSetter();
            cbxSetter.setCbxInterfaceDataSource(cbxInterface);

            cbxSetter.setCbxDictionaryDataSource(Global.inf.interfaceDr.ToString(), "insutype", cbxInsuType);
            cbxSetter.setCbxDictionaryDataSource(Global.inf.interfaceDr.ToString(), "clr_type", cbxClrType);

            GridViewSetter grdSetter = new GridViewSetter();
            grdSetter.SetHeaderTextOfCheck(dgvSettlSummary);

            cbgGroupSet.SelectAll();
            cbgGroupSet.SetItemCheckState(4, false);

            cbxValid.SelectedIndex = 1;
            cbReservelFlag.SelectedIndex = 2;
            cbConfirmFlag.SelectedIndex = 1;

            dpST.Text = DateTime.Now.ToString("yyyy-MM-01");
            dpED.Value = DateTime.Now.AddDays(1 - DateTime.Now.Day).AddMonths(1).AddDays(-1);

            WindowState = FormWindowState.Maximized;

            fileDir = Global.currentDirectory + "\\Download";

            this.WindowState = FormWindowState.Maximized;

            this.uiTabControl1.SelectedIndex = 1;
        }

        private void AddForm(TabPage tabpage, Form frm)
        {
            tabpage.Controls.Add(frm);
            frm.Show();
        }
        #endregion

        #region 非按钮事件

        #region 查询HIS 
        private int queryHisSettlementInfo(out string error)
        {
            GridViewSetter grdSetter = new GridViewSetter();
            grdSetter.SetHeaderTextOfHisSettlRec(dgvHisSettlRec);
            error = "";
            try
            {
                DataTable dtInteface = (DataTable)cbxInterface.DataSource;
                int i = cbxInterface.SelectedIndex;

                string sqlStr = "";
                string conditionStr = " ";
                DataTable dtSettlSummary = (DataTable)dgvSettlSummary.DataSource;
                int iCurRow = dgvSettlSummary.CurrentRow.Index;

                //DataTable dtInteface = (DataTable)cbxInterface.DataSource;
                if (cbgGroupSet.GetItemCheckState(0))
                {
                    conditionStr = conditionStr + " and Interface_Dr ='" + dtSettlSummary.Rows[iCurRow]["Interface_dr"].ToString() + "'";
                }
                //if (cbgGroupSet.GetItemCheckState(1))
                //{
                //    conditionStr = conditionStr + " and InsuranceType ='" + dtSettlSummary.Rows[iCurRow]["insutype"].ToString() + "'";
                //}
                if (cbgGroupSet.GetItemCheckState(2))
                {
                    conditionStr = conditionStr + " and ClearingType ='" + dtSettlSummary.Rows[iCurRow]["clr_type"].ToString() + "'";
                }
                if (cbgGroupSet.GetItemCheckState(3))
                {
                    conditionStr = conditionStr + " and ClearingOrgan ='" + dtSettlSummary.Rows[iCurRow]["setl_optins"].ToString() + "'";
                }
                if (cbgGroupSet.GetItemCheckState(4))
                {
                    sqlStr = sqlStr + ",BillType";
                    conditionStr = conditionStr + " and BillType ='" + dtSettlSummary.Rows[iCurRow]["BillType"].ToString() + "'";
                }

                sqlStr = "select * " + getWhereCondition();
                sqlStr = sqlStr + conditionStr;
                JObject joSqlstr = new JObject();
                joSqlstr.Add("sqlStr", sqlStr);
                JArray jaParam = new JArray();
                jaParam.Add(joSqlstr);
                JObject joSettlQuery = new JObject();
                joSettlQuery.Add("params", jaParam);
                joSettlQuery.Add("code", "09010059");
                InvokeHelper invoker = new InvokeHelper();
                JObject joRtn = invoker.invokeInsuService(joSettlQuery.ToString(), "查询结算信息");

                //DataTable dt = (DataTable)joRtn["result"]["data"].ToObject(typeof(DataTable));
                JArray ja = JArray.Parse(JsonHelper.getDestValue(joRtn, "result.data"));
                DataTable dt = (DataTable)JsonConvert.DeserializeObject(JsonHelper.getDestValue(joRtn, "result.data"), (typeof(DataTable)));
                dgvHisSettlRec.DataSource = dt;
                if (dt.Rows.Count == 0)
                {
                    error = "未查询到数据";
                    return -1;
                }
                //dt.Columns[7].DataType = typeof(float);//不允许
                //dgvHisSettlRecFooter.DataGridView = dgvHisSettlRec;
                //dgvHisSettlRecFooter.Dock = System.Windows.Forms.DockStyle.Bottom;
                //dgvHisSettlRecFooter.Clear();
                //dgvHisSettlRecFooter["AdmID"] = "合计";
                //dgvHisSettlRecFooter["OverLimitAmount"] = "测试";

                return 0;
            }
            catch (Exception ex)
            {
                error = "queryHisSettlementInfo:" + ex.Message;
                return -1;
            }
        }

        private string getWhereCondition()
        {
            string sqlStr = "";
            sqlStr = sqlStr + " FROM BS_MedInsuSettlement WHERE Hospital_Dr=" + Global.inf.hospitalDr;
            sqlStr = sqlStr + " and OccurTime>'" + dpST.Text + " 00:00:00'";
            sqlStr = sqlStr + " and OccurTime<'" + dpED.Text + " 23:59:59'";
            sqlStr = sqlStr + " and (left(InsuranceAreaCode,2)='44')";
            DataTable dtInteface = (DataTable)cbxInterface.DataSource;
            int i = cbxInterface.SelectedIndex;
            if (cbxInterface.Text != "")
            {
                sqlStr = sqlStr + " and Interface_Dr =" + dtInteface.Rows[i]["ID"].ToString();
            }

            if (cbxInsuType.Text != "")
            {
                sqlStr = sqlStr + " and InsuranceType ='" + cbxInsuType.SelectedValue + "'";
            }

            if (cbxClrType.Text != "")
            {
                sqlStr = sqlStr + " and ClearingType ='" + cbxClrType.SelectedValue + "'";
            }

            if (tbSettlOption.Text != "")
            {
                sqlStr = sqlStr + " and ClearingOrgan ='" + tbSettlOption.Text + "'";
            }

            //ValidFlag=1 and BillType=1 表示正常结算记录   ValidFlag=0 and BillType=-1 表示退费记录  ValidFlag=0表示无效记录 
            if (cbxValid.SelectedIndex != 0)
            {
                if (cbxValid.SelectedIndex == 1)
                    sqlStr = sqlStr + " and ValidFlag =1 and BillType=1";
                else
                    sqlStr = sqlStr + " and ValidFlag =0 and BillType=-1";
            }
            //确认标志
            if (cbConfirmFlag.SelectedIndex != 0)
            {
                if (cbConfirmFlag.SelectedIndex == 1)
                    sqlStr = sqlStr + " and ((ConfirmFlag = 1 and AdmType = 3) or (AdmType in ('1','2'))) ";
                else
                    sqlStr = sqlStr + " and ConfirmFlag <> 1";
            }

            // ReversalFlag = 1  表示数据已冲正，ReversalFlag =0 表示 正常未冲正数据
            if (cbReservelFlag.SelectedIndex != 0)
            {
                if (cbReservelFlag.SelectedIndex == 1)
                    sqlStr = sqlStr + " and ReversalFlag =1 ";
                else
                    sqlStr = sqlStr + " and ReversalFlag <> 1 ";
            }

            return sqlStr;
        }
        #endregion

        #region 对明细账

        public static void writeToTxt(string content, string filePath, string fileName)
        {
            //创建文件夹,文件夹名称与TXT同名
            string finalPath = filePath + "\\" + fileName;
            if (!Directory.Exists(finalPath))
            {
                DirectoryInfo dirInfo = Directory.CreateDirectory(finalPath);
            }
            //判断文件夹中是否存在txt
            string finalFileName = finalPath + "\\" + fileName + ".txt";
            if (!File.Exists(finalFileName))
            {
                FileStream fs1 = File.Create(finalFileName);
                fs1.Close();
            }

            FileStream fs = new FileStream(finalFileName, FileMode.Append, FileAccess.Write);
            StreamWriter sw = new StreamWriter(fs);
            sw.WriteLine(content);
            sw.Close();
            fs.Close();
        }

        /// <summary>
        /// 读文件到byte[]
        /// </summary>
        /// <param name="fileName">硬盘文件路径</param>
        /// <returns></returns>
        public static byte[] ReadFileToByte(string fileName)
        {
            FileStream pFileStream = null;
            byte[] pReadByte = new byte[0];
            try
            {
                pFileStream = new FileStream(fileName, FileMode.Open, FileAccess.Read);
                BinaryReader r = new BinaryReader(pFileStream);
                r.BaseStream.Seek(0, SeekOrigin.Begin);    //将文件指针设置到文件开
                pReadByte = r.ReadBytes((int)r.BaseStream.Length);
                return pReadByte;
            }
            catch
            {
                return pReadByte;
            }
            finally
            {
                if (pFileStream != null)
                    pFileStream.Close();
            }
        }

        /// <summary>
        ///单字节转有符号整数
        /// </summary>
        /// <param name="data"></param>
        /// <returns></returns>
        public string byteArrayToDecString(byte[] data)
        {
            StringBuilder builder = new StringBuilder();
            for (int i = 0; i < data.Length; i++)
            {
                builder.Append((sbyte)data[i] + ",");
            }
            return builder.ToString().Trim();
        }

        private int HISDetailDataExport(string filePath, string fileName)
        {
            try
            {
                DataTable dt = (DataTable)dgvHisSettlRec.DataSource;
                string content = "";
                for (int i = 0; i < dt.Rows.Count; i++)
                {
                    string flag = "";
                    if (dt.Rows[i]["ValidFlag"].ToString() == "-1")
                    {
                        flag = "1";
                    }
                    else
                    {
                        flag = "0";
                    }
                    content = "\r\n"
                            + dt.Rows[i]["SettlementID"].ToString() + "\t"
                            + dt.Rows[i]["MdtrtID"].ToString() + "\t"
                            + dt.Rows[i]["PersonnelNO"].ToString() + "\t"
                            + dt.Rows[i]["Sumamt"].ToString() + "\t"
                            + dt.Rows[i]["FundPaySumamt"].ToString() + "\t"
                            + dt.Rows[i]["AccountPaySumamt"].ToString() + "\t"
                            + flag
                            + content;
                }
                string finalContent = content.Remove(0, 2);
                writeToTxt(finalContent, filePath, fileName);
                return 0;
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
                return -1;
            }
        }
        private int exportAndCompress(out string zipPath)
        {
            zipPath = "";
            try
            {
                //导出TXT
                string fileName = DateTime.Now.ToString("yyyyMMddHHmmssffff");
                string filePath = Global.currentDirectory + "\\Download";
                HISDetailDataExport(filePath, fileName);
                //压缩
                string finalDirPath = filePath + "\\" + fileName;//同名文件夹
                zipPath = finalDirPath + ".zip";
                System.IO.Compression.ZipFile.CreateFromDirectory(finalDirPath, zipPath);
                return 0;
            }
            catch (Exception ex)
            {
                zipPath = "exportAndCompress:" + ex.Message;
                return -1;
            }
        }

        /// <summary>
        /// 上传ZIP文件转字节流再转换为有符号10进制数组后上传
        /// </summary>
        /// <param name="zipPath"></param>
        /// <param name="file_qury_no"></param>
        /// <returns></returns>
        private int uploadFileToCenter(string zipPath, out string file_qury_no)
        {
            string outParam = "";
            try
            {
                byte[] bArray = ReadFileToByte(zipPath);
                string str = "[" + byteArrayToDecString(bArray) + "]";

                JObject joTmp = new JObject();
                joTmp.Add("in", JArray.Parse(str));
                joTmp.Add("filename", txtName + ".zip");
                joTmp.Add("fixmedins_code", Global.inf.hospitalNO);

                JObject joFsUploadIn = new JObject();
                joFsUploadIn.Add("fsUploadIn", joTmp);

                InvokeHelper invoker = new InvokeHelper();
                JObject jo9101Rtn = invoker.invokeCenterService(TradeEnum.FileUpload, joFsUploadIn);

                if (JsonHelper.parseCenterReturnJson(jo9101Rtn, out outParam) != 0)
                {
                    file_qury_no = outParam;
                    return -1;
                }
                else
                {
                    file_qury_no = JsonHelper.getDestValue(jo9101Rtn, "output.file_qury_no");
                    return 0;
                }

            }
            catch (Exception ex)
            {
                file_qury_no = "uploadFileToCenter:" + ex.Message;
                return -1;
            }
        }
        private int checkDetail(string file_qury_no, out string outParam, out string fileName)
        {
            fileName = "";
            try
            {
                DataTable dt = (DataTable)dgvSettlSummary.DataSource;
                int i = dgvSettlSummary.CurrentRow.Index;

                dynamic joCheck = new JObject();
                joCheck.file_qury_no = file_qury_no.Replace(@"\\", @"\");
                joCheck.clr_type = dt.Rows[i]["clr_type"].ToString();
                joCheck.setl_optins = dt.Rows[i]["setl_optins"].ToString();
                joCheck.stmt_begndate = dpST.Value.ToString("yyyy-MM-dd HH:mm:ss");
                joCheck.stmt_enddate = dpED.Value.ToString("yyyy-MM-dd HH:mm:ss");
                joCheck.medfee_sumamt = dt.Rows[i]["medfee_sumamt"].ToString();
                joCheck.fund_pay_sumamt = dt.Rows[i]["fund_pay_sumamt"].ToString();
                joCheck.cash_payamt = dt.Rows[i]["cash_payamt"].ToString();
                joCheck.fixmedins_setl_cnt = dt.Rows[i]["fixmedins_setl_cnt"].ToString();

                JObject joData = new JObject();
                joData.Add("data", joCheck);
                InvokeHelper invoker = new InvokeHelper();
                JObject jo3202Rtn = invoker.invokeCenterService(TradeEnum.FeeDetailCheck, joData);
                if (JsonHelper.parseCenterReturnJson(jo3202Rtn, out outParam) != 0)
                {
                    return -1;
                }
                else
                {
                    outParam = JsonHelper.getDestValue(jo3202Rtn, "output.fileinfo.file_qury_no");
                    fileName = JsonHelper.getDestValue(jo3202Rtn, "output.fileinfo.filename");
                    return 0;
                }
            }
            catch (Exception ex)
            {
                outParam = "checkDetail:" + ex.Message;
                return -1;
            }

        }
        private int downloadZIP(string file_qury_no, string fileName, out string outParam)
        {
            outParam = "";
            try
            {
                JObject joTmp = new JObject();
                joTmp = new JObject();
                joTmp.Add("file_qury_no", file_qury_no.Replace(@"\\", @"\"));
                joTmp.Add("filename", fileName);
                joTmp.Add("fixmedins_code", Global.inf.hospitalNO);

                JObject joFsDownloadIn = new JObject();
                joFsDownloadIn.Add("fsDownloadIn", joTmp);
                InvokeHelper invoker = new InvokeHelper();
                JObject jo9102Rtn = invoker.DownloadCenterFile(JsonHelper.setCenterInpar("9102", joFsDownloadIn).ToString());
                string error = "";
                if (JsonHelper.parseIrisRtnValue(jo9102Rtn, out error) != 0)
                {
                    outParam = error;
                    return -1;
                }
                else
                {
                    outParam = JsonHelper.getDestValue(jo9102Rtn, "filePath");
                    return 0;
                }
            }
            catch (Exception ex)
            {
                outParam = "downloadZIP:" + ex.Message;
                return -1;
            }

        }
        private int importToDgvCenterSetlRec(string fileName, string zipFilePath, out string outParam)
        {
            outParam = "";
            try
            {
                string dir = fileName.Substring(1, fileName.Length - 4);
                //解压缩
                string txtFileDir = System.Environment.CurrentDirectory + "\\Download\\" + dir;
                string txtFilePath = zipFilePath.Substring(0, zipFilePath.Length - 4);
                if (File.Exists(txtFilePath))
                {
                    File.Delete(txtFilePath);
                }
                if (!Directory.Exists(txtFileDir))
                {
                    Directory.CreateDirectory(txtFileDir);
                }

                ZipFile.ExtractToDirectory(zipFilePath, txtFileDir);

                //导入文件
                GridViewSetter grd = new GridViewSetter();
                grd.SetHeaderTextOfDgvCenterSetlRec(dgvCenterSettlRec);
                //txtFileDir = txtFileDir;//E:\GHSF\SCYBDownLoad\result.txt
                string[] lines = System.IO.File.ReadAllLines(txtFileDir + "\\result.txt");

                DataTable dt = new DataTable();
                dt.Columns.Add("sn", typeof(int));
                dt.Columns.Add("psn_no", typeof(string));
                dt.Columns.Add("mdtrt_id", typeof(string));
                dt.Columns.Add("setl_id", typeof(string));
                dt.Columns.Add("msgid", typeof(string));
                dt.Columns.Add("stmt_rslt", typeof(string));
                dt.Columns.Add("refd_setl_flag", typeof(string));
                dt.Columns.Add("memo", typeof(string));
                dt.Columns.Add("medfee_sumamt", typeof(string));
                dt.Columns.Add("fund_pay_sumamt", typeof(string));
                dt.Columns.Add("acct_pay", typeof(string));

                //foreach (string line in lines)
                for (int i = 0; i < lines.Length; i++)
                {
                    string[] strs = (lines[i] + "\t").Split('\t');
                    DataRow dr = dt.NewRow();
                    //Global.inf.writeLog(lines[i].ToString());
                    //Global.inf.writeLog(strs.Length.ToString());
                    dr["sn"] = i + 1;
                    dr["psn_no"] = strs[0];
                    dr["mdtrt_id"] = strs[1];
                    dr["setl_id"] = strs[2];
                    dr["msgid"] = strs[3];
                    dr["stmt_rslt"] = strs[4];
                    dr["refd_setl_flag"] = strs[5];
                    dr["memo"] = strs[6];
                    dr["medfee_sumamt"] = strs[7];
                    dr["fund_pay_sumamt"] = strs[8];
                    dr["acct_pay"] = strs[9];
                    //dr["Field2"] = strs[2];

                    dt.Rows.Add(dr);
                }
                dgvCenterSettlRec.DataSource = dt;

                return 0;
            }
            catch (Exception ex)
            {
                outParam = "importToDgvCenterSetlRec:" + ex.Message;
                return -1;
            }
        }

        private int CheckDetail_Single(out string outParam)
        {
            outParam = "";
            //先签到
            CenterBusiness cBus = new CenterBusiness();
            JObject jo9001Rtn = new JObject();
            cBus.signIn(out jo9001Rtn);
            try
            {
                //导出并压缩
                if (exportAndCompress(out outParam) != 0)
                {
                    return -1;
                }

                string zipPath = outParam;

                //上传给中心，
                if (uploadFileToCenter(zipPath, out outParam) != 0)
                {
                    return -1;
                }

                string file_query_no = outParam;
                string fileName = "";
                //3202明细对账  输出查询号和文件名
                if (checkDetail(file_query_no, out outParam, out fileName) != 0)
                {
                    return -1;
                }
                file_query_no = outParam;
                Global.writeLog("checkDetail:" + outParam + "///" + fileName);
                //下载  获取 查询号和文件名后 下载
                if (downloadZIP(file_query_no, fileName, out outParam) != 0)
                {
                    return -1;
                }

                zipPath = outParam;

                Global.writeLog("downloadZIP:" + outParam);
                //导入DGV
                if (importToDgvCenterSetlRec(fileName, zipPath, out outParam) != 0)
                {
                    return -1;
                }
                Global.writeLog("importToDgvCenterSetlRec:" + outParam);
                return 0;
            }
            catch (Exception ex)
            {
                outParam = "CheckDetail_Single:" + ex.Message;
                return -1;
            }

        }
        #endregion

        #region 对账
        /// <summary>
        /// 单条对总账【本地】
        /// </summary>
        /// <param name="error"></param>
        /// <returns></returns>
        private int Check_Single(out string error)
        {
            error = ""; string setlOptins = "";
            DataTable dt = (DataTable)dgvSettlSummary.DataSource;
            int i = dgvSettlSummary.CurrentRow.Index;

            dynamic joCheck = new JObject();
            joCheck.insutype = dt.Rows[i]["insutype"].ToString();                       //险种类型
            joCheck.clr_type = dt.Rows[i]["clr_type"].ToString();                       //清算类别            

            //if (tbSettlOption.Text != "")
            //{
            //    joCheck.setl_optins = tbSettlOption.Text; //dt.Rows[i]["setl_optins"].ToString();  //结算经办机构
            //    setlOptins = tbSettlOption.Text;
            //}
            //else
            //{
            joCheck.setl_optins = dt.Rows[i]["setl_optins"].ToString();             //结算经办机构
            setlOptins = dt.Rows[i]["setl_optins"].ToString();
            //}

            joCheck.medfee_sumamt = dt.Rows[i]["medfee_sumamt"].ToString();             //医疗费总额
            joCheck.fund_pay_sumamt = dt.Rows[i]["fund_pay_sumamt"].ToString();         //基金支付总额
            joCheck.acct_pay = dt.Rows[i]["acct_pay"].ToString();                       //个人账户支付金额
            joCheck.fixmedins_setl_cnt = dt.Rows[i]["fixmedins_setl_cnt"].ToString();   //定点医药机构结算笔数
            joCheck.stmt_begndate = dpST.Value.ToString("yyyy-MM-dd 00:00:00");         //对账开始日期
            joCheck.stmt_enddate = dpED.Value.ToString("yyyy-MM-dd 23:59:59");          //对账结束日期

            JObject joData = new JObject();
            joData.Add("data", joCheck);
            //上传给中心
            //先签到
            CenterBusiness cBus = new CenterBusiness();
            JObject jo9001Rtn = new JObject();
            cBus.signIn(out jo9001Rtn);

            Global.pat.insuplc_admdvs = setlOptins;

            InvokeHelper invoker = new InvokeHelper();
            JObject joRtn = invoker.invokeCenterService(TradeEnum.FeeSummaryCheck, joData);
            if (JsonHelper.parseCenterReturnJson(joRtn, out error) != 0)
            {
                return -1;
            }
            else
            {
                if (JsonHelper.getDestValue(joRtn, "output.stmtinfo.stmt_rslt") != "0")
                {
                    error = JsonHelper.getDestValue(joRtn, "output.stmtinfo.stmt_rslt_dscr");
                    return -1;
                }
                else
                {
                    return 0;
                }
            }
        }

        #endregion

        #region 智能比对
        private int compareDataGridView(string value, string colName, Sunny.UI.UIDataGridView dgv)
        {
            try
            {
                for (int i = 0; i < dgv.RowCount; i++)
                {
                    if (dgv.Rows[i].Cells[colName].Value.ToString() == value)
                    {
                        return 0;
                    }
                }
                return -1;
            }
            catch (Exception ex)
            {
                MessageBox.Show("compareDataGridView" + ex.Message);
                return -1;
            }
        }

        #endregion

        #endregion

        #region  按钮事件

        private void Btn_Query_Click(object sender, EventArgs e)
        {
            DataTable dtInteface = (DataTable)cbxInterface.DataSource;
            int i = cbxInterface.SelectedIndex;
            //乘以单据类型后，IRIS会返回整数，关键不知道SQL里咋转换为浮点数
            //string sqlStr = "SELECT SUM(BillType*Sumamt) AS medfee_sumamt,count(*) AS fixmedins_setl_cnt,SUM(BillType*PersonCashPay) AS cash_payamt, ";
            //sqlStr = sqlStr + " SUM(BillType*AccountPaySumamt) AS acct_pay,SUM(BillType*FundPaySumamt) AS fund_pay_sumamt ";
            //对账时个人账户=个人账户+共济账户
            string sqlStr = "SELECT SUM(BillType*Sumamt) AS medfee_sumamt,count(*) AS fixmedins_setl_cnt,SUM(BillType*PersonCashPay) AS cash_payamt,  ";
            sqlStr = sqlStr + " SUM(billType*(AccountPaySumamt+AccountMutualAidAmount)) AS acct_pay,SUM(BillType*FundPaySumamt) AS fund_pay_sumamt ";
            //sqlStr = sqlStr + " Interface_dr,clearingWay AS clr_way,clearingType AS clr_type ";
            // 增加先行自付金额、医疗救助基金、公务员医疗补助、个人账户共济支付、企业补充、职工大额
            sqlStr += ",Sum(BillType*PreSelfPayAmount) as PreSelfPayAmount,sum(BillType*MedicalAssistPay) as MedicalAssistPay,sum(BillType*CivilserviceAllowancePay) as CivilserviceAllowancePay,"
                   + "sum(BillType*AccountMutualAidAmount) as AccountMutualAidAmount ,sum(BillType*LargeExpensesSupplementPay) as LargeExpensesSupplementPay,"
                   + "sum(BillType*EnterpriseSupplementPay) as EnterpriseSupplementPay ";

            string conditionStr = " Group By";
            if (cbgGroupSet.GetItemCheckState(0))
            {
                sqlStr = sqlStr + ",Interface_Dr";
                conditionStr = conditionStr + " Interface_Dr,";
            }
            if (cbgGroupSet.GetItemCheckState(1))
            {
                sqlStr = sqlStr + ",InsuranceType as insutype";
                conditionStr = conditionStr + " InsuranceType,";
            }
            if (cbgGroupSet.GetItemCheckState(2))
            {
                sqlStr = sqlStr + ",ClearingType as clr_type";
                conditionStr = conditionStr + " ClearingType,";
            }
            if (cbgGroupSet.GetItemCheckState(3))
            {
                sqlStr = sqlStr + ",ClearingOrgan as setl_optins";
                conditionStr = conditionStr + " ClearingOrgan,";
            }
            if (cbgGroupSet.GetItemCheckState(4))
            {
                sqlStr = sqlStr + ",BillType";
                conditionStr = conditionStr + " BillType,";
            }

            sqlStr = sqlStr + getWhereCondition();

            conditionStr = conditionStr.Remove(conditionStr.Length - 1, 1);

            sqlStr = sqlStr + conditionStr;
            JObject joSqlstr = new JObject();

            //MessageBox.Show(sqlStr);

            joSqlstr.Add("sqlStr", sqlStr);
            JArray jaParam = new JArray();
            jaParam.Add(joSqlstr);
            JObject joSettlQuery = new JObject();
            joSettlQuery.Add("params", jaParam);
            joSettlQuery.Add("code", "09010061");
            InvokeHelper invoker = new InvokeHelper();
            JObject joRtn = invoker.invokeInsuService(joSettlQuery.ToString(), "查询汇总结算信息");

            DataTable dt = (DataTable)joRtn["result"]["data"].ToObject(typeof(DataTable));
            dgvSettlSummary.DataSource = dt;

            //初始化HIS结算明细View数据
            dgvHisSettlRec.DataSource = null;
        }

        private void btBatchCheck_Click(object sender, EventArgs e)
        {
            string errMsg = "";
            bool success = true;
            for (int i = 0; i < dgvSettlSummary.RowCount; i++)
            {
                dgvSettlSummary.CurrentCell = dgvSettlSummary.Rows[i].Cells[0];
                if (Check_Single(out errMsg) != 0)
                {
                    dgvSettlSummary.Rows[i].DefaultCellStyle.BackColor = Color.Red;
                    rtbCheckLog.AppendText("第" + (i + 1).ToString() + "条对账失败！" + errMsg + "\r\n");
                    success = false;
                }

            }

            if (success)
            {
                MessageBox.Show("批量对账全部成功！");
            }
            else
            {
                MessageBox.Show("部分对账失败，请查看对账结果！");
            }
        }

        private void tsmCheck_Single_Click(object sender, EventArgs e)
        {
            string error = "";
            if (Check_Single(out error) != 0)
            {
                MessageBox.Show("对总账失败：" + error);
            }
            else
            {
                if (dgvHisSettlRec.SelectedIndex != -1)
                {
                    dgvHisSettlRec.Rows[dgvHisSettlRec.SelectedIndex].DefaultCellStyle.BackColor = Color.White;
                }
                MessageBox.Show("对总账成功");
            }
        }

        private void tsmCheckDetail_Single_Click(object sender, EventArgs e)
        {
            //HIS明细
            string error;
            if (queryHisSettlementInfo(out error) != 0)
            {
                MessageBox.Show(error);
            }
            //中心明细
            if (CheckDetail_Single(out error) != 0)
            {
                MessageBox.Show(error);
            }
        }

        private void tsmCheck_Batch_Click(object sender, EventArgs e)
        {
            btBatchCheck_Click(sender, e);
        }

        private void tsmCheckDetail_Batch_Click(object sender, EventArgs e)
        {

        }

        private void tsmHisRecord_Click(object sender, EventArgs e)
        {
            string error;
            if (queryHisSettlementInfo(out error) != 0)
            {
                MessageBox.Show(error);
            }
        }

        private void tsmAICheck_Click(object sender, EventArgs e)
        {
            for (int i = 0; i < dgvHisSettlRec.RowCount; i++)
            {
                string value = dgvHisSettlRec.Rows[i].Cells["SettlementID"].Value.ToString();
                string colName = "setl_id";
                if (compareDataGridView(value, colName, dgvCenterSettlRec) != 0)
                {
                    dgvHisSettlRec.Rows[i].DefaultCellStyle.BackColor = Color.Red;
                    rtbCheckDetailLog.AppendText("HIS结算ID:" + value + "在中心明细中未找到数据！" + "\r\n");
                }
            }

            for (int i = 0; i < dgvCenterSettlRec.RowCount; i++)
            {
                string value = dgvCenterSettlRec.Rows[i].Cells["setl_id"].Value.ToString();
                string colName = "SettlementID";
                if (compareDataGridView(value, colName, dgvHisSettlRec) != 0)
                {
                    dgvCenterSettlRec.Rows[i].DefaultCellStyle.BackColor = Color.Red;
                    rtbCheckDetailLog.AppendText("中心结算ID:" + value + "在HIS明细中未找到数据！" + "\r\n");
                }
            }
        }

        private void tsmExport_Click(object sender, EventArgs e)
        {
            txtName = DateTime.Now.ToString("yyyyMMddHHmmssffff");
            txtPath = Global.currentDirectory + "\\Download";
            if (HISDetailDataExport(txtPath, txtName) != 0)
            {
                MessageBox.Show("导出TXT失败！");
            }
            else
            {
                MessageBox.Show("导出TXT成功！");
            }
        }

        private void tsmCompress_Click(object sender, EventArgs e)
        {
            string finalDirPath = txtPath + "\\" + txtName;
            finalAchPath = finalDirPath + ".zip";
            System.IO.Compression.ZipFile.CreateFromDirectory(finalDirPath, finalAchPath);
            MessageBox.Show("将TXT压缩为ZIP成功！");
        }

        private void tsmZIPToSDec_Click(object sender, EventArgs e)
        {
            byte[] bArray = ReadFileToByte(finalAchPath);
            string str = byteArrayToDecString(bArray);
            Global.writeLog(str);

            MessageBox.Show("ZIP转为有符号整数成功！");
        }

        private void tsmUploadZIP_Click(object sender, EventArgs e)
        {
            string outParam = "";
            byte[] bArray = ReadFileToByte(finalAchPath);
            string str = "[" + byteArrayToDecString(bArray) + "]";

            JObject joTmp = new JObject();
            joTmp.Add("in", JArray.Parse(str));
            joTmp.Add("filename", txtName + ".zip");

            Global.inf.fileName = txtName + ".zip";

            //joTmp.Add("filename", finalAchPath.Replace("\\",@"\"));
            joTmp.Add("fixmedins_code", Global.inf.hospitalNO);

            JObject joFsUploadIn = new JObject();
            joFsUploadIn.Add("fsUploadIn", joTmp);

            InvokeHelper invoker = new InvokeHelper();
            JObject jo9101Rtn = invoker.invokeCenterService(TradeEnum.FileUpload, joFsUploadIn);

            if (JsonHelper.parseCenterRtnValue(jo9101Rtn, out outParam) != 0)
            {
                outParam = JsonHelper.setExceptionJson(-1, "【9101】文件上传失败", outParam).ToString();

                return;
            }
            else
            {
                MessageBox.Show("【9101】文件上传成功");
            }
        }

        private void tsm3202_Click(object sender, EventArgs e)
        {
            if (string.IsNullOrEmpty(Global.inf.areaCode))
            {
                MessageBox.Show("请先签到!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                return;
            }

            string outParam = "";
            DataTable dt = (DataTable)dgvSettlSummary.DataSource;
            int i = dgvSettlSummary.CurrentRow.Index;

            dynamic joCheck = new JObject();
            joCheck.file_qury_no = JObject.Parse(fileDir);
            joCheck.clr_type = dt.Rows[i]["clr_type"].ToString();
            joCheck.setl_optins = dt.Rows[i]["setl_optins"].ToString();
            joCheck.stmt_begndate = dpST.Value.ToString("yyyy-MM-dd HH:mm:ss");
            joCheck.stmt_enddate = dpED.Value.ToString("yyyy-MM-dd HH:mm:ss");
            joCheck.medfee_sumamt = dt.Rows[i]["medfee_sumamt"].ToString();
            joCheck.fund_pay_sumamt = dt.Rows[i]["fund_pay_sumamt"].ToString();
            joCheck.cash_payamt = dt.Rows[i]["cash_payamt"].ToString();
            joCheck.fixmedins_setl_cnt = dt.Rows[i]["fixmedins_setl_cnt"].ToString();

            JObject joData = new JObject();
            joData.Add("data", joCheck);
            InvokeHelper invoker = new InvokeHelper();

            JObject jo3202Rtn = invoker.invokeCenterService(TradeEnum.FeeDetailCheck, joData);
            if (JsonHelper.parseCenterRtnValue(jo3202Rtn, out outParam) != 0)
            {
                outParam = JsonHelper.setExceptionJson(-1, "【3202】医保明细对账失败", outParam).ToString();
                MessageBox.Show(outParam);
                return;
            }
            else
            {
                MessageBox.Show("【3202】医保明细对账成功");
            }
        }

        private void tsmDownload_Click(object sender, EventArgs e)
        {
            string outParam = "";
            JObject joTmp = new JObject();
            joTmp.Add("file_qury_no", JObject.Parse(fileDir.Replace(@"\\", @"\")));
            joTmp.Add("filename", txtName + ".zip");
            joTmp.Add("fixmedins_code", Global.inf.hospitalNO);

            JObject joFsDownloadIn = new JObject();
            joFsDownloadIn.Add("fsDownloadIn", joTmp);

            InvokeHelper invoker = new InvokeHelper();
            jo9102Rtn = invoker.invokeCenterService(TradeEnum.FileDownload, joFsDownloadIn);

            if (JsonHelper.parseCenterRtnValue(jo9102Rtn, out outParam) != 0)
            {
                outParam = JsonHelper.setExceptionJson(-1, "【9102】文件下载失败", outParam).ToString();
                MessageBox.Show(outParam);
                return;
            }
            else
            {
                MessageBox.Show("【9102】文件下载成功");
            }
        }

        private void tsmUnCompress_Click(object sender, EventArgs e)
        {
            //解压缩
            string zipFilePath = jo9102Rtn["filePath"].ToString();
            string txtFileDir = System.Environment.CurrentDirectory + "\\Download";
            //string txtFilePath = txtFileDir + "\\" + filename.Substring(0, filename.Length - 4);
            string txtFilePath = txtFileDir;
            if (File.Exists(txtFilePath))
            {
                File.Delete(txtFilePath);
            }

            ZipFile.ExtractToDirectory(zipFilePath, txtFileDir);
        }

        private void tsmImport_Click(object sender, EventArgs e)
        {
            GridViewSetter grd = new GridViewSetter();
            grd.SetHeaderTextOfDgvCenterSetlRec(dgvCenterSettlRec);
            string txtFileDir = fileDir;//E:\GHSF\SCYBDownLoad\result.txt
            string[] lines = System.IO.File.ReadAllLines(txtFileDir);
            Global.writeLog(lines.ToString());

            DataTable dt = new DataTable();
            dt.Columns.Add("sn", typeof(int));
            dt.Columns.Add("psn_no", typeof(string));
            dt.Columns.Add("mdtrt_id", typeof(string));
            dt.Columns.Add("setl_id", typeof(string));
            dt.Columns.Add("msgid", typeof(string));
            dt.Columns.Add("stmt_rslt", typeof(string));
            dt.Columns.Add("refd_setl_flag", typeof(string));
            dt.Columns.Add("memo", typeof(string));
            dt.Columns.Add("medfee_sumamt", typeof(string));
            dt.Columns.Add("fund_pay_sumamt", typeof(string));
            dt.Columns.Add("acct_pay", typeof(string));

            //foreach (string line in lines)
            for (int i = 0; i < lines.Length; i++)
            {
                string[] strs = (lines[i] + "\t").Split('\t');
                DataRow dr = dt.NewRow();
                //Global.inf.writeLog(lines[i].ToString());
                //Global.inf.writeLog(strs.Length.ToString());

                dr["sn"] = i;
                dr["psn_no"] = strs[0];
                dr["mdtrt_id"] = strs[1];
                dr["setl_id"] = strs[2];
                dr["msgid"] = strs[3];
                dr["stmt_rslt"] = strs[4];
                dr["refd_setl_flag"] = strs[5];
                dr["memo"] = strs[6];
                dr["medfee_sumamt"] = strs[7];
                dr["fund_pay_sumamt"] = strs[8];
                dr["acct_pay"] = strs[9];
                //dr["Field2"] = strs[2];

                dt.Rows.Add(dr);
            }
            dgvCenterSettlRec.DataSource = dt;
        }

        private void tsmHandCheck_Click(object sender, EventArgs e)
        {
            JObject joData = JObject.Parse(rtbCheckDetailLog.Text);
            InvokeHelper invoker = new InvokeHelper();
            JObject joRtn = invoker.invokeCenterService(TradeEnum.FeeSummaryCheck, joData);
        }

        private void btClose_Click(object sender, EventArgs e)
        {
            Close();
        }

        #endregion       
    }

}