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;
}
