private bool CheckInHosSaving() { try { string sql = "SELECT ID,STARTNUMBER,CURRNUMBER,ENDNUMBER,SURPLUSNUMBER FROM T_OPERATOR_INVOICE WHERE INVOICETYPE=:INVOICETYPE AND OPERATORID=:OPERATORID AND SURPLUSNUMBER>'0' AND CURRNUMBER<=ENDNUMBER ORDER BY ID"; Hashtable para = new Hashtable(); para.Add(":INVOICETYPE", "预交款发票"); para.Add(":OPERATORID", SysOperatorInfo.OperatorID); QuerySolutionFacade facadem = new QuerySolutionFacade(); DataSet dsAdvance = facadem.ExeQuery(sql, para); if (dsAdvance == null || dsAdvance.Tables.Count == 0 || dsAdvance.Tables[0].Rows.Count == 0) { SkyComm.ShowMessageInfo("该自助机无可用发票,请到其他自助机进行预存操作!"); return(false); } Int64 currnumber = Convert.ToInt64(dsAdvance.Tables[0].Rows[0]["CURRNUMBER"]); if (currnumber > Convert.ToInt64(dsAdvance.Tables[0].Rows[0]["ENDNUMBER"])) { SkyComm.ShowMessageInfo("该自助机已无可用发票,请到其他自助机进行预存操作!"); return(false); } return(true); } catch (Exception ex) { Skynet.LoggingService.LogService.GlobalErrorMessage("检测是否可进行住院预存方法调用失败,原因:" + ex.Message); SkyComm.ShowMessageInfo("该自助机暂无法进行住院预存操作,请到其他自助机进行住院预存!"); return(false); } }
private DataSet GetAdvanceRecord() { try { string sql = " SELECT H_ADVANCE_RECORD.*,H_CHARGE_TYPE.CHARGETYPE AS PAYMODE, T_PATIENT_INFO.PATIENTNAME ,T_OPERATOR.OPERATORNAME" + " FROM H_ADVANCE_RECORD,H_CHARGE_TYPE ,H_INHOS_RECORD,T_PATIENT_INFO,T_OPERATOR" + " WHERE H_ADVANCE_RECORD.PAYMODEID = H_CHARGE_TYPE.CHARGETYPEID " + " AND H_ADVANCE_RECORD.INHOSID = H_INHOS_RECORD.INHOSID " + " AND H_INHOS_RECORD.DIAGNOSEID = T_PATIENT_INFO.DIAGNOSEID " + " AND H_ADVANCE_RECORD.OPERATORID = T_OPERATOR.OPERATORID " + " AND H_ADVANCE_RECORD.INHOSID = @INHOSID " + " ORDER BY OPERATEDATE"; Hashtable htm = new Hashtable(); htm.Add("@INHOSID", _inHosID); QuerySolutionFacade facadem = new QuerySolutionFacade(); DataSet dsAdvance = facadem.ExeQuery(sql, htm); return(dsAdvance); } catch (Exception ex) { Skynet.LoggingService.LogService.GlobalErrorMessage("调用住院预交金充值记录查询失败,原因:" + ex.Message); return(null); } }
public DataSet getBankInfo(string id, string HisSeqNo) { string sql = "SELECT * FROM T_BANKHISEXCHANGE_TRANS a where a.DIAGNOSEID = @HISID and a.HISSEQNO = @HISSEQNO"; DataSet dataSet = new DataSet(); Hashtable ht = new Hashtable(); ht.Add("@HISID", id); ht.Add("@HISSEQNO", HisSeqNo); QuerySolutionFacade querySolutionFacade = new QuerySolutionFacade(); return(querySolutionFacade.ExeQuery(sql, ht)); }
public DataSet getPayType(string id) { string sql = "SELECT * FROM H_CHARGE_TYPE a where a.CHARGETYPEID = @CHARGETYPEID"; DataSet dataSet = new DataSet(); Hashtable ht = new Hashtable(); ht.Add("@CHARGETYPEID", id); QuerySolutionFacade querySolutionFacade = new QuerySolutionFacade(); return(querySolutionFacade.ExeQuery(sql, ht)); }
public List <string> getRequestBaseData(Hashtable hashtable) { EInterfaceinfoFacade interfacefacade = new EInterfaceinfoFacade(); string userArea = hashtable["使用范围"].ToString(); string type = hashtable["接口类型"].ToString(); LogService.GlobalInfoMessage("进入撤销方法,userArea=" + userArea + ",type=" + type); string sql = "select * from E_INTERFACEINFO where ISTATUS=0 and IUSEAREA=2 and ITYPE='支付接口' and INAME='云平台支付接口'"; Hashtable h1 = new Hashtable(); QuerySolutionFacade querySolutionFacade = new QuerySolutionFacade(); //DataSet dsInterface = interfacefacade.dsInterfaceInfo(userArea, type, "云平台支付接口"); DataSet dsInterface = querySolutionFacade.ExecCustomQuery(sql); LogService.GlobalInfoMessage("调用云平台。获取接口相关信息count=" + dsInterface.Tables[0].Rows.Count); string token = string.Empty; string hosId = ""; string strUrl = string.Empty; if (dsInterface.Tables[0].Rows.Count > 0) { LogService.GlobalInfoMessage("调用云平台。获取接口相关信息:" + dsInterface.Tables[0].Rows[0]["IDESCRIPTION"].ToString() + "|" + dsInterface.Tables[0].Rows[0]["IPARAMFORMAT"].ToString() + "|" + dsInterface.Tables[0].Rows[0]["IURL"].ToString()); token = dsInterface.Tables[0].Rows[0]["IDESCRIPTION"].ToString(); hosId = dsInterface.Tables[0].Rows[0]["IPARAMFORMAT"].ToString(); strUrl = dsInterface.Tables[0].Rows[0]["IURL"].ToString(); } List <string> mList = new List <string>(); try { mList.Add(token.Split('|')[0]); LogService.GlobalInfoMessage("token:" + token.Split('|')[0]); } catch (Exception e) { mList.Add(token); } mList.Add(hosId); LogService.GlobalInfoMessage("hosId:" + hosId); mList.Add(strUrl); LogService.GlobalInfoMessage("strUrl:" + strUrl); return(mList); }
public string getType(string id) { string sql = "SELECT * FROM S_CHARGE_KIND a where a.CHARGEKINDID = @CHARGEKINDID"; DataSet dataSet = new DataSet(); Hashtable ht = new Hashtable(); ht.Add("@CHARGEKINDID", id); QuerySolutionFacade querySolutionFacade = new QuerySolutionFacade(); dataSet = querySolutionFacade.ExeQuery(sql, ht); return(dataSet.Tables[0].Rows[0]["CHARGEKIND"].ToString()); }
public string GetStartTime() { QuerySolutionFacade querySolutionFacade = new QuerySolutionFacade(); DetailAccountFacade detailAccountFacade = new DetailAccountFacade(); string mechinNo = string.Empty; #region 获取ip string ipAddress = null; try { string hostName = Dns.GetHostName(); IPHostEntry ipEntry = Dns.GetHostEntry(hostName); for (int i = 0; i < ipEntry.AddressList.Length; i++) { if (ipEntry.AddressList[i].AddressFamily == AddressFamily.InterNetwork) { ipAddress = ipEntry.AddressList[i].ToString(); } } } catch (Exception ex) { } #endregion #region 获取机器码 string sql1 = "select * from T_AUTOSERVICEMACHINE_INFO where IPADDRESS = @IPADDRESS"; Hashtable hashtable1 = new Hashtable(); hashtable1.Add("@IPADDRESS", ipAddress); DataSet dataSet = querySolutionFacade.ExeQuery(sql1, hashtable1); if (dataSet.Tables[0].Rows.Count > 0) { mechinNo = dataSet.Tables[0].Rows[0]["MACHINENO"].ToString(); } string MBeginTime = DateTime.Now.ToLocalTime().ToString();; string MEndTime = DateTime.Now.ToLocalTime().ToString();; string sql3 = "select * from SETTLEMENT_TIME where M_NO = @M_NO"; Hashtable hashtable3 = new Hashtable(); hashtable3.Add("@M_NO", mechinNo); DataSet dataSet3 = querySolutionFacade.ExeQuery(sql3, hashtable3); if (dataSet3.Tables[0].Rows.Count > 0) { MBeginTime = dataSet3.Tables[0].Rows[0]["TIMES"].ToString(); } return(MBeginTime); #endregion }
/// <summary> /// 查询检验中间表,查询患者检验报告信息 /// </summary> /// <returns></returns> private DataTable GetListData() { try { DataTable dtAllReport = this.CreateDataTable(); #region 查询杏和LIS数据 StringBuilder sb = new StringBuilder(); sb.Append("select distinct OUTPATIENT_ID,REQUISITION_ID,TEST_ORDER_NAME,SAMPLING_TIME from HIS_INSPECTION_SAMPLE left outer join T_PRINT_RECORD tp on HIS_INSPECTION_SAMPLE.REQUISITION_ID=tp.PRINTBUSINESSID where PATIENT_TYPE='2'and OUTPATIENT_ID=@OUTPATIENT_ID AND ( SAMPLING_TIME IS NOT NULL OR SAMPLING_TIME<>'') AND LENGTH(SAMPLING_TIME)>6 AND TP.PRINTCOUNT IS NULL"); Hashtable ht1 = new Hashtable(); ht1.Add("@OUTPATIENT_ID", SkyComm.eCardAuthorizationData.Tables[0].Rows[0]["DIAGNOSEID"].ToString()); QuerySolutionFacade facade1 = new QuerySolutionFacade(); DataSet ds1 = facade1.ExeQuery(sb.ToString(), ht1); if (ds1 != null && ds1.Tables.Count != 0 && ds1.Tables[0].Rows.Count != 0) { for (int i = 0; i < ds1.Tables[0].Rows.Count; i++) { string ora_startDate = new CommonFacade().GetServerDateTime().AddMonths(-3).ToString("yyyy-MM-dd 00:00:00"); if (ds1.Tables[0].Rows[i]["SAMPLING_TIME"].ToString().Trim() != "") { DateTime samplingTime = Convert.ToDateTime(ds1.Tables[0].Rows[i]["SAMPLING_TIME"].ToString().Trim().Replace("@", ":")); ds1.Tables[0].Rows[i]["SAMPLING_TIME"] = samplingTime.ToString("yyyy-MM-dd HH:mm:ss"); if (samplingTime <= Convert.ToDateTime(ora_startDate)) { continue; } } else { continue; } object[] obj = new object[dtAllReport.Columns.Count]; ds1.Tables[0].Rows[i].ItemArray.CopyTo(obj, 0); dtAllReport.Rows.Add(obj); } } #endregion return(dtAllReport); } catch (Exception ex) { Skynet.LoggingService.LogService.GlobalErrorMessage("查询检验结果报表失败,原因:" + ex.Message); return(null); } }
/// <summary> /// 保存基础交易信息 /// </summary> public void saveTradeInfo(Hashtable hashtable) { string mSql = "INSERT INTO T_BANKHISEXCHANGE_TRANS (HISSEQNO,BANKSTATE,HISSTATE,BUSCD,HISID,TRFAMT,USETYPE,OPERATORID,OPERATETIME,DIAGNOSEID,BUSINESSTYPE,DATASOURCES,OHISSEQNO,BANKSEQNO,PAYCHANNELS) VALUES (@HISSEQNO ,@BANKSTATE,@HISSTATE,@BUSCD,@HISID,@TRFAMT,@USETYPE,@OPERATORID,@OPERATETIME,@DIAGNOSEID,@BUSINESSTYPE,@DATASOURCES,'','','原生接口支付')"; string start = DateTime.Now.ToString("yyyy-MM-dd ") + " 00:00:00"; QuerySolutionFacade querySolutionFacade = new QuerySolutionFacade(); int i = querySolutionFacade.ExeNonQuery(mSql, hashtable); if (i <= 0) { throw new Exception("保存基础信息失败!"); } }
public string getOfficeName(string id) { DataSet dataSet = new DataSet(); string sql = "select * from T_OFFICE a where a.OFFICEID = @OFFICEID"; Hashtable ht = new Hashtable(); ht.Add("@OFFICEID", id); QuerySolutionFacade querySolutionFacade = new QuerySolutionFacade(); dataSet = querySolutionFacade.ExeQuery(sql, ht); return(dataSet.Tables[0].Rows[0]["OFFICE"].ToString()); }
public DataSet getPayResult(string hisSerialNo) { DataSet data = new DataSet(); Hashtable hashtable = new Hashtable(); hashtable.Add("@HISSEQNO", hisSerialNo); string mSql = "SELECT * FROM T_BANKHISEXCHANGE_TRANS where HISSEQNO = @HISSEQNO";// and BANKSTATE = '1' QuerySolutionFacade querySolutionFacade = new QuerySolutionFacade(); data = querySolutionFacade.ExeQuery(mSql, hashtable); return(data); }
public void updateHisState(string hisSerialNo) { string mSql = "UPDATE T_BANKHISEXCHANGE_TRANS set HISSTATE = '1' where HISSEQNO = @HISSEQNO"; Hashtable hashtable = new Hashtable(); hashtable.Add("@HISSEQNO", hisSerialNo); QuerySolutionFacade querySolutionFacade = new QuerySolutionFacade(); int i = querySolutionFacade.ExeNonQuery(mSql, hashtable); if (i <= 0) { throw new Exception("更新医院状态失败!"); } }
public DataSet getWindowIdSend(string dignoseID) { string mSql = " select DISTINCT D_ECIPE_MEDICINE.DIAGNOSEID,T_PATIENT_INFO.PATIENTNAME,D_ECIPE_MEDICINE.OPERATEDATE , P_DOSAGE.WINDOWID,P_DOSAGE.PHARMACYID,P_PHARMACYWINDOW.PHARMARYWINDOWID,P_PHARMACYWINDOW.WINDOWNAME\r\nfrom P_DOSAGE,D_ECIPE_MEDICINE,T_PATIENT_INFO,T_OFFICE,T_USERS,P_PHARMACYWINDOW where D_ECIPE_MEDICINE.OPERATEDATE>@OPERATEDATE and P_DOSAGE.DOSAGESTATE= 0 AND P_DOSAGE.DETAILACCOUNTID = D_ECIPE_MEDICINE.DETAILACCOUNTID AND CANCELMARK = 0 AND SENDLEECHDOMMARK = 0 AND D_ECIPE_MEDICINE.DIAGNOSEID = T_PATIENT_INFO.DIAGNOSEID AND REGISTEROFFICEID = T_OFFICE.OFFICEID AND DOCTORID = USERID AND P_DOSAGE.MEDICALCODE = D_ECIPE_MEDICINE.MEDICALCODE AND D_ECIPE_MEDICINE.MEDICALCODE =T_PATIENT_INFO.MEDICALCODE AND T_PATIENT_INFO.MEDICALCODE =T_OFFICE.MEDICALCODE AND T_OFFICE.MEDICALCODE =T_USERS.MEDICALCODE AND T_USERS.MEDICALCODE = @MEDICALCODE and P_PHARMACYWINDOW.WINDOWTYPE = '发药' and P_DOSAGE.PHARMACYID = P_PHARMACYWINDOW.PHARMACYID and P_DOSAGE.WINDOWID = P_PHARMACYWINDOW.WINDOWID "; string start = DateTime.Now.ToString("yyyy-MM-dd ") + " 00:00:00"; DataSet mDataSet = new DataSet(); Hashtable ht = new Hashtable(); ht.Add("@OPERATEDATE", Convert.ToDecimal(start)); ht.Add("@MEDICALCODE", SkyComm.getvalue("MedicalCode")); QuerySolutionFacade querySolutionFacade = new QuerySolutionFacade(); mDataSet = querySolutionFacade.ExeQuery(mSql, ht); return(mDataSet); }
public string getOfficeId(string officeName) { string mSql = "SELECT* FROM T_OFFICE a where a.OFFICE = @OFFICE and a.MEDICALCODE = @MEDICALCODE"; DataSet mDataSet = new DataSet(); Hashtable ht = new Hashtable(); ht.Add("@OFFICE", officeName); ht.Add("@MEDICALCODE", SkyComm.getvalue("MedicalCode")); QuerySolutionFacade querySolutionFacade = new QuerySolutionFacade(); mDataSet = querySolutionFacade.ExeQuery(mSql, ht); return(mDataSet.Tables[0].Rows[0]["OFFICEID"].ToString()); }
public int getArrayCount(string officeID, string windowId) { string mSql = "SELECT * FROM P_DOSAGECOMPLETE where P_DOSAGECOMPLETE.PHARMACYID = @PHARMACYID and P_DOSAGECOMPLETE.PHARMARYWINDOWID = @PHARMARYWINDOWID and P_DOSAGECOMPLETE.MEDICALCODE = @MEDICALCODE"; DataSet mDataSet = new DataSet(); Hashtable ht = new Hashtable(); ht.Add("@PHARMACYID", officeID); ht.Add("@PHARMARYWINDOWID", windowId); ht.Add("@MEDICALCODE", SkyComm.getvalue("MedicalCode")); QuerySolutionFacade querySolutionFacade = new QuerySolutionFacade(); mDataSet = querySolutionFacade.ExeQuery(mSql, ht); return(mDataSet.Tables[0].Rows.Count); }
public void revokedTrade(string hisSerialNo, string errorId) { try { string mSql = "UPDATE T_BANKHISEXCHANGE_TRANS set REMARK = @REMARK where HISSEQNO = @HISSEQNO"; Hashtable hashtable = new Hashtable(); hashtable.Add("@HISSEQNO", hisSerialNo); hashtable.Add("@REMARK", errorId); QuerySolutionFacade querySolutionFacade = new QuerySolutionFacade(); int i = querySolutionFacade.ExeNonQuery(mSql, hashtable); } catch (Exception e) { Log.Info(GetType().ToString(), "等待支付结果超时,更新交易表异常:" + e.Message); } }
/// <summary> /// 更新检验报告中间表,更新打印状态 /// </summary> private void UpdateListData() { DataTable dtPrint = (DataTable)this.gdcMain.DataSource; QuerySolutionFacade facade = new QuerySolutionFacade(); try { foreach (DataRow dr in dtPrint.Rows) { string sql = "UPDATE LIS_REPORTFILE SET PRINTCOUNT=PRINTCOUNT+1 WHERE CHECK_NO=@CHECKNO"; Hashtable ht = new Hashtable(); ht.Add("@CHECKNO", dr["CHECK_NO"].ToString()); facade.ExeNonQuery(sql, ht); } } catch (Exception ex) { Skynet.LoggingService.LogService.GlobalErrorMessage("更新检验结果中间表失败,原因:" + ex.Message); } }
private DataSet GetRegisterIDInfo() { try { DateTime dtEnd = Convert.ToDateTime(new CommonFacade().GetServerDateTime().AddMonths(-3).ToString("yyyy-MM-dd 00:00:00")); string sql = "SELECT REGISTERID FROM T_REGISTER_INFO WHERE DIAGNOSEID=@DIAGNOSEID AND OPERATEDATE>=@ENDTIME"; Hashtable htm = new Hashtable(); htm.Add("@DIAGNOSEID", _diagnoseID); htm.Add("@ENDTIME", dtEnd); QuerySolutionFacade facadem = new QuerySolutionFacade(); DataSet dsRegister = facadem.ExeQuery(sql, htm); return dsRegister; } catch (Exception ex) { Skynet.LoggingService.LogService.GlobalErrorMessage("获取患者挂号信息失败,原因:" + ex.Message); return null; } }
public void updateRefundOrderResult(List <string> list, string hisSerialNo) { try { string mSql = "UPDATE T_BANKHISEXCHANGE_TRANS set OHISSEQNO = @OHISSEQNO, BANKSTATE = '0', HISSTATE = '0',REFUNDMONEY = @REFUNDMONEY,OPERATETIME = @OPERATETIME where a.HISSEQNO = @HISSEQNO"; Hashtable hashtable = new Hashtable(); hashtable.Add("@OHISSEQNO", list[1]); hashtable.Add("@REFUNDMONEY", list[2]); hashtable.Add("@OPERATETIME", list[3]); hashtable.Add("@HISSEQNO", hisSerialNo); QuerySolutionFacade querySolutionFacade = new QuerySolutionFacade(); int i = querySolutionFacade.ExeNonQuery(mSql, hashtable); } catch (Exception e) { Log.Info(GetType().ToString(), "保存" + SkyComm.cardInfoStruct.CardNo + "的退费记录", e.Message); } }
/// <summary> /// 获取卡余额 /// </summary> private void GetMoeny() { //获取诊疗号 string diagnoseId = SkyComm.DiagnoseID; //预交金 if (eCardSavingFacade == null) { eCardSavingFacade = new CardSavingFacade(); } string yje = string.Empty; if (SystemInfo.SystemConfigs["院内就诊卡模式"].DefaultValue.ToString() != "2") { yje = eCardSavingFacade.FindBalanceMoneyByDiagnoseID(diagnoseId).ToString("0.00"); } else { yje = eCardSavingFacade.FindBalanceMoneyByDiagnoseID_New(diagnoseId, SkyComm.eCardAuthorizationData.Tables[0].Rows[0]["ACCOUNT_ID"].ToString()).ToString("0.00"); } //门诊未结 //string wj = eCardAuthorizationFacade.FindClinicNoCheckoutMoney(diagnoseId).ToString("0.00"); //门诊未缴费 #region 查询未缴费的金额 QuerySolutionFacade query = new QuerySolutionFacade(); Hashtable ht = new Hashtable(); string wj = "0.00"; string strsql = " SELECT COALESCE(SUM(TOTALMONEY),0) TOTALMONEY FROM (" + " select SUM(C.TOTALMONEY) TOTALMONEY" + " from CLINICPHYSICIANRECIPE C" + " where C.DIAGNOSEID=:DIAGNOSEID AND RECIPESTATE = 0 and OPERATETIME >= :YPDATE " + " AND C.RECIPETYPE IN ('药品费','中草药','医材')" + " union all " + " SELECT SUM(D_SUMMARY_INFO.UNITPRICE * CLINICPHYSICIANRECIPE.AMOUNT * S_MEDORD_DETAIL.AMOUNT) AS TOTALMONEY" + " FROM CLINICPHYSICIANRECIPE,D_SUMMARY_INFO,S_MEDORD_DETAIL,S_MEDORD_MAIN " + " WHERE CLINICPHYSICIANRECIPE.RECIPECONTENT = S_MEDORD_DETAIL.MEDORDID AND S_MEDORD_DETAIL.ITEMID = D_SUMMARY_INFO.ITEMID AND" + " CLINICPHYSICIANRECIPE.DIAGNOSEID=:DIAGNOSEID AND RECIPESTATE = 0 AND" + " CLINICPHYSICIANRECIPE.RECIPETYPE <> '附加' AND CLINICPHYSICIANRECIPE.RECIPECONTENT = S_MEDORD_MAIN.MEDORDID " + " AND OPERATETIME >=:JZFDATE AND (ISCHANGEPRICE<> 1 OR ISCHANGEPRICE IS NULL)" + " union all " + " SELECT SUM(CLINICPHYSICIANRECIPE.UNITPRICE * CLINICPHYSICIANRECIPE.AMOUNT) AS TOTALMONEY" + " FROM CLINICPHYSICIANRECIPE " + " WHERE CLINICPHYSICIANRECIPE.DIAGNOSEID=:DIAGNOSEID AND RECIPESTATE = 0 AND" + " CLINICPHYSICIANRECIPE.RECIPETYPE <> '附加' " + " AND OPERATETIME >=:JZFDATE AND ISCHANGEPRICE = 1" + " union all " + " select SUM(CLINICPHYSICIANRECIPE.UNITPRICE * CLINICPHYSICIANRECIPE.AMOUNT) TOTALMONEY" + " from CLINICPHYSICIANRECIPE " + " where RECIPESTATE = 0 AND CLINICPHYSICIANRECIPE.RECIPETYPE = '附加' " + " AND CLINICPHYSICIANRECIPE.DIAGNOSEID=:DIAGNOSEID and OPERATETIME >=:JZFDATE ) AA "; string ypDate = SystemInfo.SystemConfigs["药品处方有效期"].DefaultValue; string jzfDate = SystemInfo.SystemConfigs["检治费处方有效期"].DefaultValue; CommonFacade commonFacade = new CommonFacade(); DateTime dtCurrent = commonFacade.GetServerDateTime(); ht.Add(":DIAGNOSEID", diagnoseId); ht.Add(":YPDATE", dtCurrent.Date.AddDays(Convert.ToInt32(ypDate) * -1)); ht.Add(":JZFDATE", dtCurrent.Date.AddDays(Convert.ToInt32(jzfDate) * -1)); try { lblNoPaymentCharge.Visible = false; decimal decNoCharge = 0; DataSet ds = query.ExeQuery(strsql, ht); if (ds.Tables[0].Rows.Count > 0) { decNoCharge = DecimalRound.Round(Convert.ToDecimal(ds.Tables[0].Rows[0]["TOTALMONEY"]), 2); } wj = decNoCharge.ToString(); lblwjf.Text = decNoCharge.ToString(); if (decNoCharge != 0) { lblNoPaymentCharge.Visible = true; } else { lblNoPaymentCharge.Visible = false; } } catch (Exception ex) { SkynetMessage.MsgInfo("获取未交费信息出错:" + ex.Message); } #endregion lblwjf.Text = wj + "元"; //余额 lblye.Text = SkyComm.cardBlance.ToString(); }
private void btnBalance_Click(object sender, EventArgs e) { QuerySolutionFacade querySolutionFacade = new QuerySolutionFacade(); DetailAccountFacade detailAccountFacade = new DetailAccountFacade(); string mechinNo = string.Empty; try { #region 获取ip string ipAddress = null; try { string hostName = Dns.GetHostName(); IPHostEntry ipEntry = Dns.GetHostEntry(hostName); for (int i = 0; i < ipEntry.AddressList.Length; i++) { if (ipEntry.AddressList[i].AddressFamily == AddressFamily.InterNetwork) { ipAddress = ipEntry.AddressList[i].ToString(); } } } catch (Exception ex) { SkyComm.ShowMessageInfo(ex.Message); return; } #endregion #region 获取机器码 string sql1 = "select * from T_AUTOSERVICEMACHINE_INFO where IPADDRESS = @IPADDRESS"; Hashtable hashtable1 = new Hashtable(); hashtable1.Add("@IPADDRESS", ipAddress); DataSet dataSet = querySolutionFacade.ExeQuery(sql1, hashtable1); if (dataSet.Tables[0].Rows.Count > 0) { mechinNo = dataSet.Tables[0].Rows[0]["MACHINENO"].ToString(); } #endregion #region 判断结算 Hashtable hashtablejs = new Hashtable(); string sqljs = "select * from SETTLEMENT_RECORD where MECHINNO = @MECHINNO";// and BANKSTATE = '1' hashtablejs.Add("@MECHINNO", mechinNo); DataSet dataSet1 = querySolutionFacade.ExeQuery(sqljs, hashtablejs); if (dataSet1.Tables[0].Rows.Count > 0) { if (dataSet1.Tables[0].Rows[0]["SETTLEMENT_TIME"].ToString().Equals(DateTime.Now.ToString("yyyy-MM-dd"))) { SkyComm.ShowMessageInfo("此台机器已经结算过"); return; } else { } } #endregion #region 获取结算时间 string MBeginTime = DateTime.Now.ToLocalTime().ToString();; string MEndTime = DateTime.Now.ToLocalTime().ToString();; string sql3 = "select * from SETTLEMENT_TIME where M_NO = @M_NO"; Hashtable hashtable3 = new Hashtable(); hashtable3.Add("@M_NO", mechinNo); DataSet dataSet3 = querySolutionFacade.ExeQuery(sql3, hashtable3); if (dataSet3.Tables[0].Rows.Count > 0) { MBeginTime = dataSet3.Tables[0].Rows[0]["TIMES"].ToString(); } #endregion #region 获取现金记录 string sql2 = "select * from T_AUTOINMONEY_RECORD where MACHINENO = @MACHINENO and OPERATORTIME between @starttime and @endtime"; Hashtable hashtable2 = new Hashtable(); hashtable2.Add("@MACHINENO", mechinNo); hashtable2.Add("@starttime", MBeginTime); hashtable2.Add("@endtime", MEndTime); DataSet dataSet2 = querySolutionFacade.ExeQuery(sql2, hashtable2); if (dataSet2.Tables[0].Rows.Count == 0) { SkyComm.ShowMessageInfo("此台机器没有结算信息,已经记录结算时间"); } else { dataSet2.WriteXml(Application.StartupPath + @"\\ReportXml\\自助机结算.xml"); string path = Application.StartupPath + @"\\Reports\\自助机结算.frx"; PrintManager print = new PrintManager(); print.InitReport("自助机结算"); print.AddParam("结算时间", DateTime.Now.ToLocalTime().ToString()); print.AddData(dataSet2.Tables[0], "report"); PrintManager.CanDesign = true; print.Print(); print.Dispose(); } #endregion } catch (Exception e1) { SkyComm.ShowMessageInfo(e1.Message); return; } #region 记录结算 DataSet data = new DataSet(); Hashtable hashtable = new Hashtable(); string mSql = "delete from SETTLEMENT_RECORD where MECHINNO = @MECHINNO";// and BANKSTATE = '1' hashtable.Add("@MECHINNO", mechinNo); querySolutionFacade.ExeNonQuery(mSql, hashtable); string sql = "insert into SETTLEMENT_RECORD values (@SETTLEMENT_TIME,'已结算',@MECHINNO);"; hashtable.Add("@SETTLEMENT_TIME", DateTime.Now.ToString("yyyy-MM-dd")); data = querySolutionFacade.ExeQuery(sql, hashtable); #endregion #region 记录结算时间 string sql4 = "delete from SETTLEMENT_TIME where M_NO = @M_NO"; Hashtable hashtable4 = new Hashtable(); hashtable4.Add("@M_NO", mechinNo); int a = querySolutionFacade.ExeNonQuery(sql4, hashtable4); string sql5 = "insert into SETTLEMENT_TIME values (@TIMES,@M_NO)"; Hashtable hashtable5 = new Hashtable(); hashtable5.Add("@TIMES", DateTime.Now.ToLocalTime().ToString()); hashtable5.Add("@M_NO", mechinNo); int b = querySolutionFacade.ExeNonQuery(sql5, hashtable5); #endregion SkyComm.ShowMessageInfo("现金结算成功"); //_mSquareAccountsPresenter = new SquareAccountsPresenter(this); //_mSquareAccountsPresenter.GetSquareAccount(); }
/// <summary> /// 查询检验中间表,查询患者检验报告信息 /// </summary> /// <returns></returns> private DataTable GetListData() { try { DataTable dtAllReport = GreateDataTable(); DateTime dtEnd =Convert.ToDateTime( new CommonFacade().GetServerDateTime().AddMonths(-3).ToString("yyyy-MM-dd 00:00:00")); if (!string.IsNullOrEmpty(_inHosID)) { string sql = "SELECT CHECK_NO,PATIENT_ID,FilePath,FileName,FileOrder,ItemName,LastOpTime,CrudFlag FROM LIS_REPORTFILE WHERE PATIENT_ID=@INHOSID AND LastOpTime >=@ENDTIME AND CrudFlag=1 AND PRINTCOUNT=0 ORDER BY LastOpTime ASC,FileOrder ASC"; Hashtable htm = new Hashtable(); htm.Add("@INHOSID", _inHosID); htm.Add("@ENDTIME", dtEnd); QuerySolutionFacade facadem = new QuerySolutionFacade(); DataSet dsReport = facadem.ExeQuery(sql, htm); if (dsReport != null && dsReport.Tables.Count != 0 && dsReport.Tables[0].Rows.Count != 0) { object[] obj = new object[dtAllReport.Columns.Count]; for (int i = 0; i < dsReport.Tables[0].Rows.Count; i++) { dsReport.Tables[0].Rows[i].ItemArray.CopyTo(obj, 0); dtAllReport.Rows.Add(obj); } } } DataSet dsRegister = this.GetRegisterIDInfo(); if (dsRegister != null && dsRegister.Tables.Count != 0 && dsRegister.Tables[0].Rows.Count != 0) { foreach (DataRow drRegister in dsRegister.Tables[0].Rows) { string registerID = drRegister["REGISTERID"].ToString(); string sql = "SELECT CHECK_NO,PATIENT_ID,FilePath,FileName,FileOrder,ItemName,LastOpTime,CrudFlag FROM LIS_REPORTFILE WHERE PATIENT_ID=@DIAGNOSEID AND CrudFlag=1 AND PRINTCOUNT=0 ORDER BY LastOpTime ASC,FileOrder ASC"; Hashtable htm = new Hashtable(); htm.Add("@DIAGNOSEID", registerID); //htm.Add("@ENDTIME", dtEnd); QuerySolutionFacade facadem = new QuerySolutionFacade(); DataSet dsReport = facadem.ExeQuery(sql, htm); if (dsReport != null && dsReport.Tables.Count != 0 && dsReport.Tables[0].Rows.Count != 0) { object[] obj = new object[dtAllReport.Columns.Count]; for (int i = 0; i < dsReport.Tables[0].Rows.Count; i++) { DateTime samplingTime = Convert.ToDateTime(dsReport.Tables[0].Rows[i]["LASTOPTIME"].ToString().Trim().Replace("@", ":")); if (samplingTime <= Convert.ToDateTime(dtEnd)) continue; dsReport.Tables[0].Rows[i].ItemArray.CopyTo(obj, 0); dtAllReport.Rows.Add(obj); } } } } return dtAllReport; } catch (Exception ex) { Skynet.LoggingService.LogService.GlobalErrorMessage("查询检验结果报表失败,原因:" + ex.Message); return null; } }
private void FrmCardSavingMain_Load(object sender, EventArgs e) { string mechinNo = string.Empty; try { QuerySolutionFacade querySolutionFacade = new QuerySolutionFacade(); DetailAccountFacade detailAccountFacade = new DetailAccountFacade(); #region 获取ip string ipAddress = null; try { string hostName = Dns.GetHostName(); IPHostEntry ipEntry = Dns.GetHostEntry(hostName); for (int i = 0; i < ipEntry.AddressList.Length; i++) { if (ipEntry.AddressList[i].AddressFamily == AddressFamily.InterNetwork) { ipAddress = ipEntry.AddressList[i].ToString(); } } } catch (Exception ex) { } #endregion #region 获取机器码 string sql1 = "select MACHINENO from T_AUTOSERVICEMACHINE_INFO where IPADDRESS = @IPADDRESS"; Hashtable hashtable1 = new Hashtable(); hashtable1.Add("@IPADDRESS", ipAddress); DataSet dataSet = querySolutionFacade.ExeQuery(sql1, hashtable1); if (dataSet.Tables[0].Rows.Count > 0) { mechinNo = dataSet.Tables[0].Rows[0]["MACHINENO"].ToString(); } #endregion #region 记录结算时间 DataSet data = new DataSet(); Hashtable hashtable = new Hashtable(); string mSql = "select * from SETTLEMENT_RECORD where MECHINNO = @MECHINNO "; hashtable.Add("@MECHINNO", mechinNo); data = querySolutionFacade.ExeQuery(mSql, hashtable); if (data.Tables[0].Rows.Count > 0) { if (data.Tables[0].Rows[0]["SETTLEMENT_TIME"].ToString().Equals(DateTime.Now.ToString("yyyy-MM-dd"))) { this.lblCashStored.Enabled = false; } else { this.lblCashStored.Enabled = true; } } else { this.lblCashStored.Enabled = true; } #endregion } catch (Exception) { this.lblCashStored.Enabled = true; } //if (!string.IsNullOrEmpty(SkyComm.getvalue("禁用现金"))) //{ // lblCashStored.Visible = false; // btnWxPay.Location = new Point(142, 332); //} if (!string.IsNullOrEmpty(SkyComm.getvalue("禁用银行卡"))) { lblBankCardStored.Visible = false; } if (!string.IsNullOrEmpty(SkyComm.getvalue("禁用微信"))) { btnWxPay.Visible = false; } ucTime1.Sec = 60; ucTime1.timer1.Start(); }
public void NetPay(string hisno, string payMethod) { this.AnsyWorker(ui => { ui.UpdateTitle("正在缴费中,请稍等..."); ui.SynUpdateUI(() => { #region 验证缴费处方信息 DataTable dtMain = dsRecipe.Tables[0].DefaultView.ToTable(); IEnumerable <string> _CLINICRECIPEIDs = dtMain.AsEnumerable().Where(b => b.Field <bool>("PITCHON1") == true).Select(a => a.Field <string>("CLINICRECIPEID")).Distinct(); if (_CLINICRECIPEIDs.Count() == 0) { SkyComm.ShowMessageInfo("请选择要缴费的处方!"); return; } this.ucTime1.timer1.Stop(); //选中处方的金额 decimal sumMoney = DecimalRound.Round(Convert.ToDecimal(dtMain.Compute("SUM(TOTALMONEY)", "PITCHON1 = true")), 2); ClinicPhysicianRecipeFacade clinicPhysicianRecipeFacade = new ClinicPhysicianRecipeFacade(); DataSet dsTemp = clinicPhysicianRecipeFacade.FindRecipeDetailByDiagnoseID(SkyComm.DiagnoseID, string.Empty, "3"); DataSet ds = dsTemp.Clone(); foreach (DataRow row in dsTemp.Tables[0].Rows) { if (_CLINICRECIPEIDs.Contains(row["CLINICRECIPEID"].ToString())) { ds.Tables[0].ImportRow(row); } } if (ds.Tables[0].Rows.Count < 1) { SkyComm.ShowMessageInfo("没有找到可进行缴费的处方记录,请检查处方号"); this.ucTime1.Sec = 60; this.ucTime1.timer1.Start(); return; } //调用大通审方系统 if (!CheckDTPass(ds)) { return; } #endregion #region 组织缴费处方信息 CommonFacade commonFacade = new CommonFacade(); DateTime ServerTime = commonFacade.GetServerDateTime(); LeechdomCharge charge = new LeechdomCharge(SkyComm.DiagnoseID, SysOperatorInfo.OperatorID); charge.AddRecipeCharge(ds); decimal decHisMoney = DecimalRound.Round(Convert.ToDecimal(charge.detailAccountData.Tables[0].Compute("SUM(MONEY)", "")), 2); if (decHisMoney != sumMoney) { charge.detailAccountData.Clear(); charge.ecipeMedicineData.Clear(); SkyComm.ShowMessageInfo("选择的处方金额不正确,请在门诊窗口进行缴费!"); this.ucTime1.Sec = 60; this.ucTime1.timer1.Start(); return; } #endregion #region 缴费 try { //验证西北妇幼高值耗材 if (!CheckHValueMaterial(charge.detailAccountData)) { throw new Exception("缴费信息中有高值耗材,请在门诊窗口进行缴费!"); } DetailAccountFacade detailAccountFacade = new DetailAccountFacade(); DataSet data = new DataSet(); Hashtable hashtable = new Hashtable(); hashtable.Add("@HISSEQNO", hisno); string mSql = "SELECT * FROM T_BANKHISEXCHANGE_TRANS where HISSEQNO = @HISSEQNO";// and BANKSTATE = '1' QuerySolutionFacade querySolutionFacade = new QuerySolutionFacade(); data = querySolutionFacade.ExeQuery(mSql, hashtable); TBankhisexchangeTransData transData = new TBankhisexchangeTransData(); transData.Bankseqno = data.Tables[0].Rows[0]["BANKSEQNO"].ToString(); transData.Hisseqno = data.Tables[0].Rows[0]["HISSEQNO"].ToString(); transData.Ohisseqno = data.Tables[0].Rows[0]["OHISSEQNO"].ToString(); transData.Bankstate = data.Tables[0].Rows[0]["BANKSTATE"].ToString(); transData.Hisstate = data.Tables[0].Rows[0]["HISSTATE"].ToString(); transData.Buscd = data.Tables[0].Rows[0]["BUSCD"].ToString(); transData.Hisid = data.Tables[0].Rows[0]["HISID"].ToString(); transData.Trfamt = data.Tables[0].Rows[0]["TRFAMT"].ToString(); transData.Usetype = data.Tables[0].Rows[0]["USETYPE"].ToString(); transData.Operatorid = data.Tables[0].Rows[0]["OPERATORID"].ToString(); transData.Operatetime = Convert.ToDateTime(data.Tables[0].Rows[0]["OPERATETIME"].ToString()); transData.Diagnoseid = data.Tables[0].Rows[0]["DIAGNOSEID"].ToString(); transData.BusinessType = data.Tables[0].Rows[0]["BUSINESSTYPE"].ToString(); transData.DataSources = data.Tables[0].Rows[0]["DATASOURCES"].ToString(); transData.DataSources = data.Tables[0].Rows[0]["DATASOURCES"].ToString(); transData.RefundType = Convert.ToInt32(data.Tables[0].Rows[0]["REFUNDTYPE"].ToString()); transData.RefundMoney = Convert.ToDecimal(data.Tables[0].Rows[0]["REFUNDMONEY"].ToString()); transData.Remark = "_FromPayForRecipeForm"; foreach (DataRow Row in charge.detailAccountData.Tables[0].Rows) { Row.BeginEdit(); Row["ISBANKCARD"] = 1; Row["BALANCEMODE"] = payMethod; Row["BANKTRANSNO"] = transData.Hisseqno; Row["IS_FEECHARGING_CARD"] = "1"; Row.EndEdit(); decHisMoney += Convert.ToDecimal(Row["MONEY"]); } DataSet dads = detailAccountFacade.insertEntityNoInvoiceZZZD(charge.detailAccountData, ref charge.ecipeMedicineData, transData); //DataSet dads = detailAccountFacade.insertEntityNoInvoice(charge.detailAccountData, ref charge.ecipeMedicineData); SkyComm.GetCardBalance(); SkyComm.ShowMessageInfo("缴费成功!"); //根据“药房自动配药接口类型”配置为2时,调用西北妇幼的派昂接口 19797 string AutoDoseConfig = SystemInfo.SystemConfigs["药房自动配药接口类型"].DefaultValue; string strCK = string.Empty; if (AutoDoseConfig == "2" && charge.ecipeMedicineData.Tables[0].Rows.Count > 0) { strCK = UploadAngPaiData(dads, charge.ecipeMedicineData, dsTemp); } PrintReport(dads, strCK, dsRecipe);//打印交费凭证 } catch (Exception err) { charge.detailAccountData.Clear(); charge.ecipeMedicineData.Clear(); Skynet.LoggingService.LogService.GlobalInfoMessage(SkyComm.DiagnoseID + "缴费失败:" + err.Message); SkyComm.ShowMessageInfo("缴费失败:" + err.Message); this.ucTime1.Sec = 60; this.ucTime1.timer1.Start(); return; } dsRecipe = GetRecipeInfo(); if (dsRecipe == null || dsRecipe.Tables[0].Rows.Count == 0) { SkyComm.CloseWin(this); } else { this.gdcMain.DataSource = dsRecipe.Tables[0].DefaultView; lblYE.Text = SkyComm.cardBlance.ToString(); refreshUI(); } #endregion }); }); }