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