/// <summary> /// 导出Excel文件操作 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void ExcelExport_Click(object sender, EventArgs e) { try { if (gvAllotBillList.Rows.Count == 0) //判断gridview中是否有数据记录 { MessageBoxEx.Show("您要导出的单据列表不能为空!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } else { DataTable XlsTable = new DataTable();//导出的数据表格 foreach (DataGridViewRow dgRow in gvAllotBillList.Rows) { DataRow TableRow = XlsTable.NewRow();//创建表行项 //创建表列项 XlsTable.Columns.Add("单据类型", typeof(string)); XlsTable.Columns.Add("单据编号", typeof(string)); XlsTable.Columns.Add("单据日期", typeof(string)); XlsTable.Columns.Add("调出机构", typeof(string)); XlsTable.Columns.Add("调出仓库", typeof(string)); XlsTable.Columns.Add("调入机构", typeof(string)); XlsTable.Columns.Add("调入仓库", typeof(string)); XlsTable.Columns.Add("业务数量", typeof(string)); XlsTable.Columns.Add("金额", typeof(string)); XlsTable.Columns.Add("运输方式", typeof(string)); XlsTable.Columns.Add("送货地点", typeof(string)); XlsTable.Columns.Add("部门", typeof(string)); XlsTable.Columns.Add("经办人", typeof(string)); XlsTable.Columns.Add("操作人", typeof(string)); XlsTable.Columns.Add("备注", typeof(string)); XlsTable.Columns.Add("单据状态", typeof(string)); TableRow["单据类型"] = dgRow.Cells["OrderType"].Value.ToString(); TableRow["单据编号"] = dgRow.Cells["BillNum"].Value.ToString(); TableRow["单据日期"] = dgRow.Cells["BillDate"].Value.ToString(); TableRow["调出机构"] = dgRow.Cells["OutDepartment"].Value.ToString(); TableRow["调出仓库"] = dgRow.Cells["OutWareHouse"].Value.ToString(); TableRow["调入机构"] = dgRow.Cells["InDepartment"].Value.ToString(); TableRow["调入仓库"] = dgRow.Cells["InWareHouse"].Value.ToString(); TableRow["业务数量"] = dgRow.Cells["TotalCount"].Value.ToString(); TableRow["金额"] = dgRow.Cells["AmountMoney"].Value.ToString(); TableRow["运输方式"] = dgRow.Cells["DeliveryWays"].Value.ToString(); TableRow["送货地点"] = dgRow.Cells["ArrivePlace"].Value.ToString(); TableRow["部门"] = dgRow.Cells["DepartName"].Value.ToString(); TableRow["经办人"] = dgRow.Cells["HandlerName"].Value.ToString(); TableRow["操作人"] = dgRow.Cells["OpeName"].Value.ToString(); TableRow["备注"] = dgRow.Cells["Remarks"].Value.ToString(); TableRow["单据状态"] = dgRow.Cells["OrderState"].Value.ToString(); XlsTable.Rows.Add(TableRow); } CommonFuncCall.ExportExcelFile(XlsTable);//生成Excel表格文件 } } catch (Exception ex) { MessageBoxEx.Show(ex.Message, "异常提示", MessageBoxButtons.OK, MessageBoxIcon.Question); } }
/// <summary> /// 导出Excel文件操作 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void ExcelExport_Click(object sender, EventArgs e) { try { if (gvAllocBillList.Rows.Count == 0) //判断gridview中是否有数据记录 { MessageBoxEx.Show("您要导出的单据列表不能为空!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } else { DataTable XlsTable = new DataTable();//导出的数据表格 //创建表列项 XlsTable.Columns.Add("单据类型", typeof(string)); XlsTable.Columns.Add("开单类型", typeof(string)); XlsTable.Columns.Add("单据编号", typeof(string)); XlsTable.Columns.Add("单据日期", typeof(string)); XlsTable.Columns.Add("仓库", typeof(string)); XlsTable.Columns.Add("往来单位", typeof(string)); XlsTable.Columns.Add("数量", typeof(string)); XlsTable.Columns.Add("到货地点", typeof(string)); XlsTable.Columns.Add("部门", typeof(string)); XlsTable.Columns.Add("经办人", typeof(string)); XlsTable.Columns.Add("操作人", typeof(string)); XlsTable.Columns.Add("备注", typeof(string)); XlsTable.Columns.Add("单据状态", typeof(string)); foreach (DataGridViewRow dgRow in gvAllocBillList.Rows) { DataRow TableRow = XlsTable.NewRow();//创建表行项 TableRow["单据类型"] = dgRow.Cells["OrderType"].Value.ToString(); TableRow["开单类型"] = dgRow.Cells["BillType"].Value.ToString(); TableRow["单据编号"] = dgRow.Cells["BillNum"].Value.ToString(); TableRow["单据日期"] = dgRow.Cells["BillDate"].Value.ToString(); TableRow["仓库"] = dgRow.Cells["WHName"].Value.ToString(); TableRow["往来单位"] = dgRow.Cells["BusinessUnit"].Value.ToString(); TableRow["数量"] = dgRow.Cells["TotalCount"].Value.ToString(); TableRow["到货地点"] = dgRow.Cells["ArrivPlace"].Value.ToString(); TableRow["部门"] = dgRow.Cells["DepartName"].Value.ToString(); TableRow["经办人"] = dgRow.Cells["HandlerName"].Value.ToString(); TableRow["操作人"] = dgRow.Cells["OpeName"].Value.ToString(); TableRow["备注"] = dgRow.Cells["Remarks"].Value.ToString(); TableRow["单据状态"] = dgRow.Cells["OrderState"].Value.ToString(); XlsTable.Rows.Add(TableRow); } CommonFuncCall.ExportExcelFile(XlsTable);//生成Excel表格文件 } } catch (Exception ex) { MessageBoxEx.Show(ex.Message, "异常提示", MessageBoxButtons.OK, MessageBoxIcon.Question); } }
/// <summary> /// 导出Excel文件 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void ExcelExport_Click(object sender, EventArgs e) { try { if (gvCheckBillList.Rows.Count == 0) //判断gridview中是否有数据记录 { MessageBoxEx.Show("您要导出的单据列表不能为空!"); return; } else { DataTable XlsTable = new DataTable();//导出的数据表格 foreach (DataGridViewRow dgRow in gvCheckBillList.Rows) { DataRow TableRow = XlsTable.NewRow();//创建表行项 //创建表列项 XlsTable.Columns.Add("单据编号", typeof(string)); XlsTable.Columns.Add("单据日期", typeof(string)); XlsTable.Columns.Add("仓库", typeof(string)); XlsTable.Columns.Add("账面数量", typeof(string)); XlsTable.Columns.Add("实盘数量", typeof(string)); XlsTable.Columns.Add("盈亏数量", typeof(string)); XlsTable.Columns.Add("金额", typeof(string)); XlsTable.Columns.Add("部门", typeof(string)); XlsTable.Columns.Add("经办人", typeof(string)); XlsTable.Columns.Add("操作人", typeof(string)); XlsTable.Columns.Add("备注", typeof(string)); XlsTable.Columns.Add("单据状态", typeof(string)); TableRow["单据编号"] = dgRow.Cells["BillNum"].Value.ToString(); TableRow["单据日期"] = dgRow.Cells["BillDate"].Value.ToString(); TableRow["仓库"] = dgRow.Cells["WHName"].Value.ToString(); TableRow["账面数量"] = dgRow.Cells["PapCount"].Value.ToString(); TableRow["实盘数量"] = dgRow.Cells["FirmCount"].Value.ToString(); TableRow["盈亏数量"] = dgRow.Cells["ProfitLosCount"].Value.ToString(); TableRow["金额"] = dgRow.Cells["TotalMoney"].Value.ToString(); TableRow["部门"] = dgRow.Cells["DepartName"].Value.ToString(); TableRow["经办人"] = dgRow.Cells["HandlerName"].Value.ToString(); TableRow["操作人"] = dgRow.Cells["OpeName"].Value.ToString(); TableRow["备注"] = dgRow.Cells["Remarks"].Value.ToString(); TableRow["单据状态"] = dgRow.Cells["OrderState"].Value.ToString(); XlsTable.Rows.Add(TableRow); } CommonFuncCall.ExportExcelFile(XlsTable);//生成Excel表格文件 } } catch (Exception ex) { MessageBoxEx.Show(ex.Message, "异常提示", MessageBoxButtons.OK, MessageBoxIcon.Question); } }
/// <summary> /// 导出Excel文件操作 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void ExcelExport_Click(object sender, EventArgs e) { try { if (gvStockList.Rows.Count == 0) //判断gridview中是否有数据记录 { MessageBoxEx.Show("您要导出的单据列表不能为空!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } else { DataTable XlsTable = new DataTable();//导出的数据表格 foreach (DataGridViewRow dgRow in gvStockList.Rows) { DataRow TableRow = XlsTable.NewRow();//创建表行项 //创建表列项 XlsTable.Columns.Add("配件编码", typeof(string)); XlsTable.Columns.Add("配件名称", typeof(string)); XlsTable.Columns.Add("图号", typeof(string)); XlsTable.Columns.Add("规格", typeof(string)); XlsTable.Columns.Add("配件类别", typeof(string)); XlsTable.Columns.Add("账面库存", typeof(string)); XlsTable.Columns.Add("实际库存", typeof(string)); XlsTable.Columns.Add("占用库存", typeof(string)); XlsTable.Columns.Add("可用库存", typeof(string)); XlsTable.Columns.Add("参考进价", typeof(string)); XlsTable.Columns.Add("条码", typeof(string)); XlsTable.Columns.Add("重量", typeof(string)); XlsTable.Columns.Add("最高进价", typeof(string)); XlsTable.Columns.Add("最低售价", typeof(string)); XlsTable.Columns.Add("会员价", typeof(string)); XlsTable.Columns.Add("一级进价", typeof(string)); XlsTable.Columns.Add("二级进价", typeof(string)); XlsTable.Columns.Add("三级进价", typeof(string)); XlsTable.Columns.Add("一级销价", typeof(string)); XlsTable.Columns.Add("二级销价", typeof(string)); XlsTable.Columns.Add("三级销价", typeof(string)); XlsTable.Columns.Add("车型", typeof(string)); XlsTable.Columns.Add("产地", typeof(string)); XlsTable.Columns.Add("品牌", typeof(string)); XlsTable.Columns.Add("车厂编码", typeof(string)); XlsTable.Columns.Add("备注", typeof(string)); XlsTable.Columns.Add("启停用标志", typeof(string)); TableRow["配件编码"] = dgRow.Cells["PartNum"].Value.ToString(); TableRow["配件名称"] = dgRow.Cells["PartName"].Value.ToString(); TableRow["图号"] = dgRow.Cells["DrawingNum"].Value.ToString(); TableRow["规格"] = dgRow.Cells["PartModel"].Value.ToString(); TableRow["配件类别"] = dgRow.Cells["PartCategory"].Value.ToString(); TableRow["账面库存"] = dgRow.Cells["PapCount"].Value.ToString(); TableRow["实际库存"] = dgRow.Cells["PhysicalCount"].Value.ToString(); TableRow["占用库存"] = dgRow.Cells["OccupyCount"].Value.ToString(); TableRow["可用库存"] = dgRow.Cells["AvailableCount"].Value.ToString(); TableRow["参考进价"] = dgRow.Cells["ReferInPrice"].Value.ToString(); TableRow["条码"] = dgRow.Cells["BarCode"].Value.ToString(); TableRow["重量"] = dgRow.Cells["Weight"].Value.ToString(); TableRow["最高进价"] = dgRow.Cells["HighestInPrice"].Value.ToString(); TableRow["最低售价"] = dgRow.Cells["LowestOutPrice"].Value.ToString(); TableRow["会员价"] = dgRow.Cells["VIPPrice"].Value.ToString(); TableRow["一级进价"] = dgRow.Cells["FirstInPrice"].Value.ToString(); TableRow["二级进价"] = dgRow.Cells["SecondInPrice"].Value.ToString(); TableRow["三级进价"] = dgRow.Cells["ThirdInPrice"].Value.ToString(); TableRow["一级销价"] = dgRow.Cells["FirstOutPrice"].Value.ToString(); TableRow["二级销价"] = dgRow.Cells["SecondOutPrice"].Value.ToString(); TableRow["三级销价"] = dgRow.Cells["ThirdOutPrice"].Value.ToString(); TableRow["车型"] = dgRow.Cells["VehicleType"].Value.ToString(); TableRow["产地"] = dgRow.Cells["ProductPlace"].Value.ToString(); TableRow["品牌"] = dgRow.Cells["PartBrand"].Value.ToString(); TableRow["车厂编码"] = dgRow.Cells["FactoryCode"].Value.ToString(); TableRow["备注"] = dgRow.Cells["PartRemark"].Value.ToString(); TableRow["启停用标志"] = dgRow.Cells["ApplyFlag"].Value.ToString(); XlsTable.Rows.Add(TableRow); } CommonFuncCall.ExportExcelFile(XlsTable);//生成Excel表格文件 } } catch (Exception ex) { MessageBoxEx.Show(ex.Message, "异常提示", MessageBoxButtons.OK, MessageBoxIcon.Question); } }
/// <summary> /// 导出Excel表格数据 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void ExcelExport_Click(object sender, EventArgs e) { try { DataTable XlsTable = null; //导出的数据表格 if (TabCtrlAllocationBill.SelectedTab == tabPgBill) { //导出按出入库单查询表格 if (gvAllocBillList.Rows.Count == 0) //判断gridview中是否有数据记录 { MessageBoxEx.Show("您要导出的单据列表不能为空!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } XlsTable = new DataTable();//导出的数据表格 foreach (DataGridViewRow dgRow in gvAllocBillList.Rows) { DataRow TableRow = XlsTable.NewRow();//创建表行项 //创建表列项 XlsTable.Columns.Add("单据类型", typeof(string)); XlsTable.Columns.Add("开单类型", typeof(string)); XlsTable.Columns.Add("单据编号", typeof(string)); XlsTable.Columns.Add("单据日期", typeof(string)); XlsTable.Columns.Add("仓库", typeof(string)); XlsTable.Columns.Add("往来单位", typeof(string)); XlsTable.Columns.Add("数量", typeof(string)); XlsTable.Columns.Add("到货地点", typeof(string)); XlsTable.Columns.Add("部门", typeof(string)); XlsTable.Columns.Add("经办人", typeof(string)); XlsTable.Columns.Add("操作人", typeof(string)); XlsTable.Columns.Add("备注", typeof(string)); TableRow["单据类型"] = dgRow.Cells["OrderType"].Value.ToString(); TableRow["开单类型"] = dgRow.Cells["BillType"].Value.ToString(); TableRow["单据编号"] = dgRow.Cells["BillNum"].Value.ToString(); TableRow["单据日期"] = dgRow.Cells["BillDate"].Value.ToString(); TableRow["仓库"] = dgRow.Cells["WHName"].Value.ToString(); TableRow["往来单位"] = dgRow.Cells["BusinessUnit"].Value.ToString(); TableRow["数量"] = dgRow.Cells["TotalCount"].Value.ToString(); TableRow["到货地点"] = dgRow.Cells["ArrivePlace"].Value.ToString(); TableRow["部门"] = dgRow.Cells["DepartName"].Value.ToString(); TableRow["经办人"] = dgRow.Cells["HandlerName"].Value.ToString(); TableRow["操作人"] = dgRow.Cells["OpeName"].Value.ToString(); TableRow["备注"] = dgRow.Cells["Remarks"].Value.ToString(); XlsTable.Rows.Add(TableRow); } CommonFuncCall.ExportExcelFile(XlsTable);//生成Excel表格文件 } else if (TabCtrlAllocationBill.SelectedTab == tabPgPartBusUnt) {//导出按配件或往来单位查询表格 if (gvAllocPartList.Rows.Count == 0) { MessageBoxEx.Show("您要导出的单据列表不能为空!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } XlsTable = new DataTable();//导出的数据表格 foreach (DataGridViewRow dgRow in gvAllocPartList.Rows) { DataRow TableRow = XlsTable.NewRow();//创建表行项 //创建表列 XlsTable.Columns.Add("单据类型", typeof(string)); XlsTable.Columns.Add("开单类型", typeof(string)); XlsTable.Columns.Add("出入库单号", typeof(string)); XlsTable.Columns.Add("单据日期", typeof(string)); XlsTable.Columns.Add("配件编码", typeof(string)); XlsTable.Columns.Add("车厂编码", typeof(string)); XlsTable.Columns.Add("配件名称", typeof(string)); XlsTable.Columns.Add("图号", typeof(string)); XlsTable.Columns.Add("规格", typeof(string)); XlsTable.Columns.Add("单位", typeof(string)); XlsTable.Columns.Add("数量", typeof(string)); XlsTable.Columns.Add("车型", typeof(string)); XlsTable.Columns.Add("往来单位编码", typeof(string)); XlsTable.Columns.Add("往来单位名称", typeof(string)); XlsTable.Columns.Add("是否赠品", typeof(string)); XlsTable.Columns.Add("备注", typeof(string)); TableRow["单据类型"] = dgRow.Cells["OrderPartType"].Value.ToString(); TableRow["开单类型"] = dgRow.Cells["BillingType"].Value.ToString(); TableRow["出入库单号"] = dgRow.Cells["OrderNum"].Value.ToString(); TableRow["单据日期"] = dgRow.Cells["OrderDate"].Value.ToString(); TableRow["配件编码"] = dgRow.Cells["PartCode"].Value.ToString(); TableRow["车厂编码"] = dgRow.Cells["CarPartCode"].Value.ToString(); TableRow["配件名称"] = dgRow.Cells["PartName"].Value.ToString(); TableRow["图号"] = dgRow.Cells["DrawingNum"].Value.ToString(); TableRow["规格"] = dgRow.Cells["Spec"].Value.ToString(); TableRow["单位"] = dgRow.Cells["Unit"].Value.ToString(); TableRow["数量"] = dgRow.Cells["Count"].Value.ToString(); TableRow["车型"] = dgRow.Cells["VehicleModel"].Value.ToString(); TableRow["往来单位编码"] = dgRow.Cells["BusinessUnitCode"].Value.ToString(); TableRow["往来单位名称"] = dgRow.Cells["BussinessunitName"].Value.ToString(); if ((bool)((DataGridViewCheckBoxCell)dgRow.Cells["isgift"]).EditedFormattedValue) { TableRow["是否赠品"] = "是"; } else { TableRow["是否赠品"] = "否"; } TableRow["备注"] = dgRow.Cells["PartRemark"].Value.ToString(); XlsTable.Rows.Add(TableRow); } } } catch (Exception ex) { MessageBoxEx.Show(ex.Message, "异常提示", MessageBoxButtons.OK, MessageBoxIcon.Question); } }