private void btnOutput_Click(object sender, EventArgs e) { //UpdateProductCode(txtProductCode.Text); DataRow drMessage; DataTable dtBill = m_findSellIn.GetBill(m_strBillID, 0); if (dtBill == null || dtBill.Rows.Count == 0) { drMessage = null; } else { drMessage = m_findSellIn.GetBill(m_strBillID, 0).Rows[0]; } string strDate = drMessage == null?ServerTime.Time.ToString() : drMessage["Date"].ToString(); string strYwType = drMessage == null ? "" : drMessage["YWFS"].ToString(); DataTable dtNew = new DataTable(); DataTable dt = (DataTable)dataGridView1.DataSource; dtNew.Columns.Add("序号"); dtNew.Columns.Add("产品型号"); dtNew.Columns.Add("入库日期"); dtNew.Columns.Add("产品编号"); dtNew.Columns.Add("产品状态"); dtNew.Columns.Add("产品说明"); dtNew.Columns.Add("退库状态"); dtNew.Columns.Add("箱子编号"); for (int i = 0; i < dt.Rows.Count; i++) { DataRow dr = dtNew.NewRow(); dr["序号"] = dt.Rows[i]["Number"].ToString(); dr["产品型号"] = txtGoodsCode.Text.Trim().ToString(); dr["入库日期"] = strDate; dr["产品编号"] = dt.Rows[i]["ProductCode"].ToString(); dr["产品状态"] = m_dicMarkInfo.First().Value.ToString(); dr["产品说明"] = "【" + strYwType + "】 " + m_barCodeInfo.Remark; dr["退库状态"] = ""; dr["箱子编号"] = dt.Rows[i]["BoxNo"].ToString(); dtNew.Rows.Add(dr); } ExcelHelperP.DataTableToExcel(saveFileDialog1, dtNew, null); }
public void toolStripMenuItem_导入_Click(object sender, EventArgs e) { Control cltr = this.SourceControl; if (cltr == null) { return; } if (cltr is DataGridView) { DataGridView dgvTemp = cltr as DataGridView; DataTable dtTemp = ExcelHelperP.RenderFromExcel(openFileDialog1); if (dtTemp == null) { return; } foreach (DataGridViewColumn cl in dgvTemp.Columns) { if (!dtTemp.Columns.Contains(cl.HeaderText)) { MessageDialog.ShowPromptMessage("文件无【" + cl.HeaderText + "】列名"); return; } } if (_InputEvent != null) { _InputEvent(dtTemp); } MessageDialog.ShowPromptMessage("导入成功"); } else { if (_导入 != null) { _导入(); } } }
private void btnInput_Click(object sender, EventArgs e) { try { DataTable dtTemp = ExcelHelperP.RenderFromExcel(openFileDialog1); if (dtTemp == null || dtTemp.Rows.Count == 0) { throw new Exception("请填写对应列名的内容"); } if (!dtTemp.Columns.Contains("出厂流水码")) { MessageDialog.ShowPromptMessage("未找到列名为:【出厂流水码】的列"); return; } if (!dtTemp.Columns.Contains("箱体编码")) { MessageDialog.ShowPromptMessage("未找到列名为:【箱体编码】的列"); return; } m_dtProductCodes.Rows.Clear(); dataGridView1.DataSource = m_dtProductCodes; foreach (DataRow dr in dtTemp.Rows) { if (dr["出厂流水码"].ToString().Trim().Length != 0) { txtProductCode.Text = dr["出厂流水码"].ToString().Trim(); _TempBoxNo = dr["箱体编码"].ToString().Trim(); btnAdd_Click(sender, e); } } _TempBoxNo = ""; } catch (Exception ex) { MessageDialog.ShowPromptMessage(ex.Message); } }
public void toolStripMenuItem_导出_Click(object sender, EventArgs e) { Control cltr = this.SourceControl; if (cltr == null) { return; } if (cltr is DataGridView) { DataGridView dgvTemp = cltr as DataGridView; ExcelHelperP.DatagridviewToExcel(saveFileDialog1, dgvTemp); } else { if (_导出 != null) { _导出(); } } }
private void btnImport_Click(object sender, EventArgs e) { DataTable dtTemp = ExcelHelperP.RenderFromExcel(openFileDialog1); if (dtTemp == null) { return; } m_receivedUserType = GlobalObject.GeneralFunction.StringConvertToEnum <BillFlowMessage_ReceivedUserType>(tabControl1.SelectedTab.Name); switch (m_receivedUserType) { case BillFlowMessage_ReceivedUserType.用户: if (!dtTemp.Columns.Contains("员工姓名") && !dtTemp.Columns.Contains("员工编号")) { MessageDialog.ShowPromptMessage("无【员工编号】或【员工姓名】列"); return; } DataTable tempTable = ((DataTable)dataGridView2.DataSource).Clone(); foreach (DataRow dr in dtTemp.Rows) { DataRow newRow = tempTable.NewRow(); View_HR_Personnel personnel = new View_HR_Personnel(); object obj = ""; if (dtTemp.Columns.Contains("员工编号")) { obj = dr["员工编号"]; } else { obj = dr["员工姓名"]; } if (obj == null) { MessageDialog.ShowPromptMessage("有一行记录为空,请重新检查"); return; } personnel = UniversalFunction.GetPersonnelInfo(obj.ToString()); if (personnel == null) { MessageDialog.ShowPromptMessage("【员工编号】/【员工姓名】: " + obj.ToString() + " 数据错误,请重新检查"); return; } newRow["员工编号"] = personnel.工号; newRow["员工姓名"] = personnel.姓名; tempTable.Rows.Add(newRow); } dataGridView1.DataSource = tempTable; break; case BillFlowMessage_ReceivedUserType.角色: break; default: break; } }
private void btnExport_Click(object sender, EventArgs e) { ExcelHelperP.DatagridviewToExcel(saveFileDialog1, dataGridView1); }
private void toolStripMenuItem_取消导入项_Click(object sender, EventArgs e) { Control cltr = this.SourceControl; if (cltr == null) { return; } if (cltr is DataGridView) { DataGridView dgvTemp = cltr as DataGridView; int columnsIndex = -1; foreach (DataGridViewColumn cl in dgvTemp.Columns) { if (cl.CellType == typeof(DataGridViewCheckBoxColumn) || cl.CellType == typeof(DataGridViewCheckBoxCell)) { columnsIndex = cl.Index; break; } } if (columnsIndex != -1) { DataTable dtTemp = ExcelHelperP.RenderFromExcel(openFileDialog1); if (dtTemp == null) { return; } foreach (DataGridViewColumn cl in dgvTemp.Columns) { if (cl.Index != columnsIndex) { if (!dtTemp.Columns.Contains(cl.Name)) { MessageDialog.ShowPromptMessage("文件无【" + cl.Name + "】列名"); return; } } } foreach (DataGridViewRow dgvr in dgvTemp.Rows) { foreach (DataRow dr in dtTemp.Rows) { foreach (DataGridViewColumn dgvc in dgvTemp.Columns) { if (dgvc.Index != columnsIndex) { dgvr.Cells[dgvc.Name].Value = dgvr.Cells[dgvc.Name].Value == null ? "" : dgvr.Cells[dgvc.Name].Value.ToString(); dr[dgvc.Name] = dr[dgvc.Name] == null ? "" : dr[dgvc.Name].ToString(); if (dgvr.Cells[dgvc.Name].Value.ToString() == dr[dgvc.Name].ToString()) { dgvr.Cells[columnsIndex].Value = false; } } } } } } } else { if (_取消导入项 != null) { _取消导入项(); } } }
private void CreateExcelFile() { ExcelHelperP.DatagridviewToExcel(saveFileDialog1, dataGridView1); //Microsoft.Office.Interop.Excel.Application excel = new Microsoft.Office.Interop.Excel.Application(); //if (excel == null) //{ // MessageDialog.ShowPromptMessage("无法打开EXCEL, 不能进行此操作"); // return; //} //Cursor preCursor = Cursor.Current; //try //{ // Microsoft.Office.Interop.Excel.Workbook workbook = excel.Application.Workbooks.Add(true); // char beginColHead = 'A';//A-Z, AA-AZ, BA-BZ // int colWidth = 0; // string[] colHeadArray = { "", "A", "B", "C", "D", "E" }; // // 从数据库中获取列宽信息 // List<Show_FieldWidth> lstFieldWidth = StapleInfo.FieldWidthServer.GetFieldWidth(); // // 获取A-Z列 // Microsoft.Office.Interop.Excel.Range range = (Microsoft.Office.Interop.Excel.Range)excel.Columns["A:Z", Type.Missing]; // // 每行高度 // range.RowHeight = 25; // // 每列宽度 // //range.ColumnWidth = 15; // // 每行水平居中对齐 // range.HorizontalAlignment = Microsoft.Office.Interop.Excel.XlHAlign.xlHAlignCenter; // // 每行垂直居中对齐 // range.VerticalAlignment = Microsoft.Office.Interop.Excel.XlVAlign.xlVAlignCenter; // range.WrapText = true; // 自动换行 // //range.EntireColumn.AutoFit(); // 列高根据内容自动调整 // //range.EntireRow.AutoFit(); // 行高根据内容自动调整 // for (int i = 0; i < m_quertResultTable.Columns.Count; i++) // { // if (!dataGridView1.Columns[i].Visible) // { // m_quertResultTable.Columns.RemoveAt(i); // i--; // continue; // } // #region 设置EXCEL列宽 // string colHead = colHeadArray[i / 26] + Convert.ToChar(Convert.ToByte(beginColHead) + i % 26).ToString(); // List<Show_FieldWidth> fwInfo = StapleInfo.FieldWidthServer.GetFieldWidth(lstFieldWidth, m_quertResultTable.Columns[i].ColumnName); // if (fwInfo.Count > 0) // { // colWidth = fwInfo[0].ExcelColumnWidth; // } // else // { // colWidth = 12; // } // ((Microsoft.Office.Interop.Excel.Range)excel.Columns[colHead, Type.Missing]).ColumnWidth = colWidth; // #endregion // excel.Cells[1, i + 1] = m_quertResultTable.Columns[i].ColumnName; // } // int rowIndex = 2; // for (int i = 0; i < m_quertResultTable.Rows.Count; i++) // { // for (int col = 0; col < m_quertResultTable.Columns.Count; col++) // { // if (MustTextMode(m_quertResultTable.Columns[col].ColumnName)) // { // excel.Cells[rowIndex, col + 1] = "'" + m_quertResultTable.Rows[i][col]; // } // else // { // excel.Cells[rowIndex, col + 1] = m_quertResultTable.Rows[i][col]; // } // } // rowIndex++; // } // //excel.Cells[1, 1] = "hello"; // //excel.Cells[1, 2] = "world"; // //excel.Cells[2, 1] = "hello2"; // //excel.Cells[2, 2] = "world2"; // //excel.Visible = true; // Cursor.Current = Cursors.WaitCursor; // workbook.SaveAs(saveFileDialog1.FileName, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, // Microsoft.Office.Interop.Excel.XlSaveAsAccessMode.xlNoChange, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value); // excel.Quit(); // excel = null; //} //finally //{ // Cursor.Current = preCursor; // if (excel != null) // excel.Quit(); //} }
private void btnExport_Click(object sender, EventArgs e) { ExcelHelperP.DatagridviewToExcel(saveFileDialog1, GetDataGridView(tabControl1.SelectedTab) as DataGridView); }
private void CreateExcelFile() { ExcelHelperP.DatagridviewToExcel(saveFileDialog1, dataGridView1); }
void OutPutExcel(DataGridView dgrv) { ExcelHelperP.DatagridviewToExcel(saveFileDialog1, dgrv); }