private void gridView1_DoubleClick(object sender, EventArgs e)
{
try
{
DataRow dr = gridView1.GetFocusedDataRow();
if (dr != null)
{
frmInputParam frm = new frmInputParam(_core, Static.ToStr(dr["ReportFullName"]));
frm.ShowDialog();
}
}
catch (Exception ex)
{
colindex.Clear();
MessageBox.Show("Тайлангын формат таарахгүй байна: " + ex.Message);
}
}
private void gridView2_DoubleClick(object sender, EventArgs e)
{
try
{
DataRow dr = gridView2.GetFocusedDataRow();
Excel.Application xlsm = new Excel.Application();
Excel.Workbook xlsWorkBook = xlsm.Workbooks.Open(@Convert.ToString(dr["ReportFullName"]), 0, true, 5, "", "", true, Microsoft.Office.Interop.Excel.XlPlatform.xlWindows, "\t", false, false, 0, true, 1, 0);
Excel.Worksheet xlsWorkSheet = xlsWorkBook.Worksheets[1];
for (int i = 1; i <= xlsWorkSheet.UsedRange.Columns.Count; i++)
{
if (!colindex.ContainsKey(xlsWorkSheet.Cells[1, i].Value.ToString()))
{
colindex.Add(xlsWorkSheet.Cells[1, i].Value.ToString(), i);
}
else
{
colindex.Clear();
MessageBox.Show(string.Format("{0} талбар өмнө нь үүссэн байна.", xlsWorkSheet.Cells[1, i].Value));
}
}
frmInputParam frm = new frmInputParam(_core, xlsWorkSheet.Name);
frm.ShowDialog();
int rowindex = 2;
if (frm.ReportData != null)
{
foreach (DataRow row in frm.ReportData.Rows)
{
foreach (DictionaryEntry fieldname in colindex)
{
xlsWorkSheet.Cells[rowindex, Convert.ToInt32(fieldname.Value)].Value = row[fieldname.Key.ToString()];
}
rowindex++;
}
string path = string.Format("{0}\\Reports{1}.xlsm", _core.ReportPathOut, DateTime.Now.Ticks.ToString());
xlsWorkBook.SaveCopyAs(path);
System.Diagnostics.Process.Start(path);
colindex.Clear();
}
}
catch (Exception ex)
{
colindex.Clear();
MessageBox.Show("Тайлангын формат таарахгүй байна: " + ex.Message);
}
}
