private void FillXlWorkSheet(Excel.Worksheet xlWorkSheet, int realRowIndex, DhlWaybillParam param) { var waybillSetting = this.waybillSettingFactory.Create(); xlWorkSheet.Cells[realRowIndex, ToIndex("A")] = realRowIndex - 6; xlWorkSheet.Cells[realRowIndex, ToIndex("B")] = waybillSetting.WanwanName; xlWorkSheet.Cells[realRowIndex, ToIndex("C")] = waybillSetting.WaybillEmail; xlWorkSheet.Cells[realRowIndex, ToIndex("D")] = waybillSetting.SenderName; xlWorkSheet.Cells[realRowIndex, ToIndex("E")] = waybillSetting.SenderStreet; xlWorkSheet.Cells[realRowIndex, ToIndex("F")] = waybillSetting.SenderHouseNumber; xlWorkSheet.Cells[realRowIndex, ToIndex("G")] = waybillSetting.SenderPostCode; xlWorkSheet.Cells[realRowIndex, ToIndex("H")] = waybillSetting.SenderCity; xlWorkSheet.Cells[realRowIndex, ToIndex("I")] = waybillSetting.SenderCountry; xlWorkSheet.Cells[realRowIndex, ToIndex("J")] = waybillSetting.SenderTel; xlWorkSheet.Cells[realRowIndex, ToIndex("M")] = "China"; xlWorkSheet.Cells[realRowIndex, ToIndex("U")] = "Private Present"; xlWorkSheet.Cells[realRowIndex, ToIndex("L")] = param.Recipient.Name.NameToPinyin(); xlWorkSheet.Cells[realRowIndex, ToIndex("O")] = param.Recipient.ProviceCity.ToPinyin(); xlWorkSheet.Cells[realRowIndex, ToIndex("N")] = param.Recipient.PostCode.Trim(); xlWorkSheet.Cells[realRowIndex, ToIndex("S")] = string.Format("0086-{0}", param.Recipient.MainTel).Trim(); xlWorkSheet.Cells[realRowIndex, ToIndex("V")] = param.Order.PacketWeight; xlWorkSheet.Cells[realRowIndex, ToIndex("W")] = 100; xlWorkSheet.Cells[realRowIndex, ToIndex("Y")] = param.Recipient.Name; xlWorkSheet.Cells[realRowIndex, ToIndex("Z")] = param.Recipient.ProviceCity; xlWorkSheet.Cells[realRowIndex, ToIndex("AA")] = param.Recipient.CnAddress ; xlWorkSheet.Cells[realRowIndex, ToIndex("AB")] = param.Recipient.PostCode; xlWorkSheet.Cells[realRowIndex, ToIndex("AC")] = param.Recipient.MainTel; }
private void FillXlWorkSheet(Excel.Worksheet xlWorkSheet, int realRowIndex, DhlWaybillParam param) { xlWorkSheet.Cells[realRowIndex, ToIndex("A")] = randomNameService.GetNextRandomName().NameToPinyin(); xlWorkSheet.Cells[realRowIndex, ToIndex("N")] = param.Recipient.Name.NameToPinyin(); xlWorkSheet.Cells[realRowIndex, ToIndex("Q")] = ToMax(GetShortPingYinAddress(param.Recipient.CnAddress),99); xlWorkSheet.Cells[realRowIndex, ToIndex("U")] = param.Recipient.PostCode;//邮编 xlWorkSheet.Cells[realRowIndex, ToIndex("V")] = ToMax(GetFormattedCity(param.Recipient.ProviceCity), 40);//城市 xlWorkSheet.Cells[realRowIndex, ToIndex("AA")] = param.Recipient.MainTel;//电话 xlWorkSheet.Cells[realRowIndex, ToIndex("AB")] = param.Order.PacketWeight; FillItemDetail(xlWorkSheet,realRowIndex, param.Order.Detail); }