コード例 #1
0
 //下拉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;
 }