Example #1
0
 public MyCardQueryLogWcf.ReturnResult QueryDBTableNote(string Table)
 {
     MyCardQueryLogWcf.Service1Client MyCardQueryLogWcf = new MyCardQueryLogWcf.Service1Client();
     MyCardQueryLogWcf.ReturnResult ReturnResult = new MyCardQueryLogWcf.ReturnResult();
     try
     {
         ReturnResult = MyCardQueryLogWcf.QueryDBTableNote(Table);
     }
     catch (Exception ex)
     {
         ReturnResult.ReturnMsgNo = -99;
         ReturnResult.ReturnMsg = "連線MyCardQueryLogWcf.QueryDBTableNote失敗" + ex.Message;
         return ReturnResult;
     }
     return ReturnResult;
 }
        //資料View查詢內容描述
        public ReturnDBResult ViewQueryNote(string view) //取得資料內容描述
        {
            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 = "QueryDBTableNote";
                try
                {
                    ReturnValueB2B = MyCardQueryLogWcf.QueryDBTableNote(view);
                    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 = "QueryDBTableNote";
                try
                {
                    ReturnValueB2B = MyCardQueryLogWcfB2B.QueryDBTableNote(view);
                    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; 
        }