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); } } }