/// <summary> /// Gets Emails address routes. /// </summary> /// <returns></returns> public DataView GetRouteList() { switch(m_DB_Type) { #region DB_Type.XML case DB_Type.XML: if(!dsRouting.Tables["Routing"].Columns.Contains("Length")){ dsRouting.Tables["Routing"].Columns.Add("Length",Type.GetType("System.Int32"),"Len(Pattern)"); } DataView dv = new DataView(dsRouting.Tables["Routing"]); dv.Sort = "DomainID ASC,Length DESC,PATTERN DESC"; return dv; #endregion #region DB_Type.MSSQL case DB_Type.MSSQL: using(WSqlCommand sqlCmd = new WSqlCommand(m_ConStr,"lspr_GetRouteList")){ // sqlCmd.AddParameter("@DomainName",SqlDbType.NVarChar,source); DataSet ds = sqlCmd.Execute(); ds.Tables[0].TableName = "Routing"; if(!ds.Tables["Routing"].Columns.Contains("Length")){ ds.Tables["Routing"].Columns.Add("Length",Type.GetType("System.Int32"),"Len(Pattern)"); } ds.Tables["Routing"].DefaultView.Sort = "DomainID ASC,Length DESC,PATTERN DESC"; return ds.Tables["Routing"].DefaultView; } #endregion #region DB_Type.WebServices case DB_Type.WebServices: using(RemoteAdmin eng = new RemoteAdmin()){ _Core.InitWebService(m_WebServicesUrl,m_WebServicesPwd,m_WebServicesUser,eng); return eng.GetRouteList().Tables["Routing"].DefaultView; } #endregion } return null; }