public MyCardQueryLogWcf.ReturnResult QueryDB() { MyCardQueryLogWcf.Service1Client MyCardQueryLogWcf = new MyCardQueryLogWcf.Service1Client(); MyCardQueryLogWcf.ReturnResult ReturnResult = new MyCardQueryLogWcf.ReturnResult(); try { ReturnResult = MyCardQueryLogWcf.QueryDB(); } catch (Exception ex) { ReturnResult.ReturnMsgNo = -99; ReturnResult.ReturnMsg = "連線MyCardQueryLogWcf.QueryDB失敗" + ex.Message; return ReturnResult; } return ReturnResult; }
//下拉DB public ReturnDBResult ViewQueryDBLog() //取得資料庫資料 { ReturnDBResult ReturnResult = new ReturnDBResult(); if (MyCardQueryLog.Properties.Settings.Default.In34.ToUpper() == "TRUE") { MyCardQueryLogWcf.Service1Client MyCardQueryLogWcf = new MyCardQueryLogWcf.Service1Client(); MyCardQueryLogWcf.ReturnResult ReturnValueB2B = new MyCardQueryLogWcf.ReturnResult(); InValue = "QueryDB"; try { ReturnValueB2B = MyCardQueryLogWcf.QueryDB(); ReturnResult.ReturnMsgNo = ReturnValueB2B.ReturnMsgNo; ReturnResult.ReturnMsg = ReturnValueB2B.ReturnMsg; ReturnResult.ReturnDS = ReturnValueB2B.ReturnDS; } catch (Exception ex) { OutValue = "|回應|" + "Exception|" + ex.ToString(); ErrorLog(InValue + OutValue); ReturnResult.ReturnMsgNo = -99; ReturnResult.ReturnMsg = "系統發生錯誤"; } } else { MyCardQueryLogWcfB2B.Service1Client MyCardQueryLogWcfB2B = new MyCardQueryLogWcfB2B.Service1Client(); MyCardQueryLogWcfB2B.ReturnResult ReturnValueB2B = new MyCardQueryLogWcfB2B.ReturnResult(); InValue = "QueryDB"; try { ReturnValueB2B = MyCardQueryLogWcfB2B.QueryDB(); ReturnResult.ReturnMsgNo = ReturnValueB2B.ReturnMsgNo; ReturnResult.ReturnMsg = ReturnValueB2B.ReturnMsg; ReturnResult.ReturnDS = ReturnValueB2B.ReturnDS; } catch (Exception ex) { OutValue = "|回應|" + "Exception|" + ex.ToString(); ErrorLog(InValue + OutValue); ReturnResult.ReturnMsgNo = -99; ReturnResult.ReturnMsg = "系統發生錯誤"; } } return ReturnResult; }