public MyCardQueryLogWcf.ReturnResult QueryDBTableView(string DbName) { MyCardQueryLogWcf.Service1Client MyCardQueryLogWcf = new MyCardQueryLogWcf.Service1Client(); MyCardQueryLogWcf.ReturnResult ReturnResult = new MyCardQueryLogWcf.ReturnResult(); try { ReturnResult = MyCardQueryLogWcf.QueryDBTableView(DbName); } catch (Exception ex) { ReturnResult.ReturnMsgNo = -99; ReturnResult.ReturnMsg = "連線MyCardQueryLogWcf.QueryDBTableView失敗" + ex.Message; return ReturnResult; } return ReturnResult; }
//下拉Table public ReturnDBResult ViewQueryTableViewLog(string DBName) //取得Table資料 { ReturnDBResult ReturnResult = new ReturnDBResult(); InValue = "QueryDBTableView"; if (MyCardQueryLog.Properties.Settings.Default.In34.ToUpper() == "TRUE") { MyCardQueryLogWcf.Service1Client MyCardQueryLogWcf = new MyCardQueryLogWcf.Service1Client(); MyCardQueryLogWcf.ReturnResult ReturnValueB2B = new MyCardQueryLogWcf.ReturnResult(); try { ReturnValueB2B = MyCardQueryLogWcf.QueryDBTableView(DBName); 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(); try { ReturnValueB2B = MyCardQueryLogWcfB2B.QueryDBTableView(DBName); 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; }