/// <summary> /// Saves the dataset encrypted in specified file /// </summary> /// <param name="dataset">Dataset to save</param> /// <param name="username">Username for encryption</param> /// <param name="password">Password for encryption</param> /// <param name="fileName">File name where to save</param> /// <param name="compress">Should the file be compressed</param> internal static void EncryptDataSet(System.Data.DataSet dataset, string username, string password, string fileName, bool compress) { // Check the parameters if (dataset == null || string.IsNullOrEmpty(username) || string.IsNullOrEmpty(password) || string.IsNullOrEmpty(fileName)) { throw new System.ArgumentNullException("All arguments must be supplied."); } // Save the dataset as encrypted using (System.Security.Cryptography.Aes aes = Cryptography.InitAes(username, password)) { using (System.IO.FileStream fileStream = new System.IO.FileStream(fileName, System.IO.FileMode.Create, System.IO.FileAccess.ReadWrite, System.IO.FileShare.None)) { using (System.Security.Cryptography.CryptoStream cryptoStream = new System.Security.Cryptography.CryptoStream(fileStream, aes.CreateEncryptor(), System.Security.Cryptography.CryptoStreamMode.Write)) { if (compress) { // when compression is requested, use GZip using (System.IO.Compression.GZipStream zipStream = new System.IO.Compression.GZipStream(cryptoStream, System.IO.Compression.CompressionMode.Compress)) { dataset.WriteXml(zipStream, System.Data.XmlWriteMode.WriteSchema); zipStream.Flush(); } } else { dataset.WriteXml(cryptoStream, System.Data.XmlWriteMode.WriteSchema); cryptoStream.FlushFinalBlock(); } } } } }
public static System.Data.DataSet dsFtp = new System.Data.DataSet(); // 存储Ftp队列表 /// <summary> /// Ftp上传请求入队 /// </summary> /// <param name="Folder">文件目录</param> /// <param name="FileName">文件名</param> /// <param name="FtpSrv">Ftp服务器IP</param> /// <param name="FtpPort">端口</param> /// <param name="FtpU">用户名</param> /// <param name="FtpP">密码</param> /// <param name="FtpFolder">要上传到的Ftp目录</param> /// <returns></returns> public static void Ftp_Enqueue(string Folder, string FileName, string FtpSrv, int FtpPort, string FtpU, string FtpP, string FtpFolder) { if (!Folder.EndsWith("\\")) { Folder += "\\"; } if (FtpFile == null || FtpFile.Length < 1) { FtpFile = GlobalObject.XmlConfigChain[typeof(FtpQueue), "FtpFile"]; // 加载Ftp队列数据 if (FtpFile != null && File.Exists(FtpQueue.FtpFile)) { FtpQueue.dsFtp.ReadXml(FtpQueue.FtpFile); } } if (FtpFile == null || FtpFile.Length < 1) { throw new Exception("无法保存队列,请检查队列文件设置"); } if (dsFtp.Tables.Count == 0) { // 给定架构 System.Data.DataTable dt = dsFtp.Tables.Add("FtpQueue"); dt.Columns.Add("ID", typeof(int)); dt.Columns.Add("Folder"); dt.Columns.Add("FileName"); dt.Columns.Add("FtpSrv"); dt.Columns.Add("FtpPort", typeof(int)); dt.Columns.Add("FtpU"); dt.Columns.Add("FtpP"); dt.Columns.Add("FtpFolder"); dt.Columns["ID"].AutoIncrementSeed = 1; dt.Columns["ID"].AutoIncrementStep = 1; dt.Columns["ID"].AutoIncrement = true; } System.Data.DataRow dr = dsFtp.Tables[0].NewRow(); dr["Folder"] = Folder; dr["FileName"] = FileName; dr["FtpSrv"] = FtpSrv; dr["FtpPort"] = FtpPort; dr["FtpU"] = FtpU; dr["FtpP"] = FtpP; dr["FtpFolder"] = FtpFolder; dsFtp.Tables[0].Rows.InsertAt(dr, 0); // 存回文件 dsFtp.WriteXml(FtpFile, System.Data.XmlWriteMode.WriteSchema); }
public static void SaveData() { System.Data.DataSet ds = new System.Data.DataSet("SteamworkGUI"); System.Data.DataTable table = new System.Data.DataTable("Data"); ds.Tables.Add(table); table.Columns.Add("account", typeof(string)); table.Columns.Add("appid", typeof(int)); table.Columns.Add("language", typeof(string)); System.Data.DataRow row = table.NewRow(); row[0] = MainWindow._instance.user_name; row[1] = MainWindow._instance.Appid; row[2] = MainWindow._instance.LanguagePack; ds.Tables["Data"].Rows.Add(row); string path = Environment.CurrentDirectory + "/data.xml"; try { ds.WriteXml(path); } catch { } }
public static void Test() { string inFile = @"D:\username\Desktop\Mappe1.ods"; string outFileXml = @"D:\username\Desktop\mysheet.xml"; string outFile = @"D:\username\Desktop\notmysheet.ods"; if (System.Environment.OSVersion.Platform == System.PlatformID.Unix) { inFile = "/root/Documents/mysheet.ods"; outFileXml = "/root/Documents/mysheet.xml"; outFile = "/root/Documents/notmysheet.ods"; } // End if (System.Environment.OSVersion.Platform == System.PlatformID.Unix) OdsReaderWriter odr = new OdsReaderWriter(); using (System.Data.DataSet ds = odr.ReadOdsFile(inFile)) { System.Console.WriteLine(ds.Tables.Count); using (System.IO.FileStream fs = System.IO.File.OpenWrite(outFileXml)) { //ds.WriteXml(fs, System.Data.XmlWriteMode.WriteSchema); ds.WriteXml(fs, System.Data.XmlWriteMode.IgnoreSchema); } // End Using fs odr.WriteOdsFile(ds, outFile); } // End Using ds } // End Sub Test
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"); }
private static System.Data.DataSet GetSettingDataSet() { if (_CurrentDataSet == null) { string cPath = ConfigPath; System.Data.DataSet ds = new System.Data.DataSet(); if (System.IO.File.Exists(cPath)) { ds.ReadXml(cPath); } else { System.Data.DataTable dt = new System.Data.DataTable(); dt.TableName = "SoftSetting"; dt.Columns.Add("DataKeys"); dt.Columns.Add("DataValues"); ds.Tables.Add(dt); ds.DataSetName = "SystemSetting"; string dir = System.IO.Path.GetDirectoryName(cPath); if (!System.IO.Directory.Exists(dir)) { System.IO.Directory.CreateDirectory(dir); } ds.WriteXml(cPath); } _CurrentDataSet = ds; } return(_CurrentDataSet); }
public static void SetSoftConfig(string pKey, string pNValue) { System.Data.DataSet ds = GetSettingDataSet(); System.Data.DataRow[] drs = ds.Tables[0].Select("DataKeys='" + pKey + "'"); if (drs.Length > 0) { if (drs[0]["DataValues"].ToString() == pNValue) { return; //值没有发生改变 } else { drs[0]["DataValues"] = pNValue; } } else { System.Data.DataRow dr = ds.Tables[0].NewRow(); dr["DataKeys"] = pKey; dr["DataValues"] = pNValue; ds.Tables[0].Rows.Add(dr); } string cPath = (ConfigPath); ds.WriteXml(cPath); _CurrentDataSet = null; }
private bool bSalvaDadosInternet(bool bProxy, string strProxyHost, string strProxyPort, bool bProxyAutentication, string strProxyUser, string strProxyPassword) { bool bRetorno = true; System.Data.DataSet dtstProxy = new System.Data.DataSet(DATASET_NAME); System.Data.DataTable dttbProxy = new System.Data.DataTable(DATASET_PROXY_NAME); dttbProxy.Columns.Add(DATASET_HOST_NAME); dttbProxy.Columns.Add(DATASET_PORT_NAME); dttbProxy.Columns.Add(DATASET_USER_NAME); dttbProxy.Columns.Add(DATASET_PASSWORD_NAME); dtstProxy.Tables.Add(dttbProxy); System.Data.DataRow dtrwProxy = dttbProxy.NewRow(); dtrwProxy[DATASET_HOST_NAME] = strProxyHost; dtrwProxy[DATASET_PORT_NAME] = strProxyPort; dtrwProxy[DATASET_USER_NAME] = strProxyUser; dtrwProxy[DATASET_PASSWORD_NAME] = strProxyPassword; dttbProxy.Rows.Add(dtrwProxy); try{ dtstProxy.WriteXml(m_strFileConfigPath + m_strFileConfigName); }catch { bRetorno = false; } return(bRetorno); }
private void CheckPath(string p) { try { if (string.IsNullOrEmpty(p)) { p = PicPath; } if (Directory.Exists(p) && Directory.GetFiles(p, "*.jpg", SearchOption.TopDirectoryOnly).Length > 0) { PicPath = p; DS.Tables[0].Rows.Find(br.Name)[1] = p.Replace(AppPath, "."); DS.WriteXml(AppPath + "\\ShowPic.Dat", System.Data.XmlWriteMode.WriteSchema); ls.Clear(); foreach (string s in Directory.GetFiles(PicPath, "*.jpg", SearchOption.TopDirectoryOnly)) { ls.Add(s); } } else { MessageBox.Show("目录中没有图片,请重新选择路径"); } } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private static void NewMethod() { ds = new System.Data.DataSet("X"); { ds.Tables.Add(Class1.CreateDataStoreConfigTable( )); ds.Tables.Add(Class1.CreateDataStoreSnapshotFileTable( )); ds.Tables.Add(Class1.CreateMetadataItemTable( )); } Class1.LoadDataStoreSnapshotFilesTable(ds); { ActiveQueryBuilder.Core.SQLContext sc = Class1.CreateAqbSqlContext4SQLiteOffline(filepath); Class1.DrillDownAqbSqlContext(sc, ds.Tables[Class1.MetadataItem_TblName], "Ale"); } //ds.Tables.Add( Class1.CreateDataSetSnapshotTable( ) ); //ds.Tables.Add( Class1.CreateMetadataItemTable( ) ); //Class1.ZZZZZZZZ( ds ); //// //// ds.WriteXml(filepath2); //{ // ds.RemotingFormat = System.Data.SerializationFormat.Binary; // using( System.IO.FileStream fs = new System.IO.FileStream( filepath3, System.IO.FileMode.Create ) ) // { // System.Runtime.Serialization.Formatters.Binary.BinaryFormatter fmt = new System.Runtime.Serialization.Formatters.Binary.BinaryFormatter( ); // fmt.Serialize( fs, ds ); // fs.Close( ); // } //} //{ // System.Data.DataSet o = new System.Data.DataSet( ); // o.ReadXml( filepath2 ); //} }
public static void PersistLog(System.Data.DataTable dt) { System.Data.DataSet ds = dt.DataSet; // ds.Tables.Add(dt); string filePath = String.Format("{0}/{1}", GetExecutingPath(), REQUESTLOG_FILENAME); ds.WriteXml(filePath); }
private void CheckPath(string p) { try { if (string.IsNullOrEmpty(p)) { foreach (string s in Directory.GetFiles(AppPath + "\\PPT", "*.ppt", SearchOption.TopDirectoryOnly)) { PPTPath = s; break; } } else { PPTPath = p; } PPTPath = PPTPath.Replace(AppPath, "."); if (!string.IsNullOrEmpty(PPTPath) && File.Exists(PPTPath)) { FileInfo fi = new FileInfo(PPTPath); string path = fi.DirectoryName + "\\" + fi.Name.Replace(fi.Extension, string.Empty); bool err = false; if (Directory.Exists(path)) { if (Directory.GetFiles(path, "*.jpg", SearchOption.TopDirectoryOnly).Length == 0) { err = true; Directory.Delete(path, true); } } else { err = true; } if (err) { PowerPoint.Presentation pr = new PowerPoint.Application().Presentations.Open((PPTPath.StartsWith(".") ? AppPath + PPTPath.TrimStart('.') : PPTPath), PowerPoint.MsoTriState.msoTrue, PowerPoint.MsoTriState.msoFalse, PowerPoint.MsoTriState.msoFalse); pr.SaveAs(path + ".jpg", PowerPoint.PpSaveAsFileType.ppSaveAsJPG, PowerPoint.MsoTriState.msoTrue); pr.Close(); } foreach (string s in Directory.GetFiles(path, "*.jpg", SearchOption.TopDirectoryOnly)) { ImageBrush b = new ImageBrush(); b.ImageSource = new BitmapImage(new Uri(s, UriKind.RelativeOrAbsolute)); b.Stretch = Stretch.UniformToFill; Bor1.Background = b; break; } DS.Tables[0].Rows.Find(br.Name)[1] = PPTPath; DS.WriteXml(AppPath + "\\ShowPPT.Dat", System.Data.XmlWriteMode.WriteSchema); } } catch (Exception ex) { MessageBox.Show(ex.Message); } }
/// <summary> /// 储存XML /// </summary> /// <param name="dtYhm"></param> /// <param name="sDSName"></param> /// <param name="sXMLPath"></param> public void SaveXML(System.Data.DataTable dtYhm, string sDSName, string sXMLPath) { lock (this) { System.Data.DataSet set = new System.Data.DataSet(sDSName); set.Tables.Add(dtYhm.Copy()); set.WriteXml(sXMLPath); } }
public void GetMyTestDataXmlFile() { var connectionString = System.Configuration.ConfigurationManager.ConnectionStrings["IntegrationTests.Properties.Settings.TDDWithMVCConnectionString"].ConnectionString; var mySqlDatabase = new SqlDbUnitTest(connectionString); mySqlDatabase.ReadXmlSchema(DatabaseXsd02); System.Data.DataSet ds = mySqlDatabase.GetDataSetFromDb(); ds.WriteXml(TestdataXml02); }
/// <summary> /// Converts the provided dataset into an XPathNavigator instance. /// </summary> /// <param name="ds"></param> /// <param name="context"></param> /// <returns></returns> protected virtual XPathNavigator ConvertDataSetToXPath(System.Data.DataSet ds, string rootTable, PDFDataContext context) { using (System.IO.MemoryStream ms = new System.IO.MemoryStream()) { //ds.Tables[rootTable].DefaultView.ToTable().WriteXml(ms); ds.WriteXml(ms); ms.Flush(); ms.Position = 0; XPathDocument doc = new XPathDocument(ms); return(doc.CreateNavigator()); } }
public bool bCriaBackup() { try { m_cls_dba_ConectionDB.Log = true; m_cls_dba_ConectionDB.FonteDosDados = mdlDataBaseAccess.FonteDados.DataBase; System.Collections.ArrayList arlListaArquivo = new System.Collections.ArrayList(); System.Data.DataSet dtsetTemp = new System.Data.DataSet("Backup"); invocarMetodosDataAccessGet(ref dtsetTemp); System.Data.DataTable dtTbTemp = new System.Data.DataTable(TBVERSAOBACKUPTEXTO); dtTbTemp.Columns.Add(DATABACKUP, System.Type.GetType("System.DateTime")); dtTbTemp.Columns.Add(VERSAOBACKUPTEXTO, System.Type.GetType("System.String")); dtTbTemp.Columns.Add(VERSAOSISCOBRASTEXTO, System.Type.GetType("System.String")); System.Data.DataRow dtRow = dtTbTemp.NewRow(); dtRow[DATABACKUP] = m_dtDataBackup; dtRow[VERSAOBACKUPTEXTO] = m_rdRandomico.Next().ToString(); dtRow[VERSAOSISCOBRASTEXTO] = m_rdRandomico.Next().ToString(); dtsetTemp.Tables.Add(dtTbTemp); if (!System.IO.Directory.Exists(m_strDiretorioTemporario)) { System.IO.Directory.CreateDirectory(m_strDiretorioTemporario); } dtsetTemp.WriteXml(m_strDiretorioTemporario + "\\" + ARQUIVOXML, System.Data.XmlWriteMode.WriteSchema); arlListaArquivo.Add(m_strDiretorioTemporario + "\\" + ARQUIVOXML); mdlCompactacao.clsCompactacao obj = new mdlCompactacao.clsCompactacao(ref m_cls_ter_tratadorErro); if (!System.IO.Directory.Exists(m_strEnderecoBackup)) { System.IO.Directory.CreateDirectory(m_strEnderecoBackup); } if (System.IO.File.Exists(m_strEnderecoBackup + "\\" + m_strArquivoBackup)) { System.IO.File.Delete(m_strEnderecoBackup + "\\" + m_strArquivoBackup); } obj.compacta(ref arlListaArquivo, m_strEnderecoBackup + "\\" + m_strArquivoBackup, mdlCompactacao.NIVELCOMPACTACAO.MAXIMO); try { System.IO.File.Delete(m_strDiretorioTemporario + "\\" + ARQUIVOXML); System.IO.Directory.Delete(m_strDiretorioTemporario, true); } catch { } } catch { return(false); } return(true); }
/// <summary> /// Write the dataset to the stream using the specified format. /// </summary> /// <param name="destination"></param> /// <param name="source"></param> /// <param name="format"></param> public static void Write(System.IO.Stream destination, System.Data.DataSet source, StreamDataSetFormat format) { switch (format) { case StreamDataSetFormat.XML: source.WriteXml(destination, System.Data.XmlWriteMode.WriteSchema); break; case StreamDataSetFormat.Binary: BinWriteDataSetToStream(destination, source); break; default: throw new ApplicationException("StreamDataSet Format not supported"); } }
public bool bCriaArquivo() { bool bRetorno = false; try { System.Data.DataSet dtSetArquivoConfiguracao = new System.Data.DataSet("Siscobras"); if (System.IO.File.Exists(m_strPathArquivo)) { System.IO.File.Delete(m_strPathArquivo); } dtSetArquivoConfiguracao.WriteXml(m_strPathArquivo); bRetorno = true; }catch { } return(bRetorno); }
static void CreateDemoData(InMemoryDataStore inMemoryDataStore) { var ds = new System.Data.DataSet(); using (var ms = new System.IO.MemoryStream()) { using (var writer = System.Xml.XmlWriter.Create(ms)) { inMemoryDataStore.WriteXml(writer); writer.Flush(); } ms.Flush(); ms.Position = 0; ds.ReadXml(ms); } var gen = new GenHelper(); var idsAccount = new List <string>(); var dtAccounts = ds.Tables["Accounts"]; for (int i = 0; i < 200; i++) { var id = gen.MakeTosh(20); idsAccount.Add(id); dtAccounts.Rows.Add(id, gen.GetFullName()); } var dtMessages = ds.Tables["Messages"]; for (int i = 0; i < 5000; i++) { var id1 = gen.Next(idsAccount.Count); var id2 = gen.Next(idsAccount.Count - 1); dtMessages.Rows.Add(null, GenHelper.ToTitle(gen.MakeBlah(gen.Next(7))), gen.MakeBlahBlahBlah(5 + gen.Next(100), 7), idsAccount[id1], idsAccount[(id1 + id2 + 1) % idsAccount.Count]); } ds.AcceptChanges(); using (var ms = new System.IO.MemoryStream()) { ds.WriteXml(ms, System.Data.XmlWriteMode.WriteSchema); ms.Flush(); ms.Position = 0; using (var reader = System.Xml.XmlReader.Create(ms)) { inMemoryDataStore.ReadXml(reader); } } }
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"); }
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)) { continue; } 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.Options.OutputFile + ".config"); } catch (Exception e) { repack.Logger.Error("Failed to merge configuration files: " + e); } }
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); } }
/// <summary> /// 写入配置信息 /// </summary> /// <param name="config">配置信息</param> public static void WriteConfig(Config config) { if (!Directory.Exists(configPath)) { Directory.CreateDirectory(configPath); } //创建一个config.xml程序,写入同步配置文件 System.Data.DataSet ds = new System.Data.DataSet("Config"); System.Data.DataTable table = new System.Data.DataTable("System"); ds.Tables.Add(table); table.Columns.Add("ProjectNum", typeof(string)); table.Columns.Add("ProjectName", typeof(string)); table.Columns.Add("OnloadUrl", typeof(string)); table.Columns.Add("HumanSql", typeof(string)); table.Columns.Add("AttendSql", typeof(string)); System.Data.DataRow row = table.NewRow(); row[0] = config.projectNum; row[1] = config.projectName; row[2] = config.onloadUrl; try { FileInfo file = new FileInfo(datePath + "QueryHuman.sql"); string script = file.OpenText().ReadToEnd(); row[3] = script.Replace("dbo.", ""); } catch { row[3] = "select top(1) * from TEmployee where Car != 1"; } row[4] = "select * from TEmployee"; ds.Tables["System"].Rows.Add(row); ds.WriteXml(configPath + "config.xml"); }
/// <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(); } }
/// <summary> /// 执行 /// </summary> /// <returns>返回执行结果</returns> public override object Do() { string path = this.GetValStrByKey("Path") + "_" + DateTime.Now.ToString("yy年MM月dd日HH时mm分"); if (System.IO.Directory.Exists(path)) { return("系统正在执行中,请稍后。"); } System.IO.Directory.CreateDirectory(path); System.IO.Directory.CreateDirectory(path + "\\Flow.流程模板"); System.IO.Directory.CreateDirectory(path + "\\Frm.表单模板"); Flows fls = new Flows(); fls.RetrieveAll(); FlowSorts sorts = new FlowSorts(); sorts.RetrieveAll(); // 生成流程模板。 foreach (FlowSort sort in sorts) { string pathDir = path + "\\Flow.流程模板\\" + sort.No + "." + sort.Name; System.IO.Directory.CreateDirectory(pathDir); foreach (Flow fl in fls) { fl.DoExpFlowXmlTemplete(pathDir); } } // 生成表单模板。 foreach (FlowSort sort in sorts) { string pathDir = path + "\\Frm.表单模板\\" + sort.No + "." + sort.Name; System.IO.Directory.CreateDirectory(pathDir); foreach (Flow fl in fls) { string pathFlowDir = pathDir + "\\" + fl.No + "." + fl.Name; System.IO.Directory.CreateDirectory(pathFlowDir); Nodes nds = new Nodes(fl.No); foreach (Node nd in nds) { MapData md = new MapData("ND" + nd.NodeID); System.Data.DataSet ds = md.GenerHisDataSet(); ds.WriteXml(pathFlowDir + "\\" + nd.NodeID + "." + nd.Name + ".Frm.xml"); } } } // 流程表单模板. SysFormTrees frmSorts = new SysFormTrees(); frmSorts.RetrieveAll(); foreach (SysFormTree sort in frmSorts) { string pathDir = path + "\\Frm.表单模板\\" + sort.No + "." + sort.Name; System.IO.Directory.CreateDirectory(pathDir); MapDatas mds = new MapDatas(); mds.Retrieve(MapDataAttr.FK_FrmSort, sort.No); foreach (MapData md in mds) { System.Data.DataSet ds = md.GenerHisDataSet(); ds.WriteXml(pathDir + "\\" + md.No + "." + md.Name + ".Frm.xml"); } } return("生成成功,请打开" + path + "。<br>如果您想共享出来请压缩后发送到template@ccflow.org"); }
public bool getData(string job, string rowIndex,string po,bool isEnBlanco) { bool outPut = false; System.Data.DataSet DTS = null; System.Data.SqlClient.SqlDataAdapter myDataAdapter = null; SqlDataReader dr =null; bool isStart = true; int recNum = 0; string _qtyShipped = null; string _description = null; int _componentNumber = 0; string spacio = new string(' ', 17); int myY = 555; int myCopyY = 160; string sql = "SELECT P.PackageID, P.ShipmentNumber, P.Quantity, P.Weight, P.FreightCost, P.ShipMethod, P.ShipDate, P.ComponentNumber, P.StartNumber, " + "P.EndNumber, P.TrackingNumber, P.NumberofPackages, S.JobNumber, S.ShipmentNumber, S.ShipName, S.ShipAddress1, S.ShipAddress2, S.ShipAddress3, " + "S.ShipCountry, S.ShipCity, S.ShipState, S.ShipZip, S.ShipCountry, S.ShipContact, S.ShipPhone, S.ShipFax, S.ShipInNameOf, S.FOB, " + "S.Instructions, OC.BackOrder as BackOrderShipment, SR.Description as SalesRepName, SV.Description as ShipDescription, OH.PONumber, " + "OH.JobDescription, OC.Description as ComponentDescription, C.BillName, C.BillAddress1, C.BillAddress2, C.BillCity, C.BillState, C.BillZip, " + "C.BillPhone, C.BillFax, C.BillContact, C.BillCountry, OQ.Quantity as OrderQuantity, OH.CustAccount, OH.CustName, OH.CustAddress1, " + "OH.CustAddress2, OH.CustAddress3, OH.CustCity, OH.CustState, OH.CustZip, OH.CustPhone, OH.CustFax, OH.CustContact, OH.FormNumber, " + "OH.OriginalJobNumber, OH.ReleaseNumber, P.Description as PackageDescription, OC.BackOrderQuantity as BackOrderQuantity, P.OddPackageQty, " + "S.MShipInstructions, OH.PlantID, P.PostageCost, C.TermsCode, S.Residence, OH.DeliveryDate, S.Email, OH.CSR, P.TotalQtyShipped, OH.ProofDate, " + "OH.ProofTime, OH.ProofDeliveryDate, P.ShipViaService, SS.Description as ShipingServiceDescription, OH.DistPO, OC.FinGoodCode, OH.OrderDate, " + "S.ThirdPartyBilling, S.Shipped, S.SequenceNumber, P.OddPackageWeight " + "FROM Package P INNER JOIN Shipment S ON P.ShipmentNumber = S.ShipmentNumber " + "INNER JOIN OrderHeader OH ON S.JobNumber = OH.JobNumber " + "INNER JOIN Customer C ON OH.CustAccount = C.Account " + "LEFT JOIN OrderComponent OC ON P.JobNumber = OC.JobNumber AND ((P.ComponentNumber = OC.ComponentNumber) OR " + "(P.ComponentNumber = 0 AND OC.ComponentNumber = 1)) LEFT JOIN OrderQtyTable OQ ON OC.JobNumber = OQ.JobNumber AND " + "OC.ComponentNumber = OQ.ComponentNumber AND OC.QtyOrdIndex = OQ.QuantityLineNo " + "LEFT JOIN SalesRep SR ON OH.SalesRepCode = SR.Code " + "LEFT JOIN ShipVia SV ON P.ShipMethod = SV.Code " + "LEFT JOIN ShipViaService SS ON P.ShipMethod = SS.ShipviaCode AND P.ShipViaService = SS.Code " + "WHERE S.JobNumber = '" + job + "' and s.sequencenumber='" + rowIndex + "';"; string sqlGetConduceNum = "select max(ConduceNum) from tblConduce"; int conduceNum = 0; string myPdfFile = null; string pdfCopy = null; if (po.Trim().Length > 0) { po += "-"; po +=myPdfFile; myPdfFile = po; } pdfCopy = myPdfFile; try { mySQlCnn(); myDataAdapter = new SqlDataAdapter(); myDataAdapter.TableMappings.Add("Table", "Table1"); DTS = new System.Data.DataSet("Table1"); sqlCmd.CommandType = System.Data.CommandType.Text; sqlCmd.CommandText = sqlGetConduceNum; conduceNum = (int) sqlCmd.ExecuteScalar(); conduceNum++; if (!isEnBlanco) { sqlCmd.CommandText = sql; myDataAdapter.SelectCommand = sqlCmd; myDataAdapter.Fill(DTS); DTS.WriteXml(@"prueba.xml"); dr = sqlCmd.ExecuteReader(); } // crate el PDF if (isEnBlanco) { job = "EnBlanco"; } myPdfFile = GetRegistry.Registry.read("Software\\mop\\Conduce", "pdfPath"); myPdfFile += conduceNum + "-" + job + "-" + rowIndex + "-" + DateTime.Now.ToString("yyyMMdd") + ".pdf"; pdfCopy ="Copy_" + myPdfFile; Document document = new Document(PageSize.LETTER); Document Copydocument = new Document(PageSize.LETTER); PdfWriter writer = PdfWriter.GetInstance(document, new FileStream(myPdfFile, FileMode.Create)); PdfWriter Copywriter = PdfWriter.GetInstance(document, new FileStream(pdfCopy, FileMode.Create)); document.Open(); Copydocument.Open(); // we grab the ContentByte and do some stuff with it PdfContentByte cb = writer.DirectContent; // para ver el pdf System.Diagnostics.Process pr = new System.Diagnostics.Process(); pr.StartInfo.FileName = myPdfFile; // Set font BaseFont tahoma = BaseFont.CreateFont("tahoma.ttf", BaseFont.CP1252, BaseFont.NOT_EMBEDDED); Font font = new Font(tahoma, 9, Font.NORMAL); Font fontH = new Font(tahoma, 10, Font.BOLD); Font fontT = new Font(tahoma, 8, Font.NORMAL); // Set Img string img = GetRegistry.Registry.read("Software\\mop\\Conduce", "img"); string newImg = GetRegistry.Registry.read("Software\\mop\\Conduce", "newImg"); iTextSharp.text.Image jpg = iTextSharp.text.Image.GetInstance(img); jpg.ScaleToFit(PageSize.LETTER.Width, PageSize.LETTER.Height); jpg.SetAbsolutePosition(0, 0); jpg.Alignment = iTextSharp.text.Image.ALIGN_CENTER; document.Add(jpg); //Copy iTextSharp.text.Image copyJpg = iTextSharp.text.Image.GetInstance(newImg); copyJpg.ScaleToFit(PageSize.LETTER.Width, PageSize.LETTER.Height); copyJpg.SetAbsolutePosition(0, 0); copyJpg.Alignment = iTextSharp.text.Image.ALIGN_CENTER; Copydocument.Add(copyJpg); cb.BeginText(); if (!isEnBlanco) { while (dr.Read()) { recNum++; if (isStart) { cb.SetFontAndSize(tahoma, 9); int Y = 717; int CopyY = 320; string CustPhone = ""; string CustName = dr["CustName"].ToString().Trim(); string ShipAddress1 = dr["ShipAddress1"].ToString().Trim(); string ShipAddress2 = dr["ShipAddress2"].ToString().Trim(); string ShipAddress3 = dr["ShipAddress3"].ToString().Trim(); string ShipCity = dr["ShipCity"].ToString().Trim(); string ShipState = dr["ShipState"].ToString().Trim(); string ShipZip = dr["ShipZip"].ToString().Trim(); string ShipContact = dr["ShipContact"].ToString().Trim(); if (dr["CustPhone"].ToString().Trim().Length >= 14) { CustPhone = dr["CustPhone"].ToString().Trim().Substring(0, 14); } else { CustPhone = dr["CustPhone"].ToString().Trim(); } string JobNumber = dr["JobNumber"].ToString().Trim(); DateTime ShipDate = DateTime.Now; if (dr["ShipDate"].ToString().Trim().Length > 0) { ShipDate = Convert.ToDateTime(dr["ShipDate"]); } string PONumber = dr["PONumber"].ToString().Trim(); cb.ShowTextAligned(PdfContentByte.ALIGN_LEFT, CustName, 95, Y, 0); Y = Y - 10; cb.ShowTextAligned(PdfContentByte.ALIGN_LEFT, ShipAddress1, 95, Y, 0); Y = Y - 10; cb.ShowTextAligned(PdfContentByte.ALIGN_LEFT, ShipAddress2, 95, Y, 0); Y = Y - 10; cb.ShowTextAligned(PdfContentByte.ALIGN_LEFT, ShipAddress3, 95, Y, 0); Y = Y - 10; cb.ShowTextAligned(PdfContentByte.ALIGN_LEFT, ShipCity, 95, Y, 0); cb.ShowTextAligned(PdfContentByte.ALIGN_LEFT, ShipState, 205, Y, 0); cb.ShowTextAligned(PdfContentByte.ALIGN_LEFT, ShipZip, 225, Y, 0); cb.ShowTextAligned(PdfContentByte.ALIGN_LEFT, ShipContact, 100, 640, 0); cb.ShowTextAligned(PdfContentByte.ALIGN_LEFT, CustPhone, 77, 625, 0); cb.ShowTextAligned(PdfContentByte.ALIGN_LEFT, ShipDate.ToString("MM/dd/yyyy"), 420, 697, 0); cb.ShowTextAligned(PdfContentByte.ALIGN_LEFT, ShipDate.ToString("MM/dd/yyyy"), 420, 300, 0); //copia cb.ShowTextAligned(PdfContentByte.ALIGN_LEFT, conduceNum.ToString("000000000#"), 490, 697, 0); cb.ShowTextAligned(PdfContentByte.ALIGN_LEFT, conduceNum.ToString("000000000#"), 490, 300, 0); // copia // copia cb.ShowTextAligned(PdfContentByte.ALIGN_LEFT, CustName, 95, CopyY, 0); CopyY = CopyY - 10; cb.ShowTextAligned(PdfContentByte.ALIGN_LEFT, ShipAddress1, 95, CopyY, 0); CopyY = CopyY - 10; cb.ShowTextAligned(PdfContentByte.ALIGN_LEFT, ShipAddress2, 95, CopyY, 0); CopyY = CopyY - 10; cb.ShowTextAligned(PdfContentByte.ALIGN_LEFT, ShipAddress3, 95, CopyY, 0); CopyY = CopyY - 10; cb.ShowTextAligned(PdfContentByte.ALIGN_LEFT, ShipCity, 95, CopyY, 0); cb.ShowTextAligned(PdfContentByte.ALIGN_LEFT, ShipState, 205, CopyY, 0); cb.ShowTextAligned(PdfContentByte.ALIGN_LEFT, ShipZip, 225, CopyY, 0); cb.ShowTextAligned(PdfContentByte.ALIGN_LEFT, ShipContact, 100, 243, 0); cb.ShowTextAligned(PdfContentByte.ALIGN_LEFT, CustPhone, 77, 228, 0); isStart = false; //cb.SetFontAndSize(tahoma, 9); cb.ShowTextAligned(PdfContentByte.ALIGN_LEFT, JobNumber, 492, 629, 0); cb.ShowTextAligned(PdfContentByte.ALIGN_LEFT, JobNumber, 492, 232, 0); // copia cb.ShowTextAligned(PdfContentByte.ALIGN_LEFT, PONumber, 400, 629, 0); cb.ShowTextAligned(PdfContentByte.ALIGN_LEFT, PONumber, 400, 232, 0);// copia } string OddPackageQty = dr["OddPackageQty"].ToString(); string TotalQtyShipped = dr["TotalQtyShipped"].ToString(); _qtyShipped = qtyShipped(dr["Quantity"].ToString(), dr["NumberofPackages"].ToString()); _componentNumber = Convert.ToInt16(dr["ComponentNumber"].ToString()); _description = Description(dr["PackageDescription"].ToString(), _componentNumber, dr["JobDescription"].ToString(), dr["ComponentDescription"].ToString()); cb.SetFontAndSize(tahoma, 7); if (_qtyShipped != "0") { cb.ShowTextAligned(PdfContentByte.ALIGN_LEFT, recNum.ToString(), 60, myY, 0); if (TotalQtyShipped == _qtyShipped) { cb.ShowTextAligned(PdfContentByte.ALIGN_LEFT, _qtyShipped, 81, myY, 0); cb.ShowTextAligned(PdfContentByte.ALIGN_LEFT, dr["NumberofPackages"].ToString(), 118, myY, 0); cb.ShowTextAligned(PdfContentByte.ALIGN_LEFT, dr["Quantity"].ToString(), 145, myY, 0); cb.ShowTextAligned(PdfContentByte.ALIGN_LEFT, _description, 238, myY, 0); cb.ShowTextAligned(PdfContentByte.ALIGN_LEFT, "0", 180, myY, 0); cb.ShowTextAligned(PdfContentByte.ALIGN_LEFT, "0", 215, myY, 0); } else { cb.ShowTextAligned(PdfContentByte.ALIGN_LEFT, TotalQtyShipped, 81, myY, 0); cb.ShowTextAligned(PdfContentByte.ALIGN_LEFT, dr["NumberofPackages"].ToString(), 118, myY, 0); cb.ShowTextAligned(PdfContentByte.ALIGN_LEFT, dr["Quantity"].ToString(), 145, myY, 0); cb.ShowTextAligned(PdfContentByte.ALIGN_LEFT, "1", 180, myY, 0); cb.ShowTextAligned(PdfContentByte.ALIGN_LEFT, OddPackageQty, 215, myY, 0); cb.ShowTextAligned(PdfContentByte.ALIGN_LEFT, _description, 238, myY, 0); } myY = myY - 10; // copia cb.ShowTextAligned(PdfContentByte.ALIGN_LEFT, recNum.ToString(), 60, myCopyY, 0); if (TotalQtyShipped == _qtyShipped) { cb.ShowTextAligned(PdfContentByte.ALIGN_LEFT, _qtyShipped, 81, myCopyY, 0); cb.ShowTextAligned(PdfContentByte.ALIGN_LEFT, dr["NumberofPackages"].ToString(), 118, myCopyY, 0); cb.ShowTextAligned(PdfContentByte.ALIGN_LEFT, dr["Quantity"].ToString(), 145, myCopyY, 0); cb.ShowTextAligned(PdfContentByte.ALIGN_LEFT, _description, 238, myCopyY, 0); cb.ShowTextAligned(PdfContentByte.ALIGN_LEFT, "0", 180, myCopyY, 0); cb.ShowTextAligned(PdfContentByte.ALIGN_LEFT, "0", 215, myCopyY, 0); } else { cb.ShowTextAligned(PdfContentByte.ALIGN_LEFT, TotalQtyShipped, 81, myCopyY, 0); cb.ShowTextAligned(PdfContentByte.ALIGN_LEFT, dr["NumberofPackages"].ToString(), 118, myCopyY, 0); cb.ShowTextAligned(PdfContentByte.ALIGN_LEFT, dr["Quantity"].ToString(), 145, myCopyY, 0); cb.ShowTextAligned(PdfContentByte.ALIGN_LEFT, "1", 180, myCopyY, 0); cb.ShowTextAligned(PdfContentByte.ALIGN_LEFT, OddPackageQty, 215, myCopyY, 0); cb.ShowTextAligned(PdfContentByte.ALIGN_LEFT, _description, 238, myCopyY, 0); } /* cb.ShowTextAligned(PdfContentByte.ALIGN_LEFT, recNum.ToString(), 60, myCopyY, 0); cb.ShowTextAligned(PdfContentByte.ALIGN_LEFT, _qtyShipped, 90, myCopyY, 0); cb.ShowTextAligned(PdfContentByte.ALIGN_LEFT, dr["NumberofPackages"].ToString(), 140, myCopyY, 0); cb.ShowTextAligned(PdfContentByte.ALIGN_LEFT, dr["Quantity"].ToString(), 185, myCopyY, 0); cb.ShowTextAligned(PdfContentByte.ALIGN_LEFT, _description, 220, myCopyY, 0); */ myCopyY = myCopyY - 10; } }//end while } else { cb.SetFontAndSize(tahoma, 9); cb.ShowTextAligned(PdfContentByte.ALIGN_LEFT, conduceNum.ToString("000000000#"), 490, 697, 0); cb.ShowTextAligned(PdfContentByte.ALIGN_LEFT, conduceNum.ToString("000000000#"), 490, 300, 0); // copia }//end if enBlanco cb.EndText(); document.Close(); Copydocument.Close(); if (!isEnBlanco) dr.Close(); outPut = true; sqlCmd.CommandText = "insert into tblConduce(ConduceNum,pdfFile,Date) values(" + conduceNum.ToString() + ",'" + myPdfFile + "','" + DateTime.Now.ToString("yyyyMMdd") + "')"; sqlCmd.ExecuteNonQuery(); pr.Start(); // para ver el pdf en pantalla } catch (Exception ex) { throw (new Exception(ex.Message + " - getitem - ")); } finally { DTS = null; myDataAdapter = null; } return outPut; }
private string strRetornaValor(string strSessao, string strNomeVariavel, string strValorDefault) { string strRetorno = ""; if (System.IO.File.Exists(m_strPathArquivo)) { System.Data.DataSet dtSetArquivoConfiguracao = new System.Data.DataSet(); try { dtSetArquivoConfiguracao.ReadXml(m_strPathArquivo); } catch { // Arquivo XML esta incorreto return(strValorDefault); } // Procurando a Sessao System.Data.DataTable dttbSessao = null; for (int nCont = 0; nCont < dtSetArquivoConfiguracao.Tables.Count; nCont++) { if (dtSetArquivoConfiguracao.Tables[nCont].TableName == strSessao) { dttbSessao = dtSetArquivoConfiguracao.Tables[nCont]; } } // Sessao nao existe , criando ela if (dttbSessao == null) { dttbSessao = dtSetArquivoConfiguracao.Tables.Add(strSessao); } // Procurando a Variavel bool bAchouVariavel = false; for (int nCont = 0; nCont < dttbSessao.Columns.Count; nCont++) { if (dttbSessao.Columns[nCont].ColumnName == strNomeVariavel) { bAchouVariavel = true; if (dttbSessao.Rows.Count == 0) { System.Data.DataRow dtrwSessao = dttbSessao.NewRow(); dttbSessao.Rows.Add(dtrwSessao); } strRetorno = dttbSessao.Rows[0][dttbSessao.Columns[nCont].ColumnName].ToString(); if (strRetorno == "") { strRetorno = strValorDefault; dttbSessao.Rows[0][dttbSessao.Columns[nCont].ColumnName] = strRetorno; } } } // Variavel nao existe, criando ela if (!bAchouVariavel) { dttbSessao.Columns.Add(strNomeVariavel); if (dttbSessao.Rows.Count == 0) { System.Data.DataRow dtrwSessao = dttbSessao.NewRow(); dttbSessao.Rows.Add(dtrwSessao); } strRetorno = dttbSessao.Rows[0][strNomeVariavel].ToString(); if (strRetorno == "") { strRetorno = strValorDefault; dttbSessao.Rows[0][strNomeVariavel] = strRetorno; } } // Salvando o Arquivo XML try { dtSetArquivoConfiguracao.WriteXml(m_strPathArquivo); }catch { } } return(strRetorno); }
/// <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; } }
/// <summary> /// 储存数据到xml /// </summary> public void WriteXml(string str = "") { //创建一个数据集,将其写入xml文件 //string filename = DateTime.Now.ToString("yyyyMMddHHmmss") + "model.xml"; string filename = "\\model" + str + ".xml"; System.Data.DataSet ds = new System.Data.DataSet("MODEL"); System.Data.DataTable table = new System.Data.DataTable("w"); ds.Tables.Add(table); table.Columns.Add("c1", typeof(double)); table.Columns.Add("c2", typeof(double)); for (int i = 0; i < 200; i++) { System.Data.DataRow row = table.NewRow(); for (int j = 0; j < 2; j++) { row[j] = w[j, i]; } ds.Tables["w"].Rows.Add(row); } table = new System.Data.DataTable("w0"); ds.Tables.Add(table); table.Columns.Add("c1", typeof(double)); table.Columns.Add("c2", typeof(double)); for (int i = 0; i < 1; i++) { System.Data.DataRow row = table.NewRow(); for (int j = 0; j < 2; j++) { row[j] = w0[j, i]; } ds.Tables["w0"].Rows.Add(row); } table = new System.Data.DataTable("b"); ds.Tables.Add(table); table.Columns.Add("c1", typeof(double)); table.Columns.Add("c2", typeof(double)); for (int i = 0; i < 1; i++) { System.Data.DataRow row = table.NewRow(); for (int j = 0; j < 2; j++) { row[j] = b[j, i]; } ds.Tables["b"].Rows.Add(row); } table = new System.Data.DataTable("checkpoint"); ds.Tables.Add(table); table.Columns.Add("trainumber", typeof(int)); table.Columns.Add("batch", typeof(int)); table.Columns.Add("rate", typeof(double)); System.Data.DataRow row1 = table.NewRow(); row1[0] = trainumber; row1[1] = batch; row1[2] = rate; ds.Tables["checkpoint"].Rows.Add(row1); string pathbase = Environment.CurrentDirectory; string path = pathbase + filename; ds.WriteXml(path); textBox1.Text = "写入数据成功!数据见" + path; }
static void Main(string[] args) { String database = ""; String entity = ""; try { Console.WriteLine("Hello World!"); // Create general web service link. HSFWebService hsfWebService = new HSFWebService(); HSFEntityWebService hsfEntityWebService = new HSFEntityWebService(); //call with hsfEntityWebService1 to forward to proxy proxyTrace012 to capture request xml HSFEntityWebService hsfEntityWebService1 = new HSFEntityWebService("abc"); // Create session with user/password. String sessionID = hsfWebService.CreateSession("admin", "Welcome1"); if (sessionID == "") { throw new Exception("Can not create a valid session."); } Console.WriteLine("Session ID : " + sessionID); hsfWebService.OpenServer(sessionID, "HSFServer"); string[] databases = hsfWebService.EnumDatabases(sessionID); if (databases.Length < 1) { throw new Exception("There are no databases in the current server."); } // Open database. if (database == null || database == "") { database = databases[0]; } Console.WriteLine("Database : " + database); hsfWebService.OpenDatabase(sessionID, database); System.Data.DataSet entities = hsfWebService.EnumEntities(sessionID, "", "All"); if (entities == null || entities.Tables["Entities"] == null) { throw new Exception("There are no entities in this database"); } System.Data.DataRow[] entityRows = entities.Tables["Entities"].Select(); if (entityRows.Length < 1) { throw new Exception("There are no entities in this database"); } entity = (string)entityRows[1]["ID"]; Console.WriteLine("Entity : " + entity); // Open entity. hsfEntityWebService.OpenEntity(sessionID, entity, false); // Mark entity as opened. Boolean entityOpened = true; // Get list of time periods. System.Data.DataSet timePeriods = hsfEntityWebService.EnumTimePeriods(sessionID); if (timePeriods == null || timePeriods.Tables["TimePeriods"] == null) { throw new Exception("There are no time periods in this entity"); } System.Data.DataRow[] timePeriodRows = timePeriods.Tables["TimePeriods"].Select(); if (timePeriodRows.Length < 1) { throw new Exception("here are no time periods in this entity"); } int timeCols = timePeriodRows.Length; System.Data.DataSet scenarios = hsfEntityWebService.EnumScenarios(sessionID); if (scenarios == null || scenarios.Tables["Scenarios"] == null) { throw new Exception("There are no scenarios in this entity"); } System.Data.DataRow[] scenarioRows = scenarios.Tables["Scenarios"].Select(); if (scenarioRows.Length < 1) { throw new Exception("here are no scenarios in this entity"); } System.Data.DataSet accounts = hsfEntityWebService.EnumAccounts(sessionID); if (accounts == null || accounts.Tables["Accounts"] == null) { throw new Exception("There are no accounts in this entity"); } System.Data.DataTable accountTable = accounts.Tables["Accounts"]; System.Data.DataRow[] accountRows = accountTable.Select(); if (accountRows.Length < 1) { throw new Exception("here are no accounts in this entity"); } System.Data.DataSet dataCellsOut = null; // Create data set for GetCellData call. System.Data.DataSet dataCellsIn = new System.Data.DataSet(); System.Data.DataTable dataCellsInTable = dataCellsIn.Tables.Add("DataCells"); // Add columns to the table. dataCellsInTable.Columns.Add("Entity", typeof(string)); dataCellsInTable.Columns.Add("Account", typeof(string)); dataCellsInTable.Columns.Add("Time", typeof(string)); dataCellsInTable.Columns.Add("Scenario", typeof(string)); dataCellsInTable.Columns.Add("Measure", typeof(string)); dataCellsInTable.Columns.Add("CustomMembers", typeof(string)); for (int j = 0; j < timeCols; j++) { System.Data.DataRow dataRow = dataCellsInTable.NewRow(); dataRow["Entity"] = entity; dataRow["Account"] = "100.00.000"; dataRow["Measure"] = "Output"; dataRow["Scenario"] = "Base"; dataRow["Time"] = timePeriodRows[j]["ID"]; dataRow["CustomMembers"] = ""; dataCellsInTable.Rows.Add(dataRow); } Console.WriteLine("Request Payload"); dataCellsIn.WriteXml("E:\\VisualStudio2015Workspace\\CSharp_HSF_ConsoleApplication\\GetEntityDataCells.xml", System.Data.XmlWriteMode.WriteSchema); Console.WriteLine("Press any key to proceed."); Console.ReadKey(); // Call GetDataCells. dataCellsOut = hsfEntityWebService.GetEntityDataCells(sessionID, dataCellsIn); if (dataCellsOut == null) { throw new Exception("DataCells data set not found."); } System.Data.DataTable dataCellsOutTable = dataCellsOut.Tables["DataCells"]; System.Data.DataRow[] valueRows = dataCellsOutTable.Select(); System.Data.DataRow[] valueRows2 = valueRows; Console.WriteLine(valueRows.Length); for (int i = 0; i < valueRows2.Length; i++) { System.Data.DataRow dataRow = valueRows2[i]; String text = "<DataCell "; text += "Account=\""; text += dataRow["Account"]; text += "\" Scenario=\""; text += dataRow["Scenario"]; text += "\" Time=\""; text += dataRow["Time"]; text += "\" Measure=\""; text += dataRow["Measure"]; text += "\" Value=\""; text += dataRow["Value"]; Console.WriteLine(text); } Console.WriteLine("calling setentitydatacells"); Console.WriteLine("Press any key to proceed."); Console.ReadKey(); System.Data.DataSet dataCellsOutSet = null; System.Data.DataSet dataCellsInSet = new System.Data.DataSet(); System.Data.DataTable dataCellsInTableSet = dataCellsInSet.Tables.Add("DataCells"); // Add columns to the table. dataCellsInTableSet.Columns.Add("Entity", typeof(string)); dataCellsInTableSet.Columns.Add("Account", typeof(string)); dataCellsInTableSet.Columns.Add("Time", typeof(string)); dataCellsInTableSet.Columns.Add("Scenario", typeof(string)); dataCellsInTableSet.Columns.Add("Measure", typeof(string)); dataCellsInTableSet.Columns.Add("Value", typeof(string)); dataCellsInTableSet.Columns.Add("CustomMembers", typeof(string)); for (int j = 0; j < 10; j++) { System.Data.DataRow dataRowSet = dataCellsInTableSet.NewRow(); dataRowSet["Entity"] = entity; dataRowSet["Account"] = "100.00.000"; dataRowSet["Measure"] = "Output"; dataRowSet["Scenario"] = "Base"; dataRowSet["Time"] = timePeriodRows[j]["ID"]; dataRowSet["Value"] = "100"; dataRowSet["CustomMembers"] = ""; dataCellsInTableSet.Rows.Add(dataRowSet); } dataCellsInSet.WriteXml("E:\\VisualStudio2015Workspace\\CSharp_HSF_ConsoleApplication\\SetEntityDataCells.xml", System.Data.XmlWriteMode.WriteSchema); // Call SetDataCells. //call with hsfEntityWebService1 to forward to proxy proxyTrace012 to capture request xml //dataCellsOutSet = hsfEntityWebService1.SetEntityDataCells(sessionID, dataCellsInSet,"csharpConsoleClient"); // dataCellsOutSet = hsfEntityWebService.SetEntityDataCells(sessionID, dataCellsInSet, "csharpConsoleClient"); // if (dataCellsOutSet == null) throw new Exception("DataCells data set not found."); // System.Data.DataTable dataCellsOutTableSet = dataCellsOutSet.Tables["DataCells"]; // if (dataCellsOutTableSet == null) throw new Exception("DataCells table not found."); System.Data.DataSet dataCellsOutAccountList = hsfEntityWebService.EnumAccounts(sessionID); dataCellsOutAccountList.WriteXml("E:\\VisualStudio2015Workspace\\CSharp_HSF_ConsoleApplication\\EnumAccountsResponse.xml", System.Data.XmlWriteMode.WriteSchema); } catch (Exception e) { Console.WriteLine("*******************************************************"); Console.WriteLine("IN EXCEPTION"); Console.WriteLine(e.StackTrace); Console.WriteLine("Press any key to proceed."); Console.ReadKey(); } finally { Console.WriteLine("Press any key to exit."); Console.ReadKey(); } }