private void ExportDetail()
{
if (dgvList.DataSource == null || dgvList.Rows.Count <= 0)
{
MessageBox.Show("请先查询到结果后再尝试导出明细", "导出失败");
return;
}
bsMain.EndEdit();
string strErrMsg = string.Empty;
List <OverViewExportInfo> lstExport = new List <OverViewExportInfo>();
OverViewExportInfo queryExport = new OverViewExportInfo();
try
{
this.Cursor = Cursors.WaitCursor;
queryExport.TaskType = queryMain.TaskType;
queryExport.StartTime = queryMain.StartTime;
queryExport.EndTime = queryMain.EndTime;
queryExport.DeliveryNo = queryMain.DeliveryNo;
queryExport.MaterialDoc = queryMain.MaterialDoc;
queryExport.TaskNo = queryMain.TaskNo;
queryExport.SupCusNo = queryMain.SupcusNo;
queryExport.ReceiveUserNo = queryMain.ReceiveUserNo;
queryExport.TaskStatus = queryMain.TaskStatus;
queryExport.VoucherType = queryMain.VoucherType;
queryExport.PostStatus = queryMain.PostStatus;
queryExport.IsQuality = queryMain.IsQuality;
queryExport.WarehouseID = queryMain.WarehouseID;
DividPage serverPage = new DividPage();
serverPage.CurrentPageNumber = 1;
serverPage.CurrentPageShowCounts = -1;
if (!Task_Func.GetOverViewExportListByPage(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,Task_ID,TaskStatus,PlantName,Remark,Reason,PostStatus,StartTime,EndTime,WarehouseCode,WarehouseID,ReceiveUserNo,OperatorUserNo,CreateUserNo,IsShelvePost,IsQuality,IsReceivePost,VoucherType,TaskType,StrTaskType,VoucherNo,Status,IsQualityComp,Unit,CompleteDateTime";
Dictionary <string, string> dicFields = new Dictionary <string, string>();
dicFields.Add("TaskNo", "任务单号");
dicFields.Add("DeliveryNo", "单据编号");
dicFields.Add("SupCusNo", "供应商代码");
dicFields.Add("SupCusName", "供应商名称");
dicFields.Add("TaskIssued", "任务下发时间");
dicFields.Add("ReceiveUserName", "收货人");
dicFields.Add("Plant", "工厂");
dicFields.Add("StrVoucherType", "入库类型");
dicFields.Add("StrTaskType", "任务类型");
dicFields.Add("StrIsQuality", "是否质检");
dicFields.Add("StrIsShelvePost", "是否上架过账");
dicFields.Add("StrIsReceivePost", "是否收货过账");
dicFields.Add("StrTaskStatus", "任务状态");
dicFields.Add("StrPostStatus", "过账状态");
dicFields.Add("MaterialDoc", "物料凭证");
dicFields.Add("WarehouseName", "仓库名称");
dicFields.Add("CreateUserName", "创建人");
dicFields.Add("CreateDateTime", "创建时间");
dicFields.Add("ToAreaNo", "入库货位");
dicFields.Add("RowNo", "行号");
dicFields.Add("VoucherNo", "订单号");
dicFields.Add("MaterialNo", "物料编号");
dicFields.Add("MaterialDesc", "物料描述");
dicFields.Add("TaskQty", "任务数量");
dicFields.Add("QualityQty", "质检数量");
dicFields.Add("RemainQty", "剩余数量");
dicFields.Add("ShelveQty", "已上架数量");
dicFields.Add("UnQualityQty", "不合格数量");
dicFields.Add("PostQty", "过账数量");
dicFields.Add("OperatorUserName", "操作人");
dicFields.Add("OperatorDateTime", "操作时间");
dicFields.Add("Unit", "计量单位");
dicFields.Add("StrStatus", "状态");
dicFields.Add("StrIsQualityComp", "是否质检完成");
dicFields.Add("CompleteDateTime", "完成时间");
ExcelLibrary.ExcelLibrary_Func.SaveListToExcelByNPOI(lstExport, true, excludecol, dicFields, dgvList.DefaultCellStyle.Font);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "导出失败");
return;
}
}
//public static bool PostOutSideByDeliveryAndPOToSAP(ref DeliveryReceive_Model DeliveryInfo, ref string strError)
//{
// return WMSWebService.service.PostOutSideByDeliveryAndPOToSAP(ref DeliveryInfo, Common_Var.CurrentUser, ref strError);
//}
public static bool GetOverViewExportListByPage(ref List <OverViewExportInfo> modelList, OverViewExportInfo model, ref DividPage page, ref string strError)
{
return(WMSWebService.service.GetOverViewExportListByPage(ref modelList, model, ref page, Common_Var.CurrentUser, ref strError));
}
