private void _Mtd_CrearArchivoISLR(string _P_Str_ID_Archivo) { System.IO.DirectoryInfo _DirInf = new System.IO.DirectoryInfo("c:\\seniat"); if (!_DirInf.Exists) { _DirInf.Create(); } string _Str_Cadena = "SELECT REPLACE(crifagenretencion,'-','') AS crifagenretencion,cfecha FROM TARCHIVOISLRD WHERE cgroupcomp='" + Frm_Padre._Str_GroupComp + "' AND ccompany='" + Frm_Padre._Str_Comp + "' AND cidarchivoislr='" + _P_Str_ID_Archivo + "'"; DataSet _Ds = Program._MyClsCnn._mtd_conexion._Mtd_RetornarDataset(_Str_Cadena); if (_Ds.Tables[0].Rows.Count > 0) { string _Str_RifAgente = _Ds.Tables[0].Rows[0]["crifagenretencion"].ToString().Trim(); string _Str_Periodo = _Ds.Tables[0].Rows[0]["cfecha"].ToString().Trim(); _Str_Cadena = "SELECT REPLACE(crifprovee,'-','') AS RifRetenido,REPLACE(cnumfact,'-','') AS NumeroFactura, REPLACE(cnumcont,'-','') AS NumeroControl,CONVERT(VARCHAR,cfechaoperacion,103) AS FechaOperacion,ccodigoconcepto AS CodigoConcepto,REPLACE(cmontdocu,',','.') AS MontoOperacion,REPLACE(cporcenreten,',','.') AS PorcentajeRetencion FROM TARCHIVOISLRD WHERE cgroupcomp='" + Frm_Padre._Str_GroupComp + "' AND ccompany='" + Frm_Padre._Str_Comp + "' AND cidarchivoislr='" + _P_Str_ID_Archivo + "'"; _Ds = Program._MyClsCnn._mtd_conexion._Mtd_RetornarDataset(_Str_Cadena); _Ds.Tables[0].TableName = "DetalleRetencion"; //const string _Str_Comillas = "\""; //_Ds.DataSetName = "RelacionRetencionesISLR RifAgente=" + _Str_Comillas + _Str_RifAgente + _Str_Comillas + " Periodo=" + _Str_Periodo; _Ds.DataSetName = "RelacionRetencionesISLR"; _Ds.EnforceConstraints = false; XmlDataDocument _Xml_d = new XmlDataDocument(_Ds); XmlDeclaration _Xml_Decl = _Xml_d.CreateXmlDeclaration("1.0", "ISO-8859-1", null); XmlElement _Xml_Elem = _Xml_d.DocumentElement; _Xml_d.InsertBefore(_Xml_Decl, _Xml_Elem); XmlAttribute _Xml_a = _Xml_d.CreateAttribute("RifAgente"); _Xml_a.Value = _Str_RifAgente; _Xml_d["RelacionRetencionesISLR"].Attributes.Append(_Xml_a); _Xml_a = _Xml_d.CreateAttribute("Periodo"); _Xml_a.Value = _Str_Periodo; _Xml_d["RelacionRetencionesISLR"].Attributes.Append(_Xml_a); _Xml_d.Save("c:\\seniat\\XML_relacionRetencionesISLR_.xml"); } }
public void CreateXml(DataSet dataset_for_index_doc, DataSet dataset_for_folder, string indexing, string fullPath, string filename, SqlConnection connection, string folderID, string docID) { string temp_string = System.IO.Path.GetExtension(filename); string output_filename = filename.Replace(temp_string, ".xml"); string temp_fullpath = string.Format("{0}\\{1}", fullPath, output_filename); //String SQLCommand = " select * from obj where parent_id =" + indexing ; DataRow[] indexRow = dataset_for_index_doc.Tables[0].Select("DocID = " + docID); XmlDataDocument doc = new XmlDataDocument(); XmlDeclaration xmlDeclaration = doc.CreateXmlDeclaration("1.0", "UTF-8", null); XmlElement root = doc.DocumentElement; doc.InsertBefore(xmlDeclaration, root); DataRow[] r = dataset_for_folder.Tables[0].Select("folderID = " + folderID); string temp_index_name = r[0].ItemArray[0].ToString().Replace(" ", ""); XmlElement element1 = doc.CreateElement(string.Empty, temp_index_name, string.Empty); doc.AppendChild(element1); //Create an element representing the first customer record. //foreach (DataRow row in ds.Tables[0].Rows) //{ // string temp_index_name1 = row.ItemArray[3].ToString().Replace(" ", ""); // XmlElement element2 = doc.CreateElement(string.Empty, temp_index_name1, string.Empty); // XmlText text1 = doc.CreateTextNode(row.ItemArray[3].ToString()); // element2.AppendChild(text1); // element1.AppendChild(element2); //} foreach (DataRow index in indexRow) { string temp_index_name1 = index.ItemArray[4].ToString().Replace(" ", ""); XmlElement element2 = doc.CreateElement(string.Empty, temp_index_name1, string.Empty); XmlText text1 = doc.CreateTextNode(index.ItemArray[3].ToString()); element2.AppendChild(text1); element1.AppendChild(element2); } doc.Save(temp_fullpath); }