MedicalInsurance/BeiJingMI/Forms/SettlementBilllist.cs

using Newtonsoft.Json.Linq;
using PTMedicalInsurance.Common;
using PTMedicalInsurance.FormSetter;
using PTMedicalInsurance.Helper;
using PTMedicalInsurance.Variables;
using System;
using System.Data;
using System.Windows.Forms;


namespace PTMedicalInsurance.Forms
{
    public partial class SettlementBillPrint : Form
    {
        private int hospitalDr;
        private int interfaceDr;
        private string hospitalNO;
        private string interfaceNO;
        private string hospitalName;
        private string hospitalAreaCode;
        System.Type ComType;
        object ComInstance;

        private InvokeHelper invoker = new InvokeHelper();
        ReadCardClass rcl = new ReadCardClass();

        public SettlementBillPrint()
        {
            InitializeComponent();
            hospitalDr = Global.inf.hospitalDr;
            hospitalNO = Global.inf.hospitalNO;
            hospitalName = Global.inf.hospitalName;
            hospitalAreaCode = Global.inf.areaCode;
            interfaceDr = Global.inf.interfaceDr;
        }

        public SettlementBillPrint(JObject joParam)
        {
            InitializeComponent();
            hospitalDr = Global.inf.hospitalDr;
            hospitalNO = Global.inf.hospitalNO;
            hospitalName = Global.inf.hospitalName;
            hospitalAreaCode = Global.inf.areaCode;

            if (joParam == null) return;

            string setl_id = JsonHelper.getDestValue(joParam, "setl_id");
            if (setl_id == "")
            {
                MessageBox.Show("根据传入的结算编号为查询到相关信息，请手动输入查询！");
                return;
            }
            string sqlStr = "SELECT * FROM  BS_MedInsuSettlement WHERE Hospital_Dr=" + Global.inf.hospitalDr;
            sqlStr = sqlStr + " and SettlementID='" + setl_id + "'";

            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));
            dgvSettlRecord.DataSource = dt;
        }

        private void SettlementBillPrint_Load(object sender, EventArgs e)
        {
            dpST.Text = DateTime.Now.ToString("yyyy-MM-dd 00:00:00");
            dpED.Text = DateTime.Now.ToString("yyyy-MM-dd 23:59:59");
            ComboxSetter cbxSetter = new ComboxSetter();
            cbxSetter.setCbxInterfaceDataSource(cbxInterface);
            GridViewSetter grdSetter = new GridViewSetter();
            grdSetter.SetHeaderTextOfSettlList(dgvSettlRecord);
            rbgAdmType.SelectedIndex = 2;
            rbgBillType.SelectedIndex = 1;
            //cbxInterface.SelectedValueChanged += new EventHandler(cbxInterface_SelectedValueChanged);
        }

        private void cbxInterface_SelectedValueChanged(object sender, EventArgs e)
        {
            DataTable dt = (DataTable)cbxInterface.DataSource;
            int i = cbxInterface.SelectedIndex;

            if (i >= 0)
            {
                //赋值
                hospitalNO = dt.Rows[i]["HospitalNO"].ToString();
                //MessageBox.Show(dt.Rows[i]["HospitalDr"].ToString());
                //MessageBox.Show(dt.Rows[i]["HospitalDr"].ToString(), "提示", MessageBoxButtons.OK, MessageBoxIcon.Information, MessageBoxDefaultButton.Button1, MessageBoxOptions.DefaultDesktopOnly);
                hospitalDr = int.Parse(dt.Rows[i]["HospitalDr"].ToString());
                interfaceNO = dt.Rows[i]["InterfaceNO"].ToString();
                interfaceDr = int.Parse(dt.Rows[i]["ID"].ToString());
                hospitalAreaCode = dt.Rows[i]["AreaCode"].ToString();
                //Global.inf.centerURL = dt.Rows[i]["CenterURL"].ToString();
                //Global.inf.businessDllName = dt.Rows[i]["DLLName"].ToString();
                //Global.inf.patientAreaCode = dt.Rows[i]["AreaCode"].ToString();    
            }
        }

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

        private void btnQuery_Click(object sender, EventArgs e)
        {
            string sqlStr = " SELECT * FROM  BS_MedInsuSettlement WHERE Hospital_Dr=" + hospitalDr;
            sqlStr = sqlStr + " and OccurTime>'" + dpST.Text + "'";
            sqlStr = sqlStr + " and OccurTime<'" + dpED.Text + "'";
            if (tbName.Text != "")
            {
                sqlStr = sqlStr + " and PatientName='" + tbName.Text + "'";
            }
            if (tbPatSettlID.Text != "")
            {
                sqlStr = sqlStr + " and SettlementID='" + tbPatSettlID.Text + "'";
            }
            if (tbHisNO.Text != "")
            {
                sqlStr = sqlStr + " and Adm_Dr='" + tbHisNO.Text + "'";
            }
            if (cbxInterface.Text != "")
            {
                sqlStr = sqlStr + " and Interface_Dr=" + Global.inf.interfaceDr + "";
            }
            if (rbgAdmType.SelectedIndex == 1)
            {
                sqlStr = sqlStr + " and AdmType=2";
            }
            if (rbgAdmType.SelectedIndex == 2)
            {
                sqlStr = sqlStr + " and AdmType=1";
            }
            if (rbgBillType.SelectedIndex == 1)
            {
                sqlStr = sqlStr + " and BillType=1 and ValidFlag=1 ";
            }
            if (rbgBillType.SelectedIndex == 2)
            {
                sqlStr = sqlStr + " and BillType=-1 and ValidFlag=0 ";
            }

            sqlStr = sqlStr + " Order By ID DESC ";

            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");
            JObject joRtn = invoker.invokeInsuService(joSettlQuery.ToString(), "查询结算信息");

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

        public void btnPrint_Click(object sender, EventArgs e)
        {
            string sContrl_XML, sData_XML,FunName, AppRtnMsg,sLocal;
            string OpenMsg, CloseMsg;
            string sYWLSH = "HIS05155009" + DateTime.Now.ToString("yyMMddHHmmss"); //自定义业务流水号

            if (dgvSettlRecord.RowCount <= 0)
            {
                MessageBox.Show("请先查询结算数据!");
                return;
            }

            try
            {
                //创建首信医保Com实例
                if (rcl.CreateBusinessObj(out ComType, out ComInstance) != 0)
                {
                    MessageBox.Show("收据打印实例创建失败！");
                    return;
                }

                int i = dgvSettlRecord.CurrentRow.Index;
                DataTable dt = (DataTable)dgvSettlRecord.DataSource;
                string AdmID = dt.Rows[i]["AdmID"].ToString();
                string SettlementID = dt.Rows[i]["SettlementID"].ToString();
                string ValidFlag = dt.Rows[i]["ValidFlag"].ToString();
                string MdtrtID = dt.Rows[i]["MdtrtID"].ToString();
                string iOtherProvLocal = dt.Rows[i]["ClearingWay"].ToString(); //异地标志 0本地 1异地
                string OrganSettlementID = dt.Rows[i]["OrganSettlementID"].ToString(); //门诊结算返回feeno收费单据号存在结算表msgid字段
                string RecordID = dt.Rows[i]["RecordID"].ToString();

                string BillType = dt.Rows[i]["BillType"].ToString();

                if (iOtherProvLocal == "0")
                {
                    //本地收据打印PrintInvoice
                    sData_XML = "<tradeno>" + SettlementID + "</tradeno>"  // name = "交易流水号"
                              + "<invoiceno>" + OrganSettlementID + "</invoiceno>"   // name = "收费单据号" feeno
                              + "<businessinfo>" + sYWLSH + "</businessinfo>"   // name ="业务流水号"
                              + "<hosptype>盈利性一级专科</hosptype>"       // name="医疗机构类型"
                              + "<Feecode>" + RecordID + "</Feecode>"   // name="票据代码"   HIS结算完成后 生成票据代码 传给DLL 
                              + "<Outpatientno> " + AdmID + "</Outpatientno>"; 

                    FunName = "PrintInvoice";
                    sLocal = "本地收据打印PrintInvoice：";
                }
                else
                {
                    string histradeno;
                    if (BillType == "1")
                        histradeno = OrganSettlementID;
                    else
                        histradeno = OrganSettlementID + "-1";

                    //异地收据打印PrintInvoiceNation
                    sData_XML = "<HisTradeNo>" + histradeno + "</HisTradeNo>"  // name = "交易流水号"
                              + "<invoiceno>" + OrganSettlementID + "</invoiceno>"   // name = "收费单据号"
                              + "<businessinfo>" + sYWLSH + "</businessinfo>"   // name ="业务流水号"
                              + "<hosptype>盈利性一级专科</hosptype>"       // name="医疗机构类型"
                              + "<Feecode>" + RecordID + "</Feecode>"   // name="票据代码"
                              + "<Outpatientno>" + RecordID + "</Outpatientno>";

                    FunName = "PrintInvoiceNation";
                    sLocal = "异地收据打印PrintInvoiceNation：";
                }
                       
                sData_XML = JsonHelper.GetinPar(sData_XML, 2);

                //读卡前先Open             
                rcl.Open(ComType, ComInstance, out OpenMsg);
                rcl.BussniessObj(FunName, sData_XML, ComType, ComInstance, out AppRtnMsg);
                rcl.Close(ComType, ComInstance, out CloseMsg);
            }
            catch (Exception ex)
            {
                rcl.Close(ComType, ComInstance, out CloseMsg);
                MessageBox.Show(ex.Message);
                return;
            }
        }       
            
        private JObject getPatCheckList()
        {
            try
            {
                int i = dgvSettlRecord.CurrentRow.Index;
                DataTable dt = (DataTable)dgvSettlRecord.DataSource;
                JObject joSettel = new JObject();
                joSettel.Add("HospitalDr", Global.inf.hospitalDr);
                joSettel.Add("interfaceDr", Global.inf.interfaceDr);
                joSettel.Add("admID", dt.Rows[i]["AdmID"].ToString());
                joSettel.Add("SettlementID", dt.Rows[i]["SettlementID"].ToString());
                joSettel.Add("ValidFlag", dt.Rows[i]["ValidFlag"].ToString());

                JObject joRtn = invoker.invokeInsuService(JsonHelper.setIrisInpar("09010066", joSettel).ToString(), "获取结算单信息");
                return joRtn;
            }
            catch (Exception ex)
            {
                JObject joRtn = new JObject();
                joRtn.Add("errorCode", -1);
                joRtn.Add("errorMessage", ex.Message);
                return joRtn;
            }
        }


    }
}