private void ButtonInsertAnnoToExcel_Click(object sender, EventArgs e)
{
//判断机制需要更加智能
if (this.dataGridViewAnnoText.DataSource != null && this.dataGridViewAnnoText.Rows.Count > 0)
{
if (this.dataGridViewAnnoText.Rows.Count == 0)
{
MessageBox.Show("未查询到相应数据！");
}
else
{
//int seletedHandle = this.dataGridViewResult.CurrentRow.Index;
//MessageBox.Show(dataGridViewResult.CurrentRow.Cells[3].Value.ToString());
//获得选中行的值
//EditExcel.getActivCell().Value = dataGridViewResult.CurrentRow.Cells[3].Value.ToString();
EditExcel.getActivCell().Value = StringHelper.insert2Excel(dataGridViewAnnoText.CurrentRow.Cells[2].Value.ToString(), dataGridViewAnnoText.CurrentRow.Cells[3].Value.ToString());
//MessageBox.Show(this.gridView1.GetRowCellValue(seletedHandle, "IRI").ToString());
//Insert2Excel.insert2Excel(this.gridView1.GetRowCellValue(seletedHandle, "Term").ToString(), this.gridView1.GetRowCellValue(seletedHandle, "IRI").ToString(), sheetControl);
}
}
else
{
MessageBox.Show("请先搜索", "ERROR");
}
}
public void annotatorTerm(IRibbonControl control)
{
//如果用户未创建sheet，将自动创建一个sheet
if (!EditExcel.IsSheetActive())
{
EditExcel.createWorkbook();
}
Form aForm = new AnnotatorForm();
aForm.Show();
}
public void searchTerm(IRibbonControl control)
{
//如果用户未创建sheet，将自动创建一个sheet
if (!EditExcel.IsSheetActive())
{
EditExcel.createWorkbook();
}
Form sForm = new SearchTermForm();
sForm.Show();
}
public void uploadXML(IRibbonControl control)
{
//xml文件上传模块
OpenFileDialog uploadXMLDiaglog = new OpenFileDialog();
uploadXMLDiaglog.Filter = "Xml文件|*.xml";
uploadXMLDiaglog.FileName = string.Empty;
uploadXMLDiaglog.FilterIndex = 1;
uploadXMLDiaglog.RestoreDirectory = true;
if (uploadXMLDiaglog.ShowDialog() == DialogResult.OK)
{
//test
MessageBox.Show(uploadXMLDiaglog.FileName);
string xmlFilePath = uploadXMLDiaglog.FileName;
//读取XML模板中的数据
try
{
XElement xe = XElement.Load(@xmlFilePath);
var elements = from ele in xe.Elements()
select ele;
//引入数据模型接受数据
List <DateElement> modulList = new List <DateElement>();
//测试
//MessageBox.Show(modulList.Count.ToString());
//获得xml中所有数据以及其可用性范围
//其中值为空时，输出为'',并不是null
foreach (var ele in elements)
{
DateElement de = new DateElement();
de.LONGNAME = ele.Element("LONGNAME").Value;
de.PreferredQuestionText = ele.Element("PreferredQuestionText").Value;
de.Datatype = ele.Element("VALUEDOMAIN").Element("Datatype").Value;
de.ValueDomainType = ele.Element("VALUEDOMAIN").Element("ValueDomainType").Value;
de.UnitOfMeasure = ele.Element("VALUEDOMAIN").Element("UnitOfMeasure").Value != "" ? ele.Element("VALUEDOMAIN").Element("UnitOfMeasure").Value : null;
de.MaximumLength = ele.Element("VALUEDOMAIN").Element("MaximumLength").Value != "" ? Convert.ToInt32(ele.Element("VALUEDOMAIN").Element("MaximumLength").Value) : -1;
de.MinimumLength = ele.Element("VALUEDOMAIN").Element("MinimumLength").Value != "" ? Convert.ToInt32(ele.Element("VALUEDOMAIN").Element("MinimumLength").Value) : -1;
de.DecimalPlace = ele.Element("VALUEDOMAIN").Element("DecimalPlace").Value != "" ? Convert.ToInt32(ele.Element("VALUEDOMAIN").Element("DecimalPlace").Value) : -1;
de.MaximumValue = ele.Element("VALUEDOMAIN").Element("MaximumValue").Value != "" ? Convert.ToInt32(ele.Element("VALUEDOMAIN").Element("MaximumValue").Value) : -1;
de.MinimumValue = ele.Element("VALUEDOMAIN").Element("MinimumValue").Value != "" ? Convert.ToInt32(ele.Element("VALUEDOMAIN").Element("MinimumValue").Value) : -1;
modulList.Add(de);
}
//测试
MessageBox.Show(modulList.Count.ToString());
/**
*处理Excel
*/
EditExcel ee = new EditExcel();
ee.createWorkbookWithDateElement(StringHelper.getCurrPath(xmlFilePath), modulList);
//ee.createWorkbook(sh.getCurrPath(xmlFilePath));
EditExcel.openFile(StringHelper.getCurrPath(xmlFilePath));
}
catch (Exception e)
{
// english version alt information
MessageBox.Show("错误: " + e.Message + "上传的模板编码请设置成UTF-8，提示：另存为，右下角选择编码模式UTF-8");
}
}
}
