/// <summary> <p>Parses a message string and returns the corresponding Message /// object. This method checks that the given message string is XML encoded, creates an /// XML Document object (using Xerces) from the given String, and calls the abstract /// method <code>parse(Document XMLMessage)</code></p> /// </summary> protected internal override Message doParse(System.String message, System.String version) { Message m = null; //parse message string into a DOM document try { System.Xml.XmlDocument doc = null; lock (this) { XmlTextReader reader = new XmlTextReader(new System.IO.MemoryStream(new System.Text.ASCIIEncoding().GetBytes(message))); System.Data.DataSet data = new System.Data.DataSet(); data.ReadXml(reader); doc = new XmlDataDocument(data); } m = parseDocument(doc, version); } catch (System.Xml.XmlException e) { throw new NuGenHL7Exception("SAXException parsing XML", NuGenHL7Exception.APPLICATION_INTERNAL_ERROR, e); } catch (System.IO.IOException e) { throw new NuGenHL7Exception("IOException parsing XML", NuGenHL7Exception.APPLICATION_INTERNAL_ERROR, e); } return(m); }
protected override void ReadXmlSerializable(System.Xml.XmlReader reader) { if ((this.DetermineSchemaSerializationMode(reader) == System.Data.SchemaSerializationMode.IncludeSchema)) { this.Reset(); System.Data.DataSet ds = new System.Data.DataSet(); ds.ReadXml(reader); if ((ds.Tables["Employees"] != null)) { base.Tables.Add(new EmployeesDataTable(ds.Tables["Employees"])); } this.DataSetName = ds.DataSetName; this.Prefix = ds.Prefix; this.Namespace = ds.Namespace; this.Locale = ds.Locale; this.CaseSensitive = ds.CaseSensitive; this.EnforceConstraints = ds.EnforceConstraints; this.Merge(ds, false, System.Data.MissingSchemaAction.Add); this.InitVars(); } else { this.ReadXml(reader); this.InitVars(); } }
private void Bor1_MouseRightButtonDown(object sender, MouseButtonEventArgs e) { try { using (System.Windows.Forms.FolderBrowserDialog FBD = new System.Windows.Forms.FolderBrowserDialog()) { FBD.SelectedPath = MovPath; FBD.ShowNewFolderButton = false; FBD.Description = "视频目录选择"; if (FBD.ShowDialog() == System.Windows.Forms.DialogResult.OK) { DS = new System.Data.DataSet(); DS.ReadXml(AppPath + "\\ShowMov.Dat", System.Data.XmlReadMode.ReadSchema); bool run = (ls.Count == 0); CheckPath(FBD.SelectedPath); if (run) { mediaElement_MediaEnded(null, null); } } } } catch (Exception ex) { MessageBox.Show(ex.Message); } }
public static void Init(ref System.Data.DataTable dt) { string filePath = String.Format("{0}/{1}", GetExecutingPath(), REQUESTLOG_FILENAME); System.IO.FileInfo fi = new System.IO.FileInfo(filePath); if (fi.Exists) { System.Data.DataSet ds = new System.Data.DataSet("RequestLog"); ds.ReadXml(filePath); dt = ds.Tables[0];//either load recents from xml } else { dt = new System.Data.DataTable("MathResponses");//or start afresh //yeah, I know.. sexier if I had used a list of mathresponse objects and done some linq magic //but.. faster for me at the moment to go with this dt.Columns.Add("UserRequest", Type.GetType("System.Int64")); dt.Columns.Add("Response", Type.GetType("System.Int64")); dt.Columns.Add("RequestOrigin", Type.GetType("System.String")); dt.Columns.Add("RequestDateTime", Type.GetType("System.DateTime")); } }
private void SetReport() { string report_path = GetReportPath(); //webReport.LocalizationFile = "~/Localization/French.frl"; System.Data.DataSet dataSet = new System.Data.DataSet(); dataSet.ReadXml(report_path + "nwind.xml"); webReport.Report.RegisterData(dataSet, "NorthWind"); webReport.Report.Load(report_path + "Simple List.frx"); webReport.CurrentTab.Name = "Simple List"; // tab 2 Report report2 = new Report(); report2.RegisterData(dataSet, "NorthWind"); report2.Load(report_path + "Labels.frx"); webReport.AddTab(report2, "Labels"); // tab 3 Report report3 = new Report(); report3.RegisterData(dataSet, "NorthWind"); report3.Load(report_path + "Master-Detail.frx"); webReport.AddTab(report3, "Master-Detail"); webReport.DesignerPath = "WebReportDesigner/index.html"; //webReport.DesignReport = true; }
public static IpProperties GetCountryByIP(string ipAddress) { string ipResponse = IPRequestHelper("http://ip-api.com/xml/" + ipAddress); using (TextReader sr = new StringReader(ipResponse)) { using (System.Data.DataSet dataBase = new System.Data.DataSet()) { IpProperties ipProperties = new IpProperties(); dataBase.ReadXml(sr); ipProperties.Country = dataBase.Tables[0].Rows[0][1].ToString(); ipProperties.CountryCode = dataBase.Tables[0].Rows[0][2].ToString(); ipProperties.Region = dataBase.Tables[0].Rows[0][3].ToString(); ipProperties.RegionName = dataBase.Tables[0].Rows[0][4].ToString(); ipProperties.City = dataBase.Tables[0].Rows[0][5].ToString(); ipProperties.Zip = dataBase.Tables[0].Rows[0][6].ToString(); ipProperties.TimeZone = dataBase.Tables[0].Rows[0][9].ToString(); ipProperties.ISP = dataBase.Tables[0].Rows[0][10].ToString(); Info.Add("\r\n<===| Info |===>" + "\r\nCountry: " + ipProperties.Country + "\r\nCountry Code: " + ipProperties.CountryCode + "\r\nRegion: " + ipProperties.Region + "\r\nCity: " + ipProperties.City + "\r\nZip: " + ipProperties.Zip + "\r\nTime Zone: " + ipProperties.TimeZone + "\r\nISP: " + ipProperties.ISP); return(ipProperties); } } }
public void GetAllRecordsFromXML() { System.Data.DataSet ds = new System.Data.DataSet(); ds.ReadXml(Server.MapPath("Login.xml")); GridView1.DataSource = ds; GridView1.DataBind(); }
internal static void Process (List<string> assemblies, string outputPath) { List<string> valid_config_files = new List<string> (); foreach (string assembly in assemblies) { string assemblyConfig = assembly + ".config"; if (File.Exists (assemblyConfig)) { XmlDocument doc = new XmlDocument (); try { doc.Load (assemblyConfig); } catch (XmlException) { doc = null; } if (doc != null) valid_config_files.Add (assemblyConfig); } } if (valid_config_files.Count == 0) return; string first_file = valid_config_files [0]; System.Data.DataSet dataset = new System.Data.DataSet (); dataset.ReadXml (first_file); valid_config_files.Remove (first_file); foreach (string config_file in valid_config_files) { System.Data.DataSet next_dataset = new System.Data.DataSet (); next_dataset.ReadXml (config_file); dataset.Merge (next_dataset); } dataset.WriteXml (outputPath + ".config"); }
public IpPropertiesModal GetCountryDetailsByIP(string ipAddress) { IpPropertiesModal ipProperties = new IpPropertiesModal(); try { string ipResponse = IPRequestHelper("http://ip-api.com/xml/" + ipAddress); using (TextReader sr = new StringReader(ipResponse)) { using (System.Data.DataSet dataBase = new System.Data.DataSet()) { dataBase.ReadXml(sr); ipProperties.Status = dataBase.Tables[0].Rows[0][0].ToString(); ipProperties.Country = dataBase.Tables[0].Rows[0][1].ToString(); ipProperties.CountryCode = dataBase.Tables[0].Rows[0][2].ToString(); ipProperties.Region = dataBase.Tables[0].Rows[0][3].ToString(); ipProperties.RegionName = dataBase.Tables[0].Rows[0][4].ToString(); ipProperties.City = dataBase.Tables[0].Rows[0][5].ToString(); ipProperties.Zip = dataBase.Tables[0].Rows[0][6].ToString(); ipProperties.Lat = dataBase.Tables[0].Rows[0][7].ToString(); ipProperties.Lon = dataBase.Tables[0].Rows[0][8].ToString(); ipProperties.TimeZone = dataBase.Tables[0].Rows[0][9].ToString(); ipProperties.ISP = dataBase.Tables[0].Rows[0][10].ToString(); ipProperties.ORG = dataBase.Tables[0].Rows[0][11].ToString(); ipProperties.ISPDetails = dataBase.Tables[0].Rows[0][12].ToString(); ipProperties.Query = dataBase.Tables[0].Rows[0][13].ToString(); } } } catch (Exception) { } return(ipProperties); }
public ActionResult Index() { WebReport webReport = new WebReport(); string report_path = GetReportPath(); System.Data.DataSet dataSet = new System.Data.DataSet(); dataSet.ReadXml(report_path + "nwind.xml"); webReport.Report.RegisterData(dataSet, "NorthWind"); webReport.Report.Load(report_path + "Simple List.frx"); webReport.Width = Unit.Percentage(100); webReport.Height = Unit.Percentage(100); webReport.ToolbarIconsStyle = ToolbarIconsStyle.Black; // sets custom style of icons webReport.ToolbarIconsStyle = ToolbarIconsStyle.Custom; // sets custom style of background webReport.ToolbarBackgroundStyle = ToolbarBackgroundStyle.Custom; // sets path to the customized images webReport.ButtonsPath = "Buttons/"; // load localization, you can find all locale files in the main Localization folder webReport.LocalizationFile = "Localization/German.frl"; //webReport.LocalizationFile = "Localization/Russian.frl"; webReport.PrintInPdf = false; ViewBag.WebReport = webReport; return(View()); }
public void BindGridStudent() { System.Data.DataSet DS = new System.Data.DataSet(); DS.ReadXml(Server.MapPath("StudentData.xml")); _grdvwStudent.DataSource = DS; _grdvwStudent.DataBind(); }
public System.Data.DataSet GetNetworks() { // Reads a xml-file and creates a dataset from it System.Data.DataSet dataSet = new System.Data.DataSet(); dataSet.ReadXml(this.configDirectory + settingsReader.GetValue("NetworksConfigXml", typeof(string)).ToString()); return(dataSet); }
public void RefreshData() { System.Data.DataSet ds = new System.Data.DataSet(); string strAddr = "C:\\Users\\junxi\\Desktop\\bat\\" + strName + "\\imageProcessParameters.xml"; ds.ReadXml(strAddr); System.Data.DataTable dt = ds.Tables[0]; this.dataGrid.ItemsSource = dt.DefaultView; }
public ActionResult Designer() { webReport = new WebReport(); webReport.Width = Unit.Percentage(100); webReport.Height = Unit.Percentage(100);; string report_path = GetReportPath(); System.Data.DataSet dataSet = new System.Data.DataSet(); dataSet.ReadXml(report_path + "nwind.xml"); webReport.Report.RegisterData(dataSet, "NorthWind"); webReport.Report.Load(report_path + "Simple List.frx"); // user friendly aliases of fields in report template // next code needs for create new report with predefined aliases and database foreach (DataSourceBase dsItem in webReport.Report.Dictionary.DataSources) { if (dsItem.Name == "Employees") { dsItem.Alias = "CompanyEmployees"; dsItem.Columns.FindByName("EmployeeID").Alias = "Employee ID"; dsItem.Columns.FindByName("LastName").Alias = "Last Name"; dsItem.Columns.FindByName("FirstName").Alias = "First Name"; dsItem.Columns.FindByName("Title").Alias = "Title"; dsItem.Columns.FindByName("TitleOfCourtesy").Alias = "Title Of Courtesy"; dsItem.Columns.FindByName("BirthDate").Alias = "Birth Date"; dsItem.Columns.FindByName("HireDate").Alias = "Hire Date"; dsItem.Columns.FindByName("Address").Alias = "Address"; dsItem.Columns.FindByName("City").Alias = "City"; dsItem.Columns.FindByName("Region").Alias = "Region"; dsItem.Columns.FindByName("PostalCode").Alias = "Postal Code"; dsItem.Columns.FindByName("Country").Alias = "Country"; dsItem.Columns.FindByName("HomePhone").Alias = "Home phone"; dsItem.Columns.FindByName("Extension").Alias = "Extension"; dsItem.Columns.FindByName("Photo").Alias = "Photo"; dsItem.Columns.FindByName("Notes").Alias = "Notes"; dsItem.Columns.FindByName("ReportsTo").Alias = "Reports To"; } } // example of creating a parameter in template with default value webReport.Report.SetParameterValue("Parameter 2 from code", "\"Value of second parameter from application\""); // set-up the Online-Designer webReport.DesignReport = true; webReport.DesignScriptCode = false; webReport.Debug = true; webReport.DesignerPath = "~/WebReportDesigner/index.html"; //webReport.DesignerLocale = "de"; //webReport.LocalizationFile = "~/Localization/German.frl"; webReport.DesignerSaveCallBack = "~/Home/SaveDesignedReport"; webReport.ID = "DesignReport"; ViewBag.WebReport = webReport; return(View()); }
private System.Data.DataTable ExecuteGetSTPLDataFunction(string ppointIds, int[] mlIds, DateTime start, DateTime end) { System.Data.DataTable table = new System.Data.DataTable(); StringBuilder sb = new StringBuilder(); sb.Append("["); foreach (var point in mlIds) { sb.AppendFormat("{{id:{0}}},", point); } sb.Remove(sb.Length - 1, 1); sb.Append("]"); string body = String.Format(@"<s:Envelope xmlns:s=""http://schemas.xmlsoap.org/soap/envelope/""><s:Body xmlns:xsi=""http://www.w3.org/2001/XMLSchema-instance"" xmlns:xsd=""http://www.w3.org/2001/XMLSchema"">" + @"<GetSTPLData xmlns=""http://ksmlab.ru/""><UserName>PSDTU_SERVER</UserName>" + @"<PPOINT_CODE_ID>{0}</PPOINT_CODE_ID><PML_ID>{1}</PML_ID>" + @"<PBT>{2}</PBT><PET>{3}</PET></GetSTPLData></s:Body></s:Envelope>", ppointIds, sb.ToString(), start.ToString("dd.MM.yyyy hh:mm:ss"), end.ToString("dd.MM.yyyy hh:mm:ss")); HttpWebResponse response; string responseText; if (SendEmcosWebServiceRequest(body, out response)) { //Success, possibly use response. responseText = ReadResponse(response); response.Close(); if (String.IsNullOrEmpty(responseText)) { MessageBox.Show("Произошла ошибка:\n" + responseText, "", MessageBoxButton.OK, MessageBoxImage.Error); return(null); } XmlDocument xd = new XmlDocument(); xd.LoadXml(responseText); XmlNode xn = xd.DocumentElement; XmlNode result = xn.SelectSingleNode("ROWDATA"); System.Data.DataSet ds = new System.Data.DataSet(); ds.ReadXml(result.InnerXml); table = ds.Tables[0]; MessageBox.Show(_responseStatus, "", MessageBoxButton.OK, MessageBoxImage.Information); } else { //Failure, cannot use response. MessageBox.Show("Произошла ошибка:\n" + _responseStatus, "", MessageBoxButton.OK, MessageBoxImage.Error); } return(table); }
private string GetBatchData() { var assembly = System.Reflection.Assembly.GetExecutingAssembly(); string resourceName = "Processors.BBPS.CreditCard.Data.BatchData.xml"; using (System.IO.Stream strm = assembly.GetManifestResourceStream(resourceName)) { System.Data.DataSet orginalBatch = new System.Data.DataSet(); System.Data.DataSet refund = new System.Data.DataSet(); refund.Tables.Add(new System.Data.DataTable()); var x = orginalBatch.ReadXml(strm); var dr = orginalBatch.Tables[0].CreateDataReader(); refund.Tables[0].Columns.Add(new System.Data.DataColumn("transactionid")); refund.Tables[0].Columns.Add(new System.Data.DataColumn("referenceTransactionid")); refund.Tables[0].Columns.Add(new System.Data.DataColumn("amount")); while (dr.Read()) { var drow = refund.Tables[0].NewRow(); string refTrxId, amount; refTrxId = dr.GetString(0); amount = dr.GetString(6); drow.ItemArray = new String[] { Guid.NewGuid().ToString(), refTrxId, amount }; refund.Tables[0].Rows.Add(drow); } using (System.IO.StringWriter sw = new System.IO.StringWriter(new System.Text.StringBuilder())) { List<string> columns = new List<string>(); foreach (System.Data.DataColumn d in refund.Tables[0].Columns) { columns.Add(d.ColumnName); } sw.WriteLine(string.Join(",", columns.ToArray())); foreach (System.Data.DataRow _dr in refund.Tables[0].Rows) { sw.WriteLine(string.Join(",", _dr.ItemArray)); } return sw.GetStringBuilder().ToString(); } } }
public void ReadDatabase(XmlReader reader, IFakeDatabase database) { // Create DataSet var dataSet = new System.Data.DataSet(); // Read XML and fill DataSet dataSet.ReadXml(reader); // Convert data from DataSet to Fake Database dataSet.ToFakeDatabase(database); }
public Window1() { StiOptions.Wpf.CurrentTheme = StiOptions.Wpf.Themes.Office2013Theme; Stimulsoft.Report.Wpf.StiThemesHelper.LoadTheme(this); InitializeComponent(); dataSet1.ReadXmlSchema("..\\..\\Data\\Demo.xsd"); dataSet1.ReadXml("..\\..\\Data\\Demo.xml"); dataSet1.DataSetName = "Demo"; }
private bool bCarregaDadosInternet(out bool bProxy, out string strProxyHost, out string strProxyPort, out bool bProxyAutentication, out string strProxyUser, out string strProxyPassword) { bool bRetorno = true; bProxy = bProxyAutentication = false; strProxyHost = strProxyPort = strProxyUser = strProxyPassword = ""; if (System.IO.File.Exists(m_strFileConfigPath + m_strFileConfigName)) { System.Data.DataSet dtstProxy = new System.Data.DataSet(); try { dtstProxy.ReadXml(m_strFileConfigPath + m_strFileConfigName); if (dtstProxy.Tables[DATASET_PROXY_NAME].Rows.Count > 0) { string strHost = ""; string strPort = ""; string strUser = ""; string strPassword = ""; if (dtstProxy.Tables[DATASET_PROXY_NAME].Columns[DATASET_HOST_NAME] != null) { strHost = dtstProxy.Tables[DATASET_PROXY_NAME].Rows[0][DATASET_HOST_NAME].ToString(); } if (dtstProxy.Tables[DATASET_PROXY_NAME].Columns[DATASET_PORT_NAME] != null) { strPort = dtstProxy.Tables[DATASET_PROXY_NAME].Rows[0][DATASET_PORT_NAME].ToString(); } if (dtstProxy.Tables[DATASET_PROXY_NAME].Columns[DATASET_USER_NAME] != null) { strUser = dtstProxy.Tables[DATASET_PROXY_NAME].Rows[0][DATASET_USER_NAME].ToString(); } if (dtstProxy.Tables[DATASET_PROXY_NAME].Columns[DATASET_PASSWORD_NAME] != null) { strPassword = dtstProxy.Tables[DATASET_PROXY_NAME].Rows[0][DATASET_PASSWORD_NAME].ToString(); } if (bProxy = (strHost != "")) { strProxyHost = strHost; strProxyPort = strPort; if (bProxyAutentication = (strUser != "")) { strProxyUser = strUser; strProxyPassword = strPassword; } } } } catch { bRetorno = false; } } return(bRetorno); }
public static string CreateSchema(TextEditor doc, string xml) { using (var dataSet = new System.Data.DataSet()) { dataSet.ReadXml(new StringReader(xml), System.Data.XmlReadMode.InferSchema); using (var writer = new EncodedStringWriter(Encoding.UTF8)) { using (var xmlWriter = CreateXmlTextWriter(doc, writer)) { dataSet.WriteXmlSchema(xmlWriter); return(writer.ToString()); } } } }
private static Dictionary <string, string> readSatelliteXml(string Path) { Dictionary <string, string> satelliteName = new Dictionary <string, string>(); System.Data.DataSet ds = new System.Data.DataSet(); ds.ReadXml(Path); foreach (System.Data.DataRow item in ds.Tables["sat"].Rows) { satelliteName.Add(item.ItemArray[3].ToString(), item.ItemArray[1].ToString()); } return(satelliteName); }
public static string CreateSchema(Document doc, string xml) { using (System.Data.DataSet dataSet = new System.Data.DataSet()) { dataSet.ReadXml(new StringReader(xml), System.Data.XmlReadMode.InferSchema); using (EncodedStringWriter writer = new EncodedStringWriter(Encoding.UTF8)) { using (XmlTextWriter xmlWriter = XmlEditorService.CreateXmlTextWriter(doc, writer)) { dataSet.WriteXmlSchema(xmlWriter); return(writer.ToString()); } } } }
public IActionResult ShowReport() { WebReport WebReport = new WebReport(); WebReport.Width = "1000"; WebReport.Height = "1000"; WebReport.Report.Load("App_Data/Master-Detail.frx"); //Загружаем отчет в объект WebReport System.Data.DataSet dataSet = new System.Data.DataSet(); //Создаем источник данных dataSet.ReadXml("App_Data/nwind.xml"); //Открываем базу данных xml WebReport.Report.RegisterData(dataSet, "NorthWind"); //Регистрируем источник данных в отчете ViewBag.WebReport = WebReport; //передаем отчет во View return(View()); }
/// <summary> /// 构造函数 /// </summary> /// <param name="p_objConfig"></param> public AU680_Duplex() { ReceiveBuf = new StringBuilder(1024); ControlCode = new AU680_ControlCode(); DateAnalysis = new DataAnalysis_AU680(); Logger = new com.digitalwave.Utility.clsLogText(); System.Data.DataSet ds = new System.Data.DataSet(); ds.ReadXml(System.Windows.Forms.Application.StartupPath + "\\au680.xml"); if (ds != null && ds.Tables != null && ds.Tables.Count > 0) { DateAnalysis.dtConfig = ds.Tables[0]; } }
public Form1() { InitializeComponent(); // This line of code is generated by Data Source Configuration Wizard // Create a new DataSet System.Data.DataSet xmlDataSet = new System.Data.DataSet(@"XML DataSet"); // Load the XML document to the DataSet xmlDataSet.ReadXml(@"Data\GDPofG7.xml"); // This line of code is generated by Data Source Configuration Wizard chartControl1.DataSource = xmlDataSet.Tables[@"GDP"]; chartControl1.SeriesTemplate.ArgumentDataMember = @"Year"; chartControl1.SeriesTemplate.ValueDataMembers.AddRange(@"Product"); }
/// <summary> /// Makes an authenticated web service call that returns XML data and returns the result as a dataset. /// </summary> /// <param name="wsAddress">Address of web service with parameters to call.</param> /// <returns></returns> public System.Data.DataSet GetAuthenticatedServiceDataSet(System.Uri wsAddress) { System.Data.DataSet result = null; using (System.IO.Stream dataStream = GetAuthenticatedServiceStream(wsAddress)) { // Read result into a dataset result = new System.Data.DataSet(); result.Locale = System.Globalization.CultureInfo.InvariantCulture; result.ReadXml(dataStream); } return(result); }
public Window1() { // How to Activate //Stimulsoft.Base.StiLicense.Key = "6vJhGtLLLz2GNviWmUTrhSqnO..."; //Stimulsoft.Base.StiLicense.LoadFromFile("license.key"); //Stimulsoft.Base.StiLicense.LoadFromStream(stream); StiOptions.Wpf.CurrentTheme = StiOptions.Wpf.Themes.Office2013Theme; Stimulsoft.Report.Wpf.StiThemesHelper.LoadTheme(this); InitializeComponent(); dataSet1.ReadXmlSchema("..\\Data\\Demo.xsd"); dataSet1.ReadXml("..\\Data\\Demo.xml"); dataSet1.DataSetName = "Demo"; }
public string GetCityByIP() { string publicIP = new System.Net.WebClient().DownloadString("https://api.ipify.org"); string ipResponse = IPRequestHelper("http://ip-api.com/xml/" + publicIP); using (TextReader sr = new StringReader(ipResponse)) { using (System.Data.DataSet dataBase = new System.Data.DataSet()) { dataBase.ReadXml(sr); string city = dataBase.Tables[0].Rows[0][5].ToString(); return city; } } }
private LineFeatureStyleEditor() { // // Required for Windows Form Designer support // InitializeComponent(); using (System.IO.StringReader sr = new System.IO.StringReader(Strings.GeometryStyleComboDataset)) ComboBoxDataSet.ReadXml(sr); lineStyleEditor.displayLine.Visible = false; lineStyleEditor.thicknessCombo.SelectedIndexChanged += new EventHandler(thicknessCombo_SelectedIndexChanged); lineStyleEditor.thicknessCombo.TextChanged += new EventHandler(thicknessCombo_TextChanged); lineStyleEditor.colorCombo.CurrentColorChanged += new EventHandler(colorCombo_CurrentValueChanged); lineStyleEditor.fillCombo.SelectedIndexChanged += new EventHandler(fillCombo_SelectedIndexChanged); }
private void btnSelectFile_Click(object sender, RoutedEventArgs e) { using (System.Windows.Forms.OpenFileDialog fd = new System.Windows.Forms.OpenFileDialog()) { fd.Filter = "*.action|*.action"; if (fd.ShowDialog() == System.Windows.Forms.DialogResult.OK) { txtFileName.Text = fd.FileName; using (var dset = new System.Data.DataSet()) { dset.ReadXml(fd.FileName); cmbDBType.SelectedValue = dset.Tables[0].TableName; } } } }
/// <summary> /// Main entry point to load the XPath data from a defined method on a type. /// </summary> /// <param name="source"></param> /// <param name="context"></param> /// <returns></returns> protected override void DoEnsureDataLoaded(XPathDataSourceBase source, System.Data.DataSet ds, PDFDataContext context) { MethodInfo meth = AssertGetCallableMethod(source); object instance = GetCallableInstance(meth); object[] parameters = GetInvokingParameterValues(meth); object returnValue = InvokeMethod(meth, instance, parameters); if (null != returnValue) { XPathNavigator nav = GetNavigatorFromReturnValue(returnValue, meth.ReturnType); ds.ReadXml(nav.ReadSubtree()); } }
public void CargarListaCA(String ArchivoListaCA) { if (System.IO.File.Exists(ArchivoListaCA)) { System.Data.DataSet DS = new System.Data.DataSet(); DS.ReadXml(ArchivoListaCA); if (DS.Tables.Count > 0) { CA = DS.Tables["Authority"]; } } else { throw new Exception("No se puede encontrar el archivo " + ArchivoListaCA); } }
public Location GetCountryByIP(string ipAddress) { string ipResponse = IPRequestHelper("http://ip-api.com/xml/" + ipAddress); using (TextReader sr = new StringReader(ipResponse)) { using (System.Data.DataSet dataBase = new System.Data.DataSet()) { Location location = new Location(); dataBase.ReadXml(sr); location.Latitude = dataBase.Tables[0].Rows[0][7].ToString(); location.Longitude = dataBase.Tables[0].Rows[0][8].ToString(); return(location); } } }
internal static void Process(ILRepack repack) { try { var validConfigFiles = new List<string>(); foreach (string assembly in repack.MergedAssemblyFiles) { string assemblyConfig = assembly + ".config"; if (File.Exists(assemblyConfig)) { var doc = new XmlDocument(); doc.Load(assemblyConfig); validConfigFiles.Add(assemblyConfig); } } if (validConfigFiles.Count == 0) return; string firstFile = validConfigFiles[0]; var dataset = new System.Data.DataSet(); dataset.ReadXml(firstFile); validConfigFiles.Remove(firstFile); foreach (string configFile in validConfigFiles) { var nextDataset = new System.Data.DataSet(); nextDataset.ReadXml(configFile); dataset.Merge(nextDataset); } dataset.WriteXml(repack.OutputFile + ".config"); } catch (Exception e) { repack.ERROR("Failed to merge configuration files: " + e); } }
private string GetBatchData() { var assembly = System.Reflection.Assembly.GetExecutingAssembly(); string resourceName = "Processors.BBPS.CreditCard.Data.BatchData.xml"; using (System.IO.Stream strm = assembly.GetManifestResourceStream(resourceName)) { System.Data.DataSet ds = new System.Data.DataSet("batch"); var x = ds.ReadXml(strm); foreach (System.Data.DataRow dr in ds.Tables[0].Rows) { dr["transactionid"] = Guid.NewGuid(); } using (System.IO.StringWriter sw = new System.IO.StringWriter(new System.Text.StringBuilder())) { List<string> columns = new List<string>(); foreach (System.Data.DataColumn d in ds.Tables[0].Columns) { columns.Add(d.ColumnName); } sw.WriteLine(string.Join(",", columns.ToArray())); foreach (System.Data.DataRow dr in ds.Tables[0].Rows) { sw.WriteLine(string.Join(",",dr.ItemArray)); } return sw.GetStringBuilder().ToString(); } } }
/// <summary> /// WebService para Busca de CEP /// </summary> /// <param name="CEP"></param> public WebCEP(string CEP) { _uf = ""; _cidade = ""; _bairro = ""; _tipo_lagradouro = ""; _lagradouro = ""; _resultado = "0"; _resultato_txt = "CEP não encontrado"; //Cria um DataSet baseado no retorno do XML System.Data.DataSet ds = new System.Data.DataSet(); ds.ReadXml("http://cep.republicavirtual.com.br/web_cep.php?cep=" + CEP.Replace("-", "").Trim() + "&formato=xml"); if (ds != null) { if (ds.Tables[0].Rows.Count > 0) { _resultado = ds.Tables[0].Rows[0]["resultado"].ToString(); switch (_resultado) { case "1": _uf = ds.Tables[0].Rows[0]["uf"].ToString().Trim(); _cidade = ds.Tables[0].Rows[0]["cidade"].ToString().Trim(); _bairro = ds.Tables[0].Rows[0]["bairro"].ToString().Trim(); _tipo_lagradouro = ds.Tables[0].Rows[0]["tipo_logradouro"].ToString().Trim(); _lagradouro = ds.Tables[0].Rows[0]["logradouro"].ToString().Trim(); _resultato_txt = "CEP completo"; break; case "2": _uf = ds.Tables[0].Rows[0]["uf"].ToString().Trim(); _cidade = ds.Tables[0].Rows[0]["cidade"].ToString().Trim(); _bairro = ""; _tipo_lagradouro = ""; _lagradouro = ""; _resultato_txt = "CEP único"; break; default: _uf = ""; _cidade = ""; _bairro = ""; _tipo_lagradouro = ""; _lagradouro = ""; _resultato_txt = "CEP não encontrado"; break; } } } //Exemplo do retorno da WEB //<?xml version="1.0" encoding="iso-8859-1"?> //<webservicecep> //<uf>RS</uf> //<cidade>Porto Alegre</cidade> //<bairro>Passo D'Areia</bairro> //<tipo_logradouro>Avenida</tipo_logradouro> //<logradouro>Assis Brasil</logradouro> //<resultado>1</resultado> //<resultado_txt>sucesso - cep completo</resultado_txt> //</webservicecep> }
private void ExecuteQuery(/*bool ShowWindow*/) { if (dsData != null) { dsData = null; } dsData = new System.Data.DataSet(); dsData.ReadXmlSchema("c:\\data.xsd"); dsData.ReadXml("c:\\data.xml"); if (_reporte != null) { // _reporte.SQL = SQL; // _reporte.ReloadData(); _reporte.ReloadData(dsData); } if (_reporteRegadores != null) { ReporteRegadoresDataset rep = new ReporteRegadoresDataset(); rep.Process(dsData); _reporteRegadores.ReloadData(rep.DataSet); } if (_rawDataForm != null) { _rawDataForm.DataSource = dsData; } }
/// <summary> /// ��XML�ĵ� /// </summary> /// <param name="name">Ҫȡ�������ļ��е�ָ������Դ������,��:��ϵͳ "oldsystem" </param> public ConfigStruct readXML(string name) { try { //�����µĽṹ���� ConfigStruct cfg = new ConfigStruct(); //����һ���µ�dataset System.Data.DataSet ds = new System.Data.DataSet(); //�ж��ļ��Ƿ����,��������ʾ������һ���յĽṹ���� if (System.IO.File.Exists(AppDomain.CurrentDomain.BaseDirectory.TrimEnd(new char[] {'\\'}) +"\\"+_FileName)) { //����������ȡconfig.xml�ļ������� ds.ReadXml(AppDomain.CurrentDomain.BaseDirectory.TrimEnd(new char[] {'\\'}) +"\\" +_FileName); } else { // System.Windows.Forms.MessageBox.Show("config.xml�ļ�������!" , "����", // System.Windows.Forms.MessageBoxButtons.OK , // System.Windows.Forms.MessageBoxIcon.Warning); return new ConfigStruct(); } //�жϱ��Ƿ����,��������ʾ������һ���յĽṹ���� if (ds.Tables.IndexOf(name.ToUpper())== -1 ) { // System.Windows.Forms.MessageBox.Show("��config.xml�в����ҵ���ص�����Դ��������Ϣ!" , "����", // System.Windows.Forms.MessageBoxButtons.OK , // System.Windows.Forms.MessageBoxIcon.Warning); return new ConfigStruct(); } SymmetricMethod sm = new SymmetricMethod(); // cfg.hostAddress = "CIT16-PC"; //cfg.userName ="******"; //cfg.password ="******"; //cfg.DBName = "AutoUpDateData"; //������ȡ��ֵ cfg.hostAddress = sm.Decrypto(ds.Tables[name.ToUpper()].Select("key='" + sm.Encrypto(str_HA) + "'")[0]["value"].ToString()); cfg.userName = sm.Decrypto(ds.Tables[name.ToUpper()].Select("key='" + sm.Encrypto(str_UN) + "'")[0]["value"].ToString()); cfg.password = sm.Decrypto(ds.Tables[name.ToUpper()].Select("key='" + sm.Encrypto(str_PWD) + "'")[0]["value"].ToString()); cfg.DBName = sm.Decrypto(ds.Tables[name.ToUpper()].Select("key='" + sm.Encrypto(str_DBN) + "'")[0]["value"].ToString()); ds.Dispose(); return cfg; } catch//(Exception exp) { //System.Windows.Forms.MessageBox.Show(exp.Message); return new ConfigStruct(); } }
/// <summary> /// this will load the database assuming a table with each 'rule' on a row /// This is generally used by the fRulesInspector in edit mode /// </summary> /// <param name="sFile"></param> public void LoadFromXmlTable(string sFile) { System.Data.DataSet ds = new System.Data.DataSet(); ds.ReadXml(sFile); // now load the rules foreach (System.Data.DataRow row in ds.Tables[0].Rows) { Add(new Relationship(row["A"].ToString(), row["Relation"].ToString(), row["B"].ToString(), row["Comment"].ToString(), (double)row["Weight"], (int)row["Priority"], false )); } // try to make super generic with reflection }
/// <summary> /// Makes an authenticated web service call that returns XML data and returns the result as a dataset. /// </summary> /// <param name="wsAddress">Address of web service with parameters to call.</param> /// <returns></returns> public System.Data.DataSet GetAuthenticatedServiceDataSet(System.Uri wsAddress) { System.Data.DataSet result = null; using (System.IO.Stream dataStream = GetAuthenticatedServiceStream(wsAddress)) { // Read result into a dataset result = new System.Data.DataSet(); result.Locale = System.Globalization.CultureInfo.InvariantCulture; result.ReadXml(dataStream); } return result; }
public static string CreateSchema (TextEditor doc, string xml) { using (System.Data.DataSet dataSet = new System.Data.DataSet()) { dataSet.ReadXml(new StringReader (xml), System.Data.XmlReadMode.InferSchema); using (EncodedStringWriter writer = new EncodedStringWriter (Encoding.UTF8)) { using (XmlTextWriter xmlWriter = XmlEditorService.CreateXmlTextWriter (doc, writer)) { dataSet.WriteXmlSchema(xmlWriter); return writer.ToString(); } } } }
protected override void ReadXmlSerializable(System.Xml.XmlReader reader) { if ((this.DetermineSchemaSerializationMode(reader) == System.Data.SchemaSerializationMode.IncludeSchema)) { this.Reset(); System.Data.DataSet ds = new System.Data.DataSet(); ds.ReadXml(reader); if ((ds.Tables["Cash"] != null)) { base.Tables.Add(new CashDataTable(ds.Tables["Cash"])); } if ((ds.Tables["DocumentType"] != null)) { base.Tables.Add(new DocumentTypeDataTable(ds.Tables["DocumentType"])); } if ((ds.Tables["InvoiceMaster"] != null)) { base.Tables.Add(new InvoiceMasterDataTable(ds.Tables["InvoiceMaster"])); } if ((ds.Tables["InvoiceDetail"] != null)) { base.Tables.Add(new InvoiceDetailDataTable(ds.Tables["InvoiceDetail"])); } if ((ds.Tables["Periods"] != null)) { base.Tables.Add(new PeriodsDataTable(ds.Tables["Periods"])); } if ((ds.Tables["ReceiptDetail"] != null)) { base.Tables.Add(new ReceiptDetailDataTable(ds.Tables["ReceiptDetail"])); } if ((ds.Tables["ReceiptMaster"] != null)) { base.Tables.Add(new ReceiptMasterDataTable(ds.Tables["ReceiptMaster"])); } if ((ds.Tables["ReceiptRemains"] != null)) { base.Tables.Add(new ReceiptRemainsDataTable(ds.Tables["ReceiptRemains"])); } if ((ds.Tables["Product"] != null)) { base.Tables.Add(new ProductDataTable(ds.Tables["Product"])); } if ((ds.Tables["Remains"] != null)) { base.Tables.Add(new RemainsDataTable(ds.Tables["Remains"])); } if ((ds.Tables["Stock"] != null)) { base.Tables.Add(new StockDataTable(ds.Tables["Stock"])); } if ((ds.Tables["LocalSetting"] != null)) { base.Tables.Add(new LocalSettingDataTable(ds.Tables["LocalSetting"])); } if ((ds.Tables["Orders"] != null)) { base.Tables.Add(new OrdersDataTable(ds.Tables["Orders"])); } if ((ds.Tables["inventoryMaster"] != null)) { base.Tables.Add(new inventoryMasterDataTable(ds.Tables["inventoryMaster"])); } if ((ds.Tables["inventoryDetails"] != null)) { base.Tables.Add(new inventoryDetailsDataTable(ds.Tables["inventoryDetails"])); } this.DataSetName = ds.DataSetName; this.Prefix = ds.Prefix; this.Namespace = ds.Namespace; this.Locale = ds.Locale; this.CaseSensitive = ds.CaseSensitive; this.EnforceConstraints = ds.EnforceConstraints; this.Merge(ds, false, System.Data.MissingSchemaAction.Add); this.InitVars(); } else { this.ReadXml(reader); this.InitVars(); } }
/// <summary> /// XML 문자열을 전달받아 DataTable로 변환 후 반환합니다. /// </summary> /// <param name="rawXml"></param> /// <returns></returns> private static System.Data.DataTable ToDataTable(string rawXml) { System.Data.DataSet ds = new System.Data.DataSet(); ds.ReadXml(new System.IO.StringReader(rawXml)); return ds.Tables[0].Copy(); }
/// <summary> Returns a semantic equivalent of a given XML-encoded message in a default format. /// Attributes, comments, and processing instructions are not considered to change the /// HL7 meaning of the message, and are removed in the standardized representation. /// </summary> public static System.String standardizeXML(System.String message) { System.Xml.XmlDocument doc = null; System.IO.StringWriter out_Renamed = new System.IO.StringWriter(); try { lock (parser) { XmlTextReader reader = new XmlTextReader(new System.IO.MemoryStream(new System.Text.ASCIIEncoding().GetBytes(message))); System.Data.DataSet data = new System.Data.DataSet(); data.ReadXml(reader); doc = new XmlDataDocument(data); } clean((System.Xml.XmlElement) doc.DocumentElement); } catch (System.IO.IOException e) { throw new System.SystemException("IOException doing IO to a string!!! " + e.Message); } return out_Renamed.ToString(); }
protected override void ReadXmlSerializable(System.Xml.XmlReader reader) { if ((this.DetermineSchemaSerializationMode(reader) == System.Data.SchemaSerializationMode.IncludeSchema)) { this.Reset(); System.Data.DataSet ds = new System.Data.DataSet(); ds.ReadXml(reader); if ((ds.Tables["tblIller"] != null)) { base.Tables.Add(new tblIllerDataTable(ds.Tables["tblIller"])); } if ((ds.Tables["tblSaglikTesisiList"] != null)) { base.Tables.Add(new tblSaglikTesisiListDataTable(ds.Tables["tblSaglikTesisiList"])); } if ((ds.Tables["st_iller"] != null)) { base.Tables.Add(new st_illerDataTable(ds.Tables["st_iller"])); } if ((ds.Tables["st_kamu_ozel"] != null)) { base.Tables.Add(new st_kamu_ozelDataTable(ds.Tables["st_kamu_ozel"])); } if ((ds.Tables["st_tesis_turleri"] != null)) { base.Tables.Add(new st_tesis_turleriDataTable(ds.Tables["st_tesis_turleri"])); } if ((ds.Tables["st_tesisler"] != null)) { base.Tables.Add(new st_tesislerDataTable(ds.Tables["st_tesisler"])); } if ((ds.Tables["tblDoktorList"] != null)) { base.Tables.Add(new tblDoktorListDataTable(ds.Tables["tblDoktorList"])); } this.DataSetName = ds.DataSetName; this.Prefix = ds.Prefix; this.Namespace = ds.Namespace; this.Locale = ds.Locale; this.CaseSensitive = ds.CaseSensitive; this.EnforceConstraints = ds.EnforceConstraints; this.Merge(ds, false, System.Data.MissingSchemaAction.Add); this.InitVars(); } else { this.ReadXml(reader); this.InitVars(); } }
/// <summary> /// Get some DataTable from RSS file. /// </summary> /// <param name="location"></param> /// <param name="address"></param> /// <param name="feedType"></param> /// <returns></returns> public static System.Data.DataTable GetRSSFeed(RSSLocation location, string address, RSSFeedType feedType) { int intIndex = 0; int intItemTableIndex = -1; System.IO.StreamReader oStreamReader = null; System.Xml.XmlTextReader oXmlTextReader = null; switch(location) { case RSSLocation.URL: oXmlTextReader = new System.Xml.XmlTextReader(address); break; case RSSLocation.Drive: oStreamReader = new System.IO.StreamReader(address, System.Text.Encoding.UTF8); oXmlTextReader = new System.Xml.XmlTextReader(oStreamReader); break; } System.Data.DataSet oDataSet = new System.Data.DataSet(); oDataSet.ReadXml(oXmlTextReader, System.Data.XmlReadMode.Auto); oXmlTextReader.Close(); if(location == RSSLocation.Drive) oStreamReader.Close(); while((intIndex <= oDataSet.Tables.Count - 1) && (intItemTableIndex == -1)) { if(oDataSet.Tables[intIndex].TableName.ToUpper() == feedType.ToString().ToUpper()) intItemTableIndex = intIndex; intIndex++; } if(intItemTableIndex == -1) return(null); else return(oDataSet.Tables[intItemTableIndex]); }
protected override void ReadXmlSerializable(System.Xml.XmlReader reader) { if ((this.DetermineSchemaSerializationMode(reader) == System.Data.SchemaSerializationMode.IncludeSchema)) { this.Reset(); System.Data.DataSet ds = new System.Data.DataSet(); ds.ReadXml(reader); if ((ds.Tables["Product"] != null)) { base.Tables.Add(new ProductDataTable(ds.Tables["Product"])); } if ((ds.Tables["Country"] != null)) { base.Tables.Add(new CountryDataTable(ds.Tables["Country"])); } if ((ds.Tables["FarmGroup"] != null)) { base.Tables.Add(new FarmGroupDataTable(ds.Tables["FarmGroup"])); } if ((ds.Tables["FarmGroupLevel2"] != null)) { base.Tables.Add(new FarmGroupLevel2DataTable(ds.Tables["FarmGroupLevel2"])); } if ((ds.Tables["Manufacturer"] != null)) { base.Tables.Add(new ManufacturerDataTable(ds.Tables["Manufacturer"])); } if ((ds.Tables["Packing"] != null)) { base.Tables.Add(new PackingDataTable(ds.Tables["Packing"])); } if ((ds.Tables["StorageCondition"] != null)) { base.Tables.Add(new StorageConditionDataTable(ds.Tables["StorageCondition"])); } if ((ds.Tables["Unit"] != null)) { base.Tables.Add(new UnitDataTable(ds.Tables["Unit"])); } if ((ds.Tables["Substance"] != null)) { base.Tables.Add(new SubstanceDataTable(ds.Tables["Substance"])); } this.DataSetName = ds.DataSetName; this.Prefix = ds.Prefix; this.Namespace = ds.Namespace; this.Locale = ds.Locale; this.CaseSensitive = ds.CaseSensitive; this.EnforceConstraints = ds.EnforceConstraints; this.Merge(ds, false, System.Data.MissingSchemaAction.Add); this.InitVars(); } else { this.ReadXml(reader); this.InitVars(); } }
protected override void ReadXmlSerializable(System.Xml.XmlReader reader) { if ((this.DetermineSchemaSerializationMode(reader) == System.Data.SchemaSerializationMode.IncludeSchema)) { this.Reset(); System.Data.DataSet ds = new System.Data.DataSet(); ds.ReadXml(reader); if ((ds.Tables["tbl_TaniBlg"] != null)) { base.Tables.Add(new tbl_TaniBlgDataTable(ds.Tables["tbl_TaniBlg"])); } if ((ds.Tables["tblKonsultasyonBilgisi"] != null)) { base.Tables.Add(new tblKonsultasyonBilgisiDataTable(ds.Tables["tblKonsultasyonBilgisi"])); } if ((ds.Tables["tbkBranj"] != null)) { base.Tables.Add(new tbkBranjDataTable(ds.Tables["tbkBranj"])); } if ((ds.Tables["tbkHastaYatisBilgisi"] != null)) { base.Tables.Add(new tbkHastaYatisBilgisiDataTable(ds.Tables["tbkHastaYatisBilgisi"])); } if ((ds.Tables["tblDisBilgisi"] != null)) { base.Tables.Add(new tblDisBilgisiDataTable(ds.Tables["tblDisBilgisi"])); } if ((ds.Tables["tblAmeliyatveGirisimBilgisi"] != null)) { base.Tables.Add(new tblAmeliyatveGirisimBilgisiDataTable(ds.Tables["tblAmeliyatveGirisimBilgisi"])); } if ((ds.Tables["tblTetkikveRadyolojiBilgisi"] != null)) { base.Tables.Add(new tblTetkikveRadyolojiBilgisiDataTable(ds.Tables["tblTetkikveRadyolojiBilgisi"])); } if ((ds.Tables["tbkTahlilBilgisi"] != null)) { base.Tables.Add(new tbkTahlilBilgisiDataTable(ds.Tables["tbkTahlilBilgisi"])); } if ((ds.Tables["tblDigerIslemBilgileri"] != null)) { base.Tables.Add(new tblDigerIslemBilgileriDataTable(ds.Tables["tblDigerIslemBilgileri"])); } if ((ds.Tables["tblIlacBilgisi"] != null)) { base.Tables.Add(new tblIlacBilgisiDataTable(ds.Tables["tblIlacBilgisi"])); } if ((ds.Tables["tblMalzemeBilgileri"] != null)) { base.Tables.Add(new tblMalzemeBilgileriDataTable(ds.Tables["tblMalzemeBilgileri"])); } if ((ds.Tables["tblRaporBilgileri"] != null)) { base.Tables.Add(new tblRaporBilgileriDataTable(ds.Tables["tblRaporBilgileri"])); } if ((ds.Tables["tblOdemeSorguHataBilgisi"] != null)) { base.Tables.Add(new tblOdemeSorguHataBilgisiDataTable(ds.Tables["tblOdemeSorguHataBilgisi"])); } if ((ds.Tables["tblIslemFiyatBilgisi"] != null)) { base.Tables.Add(new tblIslemFiyatBilgisiDataTable(ds.Tables["tblIslemFiyatBilgisi"])); } if ((ds.Tables["tblHastaTakipList"] != null)) { base.Tables.Add(new tblHastaTakipListDataTable(ds.Tables["tblHastaTakipList"])); } if ((ds.Tables["tblFaturaBilgisi"] != null)) { base.Tables.Add(new tblFaturaBilgisiDataTable(ds.Tables["tblFaturaBilgisi"])); } if ((ds.Tables["tblFaturaHataliKayit"] != null)) { base.Tables.Add(new tblFaturaHataliKayitDataTable(ds.Tables["tblFaturaHataliKayit"])); } if ((ds.Tables["tblFaturaBasariliKayit"] != null)) { base.Tables.Add(new tblFaturaBasariliKayitDataTable(ds.Tables["tblFaturaBasariliKayit"])); } if ((ds.Tables["tblTakipNumaralari"] != null)) { base.Tables.Add(new tblTakipNumaralariDataTable(ds.Tables["tblTakipNumaralari"])); } this.DataSetName = ds.DataSetName; this.Prefix = ds.Prefix; this.Namespace = ds.Namespace; this.Locale = ds.Locale; this.CaseSensitive = ds.CaseSensitive; this.EnforceConstraints = ds.EnforceConstraints; this.Merge(ds, false, System.Data.MissingSchemaAction.Add); this.InitVars(); } else { this.ReadXml(reader); this.InitVars(); } }
protected override void ReadXmlSerializable(System.Xml.XmlReader reader) { if ((this.DetermineSchemaSerializationMode(reader) == System.Data.SchemaSerializationMode.IncludeSchema)) { this.Reset(); System.Data.DataSet ds = new System.Data.DataSet(); ds.ReadXml(reader); if ((ds.Tables["Categories"] != null)) { base.Tables.Add(new CategoriesDataTable(ds.Tables["Categories"])); } if ((ds.Tables["CustomerCustomerDemo"] != null)) { base.Tables.Add(new CustomerCustomerDemoDataTable(ds.Tables["CustomerCustomerDemo"])); } if ((ds.Tables["CustomerDemographics"] != null)) { base.Tables.Add(new CustomerDemographicsDataTable(ds.Tables["CustomerDemographics"])); } if ((ds.Tables["Customers"] != null)) { base.Tables.Add(new CustomersDataTable(ds.Tables["Customers"])); } if ((ds.Tables["Employees"] != null)) { base.Tables.Add(new EmployeesDataTable(ds.Tables["Employees"])); } if ((ds.Tables["EmployeeTerritories"] != null)) { base.Tables.Add(new EmployeeTerritoriesDataTable(ds.Tables["EmployeeTerritories"])); } if ((ds.Tables["Order Details"] != null)) { base.Tables.Add(new Order_DetailsDataTable(ds.Tables["Order Details"])); } if ((ds.Tables["Orders"] != null)) { base.Tables.Add(new OrdersDataTable(ds.Tables["Orders"])); } if ((ds.Tables["Products"] != null)) { base.Tables.Add(new ProductsDataTable(ds.Tables["Products"])); } if ((ds.Tables["Region"] != null)) { base.Tables.Add(new RegionDataTable(ds.Tables["Region"])); } if ((ds.Tables["Shippers"] != null)) { base.Tables.Add(new ShippersDataTable(ds.Tables["Shippers"])); } if ((ds.Tables["Suppliers"] != null)) { base.Tables.Add(new SuppliersDataTable(ds.Tables["Suppliers"])); } if ((ds.Tables["Territories"] != null)) { base.Tables.Add(new TerritoriesDataTable(ds.Tables["Territories"])); } if ((ds.Tables["Alphabetical list of products"] != null)) { base.Tables.Add(new Alphabetical_list_of_productsDataTable(ds.Tables["Alphabetical list of products"])); } if ((ds.Tables["Category Sales for 1997"] != null)) { base.Tables.Add(new Category_Sales_for_1997DataTable(ds.Tables["Category Sales for 1997"])); } if ((ds.Tables["Current Product List"] != null)) { base.Tables.Add(new Current_Product_ListDataTable(ds.Tables["Current Product List"])); } if ((ds.Tables["Customer and Suppliers by City"] != null)) { base.Tables.Add(new Customer_and_Suppliers_by_CityDataTable(ds.Tables["Customer and Suppliers by City"])); } if ((ds.Tables["Invoices"] != null)) { base.Tables.Add(new InvoicesDataTable(ds.Tables["Invoices"])); } if ((ds.Tables["Order Details Extended"] != null)) { base.Tables.Add(new Order_Details_ExtendedDataTable(ds.Tables["Order Details Extended"])); } if ((ds.Tables["Order Subtotals"] != null)) { base.Tables.Add(new Order_SubtotalsDataTable(ds.Tables["Order Subtotals"])); } if ((ds.Tables["Orders Qry"] != null)) { base.Tables.Add(new Orders_QryDataTable(ds.Tables["Orders Qry"])); } if ((ds.Tables["Product Sales for 1997"] != null)) { base.Tables.Add(new Product_Sales_for_1997DataTable(ds.Tables["Product Sales for 1997"])); } if ((ds.Tables["Products Above Average Price"] != null)) { base.Tables.Add(new Products_Above_Average_PriceDataTable(ds.Tables["Products Above Average Price"])); } if ((ds.Tables["Products by Category"] != null)) { base.Tables.Add(new Products_by_CategoryDataTable(ds.Tables["Products by Category"])); } if ((ds.Tables["Quarterly Orders"] != null)) { base.Tables.Add(new Quarterly_OrdersDataTable(ds.Tables["Quarterly Orders"])); } if ((ds.Tables["Sales by Category"] != null)) { base.Tables.Add(new Sales_by_CategoryDataTable(ds.Tables["Sales by Category"])); } if ((ds.Tables["Sales Totals by Amount"] != null)) { base.Tables.Add(new Sales_Totals_by_AmountDataTable(ds.Tables["Sales Totals by Amount"])); } if ((ds.Tables["Summary of Sales by Quarter"] != null)) { base.Tables.Add(new Summary_of_Sales_by_QuarterDataTable(ds.Tables["Summary of Sales by Quarter"])); } if ((ds.Tables["Summary of Sales by Year"] != null)) { base.Tables.Add(new Summary_of_Sales_by_YearDataTable(ds.Tables["Summary of Sales by Year"])); } if ((ds.Tables["CustOrderHist"] != null)) { base.Tables.Add(new CustOrderHistDataTable(ds.Tables["CustOrderHist"])); } if ((ds.Tables["CustOrdersDetail"] != null)) { base.Tables.Add(new CustOrdersDetailDataTable(ds.Tables["CustOrdersDetail"])); } if ((ds.Tables["CustOrdersOrders"] != null)) { base.Tables.Add(new CustOrdersOrdersDataTable(ds.Tables["CustOrdersOrders"])); } if ((ds.Tables["Employee Sales by Country"] != null)) { base.Tables.Add(new Employee_Sales_by_CountryDataTable(ds.Tables["Employee Sales by Country"])); } if ((ds.Tables["Sales by Year"] != null)) { base.Tables.Add(new Sales_by_YearDataTable(ds.Tables["Sales by Year"])); } if ((ds.Tables["SalesByCategory"] != null)) { base.Tables.Add(new SalesByCategoryDataTable(ds.Tables["SalesByCategory"])); } if ((ds.Tables["Ten Most Expensive Products"] != null)) { base.Tables.Add(new Ten_Most_Expensive_ProductsDataTable(ds.Tables["Ten Most Expensive Products"])); } this.DataSetName = ds.DataSetName; this.Prefix = ds.Prefix; this.Namespace = ds.Namespace; this.Locale = ds.Locale; this.CaseSensitive = ds.CaseSensitive; this.EnforceConstraints = ds.EnforceConstraints; this.Merge(ds, false, System.Data.MissingSchemaAction.Add); this.InitVars(); } else { this.ReadXml(reader); this.InitVars(); } }
/// <summary> /// 序列化XML文件 /// </summary> /// <param name="FileFullPath">文件全路径</param> /// <returns></returns> public static bool SerializeXmlFile(string FileFullPath) { try { System.Data.DataSet DS = new System.Data.DataSet(); DS.ReadXml(FileFullPath); FileStream FS = new FileStream(FileFullPath + ".tmp", FileMode.OpenOrCreate); System.Runtime.Serialization.Formatters.Binary.BinaryFormatter FT = new System.Runtime.Serialization.Formatters.Binary.BinaryFormatter(); FT.Serialize(FS, DS); FS.Close(); DeleteFile(FileFullPath); File.Move(FileFullPath + ".tmp", FileFullPath); return true; } catch { return false; } }
protected override void ReadXmlSerializable(System.Xml.XmlReader reader) { if ((this.DetermineSchemaSerializationMode(reader) == System.Data.SchemaSerializationMode.IncludeSchema)) { this.Reset(); System.Data.DataSet ds = new System.Data.DataSet(); ds.ReadXml(reader); if ((ds.Tables["PACK_ID"] != null)) { base.Tables.Add(new PACK_IDDataTable(ds.Tables["PACK_ID"])); } if ((ds.Tables["EXPORT_NOTES_HEAD"] != null)) { base.Tables.Add(new EXPORT_NOTES_HEADDataTable(ds.Tables["EXPORT_NOTES_HEAD"])); } if ((ds.Tables["SHIPPING_INSTR_HEAD"] != null)) { base.Tables.Add(new SHIPPING_INSTR_HEADDataTable(ds.Tables["SHIPPING_INSTR_HEAD"])); } if ((ds.Tables["PICKING_INSTR_HEAD"] != null)) { base.Tables.Add(new PICKING_INSTR_HEADDataTable(ds.Tables["PICKING_INSTR_HEAD"])); } if ((ds.Tables["DELIVERY_INSTR_HEAD"] != null)) { base.Tables.Add(new DELIVERY_INSTR_HEADDataTable(ds.Tables["DELIVERY_INSTR_HEAD"])); } if ((ds.Tables["SPECIAL_INSTR_HEAD"] != null)) { base.Tables.Add(new SPECIAL_INSTR_HEADDataTable(ds.Tables["SPECIAL_INSTR_HEAD"])); } if ((ds.Tables["CUSTOMER_INSTR_HEAD"] != null)) { base.Tables.Add(new CUSTOMER_INSTR_HEADDataTable(ds.Tables["CUSTOMER_INSTR_HEAD"])); } if ((ds.Tables["LABEL_INSTR_HEAD"] != null)) { base.Tables.Add(new LABEL_INSTR_HEADDataTable(ds.Tables["LABEL_INSTR_HEAD"])); } if ((ds.Tables["CARRIER_INST_HEAD"] != null)) { base.Tables.Add(new CARRIER_INST_HEADDataTable(ds.Tables["CARRIER_INST_HEAD"])); } if ((ds.Tables["INVOICE_UDF_HEAD"] != null)) { base.Tables.Add(new INVOICE_UDF_HEADDataTable(ds.Tables["INVOICE_UDF_HEAD"])); } if ((ds.Tables["UDF_HEAD"] != null)) { base.Tables.Add(new UDF_HEADDataTable(ds.Tables["UDF_HEAD"])); } if ((ds.Tables["UDF_HEADER"] != null)) { base.Tables.Add(new UDF_HEADERDataTable(ds.Tables["UDF_HEADER"])); } if ((ds.Tables["HANDLING_INSTR_HEAD"] != null)) { base.Tables.Add(new HANDLING_INSTR_HEADDataTable(ds.Tables["HANDLING_INSTR_HEAD"])); } if ((ds.Tables["PACK_ID_LINE_ITEM"] != null)) { base.Tables.Add(new PACK_ID_LINE_ITEMDataTable(ds.Tables["PACK_ID_LINE_ITEM"])); } if ((ds.Tables["EXPORT_NOTES_DETAIL"] != null)) { base.Tables.Add(new EXPORT_NOTES_DETAILDataTable(ds.Tables["EXPORT_NOTES_DETAIL"])); } if ((ds.Tables["SHIPPING_INSTR_DETAIL"] != null)) { base.Tables.Add(new SHIPPING_INSTR_DETAILDataTable(ds.Tables["SHIPPING_INSTR_DETAIL"])); } if ((ds.Tables["PICKING_INSTR_DETAIL"] != null)) { base.Tables.Add(new PICKING_INSTR_DETAILDataTable(ds.Tables["PICKING_INSTR_DETAIL"])); } if ((ds.Tables["DELIVERY_INSTR_DETAIL"] != null)) { base.Tables.Add(new DELIVERY_INSTR_DETAILDataTable(ds.Tables["DELIVERY_INSTR_DETAIL"])); } if ((ds.Tables["SPECIAL_INSTR_DETAIL"] != null)) { base.Tables.Add(new SPECIAL_INSTR_DETAILDataTable(ds.Tables["SPECIAL_INSTR_DETAIL"])); } if ((ds.Tables["CUSTOMER_INSTR_DETAIL"] != null)) { base.Tables.Add(new CUSTOMER_INSTR_DETAILDataTable(ds.Tables["CUSTOMER_INSTR_DETAIL"])); } if ((ds.Tables["HANDLING_INSTR_DETAIL"] != null)) { base.Tables.Add(new HANDLING_INSTR_DETAILDataTable(ds.Tables["HANDLING_INSTR_DETAIL"])); } if ((ds.Tables["UID_INSTR_DETAIL"] != null)) { base.Tables.Add(new UID_INSTR_DETAILDataTable(ds.Tables["UID_INSTR_DETAIL"])); } if ((ds.Tables["CONFIG_INSTR_DETAIL"] != null)) { base.Tables.Add(new CONFIG_INSTR_DETAILDataTable(ds.Tables["CONFIG_INSTR_DETAIL"])); } if ((ds.Tables["MAXKIT_DETAIL"] != null)) { base.Tables.Add(new MAXKIT_DETAILDataTable(ds.Tables["MAXKIT_DETAIL"])); } if ((ds.Tables["UDF_DET"] != null)) { base.Tables.Add(new UDF_DETDataTable(ds.Tables["UDF_DET"])); } if ((ds.Tables["UDF_DETAIL"] != null)) { base.Tables.Add(new UDF_DETAILDataTable(ds.Tables["UDF_DETAIL"])); } if ((ds.Tables["HP_PN_COMPONENTS"] != null)) { base.Tables.Add(new HP_PN_COMPONENTSDataTable(ds.Tables["HP_PN_COMPONENTS"])); } if ((ds.Tables["BOX"] != null)) { base.Tables.Add(new BOXDataTable(ds.Tables["BOX"])); } if ((ds.Tables["SERIAL_NUM"] != null)) { base.Tables.Add(new SERIAL_NUMDataTable(ds.Tables["SERIAL_NUM"])); } this.DataSetName = ds.DataSetName; this.Prefix = ds.Prefix; this.Namespace = ds.Namespace; this.Locale = ds.Locale; this.CaseSensitive = ds.CaseSensitive; this.EnforceConstraints = ds.EnforceConstraints; this.Merge(ds, false, System.Data.MissingSchemaAction.Add); this.InitVars(); } else { this.ReadXml(reader); this.InitVars(); } }
/// <summary> /// дXML�ĵ� /// </summary> /// <param name="name">���ݿ������������</param> /// <param name="con_str">���ݿ������Դ��Ϣ</param> public void writeXML(string name , ConfigStruct con_str) { try { //����һ��dataset System.Data.DataSet ds = new System.Data.DataSet("Autoconfig"); //�ж��Ƿ����config.xml�ļ�,������ڴӸ��ļ��ж�ȡ���ݵ�dataset if(System.IO.File.Exists(AppDomain.CurrentDomain.BaseDirectory.TrimEnd(new char[] {'\\'}) +"\\" +_FileName)) { ds.ReadXml(AppDomain.CurrentDomain.BaseDirectory.TrimEnd(new char[] {'\\'}) +"\\" +_FileName); } //�ж��Ƿ���ڸñ�,���������ɾ���ñ� if(ds.Tables.IndexOf(name.ToUpper()) != -1 ) { ds.Tables.Remove(name.ToUpper()); } //����һ��datatable System.Data.DataTable dt = new System.Data.DataTable(name.ToUpper()); //Ϊ�¶���ı������� dt.Columns.Add("key"); dt.Columns.Add("value"); SymmetricMethod sm = new SymmetricMethod(); //���Ӽ�¼���¶���ı��� dt.Rows.Add(new object[2]{ sm.Encrypto( str_HA ), sm.Encrypto( con_str.hostAddress)}); dt.Rows.Add(new object[2]{ sm.Encrypto( str_UN ), sm.Encrypto( con_str.userName)}); dt.Rows.Add(new object[2]{ sm.Encrypto( str_PWD ), sm.Encrypto( con_str.password)}); dt.Rows.Add(new object[2]{ sm.Encrypto( str_DBN ), sm.Encrypto( con_str.DBName)}); //�������ӵ�������µ�dataset�� ds.Tables.Add(dt); //д��xml�ĵ� ds.WriteXml(AppDomain.CurrentDomain.BaseDirectory.TrimEnd(new char[] {'\\'}) +"\\" +_FileName); //�ͷ�datatable �� dataset dt.Dispose(); ds.Dispose(); } catch(Exception exp) { //System.Windows.Forms.MessageBox.Show(exp.Message); throw exp; } }
protected override void ReadXmlSerializable(System.Xml.XmlReader reader) { this.Reset(); System.Data.DataSet ds = new System.Data.DataSet(); ds.ReadXml(reader); if ((ds.Tables["A"] != null)) { base.Tables.Add(new ADataTable(ds.Tables["A"])); } if ((ds.Tables["B"] != null)) { base.Tables.Add(new BDataTable(ds.Tables["B"])); } if ((ds.Tables["C"] != null)) { base.Tables.Add(new CDataTable(ds.Tables["C"])); } this.DataSetName = ds.DataSetName; this.Prefix = ds.Prefix; this.Namespace = ds.Namespace; this.Locale = ds.Locale; this.CaseSensitive = ds.CaseSensitive; this.EnforceConstraints = ds.EnforceConstraints; this.Merge(ds, false, System.Data.MissingSchemaAction.Add); this.InitVars(); }
protected override void ReadXmlSerializable(System.Xml.XmlReader reader) { if ((this.DetermineSchemaSerializationMode(reader) == System.Data.SchemaSerializationMode.IncludeSchema)) { this.Reset(); System.Data.DataSet ds = new System.Data.DataSet(); ds.ReadXml(reader); if ((ds.Tables["ListaCampos"] != null)) { base.Tables.Add(new ListaCamposDataTable(ds.Tables["ListaCampos"])); } if ((ds.Tables["MetodoConsulta"] != null)) { base.Tables.Add(new MetodoConsultaDataTable(ds.Tables["MetodoConsulta"])); } if ((ds.Tables["ClasseCRUD"] != null)) { base.Tables.Add(new ClasseCRUDDataTable(ds.Tables["ClasseCRUD"])); } if ((ds.Tables["Metodo"] != null)) { base.Tables.Add(new MetodoDataTable(ds.Tables["Metodo"])); } if ((ds.Tables["Versao"] != null)) { base.Tables.Add(new VersaoDataTable(ds.Tables["Versao"])); } this.DataSetName = ds.DataSetName; this.Prefix = ds.Prefix; this.Namespace = ds.Namespace; this.Locale = ds.Locale; this.CaseSensitive = ds.CaseSensitive; this.EnforceConstraints = ds.EnforceConstraints; this.Merge(ds, false, System.Data.MissingSchemaAction.Add); this.InitVars(); } else { this.ReadXml(reader); this.InitVars(); } }
protected override void ReadXmlSerializable(System.Xml.XmlReader reader) { if ((this.DetermineSchemaSerializationMode(reader) == System.Data.SchemaSerializationMode.IncludeSchema)) { this.Reset(); System.Data.DataSet ds = new System.Data.DataSet(); ds.ReadXml(reader); if ((ds.Tables["tblDoktorBilgisiDVO"] != null)) { base.Tables.Add(new tblDoktorBilgisiDVODataTable(ds.Tables["tblDoktorBilgisiDVO"])); } if ((ds.Tables["tblTaniBilgisiDVO"] != null)) { base.Tables.Add(new tblTaniBilgisiDVODataTable(ds.Tables["tblTaniBilgisiDVO"])); } if ((ds.Tables["tblHastaYatisBilgisi"] != null)) { base.Tables.Add(new tblHastaYatisBilgisiDataTable(ds.Tables["tblHastaYatisBilgisi"])); } if ((ds.Tables["tblCocukBilgisi"] != null)) { base.Tables.Add(new tblCocukBilgisiDataTable(ds.Tables["tblCocukBilgisi"])); } if ((ds.Tables["tblMalzemeBilgisi"] != null)) { base.Tables.Add(new tblMalzemeBilgisiDataTable(ds.Tables["tblMalzemeBilgisi"])); } if ((ds.Tables["tblTedaviIslemBilgisi"] != null)) { base.Tables.Add(new tblTedaviIslemBilgisiDataTable(ds.Tables["tblTedaviIslemBilgisi"])); } if ((ds.Tables["tblBransGorusBilgisi"] != null)) { base.Tables.Add(new tblBransGorusBilgisiDataTable(ds.Tables["tblBransGorusBilgisi"])); } this.DataSetName = ds.DataSetName; this.Prefix = ds.Prefix; this.Namespace = ds.Namespace; this.Locale = ds.Locale; this.CaseSensitive = ds.CaseSensitive; this.EnforceConstraints = ds.EnforceConstraints; this.Merge(ds, false, System.Data.MissingSchemaAction.Add); this.InitVars(); } else { this.ReadXml(reader); this.InitVars(); } }
protected override void ReadXmlSerializable(System.Xml.XmlReader reader) { if ((this.DetermineSchemaSerializationMode(reader) == System.Data.SchemaSerializationMode.IncludeSchema)) { this.Reset(); System.Data.DataSet ds = new System.Data.DataSet(); ds.ReadXml(reader); if ((ds.Tables["Country"] != null)) { base.Tables.Add(new CountryDataTable(ds.Tables["Country"])); } if ((ds.Tables["DocumentType"] != null)) { base.Tables.Add(new DocumentTypeDataTable(ds.Tables["DocumentType"])); } if ((ds.Tables["InvoiceDetail"] != null)) { base.Tables.Add(new InvoiceDetailDataTable(ds.Tables["InvoiceDetail"])); } if ((ds.Tables["InvoiceMaster"] != null)) { base.Tables.Add(new InvoiceMasterDataTable(ds.Tables["InvoiceMaster"])); } if ((ds.Tables["Organization"] != null)) { base.Tables.Add(new OrganizationDataTable(ds.Tables["Organization"])); } if ((ds.Tables["ReceiptRemains"] != null)) { base.Tables.Add(new ReceiptRemainsDataTable(ds.Tables["ReceiptRemains"])); } if ((ds.Tables["Stock"] != null)) { base.Tables.Add(new StockDataTable(ds.Tables["Stock"])); } if ((ds.Tables["TradePutlet"] != null)) { base.Tables.Add(new TradePutletDataTable(ds.Tables["TradePutlet"])); } if ((ds.Tables["ReceiptMaster"] != null)) { base.Tables.Add(new ReceiptMasterDataTable(ds.Tables["ReceiptMaster"])); } if ((ds.Tables["ReceiptDetail"] != null)) { base.Tables.Add(new ReceiptDetailDataTable(ds.Tables["ReceiptDetail"])); } if ((ds.Tables["StorageCondition"] != null)) { base.Tables.Add(new StorageConditionDataTable(ds.Tables["StorageCondition"])); } if ((ds.Tables["Product"] != null)) { base.Tables.Add(new ProductDataTable(ds.Tables["Product"])); } if ((ds.Tables["FarmGroup"] != null)) { base.Tables.Add(new FarmGroupDataTable(ds.Tables["FarmGroup"])); } if ((ds.Tables["Packing"] != null)) { base.Tables.Add(new PackingDataTable(ds.Tables["Packing"])); } if ((ds.Tables["Substance"] != null)) { base.Tables.Add(new SubstanceDataTable(ds.Tables["Substance"])); } if ((ds.Tables["Unit"] != null)) { base.Tables.Add(new UnitDataTable(ds.Tables["Unit"])); } if ((ds.Tables["Manufacturer"] != null)) { base.Tables.Add(new ManufacturerDataTable(ds.Tables["Manufacturer"])); } if ((ds.Tables["FarmGroupLevel2"] != null)) { base.Tables.Add(new FarmGroupLevel2DataTable(ds.Tables["FarmGroupLevel2"])); } if ((ds.Tables["Orders"] != null)) { base.Tables.Add(new OrdersDataTable(ds.Tables["Orders"])); } if ((ds.Tables["Remains"] != null)) { base.Tables.Add(new RemainsDataTable(ds.Tables["Remains"])); } if ((ds.Tables["PricesPurchase"] != null)) { base.Tables.Add(new PricesPurchaseDataTable(ds.Tables["PricesPurchase"])); } if ((ds.Tables["Periods"] != null)) { base.Tables.Add(new PeriodsDataTable(ds.Tables["Periods"])); } if ((ds.Tables["LinkedInvoiceDetail"] != null)) { base.Tables.Add(new LinkedInvoiceDetailDataTable(ds.Tables["LinkedInvoiceDetail"])); } if ((ds.Tables["LinkedInvoiceMaster"] != null)) { base.Tables.Add(new LinkedInvoiceMasterDataTable(ds.Tables["LinkedInvoiceMaster"])); } if ((ds.Tables["ReceiptDetailAdding"] != null)) { base.Tables.Add(new ReceiptDetailAddingDataTable(ds.Tables["ReceiptDetailAdding"])); } this.DataSetName = ds.DataSetName; this.Prefix = ds.Prefix; this.Namespace = ds.Namespace; this.Locale = ds.Locale; this.CaseSensitive = ds.CaseSensitive; this.EnforceConstraints = ds.EnforceConstraints; this.Merge(ds, false, System.Data.MissingSchemaAction.Add); this.InitVars(); } else { this.ReadXml(reader); this.InitVars(); } }
/// <summary>Parses profile string into DOM document </summary> private System.Xml.XmlDocument parseIntoDOM(System.String profileString) { if (this.alwaysValidate) profileString = insertDoctype(profileString); System.Xml.XmlDocument doc = null; try { lock (this) { XmlTextReader reader = new XmlTextReader(new System.IO.MemoryStream(new System.Text.ASCIIEncoding().GetBytes(profileString))); System.Data.DataSet data = new System.Data.DataSet(); data.ReadXml(reader); doc = new XmlDataDocument(data); } } catch (System.Xml.XmlException se) { throw new NuGenProfileException("SAXException parsing message profile: " + se.Message); } catch (System.IO.IOException ioe) { throw new NuGenProfileException("IOException parsing message profile: " + ioe.Message); } return doc; }
protected override void ReadXmlSerializable(System.Xml.XmlReader reader) { this.Reset(); System.Data.DataSet ds = new System.Data.DataSet(); ds.ReadXml(reader); if ((ds.Tables["Products"] != null)) { base.Tables.Add(new ProductsDataTable(ds.Tables["Products"])); } if ((ds.Tables["Orders"] != null)) { base.Tables.Add(new OrdersDataTable(ds.Tables["Orders"])); } if ((ds.Tables["Suppliers"] != null)) { base.Tables.Add(new SuppliersDataTable(ds.Tables["Suppliers"])); } if ((ds.Tables["Shippers"] != null)) { base.Tables.Add(new ShippersDataTable(ds.Tables["Shippers"])); } if ((ds.Tables["Customers"] != null)) { base.Tables.Add(new CustomersDataTable(ds.Tables["Customers"])); } if ((ds.Tables["Categories"] != null)) { base.Tables.Add(new CategoriesDataTable(ds.Tables["Categories"])); } if ((ds.Tables["Order Details"] != null)) { base.Tables.Add(new Order_DetailsDataTable(ds.Tables["Order Details"])); } if ((ds.Tables["Employees"] != null)) { base.Tables.Add(new EmployeesDataTable(ds.Tables["Employees"])); } this.DataSetName = ds.DataSetName; this.Prefix = ds.Prefix; this.Namespace = ds.Namespace; this.Locale = ds.Locale; this.CaseSensitive = ds.CaseSensitive; this.EnforceConstraints = ds.EnforceConstraints; this.Merge(ds, false, System.Data.MissingSchemaAction.Add); this.InitVars(); }
protected override void ReadXmlSerializable(System.Xml.XmlReader reader) { if ((this.DetermineSchemaSerializationMode(reader) == System.Data.SchemaSerializationMode.IncludeSchema)) { this.Reset(); System.Data.DataSet ds = new System.Data.DataSet(); ds.ReadXml(reader); if ((ds.Tables["SPR_IZG"] != null)) { base.Tables.Add(new SPR_IZGDataTable(ds.Tables["SPR_IZG"])); } if ((ds.Tables["SPR_TOV"] != null)) { base.Tables.Add(new SPR_TOVDataTable(ds.Tables["SPR_TOV"])); } this.DataSetName = ds.DataSetName; this.Prefix = ds.Prefix; this.Namespace = ds.Namespace; this.Locale = ds.Locale; this.CaseSensitive = ds.CaseSensitive; this.EnforceConstraints = ds.EnforceConstraints; this.Merge(ds, false, System.Data.MissingSchemaAction.Add); this.InitVars(); } else { this.ReadXml(reader); this.InitVars(); } }
/// <summary> /// Creates the XML schema /// </summary> /// <param name="className">Class name</param> /// <param name="methodName">Method name</param> /// <param name="paramList">Parameters list</param> /// <returns></returns> public Byte[] GetAxDataCreateSchema(string className, string methodName, params object[] paramList) { XmlDocument xmlDoc = new XmlDocument(); try { this.AxLoginAs(); AxaptaObject axObj = _Axapta.CreateAxaptaObject(className); string ret = (string)this.CallAxMethod(className, methodName, paramList); //convert string into XML document xmlDoc.LoadXml(ret); //create XML data reader to populate dataset XmlNodeReader xmlReader = new XmlNodeReader(xmlDoc.DocumentElement); System.Data.DataSet ds = new System.Data.DataSet(); //load dataset with XML data (load schema) ds.ReadXml(xmlReader, System.Data.XmlReadMode.InferSchema); //GZIP compress dataset with schema. Return byte array MemoryStream ms = new MemoryStream(); System.IO.Compression.GZipStream zip = new System.IO.Compression.GZipStream(ms, System.IO.Compression.CompressionMode.Compress); ds.WriteXml(zip, System.Data.XmlWriteMode.WriteSchema); zip.Close(); ms.Close(); axObj.Dispose(); return ms.GetBuffer(); } catch (Microsoft.Dynamics.AxaptaException ex) { this.WriteErrorToEventLog(ex); SoapException se = new SoapException(ex.Message, SoapException.ServerFaultCode, ex.InnerException); throw se; } catch (Exception ex) { this.WriteErrorToEventLog(ex); SoapException se = new SoapException(ex.Message, SoapException.ClientFaultCode, ex.InnerException); throw se; } finally { this.AxLogoff(); } }