private void InportDataSource(DataTable tableResult, DataGridView dataGridView)
{
if (tableResult != null)
{
if (tableResult.Columns.Contains("EPC") || tableResult.Columns.Contains("RFU") || tableResult.Columns.Contains("USER"))
{
cmaxPage = tableResult.Rows.Count / csize;
cminPage = 0;
tableCollection = tableResult;
cfixColumn = tableCollection.Columns.Count;
tables = new DataTable[cmaxPage + 1];
for (int i = cminPage; i < cmaxPage + 1; i++)
{
tables[i] = PageFun.PageDataTableClone(tableCollection, i, csize);
}
dataGridView.DataSource = tables[cminPage];
// m_SyncContext.Post(UpdataDataGrid, PageFun.PageDataTableClone(tableCollection, minPage, size));
UpdateGridviewHeader(cminPage, csize);
label1.Text = ccurrentPage.ToString();
label3.Text = cmaxPage.ToString();
}
else
{
MessageBox.Show(importErrorMsgStr);
}
}
}
private void CompleteDataToolStripMenuItem_Click(object sender, EventArgs e)
{
InportDataSource(PageFun.GetTables(), this.dataGridView1);
Configuration cfa = ConfigurationManager.OpenExeConfiguration(ConfigurationUserLevel.None);
cfa.AppSettings.Settings["Mode"].Value = "2";
cfa.Save();
}
private void AreaCB_SelectedIndexChanged(object sender, EventArgs e)
{
byte sample = 1;
switch (AreaCB.SelectedIndex)
{
case 0:
if (WriteTagDataFormat.tables.ContainsKey("RFU"))
{
startStrTb.Text = PageFun.AddSpace(WriteTagDataFormat.tables["RFU"].startStr);
stepTb.Text = WriteTagDataFormat.tables["RFU"].step.ToString();
startAddSampleTb.Text = PageFun.AddSpace(string.Format("{0}", sample.ToString("D" + WriteTagDataFormat.tables["RFU"].len * 4)));
areaSampleL.Text = "";
}
else
{
areaSampleL.Text = NoArea;
}
break;
case 1:
if (WriteTagDataFormat.tables.ContainsKey("EPC"))
{
startStrTb.Text = PageFun.AddSpace(WriteTagDataFormat.tables["EPC"].startStr);
stepTb.Text = WriteTagDataFormat.tables["EPC"].step.ToString();
startAddSampleTb.Text = PageFun.AddSpace(string.Format("{0}", sample.ToString("D" + WriteTagDataFormat.tables["EPC"].len * 4)));
areaSampleL.Text = "";
}
else
{
areaSampleL.Text = NoArea;
}
break;
case 2:
if (WriteTagDataFormat.tables.ContainsKey("USER"))
{
startStrTb.Text = PageFun.AddSpace(WriteTagDataFormat.tables["USER"].startStr);
stepTb.Text = WriteTagDataFormat.tables["USER"].step.ToString();
startAddSampleTb.Text = PageFun.AddSpace(string.Format("{0}", sample.ToString("D" + WriteTagDataFormat.tables["USER"].len * 4)));
areaSampleL.Text = "";
}
else
{
areaSampleL.Text = NoArea;
}
break;
default:
break;
}
}
private void StepToolToolStripMenuItem_Click(object sender, EventArgs e)
{
ImportForm importForm = new ImportForm(rm, number);
if (importForm.ShowDialog() == DialogResult.OK)
{
number = importForm.Number;
InportDataSource(PageFun.GetTables(WriteTagDataFormat.tables, number), this.dataGridView1, WriteTagDataFormat.tables);
Configuration cfa = ConfigurationManager.OpenExeConfiguration(ConfigurationUserLevel.None);
cfa.AppSettings.Settings["Number"].Value = number.ToString();
cfa.AppSettings.Settings["Mode"].Value = "1";
cfa.Save();
}
}
private void button1_Click(object sender, EventArgs e)
{
if (mode == 0) //导入原始数据
{
InportDataSource(PageFun.GetTables(), this.dataGridView1, WriteTagDataFormat.tables);
}
else if (mode == 1) //自动跳步方式
{
InportDataSource(PageFun.GetTables(WriteTagDataFormat.tables, number), this.dataGridView1, WriteTagDataFormat.tables);
}
else if (mode == 2) //导入完整数据
{
InportDataSource(PageFun.GetTables(), this.dataGridView1);
}
}
private void SaveData(DataTable source, string path, byte Mode)
{
string fileName = "";
string saveFileName = "";
if (path == "")
{
SaveFileDialog saveDialog = new SaveFileDialog();
saveDialog.DefaultExt = "xls";
saveDialog.Filter = "Excel2007|*.xlsx";
saveDialog.FileName = fileName;
saveDialog.ShowDialog();
saveFileName = saveDialog.FileName;
if (saveFileName.IndexOf(":") < 0)
{
return; //被点了取消
}
Configuration cfa = ConfigurationManager.OpenExeConfiguration(ConfigurationUserLevel.None);
cfa.AppSettings.Settings["FilePath"].Value = historyPath = saveDialog.FileName.Substring(0, saveDialog.FileName.LastIndexOf("\\"));
cfa.Save();
}
else
{
saveFileName = path + "\\" + DateTime.Now.ToFileTime().ToString() + ".xlsx";
}
Microsoft.Office.Interop.Excel.Application xlApp =
new Microsoft.Office.Interop.Excel.Application();
if (xlApp == null)
{
MessageBox.Show(excelCreatErrorStr);
return;
}
Microsoft.Office.Interop.Excel.Workbooks workbooks = xlApp.Workbooks;
Microsoft.Office.Interop.Excel.Workbook workbook =
workbooks.Add(Microsoft.Office.Interop.Excel.XlWBATemplate.xlWBATWorksheet);
Microsoft.Office.Interop.Excel.Worksheet worksheet =
(Microsoft.Office.Interop.Excel.Worksheet)workbook.Worksheets[1]; //取得sheet1
//写入标题
for (int i = 0; i < dataGridView1.ColumnCount; i++)
{
worksheet.Cells[1, i + 1] = dataGridView1.Columns[i].HeaderText;
}
//写入数值
for (int r = 0; r < source.Rows.Count; r++)
{
for (int i = 0; i < dataGridView1.ColumnCount; i++)
{
if (Mode == 0)
{
worksheet.Cells[r + 2, i + 1] = "'" + source.Rows[r][i];
}
else if (Mode == 1)
{
if (source.Rows[r][i].ToString() != null && source.Rows[r][i].ToString() != "")
{
worksheet.Cells[r + 2, i + 1] = PageFun.weigandStrTostr1(source.Rows[r][i].ToString());
}
else
{
worksheet.Cells[r + 2, i + 1] = null;
}
}
else if (Mode == 2)
{
if (source.Rows[r][i].ToString() != null && source.Rows[r][i].ToString() != "")
{
worksheet.Cells[r + 2, i + 1] = PageFun.weigandStrTostr2(source.Rows[r][i].ToString());
}
else
{
worksheet.Cells[r + 2, i + 1] = null;
}
}
}
System.Windows.Forms.Application.DoEvents();
}
worksheet.Columns.EntireColumn.AutoFit();//列宽自适应
MessageBox.Show(fileName + excelSaveSuccessStr, tipStr, MessageBoxButtons.OK);
// MessageBoxEx((IntPtr)0, excelSaveSuccessStr, tipStr, 0, 0);
if (saveFileName != "")
{
try
{
workbook.Saved = true;
workbook.SaveCopyAs(saveFileName); //fileSaved = true;
}
catch (Exception ex)
{//fileSaved = false;
MessageBox.Show(excelPathErrorStr);
}
}
xlApp.Quit();
GC.Collect();//强行销毁
}