处理中间键报DBNULL的错误
[ PATIENT_ID = 2889706, PATIENT_NUM = 29275, TIMES = 1 ] Object cannot be cast from DBNull to other types.
at System.DBNull.System.IConvertible.ToDateTime(IFormatProvider provider)
at System.Convert.ToDateTime(Object value)
at SiHome.BLL.Components.InsuranceAnalyze.CalcBillDetailDeptCodeAndDoctor(DataRow drPatientInfo, DataRow dtInBillDetail)
at SiHome.BLL.Components.InsuranceAnalyze.Analyze(DataRow drPatientInfo)
at SiHome.BLL.Components.AnalyzeIn_Sub.AnalyzeInsurance(SyncPatientData patientData, Database hisData, Database sihomeData, IDbTransaction tran)
at SiHome.BLL.Components.AnalyzeIn_Sub.SyncAnalyzePatientInfo(SyncPatientData patientData, Boolean isJob, Database hisData, Database sihomeData)
at SiHome.BLL.Components.AnalyzeIn_Main.AnalyzePatientSingle(SyncPatientData patientData)
将执行时间修改为默认值,即可。
,CAST(ISNULL(EXECUTE_TIME,‘1900-01-01 00:00:01‘) as datetime )
AS EXECUTE_TIME