private void tsmImportFromExcel_Click(object sender, EventArgs e)
{
if (this.MasterGrid is IArchiveGrid)
{
WindowInfo info = ADInfoBll.Instance.GetWindowInfo(this.Name);
if (info != null)
{
ArchiveExcelForm form = new GeneratedArchiveExcelForm(info);
form.Show();
}
}
// OpenFileDialog openFileDialog1 = new OpenFileDialog();
// openFileDialog1.RestoreDirectory = true;
// openFileDialog1.Filter = "所有 Excel 文件|*.xls;*.xlsx;*.xml|Excel 97-2003 文件|*.xls|Excel 2007 文件|*.xlsx|XML 文件|*.xml";
//
// if (openFileDialog1.ShowDialog(this) == DialogResult.OK)
// {
// try
// {
// IList<DataTable> list = ExcelXmlHelper.ReadExcelXml(openFileDialog1.FileName);
// foreach (DataTable dt in list)
// {
// foreach (DataRow row in dt.Rows)
// {
// object entity = this.ControlManager.AddNew();
// if (entity != null)
// {
// foreach (DataColumn column in dt.Columns)
// {
// EntityHelper.SetPropertyValue(entity, column.ColumnName, row[column.ColumnName]);
// }
// this.ControlManager.EndEdit(true);
// }
// }
//
// break;
// }
// }
// catch (Exception ex)
// {
// ExceptionProcess.ProcessWithNotify(ex);
// }
// }
}
private void tsmImportFromExcel_Click(object sender, EventArgs e)
{
if (this.MasterGrid is IArchiveGrid)
{
WindowInfo info = ADInfoBll.Instance.GetWindowInfo(this.Name);
if (info != null)
{
ArchiveExcelForm form = new GeneratedArchiveExcelForm(info);
form.Show();
}
}
// OpenFileDialog openFileDialog1 = new OpenFileDialog();
// openFileDialog1.RestoreDirectory = true;
// openFileDialog1.Filter = "���� Excel �ļ�|*.xls;*.xlsx;*.xml|Excel 97-2003 �ļ�|*.xls|Excel 2007 �ļ�|*.xlsx|XML �ļ�|*.xml";
//
// if (openFileDialog1.ShowDialog(this) == DialogResult.OK)
// {
// try
// {
// IList<DataTable> list = ExcelXmlHelper.ReadExcelXml(openFileDialog1.FileName);
// foreach (DataTable dt in list)
// {
// foreach (DataRow row in dt.Rows)
// {
// object entity = this.ControlManager.AddNew();
// if (entity != null)
// {
// foreach (DataColumn column in dt.Columns)
// {
// EntityHelper.SetPropertyValue(entity, column.ColumnName, row[column.ColumnName]);
// }
// this.ControlManager.EndEdit(true);
// }
// }
//
// break;
// }
// }
// catch (Exception ex)
// {
// ExceptionProcess.ProcessWithNotify(ex);
// }
// }
}
/// <summary>
/// CreateWindow
/// </summary>
/// <param name="windowInfo"></param>
/// <returns></returns>
public object CreateWindow(WindowInfo windowInfo)
{
MyForm returnForm = null;
switch (windowInfo.WindowType)
{
case WindowType.Maintain:
case WindowType.Transaction:
{
returnForm = new GeneratedArchiveOperationForm(windowInfo);
}
break;
case WindowType.Query:
{
// decide gridType
IList<WindowTabInfo> tabInfos = ADInfoBll.Instance.GetWindowTabInfosByWindowId(windowInfo.Name);
IList<GridColumnInfo> gridColumns = ADInfoBll.Instance.GetGridColumnInfos(tabInfos[0].GridName);
foreach (GridColumnInfo info in gridColumns)
{
if (!string.IsNullOrEmpty(info.ParentPropertyName))
{
returnForm = new GeneratedArchiveSeeForm(windowInfo, DataGridType.DataUnboundGridLoadOnce);
}
}
returnForm = new GeneratedArchiveSeeForm(windowInfo);
}
break;
case WindowType.QueryBound:
{
returnForm = new GeneratedArchiveSeeForm(windowInfo, DataGridType.DataBoundGridLoadOnDemand);
}
break;
case WindowType.TransactionBound:
{
returnForm = new GeneratedArchiveOperationForm(windowInfo, ArchiveGridType.ArchiveBoundGrid);
}
break;
case WindowType.Select:
{
returnForm = new GeneratedArchiveCheckForm(windowInfo);
}
break;
case WindowType.DatabaseReport:
{
returnForm = new GeneratedArchiveDatabaseReportForm(windowInfo);
}
break;
case WindowType.DataSetReport:
{
returnForm = new GeneratedArchiveDataSetReportForm(windowInfo);
}
break;
case WindowType.SelectWindow:
{
using (ArchiveSelectForm selectForm = new ArchiveSelectForm(windowInfo.Name))
{
if (selectForm.ShowDialog() == DialogResult.OK)
{
returnForm = selectForm.SelectedForm;
}
else
{
returnForm = null;
}
}
}
break;
case WindowType.DetailTransaction:
{
ArchiveDetailForm form = ArchiveFormFactory.GenerateArchiveDetailForm(ADInfoBll.Instance.GetWindowInfo(windowInfo.Name), null);
form.Load += new EventHandler(delegate(object sender, System.EventArgs e)
{
form.UpdateContent();
form.SetMenuState();
});
form.SetAsMdiChild();
//// 创建TaskPane
//GridRelatedControl gridRelatedControl = null;
//form.SetGridRelatedPanel(() =>
// {
// if (gridRelatedControl == null)
// {
// gridRelatedControl = new GridRelatedControl(form.GridName, form.DisplayManager, form);
// }
// return gridRelatedControl;
// });
form.GenerateWindowMenu(ADInfoBll.Instance.GetWindowMenuInfo(windowInfo.Name));
form.Disposed += new EventHandler(delegate(object sender, System.EventArgs e)
{
form.DisposeWindowMenu();
});
returnForm = form;
}
break;
case WindowType.DataControl:
{
returnForm = new GeneratedArchiveDataControlForm(windowInfo);
}
break;
case WindowType.ExcelOperation:
{
returnForm = new GeneratedArchiveExcelForm(windowInfo);
}
break;
default:
throw new ArgumentException("Invalid WindowType in WindowInfo");
}
if (WindowCreated != null)
{
WindowCreated(returnForm, System.EventArgs.Empty);
}
return returnForm;
}
