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