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;
}
}
