MedicalInsurance/ChengDu/ChengDuMedInsu2/Forms/SettlementChecklist1.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 MedicalInsurance.Helper;
using MedicalInsurance.Common;
using Newtonsoft.Json.Linq;
using MedicalInsurance.FormSetter;

namespace MedicalInsurance.Forms
{
    public partial class SettlementChecklist : Form
    {
        public SettlementChecklist()
        {
            InitializeComponent();
        }

        private void rbgDirecType_ValueChanged(object sender, int index, string text)
        {

        }

        private void btnQuery_Click(object sender, EventArgs e)
        {

        }

        private void btnQuery_Click_1(object sender, EventArgs e)
        {

            string sqlStr = "SELECT * FROM  MedInsu_Tables.Settlement WHERE Hosp_Dr=" + GlobalVariables.hospitalDr ;
            sqlStr = sqlStr + " and OccurTime>'" + dpST.Text + "'";
            sqlStr = sqlStr + " and OccurTime<'" + dpED.Text + "'";

            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 btnDownload_Click(object sender, EventArgs e)
        {
            InvokeHelper invoker = new InvokeHelper();
            DataTable dt =(DataTable)dgvSettlRecord.DataSource  ;

            string printRtn = "";
            JObject joInparam = new JObject();
            int a = dgvSettlRecord.CurrentRow.Index;
            joInparam.Add("setl_id", dt.Rows[a]["SettlementID"].ToString());
            joInparam.Add("psn_no", dt.Rows[a]["PersonnelNO"].ToString());
            joInparam.Add("mdtrt_id", dt.Rows[a]["MdtrtID"].ToString());
            joInparam.Add("med_type", dt.Rows[a]["MedicalType"].ToString());
            joInparam.Add("mdtrtarea_admvs", dt.Rows[a]["ClearingOrgan"].ToString());
            joInparam.Add("fixmedins_code", GlobalVariables.hospitalNO);
            joInparam.Add("fixmedins_name", GlobalVariables.hospitalName);
            invoker.printYHCom(joInparam.ToString(), out printRtn);
        }

        private void SettlementChecklist_Load(object sender, EventArgs e)
        {
            GridViewSetter gdvSetter = new GridViewSetter();
            dgvSettlRecord.AutoGenerateColumns = false;
            gdvSetter.SetHeaderTextOfSettlList(dgvSettlRecord);
        }
    }
}