public DataTable GetDataBaseInfo(string pSource, string pCatalog, string pUserName, string pPassWord) { try { ConnectionSetting.CreateDynamicConnection(pSource, pCatalog, pUserName, pPassWord); DataTable result = this.ExeStore("sp_GetDataBaseInfo"); ConnectionSetting.UseDynamicConnection = false; return(result); } catch (Exception ex) { LogError.WriteLogError("GetDataBaseInfo: ", ex); ConnectionSetting.UseDynamicConnection = false; return(new DataTable()); } }
public bool TruncateDataBase(string pSource, string pCatalog, string pUserName, string pPassWord) { try { ConnectionSetting.CreateDynamicConnection(pSource, pCatalog, pUserName, pPassWord); this.ExeStore("sp_TruncateDataBase"); ConnectionSetting.UseDynamicConnection = false; return(true); } catch (Exception ex) { LogError.WriteLogError("TruncateDataBase: ", ex); ConnectionSetting.UseDynamicConnection = false; return(false); } }