public static bool GetQualityExportListByPage(ref List <QuanlityExportInfo> modelList, QuanlityExportInfo model, ref DividPage page, ref string strError) { return(WMSWebService.service.GetQualityExportListByPage(ref modelList, model, ref page, Common_Var.CurrentUser, ref strError)); }
private void ExportDetail() { if (dgvList.DataSource == null || dgvList.Rows.Count <= 0) { MessageBox.Show("请先查询到结果后再尝试导出明细", "导出失败"); return; } bsDelivery.EndEdit(); if (dtpStartDate.Checked && DeliveryModel.StartTime != dtpStartDate.Value) { GetListQueryData(); } else if (!dtpStartDate.Checked && DeliveryModel.StartTime != null) { GetListQueryData(); } else if (dtpEndDate.Checked && DeliveryModel.EndTime != dtpEndDate.Value) { GetListQueryData(); } else if (!dtpEndDate.Checked && DeliveryModel.EndTime != null) { GetListQueryData(); } string strErrMsg = string.Empty; List <QuanlityExportInfo> lstExport = new List <QuanlityExportInfo>(); QuanlityExportInfo queryExport = new QuanlityExportInfo(); try { this.Cursor = Cursors.WaitCursor; queryExport.StartTime = DeliveryModel.StartTime; queryExport.EndTime = DeliveryModel.EndTime; queryExport.DeliveryNo = DeliveryModel.DeliveryNo; queryExport.MaterialDoc = DeliveryModel.MaterialDoc; queryExport.VoucherNo = DeliveryModel.VoucherNo; queryExport.MaterialNo = DeliveryModel.MaterialNo; DividPage serverPage = new DividPage(); serverPage.CurrentPageNumber = 1; serverPage.CurrentPageShowCounts = -1; if (!Quality_Func.GetQualityExportListByPage(ref lstExport, queryExport, ref serverPage, ref strErrMsg)) { MessageBox.Show(strErrMsg, "导出失败"); return; } } catch (Exception ex) { MessageBox.Show(ex.Message, "导出失败"); return; } finally { this.Cursor = Cursors.Default; } try { string excludecol = "ID,QualityType,StartTime,EndTime"; Dictionary <string, string> dicFields = new Dictionary <string, string>(); dicFields.Add("DeliveryNo", "送货单号"); dicFields.Add("SupplierNo", "供应商代码"); dicFields.Add("SupplierName", "供应商名称"); dicFields.Add("Plant", "工厂"); dicFields.Add("MaterialDoc", "凭证号"); dicFields.Add("CreateDate", "创建时间"); dicFields.Add("PrintedQty", "已打印次数"); dicFields.Add("PrintTime", "最后打印时间"); dicFields.Add("MoveType", "移动类型"); dicFields.Add("VoucherNo", "采购单号"); dicFields.Add("RowNo", "行号"); dicFields.Add("MaterialNo", "物料编号"); dicFields.Add("MaterialDesc", "物料描述"); dicFields.Add("ReceiveQty", "收货数量"); dicFields.Add("Unit", "计量单位"); dicFields.Add("PrdVersion", "产品版本"); dicFields.Add("QualityQty", "合格数量"); dicFields.Add("UnQualityQty", "不合格数量"); dicFields.Add("QualityType", "却先等级"); dicFields.Add("StrQualityType", "缺陷等级"); ExcelLibrary.ExcelLibrary_Func.SaveListToExcelByNPOI(lstExport, true, excludecol, dicFields, dgvList.DefaultCellStyle.Font); } catch (Exception ex) { MessageBox.Show(ex.Message, "导出失败"); return; } }