public override void OnClick()
{
if (XtraMessageBox.Show("删除标准也将删除当前标准已有数据，您确定要修改吗？", "删除确认", MessageBoxButtons.YesNo) == DialogResult.Yes)
{
if (!MetaStandardHelper.DeleteStandard(m_Manager.CurrentMetaStandard))
{
XtraMessageBox.Show(MetaStandardHelper.ErrorMessage);
}
else
{
m_Manager.Refresh();
}
}
}
public override void OnClick()
{
if (DevExpress.XtraEditors.XtraMessageBox.Show("标准的修改将导致此标准的数据表重建，您确定要修改吗？", "修改确认", MessageBoxButtons.YesNo) == DialogResult.Yes)
{
if (m_FrmEdit == null || m_FrmEdit.IsDisposed)
{
m_FrmEdit = new FrmStandardProperty();
m_FrmEdit.ViewMode = FrmStandardProperty.enumPropertyViewMode.Edit;
}
m_FrmEdit.CurrentStandard = m_Manager.CurrentMetaStandard;
m_FrmEdit.Text = string.Format("元数据标准[{0}]修改", m_Manager.CurrentMetaStandard.Name);
if (m_FrmEdit.ShowDialog(base.m_Hook.UIHook.MainForm) == DialogResult.OK)
{
MetaStandardHelper.SaveStandard(m_FrmEdit.CurrentStandard);
}
this.m_Manager.Refresh();
}
}
public override void OnClick()
{
MetaStandard newStandard = new MetaStandard();
newStandard.Name = "新建标准";
newStandard.Creator = Environment.Application.UserName;
newStandard.CreateTime = DateTime.Now;
if (m_FrmAdd == null || m_FrmAdd.IsDisposed)
{
m_FrmAdd = new FrmStandardProperty();
m_FrmAdd.ViewMode = FrmStandardProperty.enumPropertyViewMode.New;
m_FrmAdd.Text = "新建元数据标准";
}
m_FrmAdd.CurrentStandard = newStandard;
if (m_FrmAdd.ShowDialog(base.m_Hook.UIHook.MainForm) == DialogResult.OK)
{
MetaStandardHelper.SaveStandard(m_FrmAdd.CurrentStandard);
}
this.m_Manager.Refresh();
}
private void wizardControl1_FinishClick(object sender, CancelEventArgs e)
{
e.Cancel = true;
if (m_CurrentStandard == null)
{
XtraMessageBox.Show("请指定元数据标准。");
return;
}
SendMessage("正在解析数据...");
DataTable dtData = null;
try
{
if (rpDataType.SelectedIndex == 0)
{
Utility.TxtConfigReader txtReader = new Utility.TxtConfigReader();
txtReader.FileName = txtPath.Text;
txtReader.SplitString = m_SplitArray[rpSplit.SelectedIndex];
dtData = txtReader.ReadMultiToDataTable();
}
if (rpDataType.SelectedIndex == 1)
{
Utility.ExcelConfigReader excelReader = new Utility.ExcelConfigReader();
excelReader.FileName = txtPath.Text;
dtData = excelReader.ReadToDataTable();
}
if (rpDataType.SelectedIndex == 2)
{
Utility.XmlConfigReader xmlReader = new Utility.XmlConfigReader();
xmlReader.FileName = txtPath.Text;
dtData = xmlReader.ReadToDataTable();
}
}
catch
{
}
if (dtData == null)
{
XtraMessageBox.Show("数据解析失败");
return;
}
//
SendMessage("正在匹配字段...");
Dictionary <string, string> dictMapping = new Dictionary <string, string>();
Dictionary <string, int> dictFieldIndex = new Dictionary <string, int>();
if (!string.IsNullOrEmpty(this.m_CurrentStandard.MappingDict))
{
IList <Hy.Dictionary.DictItem> dictList = Hy.Dictionary.DictHelper.GetItemsByName(this.m_CurrentStandard.MappingDict);
IList <Hy.Dictionary.DictItem> mappingList = dictList.Count > 0 ? dictList[0].SubItems : null;
if (mappingList != null && mappingList.Count > 0)
{
foreach (Hy.Dictionary.DictItem dItem in mappingList)
{
dictMapping[dItem.Code] = dItem.Name;
}
}
}
for (int i = 0; i < dtData.Columns.Count; i++)
{
//dtData.Columns[i].ColumnName = dictMapping[dtData.Columns[i].ColumnName];
dictFieldIndex[dictMapping.ContainsKey(dtData.Columns[i].ColumnName) ? dictMapping[dtData.Columns[i].ColumnName] : dtData.Columns[i].ColumnName]
= i;
}
int countTemp = 0;
DataTable dtTarget = MetaStandardHelper.GetMetadata(m_CurrentStandard, "1=2", 1, 0, ref countTemp);
List <int> sourceIndexs = new List <int>();
List <int> targetIndexs = new List <int>();
for (int i = 0; i < dtTarget.Columns.Count; i++)
{
if (dtTarget.Columns[i].ColumnName == "ID")
{
continue;
}
if (dictFieldIndex.ContainsKey(dtTarget.Columns[i].ColumnName))
{
targetIndexs.Add(i);
sourceIndexs.Add(dictFieldIndex[dtTarget.Columns[i].ColumnName]);
}
}
int fieldCount = sourceIndexs.Count;
SendMessage("开始导入...");
for (int i = 0; i < dtData.Rows.Count; i++)
{
SendMessage(string.Format("正在导入{0}/{1}...", i + 1, dtData.Rows.Count));
DataRow rowNew = dtTarget.NewRow();
for (int j = 0; j < fieldCount; j++)
{
rowNew[targetIndexs[j]] = dtData.Rows[i][sourceIndexs[j]];
}
dtTarget.Rows.Add(rowNew);
}
SendMessage("正在写入数据库...");
Environment.AdodbHelper.UpdateTable(m_CurrentStandard.TableName, dtTarget);
SendMessage("导入成功");
XtraMessageBox.Show("导入成功");
e.Cancel = false;
}
public void Refresh()
{
lbStandards.DataSource = MetaStandardHelper.GetAll();
}
