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;
using PTMedicalInsurance.Business;
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;
public string insuType { get; set; }
//医疗类别(人群类别）
public string med_type { get; set; }
public string fund_pay_type { get; set; }
private InvokeHelper invoker = new InvokeHelper();
private MIIrisServices mIS = new MIIrisServices();
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");
dt_ST.Text = DateTime.Now.ToString("yyyy-MM-01 00:00:00");
dt_ET.Text = DateTime.Now.ToString("yyyy-MM-dd 23:59:59");
dt_ST_Detail.Text = DateTime.Now.ToString("yyyy-MM-01 00:00:00");
dt_ET_Detail.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;
rbg_SettleDetailAdmType.SelectedIndex = 2;
//cbxInterface.SelectedValueChanged += new EventHandler(cbxInterface_SelectedValueChanged);
grdSetter.SetHeaderTextOfSettltMentFeelDetailInfo(dgvInsuFeeUpload);
grdSetter.SetHeaderTextOfSettltMentDetailInfo(dgv_SettleMentDetail);
grdSetter.DatagridviewColumnWidthAdaptation(dgvInsuFeeUpload);
grdSetter.DatagridviewColumnWidthAdaptation(dgv_SettleMentDetail);
initCombox(Global.inf.InsuCurrencyCataLogue);
}
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 ";
}
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)
{
if (dgvSettlRecord.RowCount <= 0)
{
MessageBox.Show("请先查询结算数据!");
return;
}
try
{
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();
JObject joRtn = GetFastReportParams("", AdmID, MdtrtID, SettlementID, ValidFlag);
if (JsonHelper.parseIrisRtnValue(joRtn, out string errMsg) != 0)
{
MessageBox.Show("获取FastReport入参失败：" + errMsg);
return;
}
string sFastReportParam = JsonHelper.getDestValue(joRtn, "result");
if (FastReportPrint(sFastReportParam, out errMsg) != 0)
{
MessageBox.Show("调用FastReport打印失败！" + errMsg);
return;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
return;
}
}
public void btnDesign_Click(object sender, EventArgs e)
{
if (dgvSettlRecord.RowCount <= 0)
{
MessageBox.Show("请先查询结算数据!");
return;
}
try
{
string errMsg;
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 PsnNo = dt.Rows[i]["PersonnelNO"].ToString();
//更新医保费用明细表
//JObject joRtnFee = UpdateMedInsuUploadData(AdmID, PsnNo, MdtrtID, SettlementID);
//if (JsonHelper.parseIrisRtnValue(joRtnFee, out errMsg) != 0)
//{
// MessageBox.Show("更新医保费用明细表失败：" + errMsg);
// return;
//}
JObject joRtn = GetFastReportParams("Y", AdmID, MdtrtID, SettlementID, ValidFlag);
if (JsonHelper.parseIrisRtnValue(joRtn, out errMsg) != 0)
{
MessageBox.Show("获取FastReport入参失败：" + errMsg);
return;
}
string sFastReportParam = JsonHelper.getDestValue(joRtn, "result");
if (FastReportPrint(sFastReportParam, out errMsg) != 0)
{
MessageBox.Show("调用FastReport设计失败！" + errMsg);
return;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
return;
}
}
public int FastReportPrint(string InParams,out string OutMsg)
{
Global.writeLog("调用FastReport入参：" + InParams);
try
{
#region【调用正版FastReport打印】
FastReportFrom.FastReportDll FrDll = new FastReportFrom.FastReportDll();
string sRtnFr = FrDll.FastReport(InParams);
JObject joRetObj = JObject.Parse(sRtnFr);
if (JsonHelper.parseIrisRtnValue(joRetObj, out string errMsg) != 0)
{
OutMsg = "调用FastReport打印失败！" + errMsg;
return -1;
}
else
{
OutMsg = "";
return 0;
}
#endregion
}
catch (Exception ex)
{
OutMsg = "调用FastReport打印失败！" + ex.Message;
return -1;
}
}
public JObject GetFastReportParams(string designFlag, string admID, string MdtrtID, string settlementID, string validFlag)
{
try
{
if (designFlag == "") { designFlag = "N"; }
#region【获取HIS医保结算信息】
JObject joSettel = new JObject();
joSettel.Add("HospitalDr", Global.inf.hospitalDr);
joSettel.Add("interfaceDr", Global.inf.interfaceDr);
joSettel.Add("admID", admID);
joSettel.Add("SettlementID", settlementID);
joSettel.Add("ValidFlag", validFlag);
joSettel.Add("MdtrtID", MdtrtID);
JObject joRtnSettle = invoker.invokeInsuService(JsonHelper.setIrisInpar("09010066", joSettel).ToString(), "获取结算单信息");
if (JsonHelper.parseIrisRtnValue(joRtnSettle, out string errMsg) != 0)
{
JObject joRtnSet = new JObject();
joRtnSet.Add("errorCode", -1);
joRtnSet.Add("errorMessage", errMsg);
joRtnSet.Add("result", "");
return joRtnSet;
}
#endregion
#region【组织FastReport调用入参】
JArray jachargeItemLvFee = JArray.Parse(JsonHelper.getDestValue(joRtnSettle, "result.data.chargeItemLvFee"));
JArray jaClassification = JArray.Parse(JsonHelper.getDestValue(joRtnSettle, "result.data.classification"));
JArray jaSettlement = JArray.Parse(JsonHelper.getDestValue(joRtnSettle, "result.data.settlement"));
JArray jaSettlementDetail = JArray.Parse(JsonHelper.getDestValue(joRtnSettle, "result.data.settlementDetail"));
JArray jaReginfo = JArray.Parse(JsonHelper.getDestValue(joRtnSettle, "result.data.reginfo"));
JArray japatinsuinfo = JArray.Parse(JsonHelper.getDestValue(joRtnSettle, "result.data.patinsuinfo"));
//转换金额大写
string Sumamt = FastReportFunction.MoneyToUpper(JsonHelper.getDestValue(joRtnSettle, "result.data.settlement[0].Sumamt").ToString());
string ActualPayDeductible = FastReportFunction.MoneyToUpper(JsonHelper.getDestValue(joRtnSettle, "result.data.settlement[0].ActualPayDeductible").ToString());
string PersonCashPay = FastReportFunction.MoneyToUpper(JsonHelper.getDestValue(joRtnSettle, "result.data.settlement[0].PersonCashPay").ToString());
string AccountPaySumamt = FastReportFunction.MoneyToUpper(JsonHelper.getDestValue(joRtnSettle, "result.data.settlement[0].AccountPaySumamt").ToString());
string FundPaySumamt = FastReportFunction.MoneyToUpper(JsonHelper.getDestValue(joRtnSettle, "result.data.settlement[0].FundPaySumamt").ToString());
string LargeExpensesSupplementPay = FastReportFunction.MoneyToUpper(JsonHelper.getDestValue(joRtnSettle, "result.data.settlement[0].LargeExpensesSupplementPay").ToString());
string SeriousIllnessPay = FastReportFunction.MoneyToUpper(JsonHelper.getDestValue(joRtnSettle, "result.data.settlement[0].SeriousIllnessPay").ToString());
string CivilserviceAllowancePay = FastReportFunction.MoneyToUpper(JsonHelper.getDestValue(joRtnSettle, "result.data.settlement[0].CivilserviceAllowancePay").ToString());
string MedicalAssistPay = FastReportFunction.MoneyToUpper(JsonHelper.getDestValue(joRtnSettle, "result.data.settlement[0].MedicalAssistPay").ToString());
string OtherPay = FastReportFunction.MoneyToUpper(JsonHelper.getDestValue(joRtnSettle, "result.data.settlement[0].OtherPay").ToString());
string HospitalPartAmount = FastReportFunction.MoneyToUpper(JsonHelper.getDestValue(joRtnSettle, "result.data.settlement[0].HospitalPartAmount").ToString());
string AccountMutualAidAmount = FastReportFunction.MoneyToUpper(JsonHelper.getDestValue(joRtnSettle, "result.data.settlement[0].AccountMutualAidAmount").ToString());
string InPolicyRangeAmount = FastReportFunction.MoneyToUpper(JsonHelper.getDestValue(joRtnSettle, "result.data.settlement[0].InPolicyRangeAmount").ToString());
string InsuAdmdvsCode = JsonHelper.getDestValue(joRtnSettle, "result.data.patinsuinfo[0].insuplcAdmdvs").ToString();
string InsuAdmdvsName = string.Empty;
if ((InsuAdmdvsCode == "321200") || (InsuAdmdvsCode == "321299"))
InsuAdmdvsName = "泰州市";
else if (InsuAdmdvsCode == "321202")
InsuAdmdvsName = "海陵区";
else if (InsuAdmdvsCode == "321203")
InsuAdmdvsName = "高港区";
else if (InsuAdmdvsCode == "321204")
InsuAdmdvsName = "姜堰区";
else if (InsuAdmdvsCode == "321281")
InsuAdmdvsName = "兴化市";
else if (InsuAdmdvsCode == "321282")
InsuAdmdvsName = "靖江市";
else if (InsuAdmdvsCode == "321283")
InsuAdmdvsName = "泰兴市";
else
InsuAdmdvsName = InsuAdmdvsCode;
//string BeginDate = JsonHelper.getDestValue(joRtnSettle, "result.data.reginfo[0].RegDate").ToString();
//string EndDate = JsonHelper.getDestValue(joRtnSettle, "result.data.settlement[0].HISDischargeTime").ToString();
//string InHosDays = FastReportFunction.DateDiff(Convert.ToDateTime(BeginDate), Convert.ToDateTime(EndDate));
JObject jaAmountChiness = new JObject();
jaAmountChiness.Add("Sumamt", Sumamt);
jaAmountChiness.Add("ActualPayDeductible", ActualPayDeductible);
jaAmountChiness.Add("PersonCashPay", PersonCashPay);
jaAmountChiness.Add("AccountPaySumamt", AccountPaySumamt);
jaAmountChiness.Add("FundPaySumamt", FundPaySumamt);
jaAmountChiness.Add("LargeExpensesSupplementPay", LargeExpensesSupplementPay);
jaAmountChiness.Add("SeriousIllnessPay", SeriousIllnessPay);
jaAmountChiness.Add("CivilserviceAllowancePay", CivilserviceAllowancePay);
jaAmountChiness.Add("MedicalAssistPay", MedicalAssistPay);
jaAmountChiness.Add("OtherPay", OtherPay);
jaAmountChiness.Add("HospitalPartAmount", HospitalPartAmount);
jaAmountChiness.Add("AccountMutualAidAmount", AccountMutualAidAmount);
jaAmountChiness.Add("InPolicyRangeAmount",InPolicyRangeAmount); //合规费用
jaAmountChiness.Add("SettlOpter", Global.user.name);
jaAmountChiness.Add("InsuAdmdvsName", InsuAdmdvsName);
JArray jachinessParams = new JArray();
jachinessParams.Add(jaAmountChiness);
JObject joDataResult = new JObject();
joDataResult.Add("SettlementInfo", jaSettlement);
joDataResult.Add("SettlementDetailInfo", jaSettlementDetail);
joDataResult.Add("ChargeItemLvFee", jachargeItemLvFee);
joDataResult.Add("ClassificationInfo", jaClassification);
joDataResult.Add("RegInfo", jaReginfo);
joDataResult.Add("Patinsuinfo", japatinsuinfo);
joDataResult.Add("ChinessSummat", jachinessParams);
JObject joParams = new JObject();
joParams.Add("fastReportCode", "SP11"); //这个要从表取值
joParams.Add("hospID", Global.inf.hisHospitalDr.ToString());
joParams.Add("printCode", Global.inf.interfaceDr.ToString());
joParams.Add("templateID", "");
JArray jaParams = new JArray();
jaParams.Add(joParams);
JObject joReportParams = new JObject();
joReportParams.Add("params", jaParams);
joReportParams.Add("code", "01040306");
JObject joParam = new JObject();
joParam.Add("designFlag", designFlag); //报表设计预览
joParam.Add("logFlag", "N");
joParam.Add("dataParams", "");
joParam.Add("pdfName", "");
joParam.Add("reportparams", joReportParams);
joParam.Add("dataResult", joDataResult);
JObject joDataURL = new JObject();
joDataURL.Add("dataIP", Global.hisConfig.ip);
joDataURL.Add("urlAddress", Global.hisConfig.url);
joDataURL.Add("authorization", Global.hisConfig.authorization);
joParam.Add("dataURL", joDataURL);
JArray jaParam = new JArray();
jaParam.Add(joParam);
JObject joInparam = new JObject();
joInparam.Add("params", JArray.FromObject(jaParam));
joInparam.Add("session", Global.curEvt.jaSession);
#endregion
JObject joRtn = new JObject();
joRtn.Add("errorCode", 0);
joRtn.Add("errorMessage", "");
joRtn.Add("result", joInparam.ToString());
return joRtn;
}
catch (Exception ex)
{
JObject joRtnEx = new JObject();
joRtnEx.Add("errorCode", -1);
joRtnEx.Add("errorMessage", ex.Message);
joRtnEx.Add("result", "");
return joRtnEx;
}
}
///
/// 【5204】费用明细查询更新医保费用上传记录表
///
///
public JObject UpdateMedInsuUploadData(string AdmID, string psnNo, string MdtrtID, string SettlementID)
{
string errorMsg, outParam;
if (string.IsNullOrEmpty(AdmID))
return JObject.Parse(JsonHelper.setExceptionJson(-1, "", "AdmID不能为空！").ToString());
if (string.IsNullOrEmpty(psnNo))
return JObject.Parse(JsonHelper.setExceptionJson(-1, "", "psnNo不能为空！").ToString());
if (string.IsNullOrEmpty(MdtrtID))
return JObject.Parse(JsonHelper.setExceptionJson(-1, "", "MdtrtID不能为空！").ToString());
if (string.IsNullOrEmpty(SettlementID))
return JObject.Parse(JsonHelper.setExceptionJson(-1, "", "settlementID不能为空！").ToString());
if (string.IsNullOrEmpty(Global.inf.hospitalDr.ToString()))
return JObject.Parse(JsonHelper.setExceptionJson(-1, "", "hospitalDr不能为空！").ToString());
try
{
#region【5204】费用明细查询
JObject joData = new JObject();
joData.Add("psn_no", psnNo);
joData.Add("setl_id", SettlementID);
joData.Add("mdtrt_id", MdtrtID);
JObject joInput = new JObject();
joInput.Add("data", joData);
JObject joRtn5204 = invoker.invokeCenterService(TradeEnum.InsuFeeUpdate, joInput);
if (JsonHelper.parseCenterRtnValue(joRtn5204, out errorMsg) != 0)
{
outParam = JsonHelper.setExceptionJson(-1, "【5204】费用明细查询失败！", errorMsg).ToString();
return JObject.Parse(outParam);
}
#endregion
JArray jaRtn5204 = JArray.Parse(JsonHelper.getDestValue(joRtn5204, "output"));
if (jaRtn5204.Count <= 0)
return JObject.Parse(JsonHelper.setExceptionJson(-1, "", "【5204】医保费用明细查询返回结果为空！").ToString());
dynamic joTmp = new JObject();
joTmp.code = "09010090";
JArray jaParams = jaRtn5204;
joTmp.Add("params", jaParams);
joTmp.HospitalDr = Global.inf.hospitalDr;
joTmp.InterfaceDr = Global.inf.InsuCurrencyCataLogue; //如果是通用目录就更新通用目录
joTmp.admID = AdmID;
joTmp.mdtrt_id = MdtrtID;
joTmp.psn_no = psnNo;
joTmp.updateUserID = Global.user.ID;
JObject joRtn = invoker.invokeInsuService(joTmp.ToString(), "更新医保费用上传明细表");
if (JsonHelper.parseIrisRtnValue(joRtn, out errorMsg) != 0)
{
outParam = JsonHelper.setExceptionJson(-1, "更新医保费用上传明细表失败！", errorMsg).ToString();
return JObject.Parse(outParam);
}
return joRtn;
}
catch (Exception ex)
{
JObject joRtnEx = new JObject();
joRtnEx.Add("errorCode", -1);
joRtnEx.Add("errorMessage", ex.Message);
return joRtnEx;
}
}
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;
}
}
private void btn_UpdateMedInsuFee_Click(object sender, EventArgs e)
{
string errorMsg;
if (dgvSettlRecord.RowCount <= 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 MdtrtID = dt.Rows[i]["MdtrtID"].ToString();
string PsnNo = dt.Rows[i]["PersonnelNO"].ToString();
#region【5204】1.医保费用明细查询 2.更新医保平台费用上传明细表
JObject joRtnFee = UpdateMedInsuUploadData(AdmID, PsnNo, MdtrtID, SettlementID);
if (JsonHelper.parseIrisRtnValue(joRtnFee, out errorMsg) != 0)
{
MessageBox.Show("更新医保费用明细表失败：" + errorMsg);
return;
}
else
{
MessageBox.Show("更新医保费用明细表成功");
}
#endregion
}
private void btnOK_Click(object sender, EventArgs e)
{
string sqlStr;
sqlStr = " SELECT top 500 a.Adm_Dr,c.InsuName as HISName,a.PatientName as Name, b.HISCode, b.MedInsuNO, b.Price,b.Sumamt,";
sqlStr = sqlStr + " b.ChargeItemLevel,'' ChargeItemLevelName,b.SelfPayProp, b.UpLimitAmount,b.OverLimitAmount, ";
sqlStr = sqlStr + " b.InScopeAmount,b.FullOwnPayAmount,b.PreSelfPayAmount,b.LimitUsedFlag, b.MedicalChargeItemType,\"Count\" ";
sqlStr = sqlStr + " FROM BS_MedInsuSettlement a LEFT JOIN BS_MedInsuFeeUploadRecord b ";
sqlStr = sqlStr + " ON a.Hospital_Dr=b.Hospital_Dr AND a.MdtrtID=b.MdtrtID AND a.PersonnelNO=b.PersonnelNO ";
sqlStr = sqlStr + " LEFT JOIN HB_MedInsuMapRelation c ON b.MedInsuNO=c.InsuCode AND a.Interface_Dr=c.Interface_Dr AND a.Hospital_Dr=c.Hospital_Dr ";
sqlStr = sqlStr + " WHERE b.MedInsuNO<>'' and a.ValidFlag=1 AND a.BillType=1 AND a.AdmType=2 ";
sqlStr = sqlStr + " AND a.Interface_Dr=" + Global.inf.interfaceDr;
sqlStr = sqlStr + " AND a.Hospital_Dr= " + Global.inf.hospitalDr;
sqlStr = sqlStr + " AND a.OccurTime>'" + dt_ST.Text + "'";
sqlStr = sqlStr + " AND a.OccurTime<'" + dt_ET.Text + "'";
if (tb_InHospNo.Text != "")
{
sqlStr = sqlStr + " and a.BillID='" + tb_InHospNo.Text + "'";
}
if (tb_SettleID.Text != "")
{
sqlStr = sqlStr + " and a.SettlementID='" + tb_SettleID.Text + "'";
}
if (tbPatientName.Text != "")
{
sqlStr = sqlStr + " and a.PatientName='" + tbPatientName.Text + "'";
}
if (tbCertNo.Text != "")
{
sqlStr = sqlStr + " and a.CertificateNO='" + tbCertNo.Text + "'";
}
if (cbbOverPrice.Text == "是")
{
sqlStr = sqlStr + " AND b.OverLimitAmount>0 ";
}
else if (cbbOverPrice.Text == "否")
{
sqlStr = sqlStr + " AND b.OverLimitAmount<=0 ";
}
if (cbbLevel.Text == "甲类")
{
sqlStr = sqlStr + " AND b.ChargeItemLevel='01' ";
}
else if (cbbLevel.Text == "乙类")
{
sqlStr = sqlStr + " AND b.ChargeItemLevel='02' ";
}
else if (cbbLevel.Text == "丙类")
{
sqlStr = sqlStr + " AND b.ChargeItemLevel='03' ";
}
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", "09010118");
JObject joRtn = invoker.invokeInsuService(joSettlQuery.ToString(), "查询医保结算费用信息");
DataTable dt = (DataTable)joRtn["result"]["data"].ToObject(typeof(DataTable));
dgvInsuFeeUpload.DataSource = dt;
}
private void bt_QuerySettleDetail_Click(object sender, EventArgs e)
{
string sqlStr, sqlStr_MX, sqlStr_HZ, sqlStr_Master;
sqlStr_MX = " SELECT a.SettlementID,a.PatientName,a.Gender,a.Age,a.CertificateNO,a.AdmType,b.PayTypeCode,b.PayTypeName,";
sqlStr_MX = sqlStr_MX + " b.SettlProcInfo,a.SettlementDateTime,b.InScopyAmount,b.CurrLimtAmount,b.FundPayAmount ";
sqlStr_HZ = " SELECT '合计','0','0','0','0','0','0','0',null,null,";
sqlStr_HZ = sqlStr_HZ + "sum(b.InScopyAmount),sum(b.CurrLimtAmount),sum(b.FundPayAmount) ";
sqlStr = " FROM BS_MedInsuSettlement a, BS_MedInsuSettlementDetail b ";
sqlStr = sqlStr + " WHERE a.Interface_Dr=b.Interface_Dr AND a.SettlementID=b.SettlementID ";
sqlStr = sqlStr + " AND a.ValidFlag=1 AND a.BillType=1 ";
sqlStr = sqlStr + " AND a.Interface_Dr=" + Global.inf.interfaceDr;
sqlStr = sqlStr + " AND a.Hospital_Dr= " + Global.inf.hospitalDr;
sqlStr = sqlStr + " AND a.OccurTime>'" + dt_ST_Detail.Text + "'";
sqlStr = sqlStr + " AND a.OccurTime<'" + dt_ET_Detail.Text + "'";
if (rbg_SettleDetailAdmType.SelectedIndex > 0)
sqlStr = sqlStr + " and a.AdmType=" + rbg_SettleDetailAdmType.SelectedIndex;
if (!string.IsNullOrEmpty(tb_SettleMentID.Text))
sqlStr = sqlStr + " and a.SettlementID='" + tb_SettleMentID.Text + "'";
if (!string.IsNullOrEmpty(tb_Name.Text))
sqlStr = sqlStr + " AND a.patientName='" + tb_Name.Text + "' ";
if (!string.IsNullOrEmpty(tb_CertNo.Text))
sqlStr = sqlStr + " AND a.CertificateNO='" + tb_CertNo.Text + "' ";
if (!string.IsNullOrEmpty(dblkcbxInsuranceType.Text))
sqlStr = sqlStr + " AND a.InsuranceType='"+ insuType +"'";
if (!string.IsNullOrEmpty(dblkcbxMedicalType.Text))
sqlStr = sqlStr + " AND a.MedicalType='" + med_type + "'";
if (!string.IsNullOrEmpty(dblkcbxFundPayType.Text))
sqlStr = sqlStr + " AND b.PayTypeCode='" + fund_pay_type + "'";
sqlStr_Master = sqlStr_MX + sqlStr + " UNION ALL " + sqlStr_HZ + sqlStr;
JObject joSqlstr = new JObject();
joSqlstr.Add("sqlStr", sqlStr_Master);
JArray jaParam = new JArray();
jaParam.Add(joSqlstr);
JObject joSettlQuery = new JObject();
joSettlQuery.Add("params", jaParam);
joSettlQuery.Add("code", "09010143");
JObject joRtn = invoker.invokeInsuService(joSettlQuery.ToString(), "查询医保结算明细信息");
DataTable dt = (DataTable)joRtn["result"]["data"].ToObject(typeof(DataTable));
dgv_SettleMentDetail.DataSource = dt;
}
private void initCombox(int InsuCurrencyCataLogue)
{
//获取通用目录
if (string.IsNullOrEmpty(InsuCurrencyCataLogue.ToString()))
{
string sTYML = mIS.GetCommonInterface_Dr(Global.inf.interfaceDr.ToString(), "");
if (string.IsNullOrEmpty(sTYML))
InsuCurrencyCataLogue = Global.inf.interfaceDr;
else
InsuCurrencyCataLogue = int.Parse(sTYML);
}
string sqlStr;
string sqlCondition = " and A.Interface_Dr = '" + InsuCurrencyCataLogue.ToString() + "'";
sqlStr = "SELECT B.Code,B.Descripts AS Name FROM HB_Dictionary A JOIN HB_DictionaryDataDetail B ON A.ID = B.HBDictionary_Dr WHERE A.InsuCode = 'insutype'" + sqlCondition;
SetDBLKCombox(ref dblkcbxInsuranceType, sqlStr);
sqlStr = "SELECT B.Code,B.Descripts AS Name FROM HB_Dictionary A JOIN HB_DictionaryDataDetail B ON A.ID = B.HBDictionary_Dr WHERE A.InsuCode = 'med_type'" + sqlCondition;
SetDBLKCombox(ref dblkcbxMedicalType, sqlStr);
sqlStr = "SELECT B.Code,B.Descripts AS Name FROM HB_Dictionary A JOIN HB_DictionaryDataDetail B ON A.ID = B.HBDictionary_Dr WHERE A.InsuCode = 'fund_pay_type'" + sqlCondition;
SetDBLKCombox(ref dblkcbxFundPayType, sqlStr);
}
private DataTable GetDBLKComboxTable(string sqlStr)
{
InvokeHelper invoker = new InvokeHelper();
dynamic joInparm = new JObject();
dynamic joTmp = new JObject();
joTmp.sqlStr = sqlStr;
JArray jaParams = new JArray();
jaParams.Add(joTmp);
joInparm.Add("params", JArray.FromObject(jaParams));
joInparm.code = "09010014";
string inParam = joInparm.ToString();
JObject joRtn = invoker.invokeInsuService(inParam, "获取下拉框消息");
//dynamic jsonRtn = JsonConvert.DeserializeObject(strRtn);
DataTable dt = (DataTable)joRtn["result"].ToObject(typeof(DataTable));
//dt.Columns[0].ColumnName = "编码";
//dt.Columns[1].ColumnName = "名称";
//dt.Columns[2].ColumnName = "拼音查找码";
return dt;
}
private void SetDBLKCombox(ref PTControl.DBLookupCombox dblcbx, string sqlStr)
{
dblcbx.sDisplayField = "Code,Name,SearchCode";
dblcbx.sDisplayMember = "名称";
dblcbx.sKeyWords = "Code,SearchCode";
DataTable dt = GetDBLKComboxTable(sqlStr);
dblcbx.DataSource = dt;
if (dt?.Rows.Count > 0)
{
// default to select first one;
}
dblcbx.RowFilterVisible = true;
dblcbx.TextBox.Width = 400;
dblcbx.DataGridView.Width = 400;
dblcbx.DataGridView.Columns[0].Name = "编码";
dblcbx.DataGridView.Columns[1].Name = "名称";
dblcbx.DataGridView.Columns[2].Name = "查找码";
dblcbx.DataGridView.Columns[0].Width = 100;
dblcbx.DataGridView.Columns[1].Width = 200;
}
private void dblkcbxInsuranceType_AfterSelector(object sender, PTControl.AfterSelectorEventArgs e)
{
DataGridViewRow row = e.Value as DataGridViewRow;
DataRowView dataRow = row.DataBoundItem as DataRowView;
insuType = dataRow["Code"].ToString().Trim();
//insuTypeName = dataRow["Name"].ToString().Trim();
}
private void dblkcbxMedicalType_AfterSelector(object sender, PTControl.AfterSelectorEventArgs e)
{
DataGridViewRow row = e.Value as DataGridViewRow;
DataRowView dataRow = row.DataBoundItem as DataRowView;
med_type = dataRow["Code"].ToString().Trim();
//med_type_name = dataRow["Name"].ToString().Trim();
}
private void dblkcbxFundPayType_AfterSelector(object sender, PTControl.AfterSelectorEventArgs e)
{
DataGridViewRow row = e.Value as DataGridViewRow;
DataRowView dataRow = row.DataBoundItem as DataRowView;
fund_pay_type = dataRow["Code"].ToString().Trim();
}
}
}