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"); }
/// <summary> /// 绑定申请科室 /// </summary> /// <param name="cmb_ReferDept"></param> public System.Data.DataTable Bind_ReferDept(ComboBox cmb_ReferDept) { string sql = "select distinct a.GROUP_CODE as DEPT_CODE,a.GROUP_NAME as DEPT_NAME,a.INPUT_CODE from STAFF_GROUP_DICT a,STAFF_VS_GROUP b where (b.group_class= '科室医生' or b.group_class='病区医生') and a.GROUP_CODE=b.GROUP_CODE"; //string Xml = DBoperate.ini.IniReadValue("SettingFiles", "DeptDict"); //System.Data.DataSet ds = new System.Data.DataSet(); //ds.ReadXml(Application.StartupPath + "\\" + Xml); //dt_DeptCode = ds.Tables[1]; System.Data.DataTable dt = GetDataSet(sql).Tables[0]; System.Data.DataRow[] drs = dt.Select("DEPT_NAME like '%门诊%'"); System.Data.DataSet Result = new System.Data.DataSet(); Result.Merge(drs); drs = dt.Select("DEPT_NAME like '%病房%'"); Result.Merge(drs); drs = dt.Select("DEPT_NAME not like '%病房%' and DEPT_NAME not like '%门诊%'"); Result.Merge(drs); cmb_ReferDept.DataSource = Result.Tables[0].DefaultView; cmb_ReferDept.DisplayMember = Result.Tables[0].Columns["DEPT_NAME"].ColumnName; cmb_ReferDept.ValueMember = Result.Tables[0].Columns["DEPT_CODE"].ColumnName; return(Result.Tables[0]); }
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); } }
internal void SaveWorkbook() { try { using (SaveFileDialog saveDialog = new SaveFileDialog()) { saveDialog.CreatePrompt = false; saveDialog.OverwritePrompt = true; saveDialog.RestoreDirectory = false; saveDialog.InitialDirectory = System.IO.Path.GetDirectoryName(FilenameTextBox.Text); saveDialog.FileName = System.IO.Path.GetFileNameWithoutExtension(FilenameTextBox.Text); saveDialog.Filter = Properties.Resources.FILE_SAVEFILE_FILTER; saveDialog.DefaultExt = Constants.FILE_SAVEFILE_EXTENSION; saveDialog.FilterIndex = 2; if (saveDialog.ShowDialog() == DialogResult.OK) { System.IO.Stream dtStream; if ((dtStream = saveDialog.OpenFile()) != null) { Cursor.Current = Cursors.WaitCursor; dtStream.Close(); if (System.Threading.Tasks.Task.Run(() => { return(ExportDataTableCollection(saveDialog.FileName)); }).Result) { FilenameTextBox.Text = saveDialog.FileName; } Cursor.Current = Cursors.Default; } SaveAsLastFileOpened(saveDialog.FileName); } SetSpreadsheetChanges(false); } } catch (System.IO.IOException ex) { MessageBox.Show(string.Format(UserHelper.culture, Properties.Resources.NOTIFY_FILESAVE_ERROR, System.IO.Path.GetFileNameWithoutExtension(FilenameTextBox.Text)), Properties.Resources.CAPTION_SAVE_WORKBOOK, MessageBoxButtons.OK, MessageBoxIcon.Error); if (log != null) { log.Error(string.Format(UserHelper.culture, Properties.Resources.NOTIFY_FILESAVE_ERROR, System.IO.Path.GetFileNameWithoutExtension(FilenameTextBox.Text)), ex); } } bool ExportDataTableCollection(string destination) { using (System.Data.DataSet ExportDataSet = new System.Data.DataSet()) { foreach (System.Data.DataTable WorkTable in DataTableCollection) { WorkTable.AcceptChanges(); ExportDataSet.Merge(WorkTable); } System.Data.DataTableCollection ExportTableCollection = ExportDataSet.Tables; foreach (System.Data.DataTable ExportTable in ExportTableCollection) { ExportTable.Constraints.Clear(); ClassLibraryStandard.DataTableMethods.DeleteColumn(ExportTable, Constants.KEY_COLUMN); } return(CreateExcelFile.CreateExcelFile.ExportExcelDocument(ExportTableCollection, destination)); } } }
public System.Data.DataSet GetAppendList(Dictionary<Guid, Guid> multiBuffer) { int countProducts = multiBuffer.Where(item => Guid.Empty.Equals(item.Value)).Count(); int countProductsWithConfiguration = multiBuffer.Where(item => !Guid.Empty.Equals(item.Value)).Count(); ; System.Data.DataSet dataSet = new System.Data.DataSet(); using (CommonDataProvider provider = new CommonDataProvider()) { /* * Надо обязательно исправить, в случае когда в буфере будут и конфигурации * и просто продукты -- получится не хорошо... */ if (countProducts > 0) { string sqlProducts = BuildAppendProductsQuery(multiBuffer); dataSet.Merge(provider.ExecuteCommand(sqlProducts)); } if (countProductsWithConfiguration > 0) { string sqlConfigurations = BuildAppendConfigurationsQuery(multiBuffer); dataSet.Merge(provider.ExecuteCommand(sqlConfigurations)); } } return dataSet; }