//[Authorize(AuthenticationSchemes = JwtBearerDefaults.AuthenticationScheme)] //[HttpPost] public ShipmentDataResponse CreateShipments(List <ExcelDataObject> excelDataObjects, int workflowID) { //int i = 0; ShipmentDataResponse shipmentDataResponse = new ShipmentDataResponse(); try { List <ShipmentDataRequest> shipmentData = new List <ShipmentDataRequest>(); foreach (ExcelDataObject excelDataObject in excelDataObjects) { bool allPropertiesNull = !excelDataObject.GetType().GetProperties().Any(prop => prop == null); if (allPropertiesNull) { ShipmentDataRequest shipmentDataRequest = new ShipmentDataRequest(); if (!string.IsNullOrWhiteSpace(excelDataObject.S_shipmentno)) { shipmentDataRequest.BIL_TYP_TE = excelDataObject.S_billtype; shipmentDataRequest.CCY_VAL_TE = string.Empty; shipmentDataRequest.COD_TE = string.Empty; shipmentDataRequest.CSG_CTC_TE = excelDataObject.S_cneectc; decimal decimalvalue = 0; shipmentDataRequest.DIM_WGT_DE = 0; if (!string.IsNullOrEmpty(excelDataObject.S_dimwei)) { if (decimal.TryParse(excelDataObject.S_dimwei, out decimalvalue)) { shipmentDataRequest.DIM_WGT_DE = decimalvalue; } } //shipmentDataRequest.DIM_WGT_DE = null; //Convert.ToDecimal(excelDataObject.S_dimwei); shipmentDataRequest.DST_CTY_TE = excelDataObject.S_dstcity; shipmentDataRequest.DST_PSL_TE = excelDataObject.S_dstpsl; shipmentDataRequest.EXP_SLC_CD = excelDataObject.S_expslic; shipmentDataRequest.EXP_TYP = "顺丰即日";//excelDataObject.S_expslic; shipmentDataRequest.IMP_NR = excelDataObject.S_impr; shipmentDataRequest.IMP_SLC_TE = excelDataObject.S_impslic; shipmentDataRequest.IN_FLG_TE = excelDataObject.S_inflight; shipmentDataRequest.ORG_CTY_TE = excelDataObject.S_orgcity; string pststring = Convert.ToString(excelDataObject.S_orgpsl); if (InputValidations.IsDecimalFormat(pststring)) { shipmentDataRequest.ORG_PSL_CD = Decimal.ToInt32(Decimal.Parse(pststring)).ToString(); } else { shipmentDataRequest.ORG_PSL_CD = pststring; } // OU_FLG_TE = Convert.ToString(excelDataObject.S_outflight), int intvalue = 0; shipmentDataRequest.PCS_QTY_NR = 0; if (!string.IsNullOrEmpty(excelDataObject.pcs)) { if (int.TryParse(excelDataObject.pcs, out intvalue)) { shipmentDataRequest.PCS_QTY_NR = intvalue; } } //shipmentDataRequest.PCS_QTY_NR = null;//Convert.ToInt32(Convert.ToDouble(excelDataObject.pcs)); shipmentDataRequest.PH_NR = excelDataObject.S_ph; shipmentDataRequest.PKG_NR_TE = excelDataObject.S_packageno; shipmentDataRequest.PKG_WGT_DE = Convert.ToDecimal(excelDataObject.S_pkgwei); shipmentDataRequest.PK_UP_TM = null; //Convert.ToString(excelDataObject.S_pkuptime), shipmentDataRequest.PYM_MTD = "寄付月结"; //excelDataObject.pymt; shipmentDataRequest.RCV_ADR_TE = excelDataObject.S_address1; shipmentDataRequest.RCV_CPY_TE = excelDataObject.S_receivercompany; shipmentDataRequest.SHP_ADR_TE = excelDataObject.address; shipmentDataRequest.SHP_ADR_TR_TE = string.Empty; shipmentDataRequest.SHP_CPY_NA = excelDataObject.S_shippercompany; shipmentDataRequest.SHP_CTC_TE = excelDataObject.S_shptctc; DateTime dDate; int intdate; shipmentDataRequest.SHP_DT = null; if (!string.IsNullOrEmpty(excelDataObject.S_shipdate)) { if (int.TryParse(excelDataObject.S_shipdate, out intdate)) { shipmentDataRequest.SHP_DT = null; } else if (DateTime.TryParse(excelDataObject.S_shipdate, out dDate)) { shipmentDataRequest.SHP_DT = Convert.ToDateTime(excelDataObject.S_shipdate); } } //if(!string.IsNullOrEmpty(excelDataObject.S_shipdate)) //{ // if (DateTime.TryParse(excelDataObject.S_shipdate, out dDate)) // { // shipmentDataRequest.SHP_DT = Convert.ToDateTime(excelDataObject.S_shipdate); // } //} shipmentDataRequest.SHP_DT = null; //Convert.ToDateTime(excelDataObject.S_shipdate); shipmentDataRequest.SHP_NR = excelDataObject.S_shpr; shipmentDataRequest.SHP_PH_TE = excelDataObject.S_shptph; shipmentDataRequest.SMT_NR_TE = excelDataObject.S_shipmentno; shipmentDataRequest.SMT_STA_NR = 0; shipmentDataRequest.SMT_STA_TE = "Uploaded"; shipmentDataRequest.SMT_VAL_DE = 0; shipmentDataRequest.SMT_WGT_DE = Convert.ToDecimal(excelDataObject.S_shptwei); shipmentDataRequest.SVL_NR = Convert.ToString(excelDataObject.svl); shipmentDataRequest.WGT_UNT_TE = excelDataObject.S_weiunit; shipmentDataRequest.WFL_ID = workflowID; shipmentDataRequest.SF_TRA_LG_ID = null; shipmentDataRequest.QQS_TRA_LG_ID = null; shipmentDataRequest.FST_INV_LN_DES_TE = excelDataObject.S_1stinvoicelinedesc; shipmentDataRequest.POD_RTN_SVC = "0"; shipmentData.Add(shipmentDataRequest); } } } shipmentService = new ShipmentService(); shipmentDataResponse = shipmentService.CreateShipments(shipmentData); shipmentDataResponse.Success = true; return(shipmentDataResponse); } catch (Exception exception) { shipmentDataResponse.OperationExceptionMsg = exception.Message; shipmentDataResponse.Success = true; AuditEventEntry.WriteEntry(new Exception(exception.Message)); } return(shipmentDataResponse); }