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 { private int hospitalDr; private int interfaceDr; private string hospitalNO; private string interfaceNO; private string hospitalName; private string hospitalAreaCode; public SettlementChecklist() { InitializeComponent(); hospitalDr = GlobalVariables.hospitalDr; hospitalNO = GlobalVariables.hospitalNO; hospitalName = GlobalVariables.hospitalName; hospitalAreaCode = GlobalVariables.hospitalAreaCode; } public SettlementChecklist(JObject joParam) { InitializeComponent(); hospitalDr = GlobalVariables.hospitalDr; hospitalNO = GlobalVariables.hospitalNO; hospitalName = GlobalVariables.hospitalName; hospitalAreaCode = GlobalVariables.hospitalAreaCode; if (joParam == null) return; string setl_id = JsonHelper.getJsonValue(joParam, "setl_id"); if (setl_id == "") { MessageBox.Show("根据传入的结算编号为查询到相关信息,请手动输入查询!"); return; } string sqlStr = "SELECT * FROM MedInsu_Tables.Settlement WHERE Hosp_Dr=" + GlobalVariables.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 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=" + 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=" + GlobalVariables.interfaceDr + ""; //} //if (rbgAdmType.SelectedIndex == 1) //{ // sqlStr = sqlStr + " and Adm_Dr=1" ; //} //if (rbgAdmType.SelectedIndex == 2) //{ // sqlStr = sqlStr + " and Adm_Dr=2"; //} if (rbgBillType.SelectedIndex == 1) { sqlStr = sqlStr + " and BillType=1"; } if (rbgBillType.SelectedIndex == 2) { sqlStr = sqlStr + " and BillType=-1"; } 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", hospitalAreaCode);//结算单需要存字段 joInparam.Add("fixmedins_code", hospitalNO); joInparam.Add("fixmedins_name", hospitalName); invoker.printYHCom(joInparam.ToString(), out printRtn); JObject joRtn = JObject.Parse(printRtn); if (JsonHelper.getJsonValue(joRtn, "code") != "1") { MessageBox.Show(JsonHelper.getJsonValue(joRtn, "message")); } } private void SettlementChecklist_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 = 0; 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; //赋值 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(); //GlobalVariables.centerURL = dt.Rows[i]["CenterURL"].ToString(); //GlobalVariables.businessDllName = dt.Rows[i]["DLLName"].ToString(); //GlobalVariables.patientAreaCode = dt.Rows[i]["AreaCode"].ToString(); } private void uiPanel1_Click(object sender, EventArgs e) { } } }