using Microsoft.Office.Interop.Excel;
using seaSolveWork.basedata;
using seaSolveWork.model.healthproduct;
using seaSolveWork.model.milk;
using seaSolveWork.model.tianjin;
using System;
using System.Collections;
using System.Collections.Generic;
using System.Linq;
using System.Reflection;
using System.Text;
using System.Threading;
using System.Threading.Tasks;
using System.Windows.Forms;
namespace seaSolveWork.baseoperate
{
class ExportArrayList
{
/*
*/
public static Boolean produceHealthProductExportInfo (ArrayList importDataInfo, ArrayList sortInfo) {
if (importDataInfo == null || sortInfo == null) {
return false;
}
try
{
Microsoft.Office.Interop.Excel.Application returnExcel
= new Microsoft.Office.Interop.Excel.Application();
if (returnExcel == null) {
MessageBox.Show("无法创建Excel对象,可能你的机器没有安装Excel", "信息提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return false;
}
returnExcel.Workbooks.Add(true);
//创建两个工作薄
returnExcel.Sheets.Add(Missing.Value, Missing.Value, Missing.Value, Missing.Value);
returnExcel.Sheets.Add(Missing.Value, Missing.Value, Missing.Value, Missing.Value);
((Microsoft.Office.Interop.Excel.Worksheet)returnExcel.Sheets[1]).Name = "Orders";
((Microsoft.Office.Interop.Excel.Worksheet)returnExcel.Sheets[2]).Name = "Order Items";
ArrayList orderItemsArrayList = SortArrayList.getHealthProductOrderItemsExportInfo(importDataInfo);
int columnsOfOrdersHeads = ConstantData.columnsOfHealthProductExport;
String[] ordersHeadInfo = ConstantData.HEALTHPRODUCTEXPORT;
//添加表头信息
for (int i = 1; i <= columnsOfOrdersHeads; i++) {
returnExcel.Sheets[1].Cells[1, i] = ordersHeadInfo[i - 1];
}
//记录行数
int j = 2;
foreach (HealthProductExport objectExport in sortInfo) {
((Range)returnExcel.Sheets[1].Cells[j, 1]).Interior.Color = objectExport.UnitColor;
((Range)returnExcel.Sheets[1].Cells[j, 2]).Interior.Color = objectExport.UnitColor;
((Range)returnExcel.Sheets[1].Cells[j, 3]).Interior.Color = objectExport.UnitColor;
((Range)returnExcel.Sheets[1].Cells[j, 4]).Interior.Color = objectExport.UnitColor;
((Range)returnExcel.Sheets[1].Cells[j, 5]).Interior.Color = objectExport.UnitColor;
((Range)returnExcel.Sheets[1].Cells[j, 6]).Interior.Color = objectExport.UnitColor;
((Range)returnExcel.Sheets[1].Cells[j, 7]).Interior.Color = objectExport.UnitColor;
((Range)returnExcel.Sheets[1].Cells[j, 8]).Interior.Color = objectExport.UnitColor;
((Range)returnExcel.Sheets[1].Cells[j, 9]).Interior.Color = objectExport.UnitColor;
((Range)returnExcel.Sheets[1].Cells[j, 10]).Interior.Color = objectExport.UnitColor;
((Range)returnExcel.Sheets[1].Cells[j, 11]).Interior.Color = objectExport.UnitColor;
((Range)returnExcel.Sheets[1].Cells[j, 12]).Interior.Color = objectExport.UnitColor;
((Range)returnExcel.Sheets[1].Cells[j, 13]).Interior.Color = objectExport.UnitColor;
((Range)returnExcel.Sheets[1].Cells[j, 14]).Interior.Color = objectExport.UnitColor;
((Range)returnExcel.Sheets[1].Cells[j, 15]).Interior.Color = objectExport.UnitColor;
((Range)returnExcel.Sheets[1].Cells[j, 16]).Interior.Color = objectExport.UnitColor;
returnExcel.Sheets[1].Cells[j, 1] = "'"+objectExport.AssociateNum;
returnExcel.Sheets[1].Cells[j, 2] = objectExport.InternalTicketNum;
returnExcel.Sheets[1].Cells[j, 3] ="'"+ objectExport.PalletNum;
returnExcel.Sheets[1].Cells[j, 4] = objectExport.SenderName;
returnExcel.Sheets[1].Cells[j, 5] = objectExport.SenderAddress;
returnExcel.Sheets[1].Cells[j, 6] = "'" +objectExport.SenderPhoneNum;
returnExcel.Sheets[1].Cells[j, 7] = objectExport.ReceiverName;
returnExcel.Sheets[1].Cells[j, 8] ="'"+ objectExport.ReceiverIDCardNum;
returnExcel.Sheets[1].Cells[j, 9] ="'"+objectExport.ReceiverPhoneNum;
returnExcel.Sheets[1].Cells[j, 10] = objectExport.City;
returnExcel.Sheets[1].Cells[j, 11] = objectExport.Province;
returnExcel.Sheets[1].Cells[j, 12] = "'"+objectExport.PostCode;
returnExcel.Sheets[1].Cells[j, 13] = objectExport.ReceiverAddress;
returnExcel.Sheets[1].Cells[j, 14] = objectExport.PackageName;
returnExcel.Sheets[1].Cells[j, 15] = objectExport.PackageTotalWeight;
returnExcel.Sheets[1].Cells[j, 16] = objectExport.CountrySimName1;
Range titleRange = returnExcel.Sheets[1].Range[returnExcel.Sheets[1].Cells[j, 1], returnExcel.Sheets[1].Cells[j, 16]];
titleRange.Borders.LineStyle = Microsoft.Office.Interop.Excel.XlLineStyle.xlContinuous;//设置边框
titleRange.Borders.Weight = Microsoft.Office.Interop.Excel.XlBorderWeight.xlThin;//边框常规粗细
j++;
}
//获取order items工作薄的列数
int columnsOfOrderItemsHeads = ConstantData.columnsOfHealthProductAdditionExport;
String[] orderItemsHeadInfo = ConstantData.HEALTHPRODUCTADDITIONALEXPORT;
for (int i = 1; i <= columnsOfOrderItemsHeads; i++)
{
returnExcel.Sheets[2].Cells[1, i] = orderItemsHeadInfo[i - 1];
}
//记录行数
j = 2;
foreach (HealthProductItemsExport objectItemsExport in orderItemsArrayList)
{
((Range)returnExcel.Sheets[2].Cells[j, 1]).Interior.Color = objectItemsExport.UnitColor;
((Range)returnExcel.Sheets[2].Cells[j, 2]).Interior.Color = objectItemsExport.UnitColor;
((Range)returnExcel.Sheets[2].Cells[j, 3]).Interior.Color = objectItemsExport.UnitColor;
((Range)returnExcel.Sheets[2].Cells[j, 4]).Interior.Color = objectItemsExport.UnitColor;
((Range)returnExcel.Sheets[2].Cells[j, 5]).Interior.Color = objectItemsExport.UnitColor;
((Range)returnExcel.Sheets[2].Cells[j, 6]).Interior.Color = objectItemsExport.UnitColor;
((Range)returnExcel.Sheets[2].Cells[j, 7]).Interior.Color = objectItemsExport.UnitColor;
((Range)returnExcel.Sheets[2].Cells[j, 8]).Interior.Color = objectItemsExport.UnitColor;
((Range)returnExcel.Sheets[2].Cells[j, 9]).Interior.Color = objectItemsExport.UnitColor;
((Range)returnExcel.Sheets[2].Cells[j, 10]).Interior.Color = objectItemsExport.UnitColor;
((Range)returnExcel.Sheets[2].Cells[j, 11]).Interior.Color = objectItemsExport.UnitColor;
((Range)returnExcel.Sheets[2].Cells[j, 12]).Interior.Color = objectItemsExport.UnitColor;
((Range)returnExcel.Sheets[2].Cells[j, 13]).Interior.Color = objectItemsExport.UnitColor;
((Range)returnExcel.Sheets[2].Cells[j, 14]).Interior.Color = objectItemsExport.UnitColor;
((Range)returnExcel.Sheets[2].Cells[j, 15]).Interior.Color = objectItemsExport.UnitColor;
((Range)returnExcel.Sheets[2].Cells[j, 16]).Interior.Color = objectItemsExport.UnitColor;
Range titleRange = returnExcel.Sheets[2].Range[returnExcel.Sheets[2].Cells[j, 1], returnExcel.Sheets[2].Cells[j, 16]];
titleRange.Borders.LineStyle = Microsoft.Office.Interop.Excel.XlLineStyle.xlContinuous;//设置边框
titleRange.Borders.Weight = Microsoft.Office.Interop.Excel.XlBorderWeight.xlThin;//边框常规粗细
returnExcel.Sheets[2].Cells[j, 1] ="'"+ objectItemsExport.AssociateNum;
returnExcel.Sheets[2].Cells[j, 2] = "'"+objectItemsExport.GoodsNum;
returnExcel.Sheets[2].Cells[j, 3] = objectItemsExport.GoodsName;
returnExcel.Sheets[2].Cells[j, 4] = objectItemsExport.GoodsSimName;
returnExcel.Sheets[2].Cells[j, 5] = objectItemsExport.RegularType;
returnExcel.Sheets[2].Cells[j, 6] = objectItemsExport.BrandType;
returnExcel.Sheets[2].Cells[j, 7] = objectItemsExport.GoodsCount;
returnExcel.Sheets[2].Cells[j, 8] ="'"+ objectItemsExport.GoodsUnit;
returnExcel.Sheets[2].Cells[j, 9] ="'"+ objectItemsExport.GoodsEachPrice;
returnExcel.Sheets[2].Cells[j, 10] = objectItemsExport.TypeOfMoney;
returnExcel.Sheets[2].Cells[j, 11] ="'"+ objectItemsExport.GoodsTotalWeight;
returnExcel.Sheets[2].Cells[j, 12] = "'"+objectItemsExport.ParcelNum;
returnExcel.Sheets[2].Cells[j, 13] = "'" + objectItemsExport.GoodsTotalValue;
returnExcel.Sheets[2].Cells[j, 14] = "'"+objectItemsExport.ParcelNumSecond;
returnExcel.Sheets[2].Cells[j, 15] = "'" + objectItemsExport.GoodsTaxRate;
returnExcel.Sheets[2].Cells[j, 16] = "'" + objectItemsExport.GoodsTax;
j++;
}
returnExcel.Visible = true;
//returnExcel;
Worksheet sheet = new Worksheet();
sheet = (Worksheet)returnExcel.Sheets[1];
sheet = (Worksheet)returnExcel.Sheets[2];
sheet.SaveAs("C:/保健品.xls",
Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value);
returnExcel.Quit();
ConstantData.releaseResource(sheet);
ConstantData.releaseResource(returnExcel);
}
catch (Exception e) {
Console.WriteLine(e.ToString());
}
return true;
}
/*
奶粉
*/
public static Boolean produceChengDuMilkExcelInfo(ArrayList importDataInfo, ArrayList sortInfo) {
if (importDataInfo == null || sortInfo == null)
{
return false;
}
try
{
Microsoft.Office.Interop.Excel.Application returnExcel
= new Microsoft.Office.Interop.Excel.Application();
if (returnExcel == null)
{
MessageBox.Show("无法创建Excel对象,可能你的机器没有安装Excel", "信息提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return false;
}
returnExcel.Workbooks.Add(true);
//创建两个工作薄
returnExcel.Sheets.Add(Missing.Value, Missing.Value, Missing.Value, Missing.Value);
// ((Microsoft.Office.Interop.Excel.Worksheet)returnExcel.Sheets[1]).Name = "Sheet1";
//头信息
String[] MilkHeadInfo = ConstantData.CHENGDUMILKEXPORT;
int cloumnsOfHead = ConstantData.columnsOfChengDuMilkExport;
//添加表头信息
for (int i = 1; i <= cloumnsOfHead; i++)
{
returnExcel.Sheets[1].Cells[1, i] = MilkHeadInfo[i - 1];
}
((Range)returnExcel.Sheets[1].Cells[1, 26]).Interior.Color = ConstantData.COLOR_PLANE_GREEN;
//记录行数
int j = 2;
foreach (ChengDuMilkExport objectExport in sortInfo) {
((Range)returnExcel.Sheets[1].Cells[j, 1]).Interior.Color = objectExport.UnitColor1;
((Range)returnExcel.Sheets[1].Cells[j, 2]).Interior.Color = objectExport.UnitColor1;
((Range)returnExcel.Sheets[1].Cells[j, 3]).Interior.Color = objectExport.UnitColor1;
((Range)returnExcel.Sheets[1].Cells[j, 4]).Interior.Color = objectExport.UnitColor1;
((Range)returnExcel.Sheets[1].Cells[j, 5]).Interior.Color = objectExport.UnitColor1;
((Range)returnExcel.Sheets[1].Cells[j, 6]).Interior.Color = objectExport.UnitColor1;
((Range)returnExcel.Sheets[1].Cells[j, 7]).Interior.Color = objectExport.UnitColor1;
((Range)returnExcel.Sheets[1].Cells[j, 8]).Interior.Color = objectExport.UnitColor1;
((Range)returnExcel.Sheets[1].Cells[j, 9]).Interior.Color = objectExport.UnitColor1;
((Range)returnExcel.Sheets[1].Cells[j, 10]).Interior.Color = objectExport.UnitColor1;
((Range)returnExcel.Sheets[1].Cells[j, 11]).Interior.Color = objectExport.UnitColor1;
((Range)returnExcel.Sheets[1].Cells[j, 12]).Interior.Color = objectExport.UnitColor1;
((Range)returnExcel.Sheets[1].Cells[j, 13]).Interior.Color = objectExport.UnitColor1;
((Range)returnExcel.Sheets[1].Cells[j, 14]).Interior.Color = objectExport.UnitColor1;
((Range)returnExcel.Sheets[1].Cells[j, 15]).Interior.Color = objectExport.UnitColor1;
((Range)returnExcel.Sheets[1].Cells[j, 16]).Interior.Color = objectExport.UnitColor1;
((Range)returnExcel.Sheets[1].Cells[j, 17]).Interior.Color = objectExport.UnitColor1;
((Range)returnExcel.Sheets[1].Cells[j, 18]).Interior.Color = objectExport.UnitColor1;
((Range)returnExcel.Sheets[1].Cells[j, 19]).Interior.Color = objectExport.UnitColor1;
((Range)returnExcel.Sheets[1].Cells[j, 20]).Interior.Color = objectExport.UnitColor1;
((Range)returnExcel.Sheets[1].Cells[j, 21]).Interior.Color = objectExport.UnitColor1;
((Range)returnExcel.Sheets[1].Cells[j, 22]).Interior.Color = objectExport.UnitColor1;
((Range)returnExcel.Sheets[1].Cells[j, 23]).Interior.Color = objectExport.UnitColor1;
((Range)returnExcel.Sheets[1].Cells[j, 24]).Interior.Color = objectExport.UnitColor1;
((Range)returnExcel.Sheets[1].Cells[j, 25]).Interior.Color = objectExport.UnitColor1;
Range titleRange = returnExcel.Sheets[1].Range[returnExcel.Sheets[1].Cells[j, 1], returnExcel.Sheets[1].Cells[j, 26]];
titleRange.Borders.LineStyle = Microsoft.Office.Interop.Excel.XlLineStyle.xlContinuous;//设置边框
titleRange.Borders.Weight = Microsoft.Office.Interop.Excel.XlBorderWeight.xlThin;//边框常规粗细
returnExcel.Sheets[1].Cells[j, 1] = "'"+objectExport.InfoID;
returnExcel.Sheets[1].Cells[j, 2] = objectExport.AirMainNum;
returnExcel.Sheets[1].Cells[j, 3] = objectExport.PartUnitNum;
returnExcel.Sheets[1].Cells[j, 4] ="'"+ objectExport.CustomerRemindNum;
returnExcel.Sheets[1].Cells[j, 5] = objectExport.SenderName;
returnExcel.Sheets[1].Cells[j, 6] = "'" + objectExport.SenderPhoneNum;
returnExcel.Sheets[1].Cells[j, 7] = objectExport.SenderAddress;
returnExcel.Sheets[1].Cells[j, 8] = objectExport.SenderCountry;
returnExcel.Sheets[1].Cells[j, 9] = objectExport.ReceiverName;
returnExcel.Sheets[1].Cells[j, 10] = "'" + objectExport.ReceiverPhoneNum;
returnExcel.Sheets[1].Cells[j, 11] = "'" + objectExport.ReceiverIDCardNum;
returnExcel.Sheets[1].Cells[j, 12] = objectExport.ReceiverAddress;
returnExcel.Sheets[1].Cells[j, 13] = objectExport.ReceiverProvince;
returnExcel.Sheets[1].Cells[j, 14] = "'"+objectExport.PackageNum;
returnExcel.Sheets[1].Cells[j, 15] = "'"+objectExport.PackageWeight;
returnExcel.Sheets[1].Cells[j, 16] = objectExport.PackagePrice;
returnExcel.Sheets[1].Cells[j, 17] = objectExport.InternalNum;
returnExcel.Sheets[1].Cells[j, 18] = objectExport.InternalThingName;
returnExcel.Sheets[1].Cells[j, 19] = objectExport.RegularNum;
returnExcel.Sheets[1].Cells[j, 20] = "'"+objectExport.InternalThingParcelNum;
returnExcel.Sheets[1].Cells[j, 21] = "'"+objectExport.InternalThingNum;
returnExcel.Sheets[1].Cells[j, 22] = objectExport.InternalUnit;
returnExcel.Sheets[1].Cells[j, 23] ="'"+ objectExport.InternalUnitPrice;
returnExcel.Sheets[1].Cells[j, 24] = objectExport.InternalTotalPrice;
returnExcel.Sheets[1].Cells[j, 25] = objectExport.NoteInfo;
returnExcel.Sheets[1].Cells[j, 26] ="'"+ objectExport.AddationalPostCode;
((Range)returnExcel.Sheets[1].Cells[j, 26]).Interior.Color = ConstantData.COLOR_PLANE_GREEN;
j++;
}
returnExcel.Visible = true;
//returnExcel;
Worksheet sheet = new Worksheet();
sheet = (Worksheet)returnExcel.Sheets[1];
sheet.SaveAs("C:/成都奶粉草稿表导出.xls",
Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value);
returnExcel.Quit();
ConstantData.releaseResource(sheet);
ConstantData.releaseResource(returnExcel);
}
catch (Exception e)
{
Console.WriteLine(e.ToString());
}
return true;
}
/*
圆通奶粉的Excel导出
*/
/*
江门奶粉草稿表导出 ,申报清单导出,打单模板导出
*/
public static Boolean produceJiangMenMilkExportInfo(ArrayList importDataInfo, ArrayList sortInfo) {
if (importDataInfo == null || sortInfo == null)
{
return false;
}
else {
try
{
Microsoft.Office.Interop.Excel.Application returnExcel
= new Microsoft.Office.Interop.Excel.Application();
if (returnExcel == null)
{
MessageBox.Show("无法创建Excel对象,可能你的机器没有安装Excel", "信息提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return false;
}
returnExcel.Workbooks.Add(true);
//创建两个工作薄
returnExcel.Sheets.Add(Missing.Value, Missing.Value, Missing.Value, Missing.Value);
returnExcel.Sheets.Add(Missing.Value, Missing.Value, Missing.Value, Missing.Value);
((Microsoft.Office.Interop.Excel.Worksheet)returnExcel.Sheets[1]).Name = "Orders";
((Microsoft.Office.Interop.Excel.Worksheet)returnExcel.Sheets[2]).Name = "Order Items";
ArrayList orderItemsArrayList = null;
//获得orders工作区间的列数
ThreadStart threadStart = new ThreadStart(delegate ()
{
orderItemsArrayList = SortArrayList.getJiangMenOrderItemsExportInfo(importDataInfo);
});
Thread thread1 = new Thread(threadStart);
thread1.Start();//多线程启动匿名方法
thread1.Join();
int columnsOfOrdersHeads = ConstantData.columnsOfJiangMenMilkOrdersCraftExport;
String[] ordersHeadInfo = ConstantData.JIANGMENGEXPORTORDERSCRAFT;
//添加表头信息
for (int i = 1; i <= columnsOfOrdersHeads; i++)
{
returnExcel.Sheets[1].Cells[1, i] = ordersHeadInfo[i - 1];
}
//记录行数
int j = 2;
//添加orders的信息
foreach (JiangMenCraftExport objectExport in sortInfo)
{
((Range)returnExcel.Sheets[1].Cells[j, 1]).Interior.Color = objectExport.UnitColor;
((Range)returnExcel.Sheets[1].Cells[j, 2]).Interior.Color = objectExport.UnitColor;
((Range)returnExcel.Sheets[1].Cells[j, 3]).Interior.Color = objectExport.UnitColor;
((Range)returnExcel.Sheets[1].Cells[j, 4]).Interior.Color = objectExport.UnitColor;
((Range)returnExcel.Sheets[1].Cells[j, 5]).Interior.Color = objectExport.UnitColor;
((Range)returnExcel.Sheets[1].Cells[j, 6]).Interior.Color = objectExport.UnitColor;
((Range)returnExcel.Sheets[1].Cells[j, 7]).Interior.Color = objectExport.UnitColor;
((Range)returnExcel.Sheets[1].Cells[j, 8]).Interior.Color = objectExport.UnitColor;
((Range)returnExcel.Sheets[1].Cells[j, 9]).Interior.Color = objectExport.UnitColor;
((Range)returnExcel.Sheets[1].Cells[j, 10]).Interior.Color = objectExport.UnitColor;
((Range)returnExcel.Sheets[1].Cells[j, 11]).Interior.Color = objectExport.UnitColor;
((Range)returnExcel.Sheets[1].Cells[j, 12]).Interior.Color = objectExport.UnitColor;
((Range)returnExcel.Sheets[1].Cells[j, 13]).Interior.Color = objectExport.UnitColor;
((Range)returnExcel.Sheets[1].Cells[j, 14]).Interior.Color = objectExport.UnitColor;
((Range)returnExcel.Sheets[1].Cells[j, 15]).Interior.Color = objectExport.UnitColor;
((Range)returnExcel.Sheets[1].Cells[j, 16]).Interior.Color = objectExport.UnitColor;
returnExcel.Sheets[1].Cells[j, 1] ="'"+ objectExport.AssociateNum;
returnExcel.Sheets[1].Cells[j, 2] = objectExport.InternalTicketNum;
returnExcel.Sheets[1].Cells[j, 3] = objectExport.PalletNum;
returnExcel.Sheets[1].Cells[j, 4] = objectExport.SenderName;
returnExcel.Sheets[1].Cells[j, 5] = objectExport.SenderAddress;
returnExcel.Sheets[1].Cells[j, 6] = "'"+objectExport.SenderPhoneNum;
returnExcel.Sheets[1].Cells[j, 7] = objectExport.ReceiverName;
returnExcel.Sheets[1].Cells[j, 8] = "'"+objectExport.ReceiverIDCardNum;
returnExcel.Sheets[1].Cells[j, 9] = "'" + objectExport.ReceiverPhoneNum;
returnExcel.Sheets[1].Cells[j, 10] = "'" + objectExport.ReceiverCity;
returnExcel.Sheets[1].Cells[j, 11] = objectExport.ReceiverProvince;
returnExcel.Sheets[1].Cells[j, 12] ="'"+ objectExport.AddationalPostCode;
returnExcel.Sheets[1].Cells[j, 13] = objectExport.ReceiverAddress;
returnExcel.Sheets[1].Cells[j, 14] = objectExport.PackageName;
returnExcel.Sheets[1].Cells[j, 15] ="'" +objectExport.PackageWeight;
returnExcel.Sheets[1].Cells[j, 16] = objectExport.CountrySimName;
Range titleRange = returnExcel.Sheets[1].Range[returnExcel.Sheets[1].Cells[j, 1], returnExcel.Sheets[1].Cells[j, 16]];
titleRange.Borders.LineStyle = Microsoft.Office.Interop.Excel.XlLineStyle.xlContinuous;//设置边框
titleRange.Borders.Weight = Microsoft.Office.Interop.Excel.XlBorderWeight.xlThin;//边框常规粗细
j++;
}
//获取order items工作薄的列数
int columnsOfOrderItemsHeads = ConstantData.columnsOfJiangMenMilkOrderItemsExport;
String[] orderItemsHeadInfo = ConstantData.JIANGMENEXPORTORDERITEMS;
for (int i = 1; i <= columnsOfOrderItemsHeads; i++)
{
returnExcel.Sheets[2].Cells[1, i] = orderItemsHeadInfo[i - 1];
}
//记录行数
j = 2;
foreach (JiangMenAdditionalExport objectItemsExport in orderItemsArrayList)
{
((Range)returnExcel.Sheets[2].Cells[j, 1]).Interior.Color = objectItemsExport.UnitColor;
((Range)returnExcel.Sheets[2].Cells[j, 2]).Interior.Color = objectItemsExport.UnitColor;
((Range)returnExcel.Sheets[2].Cells[j, 3]).Interior.Color = objectItemsExport.UnitColor;
((Range)returnExcel.Sheets[2].Cells[j, 4]).Interior.Color = objectItemsExport.UnitColor;
((Range)returnExcel.Sheets[2].Cells[j, 5]).Interior.Color = objectItemsExport.UnitColor;
((Range)returnExcel.Sheets[2].Cells[j, 6]).Interior.Color = objectItemsExport.UnitColor;
((Range)returnExcel.Sheets[2].Cells[j, 7]).Interior.Color = objectItemsExport.UnitColor;
((Range)returnExcel.Sheets[2].Cells[j, 8]).Interior.Color = objectItemsExport.UnitColor;
((Range)returnExcel.Sheets[2].Cells[j, 9]).Interior.Color = objectItemsExport.UnitColor;
((Range)returnExcel.Sheets[2].Cells[j, 10]).Interior.Color = objectItemsExport.UnitColor;
((Range)returnExcel.Sheets[2].Cells[j, 11]).Interior.Color = objectItemsExport.UnitColor;
((Range)returnExcel.Sheets[2].Cells[j, 12]).Interior.Color = objectItemsExport.UnitColor;
((Range)returnExcel.Sheets[2].Cells[j, 13]).Interior.Color = objectItemsExport.UnitColor;
((Range)returnExcel.Sheets[2].Cells[j, 14]).Interior.Color = objectItemsExport.UnitColor;
((Range)returnExcel.Sheets[2].Cells[j, 15]).Interior.Color = objectItemsExport.UnitColor;
((Range)returnExcel.Sheets[2].Cells[j, 16]).Interior.Color = objectItemsExport.UnitColor;
Range titleRange = returnExcel.Sheets[2].Range[returnExcel.Sheets[2].Cells[j, 1], returnExcel.Sheets[2].Cells[j, 16]];
titleRange.Borders.LineStyle = Microsoft.Office.Interop.Excel.XlLineStyle.xlContinuous;//设置边框
titleRange.Borders.Weight = Microsoft.Office.Interop.Excel.XlBorderWeight.xlThin;//边框常规粗细
returnExcel.Sheets[2].Cells[j, 1] = "'" + objectItemsExport.AssociateNum;
returnExcel.Sheets[2].Cells[j, 2] = "'" + objectItemsExport.GoodsNum;
returnExcel.Sheets[2].Cells[j, 3] = objectItemsExport.GoodsName;
returnExcel.Sheets[2].Cells[j, 4] = objectItemsExport.GoodsSimName;
returnExcel.Sheets[2].Cells[j, 5] = objectItemsExport.RegularType;
returnExcel.Sheets[2].Cells[j, 6] = objectItemsExport.BrandType;
returnExcel.Sheets[2].Cells[j, 7] = objectItemsExport.GoodsCount;
returnExcel.Sheets[2].Cells[j, 8] = "'" + objectItemsExport.GoodsUnit;
returnExcel.Sheets[2].Cells[j, 9] = "'" + objectItemsExport.GoodsEachPrice;
returnExcel.Sheets[2].Cells[j, 10] = objectItemsExport.TypeOfMoney;
returnExcel.Sheets[2].Cells[j, 11] = "'" + objectItemsExport.GoodsTotalWeight;
returnExcel.Sheets[2].Cells[j, 12] = "'" + objectItemsExport.ParcelNum;
returnExcel.Sheets[2].Cells[j, 13] = "'" + objectItemsExport.GoodsTotalValue;
returnExcel.Sheets[2].Cells[j, 14] = "'" + objectItemsExport.ParcelNumSecond;
returnExcel.Sheets[2].Cells[j, 15] = "'" + objectItemsExport.GoodsTaxRate;
returnExcel.Sheets[2].Cells[j, 16] = "'" + objectItemsExport.GoodsTax;
j++;
}
returnExcel.Visible = true;
//returnExcel;
Worksheet sheet = new Worksheet();
sheet = (Worksheet)returnExcel.Sheets[1];
sheet = (Worksheet)returnExcel.Sheets[2];
sheet.SaveAs("C:/奶粉.xls",
Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value);
returnExcel.Quit();
ConstantData.releaseResource(sheet);
ConstantData.releaseResource(returnExcel);
}
catch (Exception e)
{
Console.WriteLine(e.ToString());
}
return true;
}
}
public static Boolean produceTianJinCraftExportInfo(ArrayList importDataInfo, ArrayList sortInfo) {
if (importDataInfo == null || sortInfo == null)
{
return false;
}
else {
try
{
Microsoft.Office.Interop.Excel.Application returnExcel
= new Microsoft.Office.Interop.Excel.Application();
if (returnExcel == null)
{
MessageBox.Show("无法创建Excel对象,可能你的机器没有安装Excel", "信息提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return false;
}
returnExcel.Workbooks.Add(true);
//创建两个工作薄
returnExcel.Sheets.Add(Missing.Value, Missing.Value, Missing.Value, Missing.Value);
returnExcel.Sheets.Add(Missing.Value, Missing.Value, Missing.Value, Missing.Value);
((Microsoft.Office.Interop.Excel.Worksheet)returnExcel.Sheets[1]).Name = "Orders";
((Microsoft.Office.Interop.Excel.Worksheet)returnExcel.Sheets[2]).Name = "Order Items";
ArrayList orderItemsArrayList = null;
//获得orders工作区间的列数
orderItemsArrayList = SortArrayList.getTianJinCraftOrderItemsInfo(importDataInfo);
int columnsOfOrdersHeads = ConstantData.columnsOfTianJinMilkOrdersCraftExport;
String[] ordersHeadInfo = ConstantData.TIANJINEXPORTORDERSCRAFT;
//添加表头信息
for (int i = 1; i <= columnsOfOrdersHeads; i++)
{
returnExcel.Sheets[1].Cells[1, i] = ordersHeadInfo[i - 1];
}
//记录行数
int j = 2;
//添加orders的信息
foreach (TianJinCraftModel objectExport in sortInfo)
{
((Range)returnExcel.Sheets[1].Cells[j, 1]).Interior.Color = objectExport.UnitColor;
((Range)returnExcel.Sheets[1].Cells[j, 2]).Interior.Color = objectExport.UnitColor;
((Range)returnExcel.Sheets[1].Cells[j, 3]).Interior.Color = objectExport.UnitColor;
((Range)returnExcel.Sheets[1].Cells[j, 4]).Interior.Color = objectExport.UnitColor;
((Range)returnExcel.Sheets[1].Cells[j, 5]).Interior.Color = objectExport.UnitColor;
((Range)returnExcel.Sheets[1].Cells[j, 6]).Interior.Color = objectExport.UnitColor;
((Range)returnExcel.Sheets[1].Cells[j, 7]).Interior.Color = objectExport.UnitColor;
((Range)returnExcel.Sheets[1].Cells[j, 8]).Interior.Color = objectExport.UnitColor;
((Range)returnExcel.Sheets[1].Cells[j, 9]).Interior.Color = objectExport.UnitColor;
((Range)returnExcel.Sheets[1].Cells[j, 10]).Interior.Color = objectExport.UnitColor;
((Range)returnExcel.Sheets[1].Cells[j, 11]).Interior.Color = objectExport.UnitColor;
((Range)returnExcel.Sheets[1].Cells[j, 12]).Interior.Color = objectExport.UnitColor;
((Range)returnExcel.Sheets[1].Cells[j, 13]).Interior.Color = objectExport.UnitColor;
((Range)returnExcel.Sheets[1].Cells[j, 14]).Interior.Color = objectExport.UnitColor;
((Range)returnExcel.Sheets[1].Cells[j, 15]).Interior.Color = objectExport.UnitColor;
((Range)returnExcel.Sheets[1].Cells[j, 16]).Interior.Color = objectExport.UnitColor;
returnExcel.Sheets[1].Cells[j, 1] = "'" + objectExport.AssociateNum;
returnExcel.Sheets[1].Cells[j, 2] = objectExport.InternalTicketNum;
returnExcel.Sheets[1].Cells[j, 3] = objectExport.PalletNum;
returnExcel.Sheets[1].Cells[j, 4] = objectExport.SenderName;
returnExcel.Sheets[1].Cells[j, 5] = objectExport.SenderAddress;
returnExcel.Sheets[1].Cells[j, 6] = "'" + objectExport.SenderPhoneNum;
returnExcel.Sheets[1].Cells[j, 7] = objectExport.ReceiverName;
returnExcel.Sheets[1].Cells[j, 8] = "'" + objectExport.ReceiverIDCardNum;
returnExcel.Sheets[1].Cells[j, 9] = "'" + objectExport.ReceiverPhoneNum;
returnExcel.Sheets[1].Cells[j, 10] = objectExport.ReceiverCity;
returnExcel.Sheets[1].Cells[j, 11] = objectExport.ReceiverProvince;
returnExcel.Sheets[1].Cells[j, 12] = "'"+objectExport.AddationalPostCode;
returnExcel.Sheets[1].Cells[j, 13] = objectExport.ReceiverAddress;
returnExcel.Sheets[1].Cells[j, 14] = "'" + objectExport.PackageName;
returnExcel.Sheets[1].Cells[j, 15] ="'"+ objectExport.PackageWeight;
returnExcel.Sheets[1].Cells[j, 16] = objectExport.CountrySimName;
Range titleRange = returnExcel.Sheets[1].Range[returnExcel.Sheets[1].Cells[j, 1], returnExcel.Sheets[1].Cells[j, 16]];
titleRange.Borders.LineStyle = Microsoft.Office.Interop.Excel.XlLineStyle.xlContinuous;//设置边框
titleRange.Borders.Weight = Microsoft.Office.Interop.Excel.XlBorderWeight.xlThin;//边框常规粗细
j++;
}
//获取order items工作薄的列数
int columnsOfOrderItemsHeads = ConstantData.columnsOfTianJinMilkOrderItemsExport;
String[] orderItemsHeadInfo = ConstantData.TIANJINEXPORTORDERITEMS;
for (int i = 1; i <= columnsOfOrderItemsHeads; i++)
{
returnExcel.Sheets[2].Cells[1, i] = orderItemsHeadInfo[i - 1];
}
//记录行数
j = 2;
foreach (TianJinOrderItemModel objectItemsExport in orderItemsArrayList)
{
((Range)returnExcel.Sheets[2].Cells[j, 1]).Interior.Color = objectItemsExport.UnitColor;
((Range)returnExcel.Sheets[2].Cells[j, 2]).Interior.Color = objectItemsExport.UnitColor;
((Range)returnExcel.Sheets[2].Cells[j, 3]).Interior.Color = objectItemsExport.UnitColor;
((Range)returnExcel.Sheets[2].Cells[j, 4]).Interior.Color = objectItemsExport.UnitColor;
((Range)returnExcel.Sheets[2].Cells[j, 5]).Interior.Color = objectItemsExport.UnitColor;
((Range)returnExcel.Sheets[2].Cells[j, 6]).Interior.Color = objectItemsExport.UnitColor;
((Range)returnExcel.Sheets[2].Cells[j, 7]).Interior.Color = objectItemsExport.UnitColor;
((Range)returnExcel.Sheets[2].Cells[j, 8]).Interior.Color = objectItemsExport.UnitColor;
((Range)returnExcel.Sheets[2].Cells[j, 9]).Interior.Color = objectItemsExport.UnitColor;
((Range)returnExcel.Sheets[2].Cells[j, 10]).Interior.Color = objectItemsExport.UnitColor;
((Range)returnExcel.Sheets[2].Cells[j, 11]).Interior.Color = objectItemsExport.UnitColor;
((Range)returnExcel.Sheets[2].Cells[j, 12]).Interior.Color = objectItemsExport.UnitColor;
((Range)returnExcel.Sheets[2].Cells[j, 13]).Interior.Color = objectItemsExport.UnitColor;
((Range)returnExcel.Sheets[2].Cells[j, 14]).Interior.Color = objectItemsExport.UnitColor;
((Range)returnExcel.Sheets[2].Cells[j, 15]).Interior.Color = objectItemsExport.UnitColor;
((Range)returnExcel.Sheets[2].Cells[j, 16]).Interior.Color = objectItemsExport.UnitColor;
Range titleRange = returnExcel.Sheets[2].Range[returnExcel.Sheets[2].Cells[j, 1], returnExcel.Sheets[2].Cells[j, 16]];
titleRange.Borders.LineStyle = Microsoft.Office.Interop.Excel.XlLineStyle.xlContinuous;//设置边框
titleRange.Borders.Weight = Microsoft.Office.Interop.Excel.XlBorderWeight.xlThin;//边框常规粗细
returnExcel.Sheets[2].Cells[j, 1] = "'" + objectItemsExport.AssociateNum;
returnExcel.Sheets[2].Cells[j, 2] = "'" + objectItemsExport.GoodsNum;
returnExcel.Sheets[2].Cells[j, 3] = objectItemsExport.GoodsName;
returnExcel.Sheets[2].Cells[j, 4] = objectItemsExport.GoodsSimName;
returnExcel.Sheets[2].Cells[j, 5] = objectItemsExport.RegularType;
returnExcel.Sheets[2].Cells[j, 6] = objectItemsExport.BrandType;
returnExcel.Sheets[2].Cells[j, 7] = objectItemsExport.GoodsCount;
returnExcel.Sheets[2].Cells[j, 8] = "'" + objectItemsExport.GoodsUnit;
returnExcel.Sheets[2].Cells[j, 9] = "'" + objectItemsExport.GoodsEachPrice;
returnExcel.Sheets[2].Cells[j, 10] = objectItemsExport.TypeOfMoney;
returnExcel.Sheets[2].Cells[j, 11] = "'" + objectItemsExport.GoodsTotalWeight;
returnExcel.Sheets[2].Cells[j, 12] = "'" + objectItemsExport.ParcelNum;
returnExcel.Sheets[2].Cells[j, 13] = "'" + objectItemsExport.GoodsTotalValue;
returnExcel.Sheets[2].Cells[j, 14] = "'" + objectItemsExport.ParcelNumSecond;
returnExcel.Sheets[2].Cells[j, 15] = "'" + objectItemsExport.GoodsTaxRate;
returnExcel.Sheets[2].Cells[j, 16] = "'" + objectItemsExport.GoodsTax;
j++;
}
returnExcel.Visible = true;
//returnExcel;
Worksheet sheet = new Worksheet();
sheet = (Worksheet)returnExcel.Sheets[1];
sheet = (Worksheet)returnExcel.Sheets[2];
sheet.SaveAs("C:/天津草稿模板.xls",
Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value);
returnExcel.Quit();
ConstantData.releaseResource(sheet);
ConstantData.releaseResource(returnExcel);
}
catch (Exception e)
{
Console.WriteLine(e.ToString());
}
return true;
}
}
}
}
using seaSolveWork.basedata;
using seaSolveWork.model.healthproduct;
using seaSolveWork.model.milk;
using seaSolveWork.model.tianjin;
using System;
using System.Collections;
using System.Collections.Generic;
using System.Linq;
using System.Reflection;
using System.Text;
using System.Threading;
using System.Threading.Tasks;
using System.Windows.Forms;
namespace seaSolveWork.baseoperate
{
class ExportArrayList
{
/*
*/
public static Boolean produceHealthProductExportInfo (ArrayList importDataInfo, ArrayList sortInfo) {
if (importDataInfo == null || sortInfo == null) {
return false;
}
try
{
Microsoft.Office.Interop.Excel.Application returnExcel
= new Microsoft.Office.Interop.Excel.Application();
if (returnExcel == null) {
MessageBox.Show("无法创建Excel对象,可能你的机器没有安装Excel", "信息提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return false;
}
returnExcel.Workbooks.Add(true);
//创建两个工作薄
returnExcel.Sheets.Add(Missing.Value, Missing.Value, Missing.Value, Missing.Value);
returnExcel.Sheets.Add(Missing.Value, Missing.Value, Missing.Value, Missing.Value);
((Microsoft.Office.Interop.Excel.Worksheet)returnExcel.Sheets[1]).Name = "Orders";
((Microsoft.Office.Interop.Excel.Worksheet)returnExcel.Sheets[2]).Name = "Order Items";
ArrayList orderItemsArrayList = SortArrayList.getHealthProductOrderItemsExportInfo(importDataInfo);
int columnsOfOrdersHeads = ConstantData.columnsOfHealthProductExport;
String[] ordersHeadInfo = ConstantData.HEALTHPRODUCTEXPORT;
//添加表头信息
for (int i = 1; i <= columnsOfOrdersHeads; i++) {
returnExcel.Sheets[1].Cells[1, i] = ordersHeadInfo[i - 1];
}
//记录行数
int j = 2;
foreach (HealthProductExport objectExport in sortInfo) {
((Range)returnExcel.Sheets[1].Cells[j, 1]).Interior.Color = objectExport.UnitColor;
((Range)returnExcel.Sheets[1].Cells[j, 2]).Interior.Color = objectExport.UnitColor;
((Range)returnExcel.Sheets[1].Cells[j, 3]).Interior.Color = objectExport.UnitColor;
((Range)returnExcel.Sheets[1].Cells[j, 4]).Interior.Color = objectExport.UnitColor;
((Range)returnExcel.Sheets[1].Cells[j, 5]).Interior.Color = objectExport.UnitColor;
((Range)returnExcel.Sheets[1].Cells[j, 6]).Interior.Color = objectExport.UnitColor;
((Range)returnExcel.Sheets[1].Cells[j, 7]).Interior.Color = objectExport.UnitColor;
((Range)returnExcel.Sheets[1].Cells[j, 8]).Interior.Color = objectExport.UnitColor;
((Range)returnExcel.Sheets[1].Cells[j, 9]).Interior.Color = objectExport.UnitColor;
((Range)returnExcel.Sheets[1].Cells[j, 10]).Interior.Color = objectExport.UnitColor;
((Range)returnExcel.Sheets[1].Cells[j, 11]).Interior.Color = objectExport.UnitColor;
((Range)returnExcel.Sheets[1].Cells[j, 12]).Interior.Color = objectExport.UnitColor;
((Range)returnExcel.Sheets[1].Cells[j, 13]).Interior.Color = objectExport.UnitColor;
((Range)returnExcel.Sheets[1].Cells[j, 14]).Interior.Color = objectExport.UnitColor;
((Range)returnExcel.Sheets[1].Cells[j, 15]).Interior.Color = objectExport.UnitColor;
((Range)returnExcel.Sheets[1].Cells[j, 16]).Interior.Color = objectExport.UnitColor;
returnExcel.Sheets[1].Cells[j, 1] = "'"+objectExport.AssociateNum;
returnExcel.Sheets[1].Cells[j, 2] = objectExport.InternalTicketNum;
returnExcel.Sheets[1].Cells[j, 3] ="'"+ objectExport.PalletNum;
returnExcel.Sheets[1].Cells[j, 4] = objectExport.SenderName;
returnExcel.Sheets[1].Cells[j, 5] = objectExport.SenderAddress;
returnExcel.Sheets[1].Cells[j, 6] = "'" +objectExport.SenderPhoneNum;
returnExcel.Sheets[1].Cells[j, 7] = objectExport.ReceiverName;
returnExcel.Sheets[1].Cells[j, 8] ="'"+ objectExport.ReceiverIDCardNum;
returnExcel.Sheets[1].Cells[j, 9] ="'"+objectExport.ReceiverPhoneNum;
returnExcel.Sheets[1].Cells[j, 10] = objectExport.City;
returnExcel.Sheets[1].Cells[j, 11] = objectExport.Province;
returnExcel.Sheets[1].Cells[j, 12] = "'"+objectExport.PostCode;
returnExcel.Sheets[1].Cells[j, 13] = objectExport.ReceiverAddress;
returnExcel.Sheets[1].Cells[j, 14] = objectExport.PackageName;
returnExcel.Sheets[1].Cells[j, 15] = objectExport.PackageTotalWeight;
returnExcel.Sheets[1].Cells[j, 16] = objectExport.CountrySimName1;
Range titleRange = returnExcel.Sheets[1].Range[returnExcel.Sheets[1].Cells[j, 1], returnExcel.Sheets[1].Cells[j, 16]];
titleRange.Borders.LineStyle = Microsoft.Office.Interop.Excel.XlLineStyle.xlContinuous;//设置边框
titleRange.Borders.Weight = Microsoft.Office.Interop.Excel.XlBorderWeight.xlThin;//边框常规粗细
j++;
}
//获取order items工作薄的列数
int columnsOfOrderItemsHeads = ConstantData.columnsOfHealthProductAdditionExport;
String[] orderItemsHeadInfo = ConstantData.HEALTHPRODUCTADDITIONALEXPORT;
for (int i = 1; i <= columnsOfOrderItemsHeads; i++)
{
returnExcel.Sheets[2].Cells[1, i] = orderItemsHeadInfo[i - 1];
}
//记录行数
j = 2;
foreach (HealthProductItemsExport objectItemsExport in orderItemsArrayList)
{
((Range)returnExcel.Sheets[2].Cells[j, 1]).Interior.Color = objectItemsExport.UnitColor;
((Range)returnExcel.Sheets[2].Cells[j, 2]).Interior.Color = objectItemsExport.UnitColor;
((Range)returnExcel.Sheets[2].Cells[j, 3]).Interior.Color = objectItemsExport.UnitColor;
((Range)returnExcel.Sheets[2].Cells[j, 4]).Interior.Color = objectItemsExport.UnitColor;
((Range)returnExcel.Sheets[2].Cells[j, 5]).Interior.Color = objectItemsExport.UnitColor;
((Range)returnExcel.Sheets[2].Cells[j, 6]).Interior.Color = objectItemsExport.UnitColor;
((Range)returnExcel.Sheets[2].Cells[j, 7]).Interior.Color = objectItemsExport.UnitColor;
((Range)returnExcel.Sheets[2].Cells[j, 8]).Interior.Color = objectItemsExport.UnitColor;
((Range)returnExcel.Sheets[2].Cells[j, 9]).Interior.Color = objectItemsExport.UnitColor;
((Range)returnExcel.Sheets[2].Cells[j, 10]).Interior.Color = objectItemsExport.UnitColor;
((Range)returnExcel.Sheets[2].Cells[j, 11]).Interior.Color = objectItemsExport.UnitColor;
((Range)returnExcel.Sheets[2].Cells[j, 12]).Interior.Color = objectItemsExport.UnitColor;
((Range)returnExcel.Sheets[2].Cells[j, 13]).Interior.Color = objectItemsExport.UnitColor;
((Range)returnExcel.Sheets[2].Cells[j, 14]).Interior.Color = objectItemsExport.UnitColor;
((Range)returnExcel.Sheets[2].Cells[j, 15]).Interior.Color = objectItemsExport.UnitColor;
((Range)returnExcel.Sheets[2].Cells[j, 16]).Interior.Color = objectItemsExport.UnitColor;
Range titleRange = returnExcel.Sheets[2].Range[returnExcel.Sheets[2].Cells[j, 1], returnExcel.Sheets[2].Cells[j, 16]];
titleRange.Borders.LineStyle = Microsoft.Office.Interop.Excel.XlLineStyle.xlContinuous;//设置边框
titleRange.Borders.Weight = Microsoft.Office.Interop.Excel.XlBorderWeight.xlThin;//边框常规粗细
returnExcel.Sheets[2].Cells[j, 1] ="'"+ objectItemsExport.AssociateNum;
returnExcel.Sheets[2].Cells[j, 2] = "'"+objectItemsExport.GoodsNum;
returnExcel.Sheets[2].Cells[j, 3] = objectItemsExport.GoodsName;
returnExcel.Sheets[2].Cells[j, 4] = objectItemsExport.GoodsSimName;
returnExcel.Sheets[2].Cells[j, 5] = objectItemsExport.RegularType;
returnExcel.Sheets[2].Cells[j, 6] = objectItemsExport.BrandType;
returnExcel.Sheets[2].Cells[j, 7] = objectItemsExport.GoodsCount;
returnExcel.Sheets[2].Cells[j, 8] ="'"+ objectItemsExport.GoodsUnit;
returnExcel.Sheets[2].Cells[j, 9] ="'"+ objectItemsExport.GoodsEachPrice;
returnExcel.Sheets[2].Cells[j, 10] = objectItemsExport.TypeOfMoney;
returnExcel.Sheets[2].Cells[j, 11] ="'"+ objectItemsExport.GoodsTotalWeight;
returnExcel.Sheets[2].Cells[j, 12] = "'"+objectItemsExport.ParcelNum;
returnExcel.Sheets[2].Cells[j, 13] = "'" + objectItemsExport.GoodsTotalValue;
returnExcel.Sheets[2].Cells[j, 14] = "'"+objectItemsExport.ParcelNumSecond;
returnExcel.Sheets[2].Cells[j, 15] = "'" + objectItemsExport.GoodsTaxRate;
returnExcel.Sheets[2].Cells[j, 16] = "'" + objectItemsExport.GoodsTax;
j++;
}
returnExcel.Visible = true;
//returnExcel;
Worksheet sheet = new Worksheet();
sheet = (Worksheet)returnExcel.Sheets[1];
sheet = (Worksheet)returnExcel.Sheets[2];
sheet.SaveAs("C:/保健品.xls",
Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value);
returnExcel.Quit();
ConstantData.releaseResource(sheet);
ConstantData.releaseResource(returnExcel);
}
catch (Exception e) {
Console.WriteLine(e.ToString());
}
return true;
}
/*
奶粉
*/
public static Boolean produceChengDuMilkExcelInfo(ArrayList importDataInfo, ArrayList sortInfo) {
if (importDataInfo == null || sortInfo == null)
{
return false;
}
try
{
Microsoft.Office.Interop.Excel.Application returnExcel
= new Microsoft.Office.Interop.Excel.Application();
if (returnExcel == null)
{
MessageBox.Show("无法创建Excel对象,可能你的机器没有安装Excel", "信息提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return false;
}
returnExcel.Workbooks.Add(true);
//创建两个工作薄
returnExcel.Sheets.Add(Missing.Value, Missing.Value, Missing.Value, Missing.Value);
// ((Microsoft.Office.Interop.Excel.Worksheet)returnExcel.Sheets[1]).Name = "Sheet1";
//头信息
String[] MilkHeadInfo = ConstantData.CHENGDUMILKEXPORT;
int cloumnsOfHead = ConstantData.columnsOfChengDuMilkExport;
//添加表头信息
for (int i = 1; i <= cloumnsOfHead; i++)
{
returnExcel.Sheets[1].Cells[1, i] = MilkHeadInfo[i - 1];
}
((Range)returnExcel.Sheets[1].Cells[1, 26]).Interior.Color = ConstantData.COLOR_PLANE_GREEN;
//记录行数
int j = 2;
foreach (ChengDuMilkExport objectExport in sortInfo) {
((Range)returnExcel.Sheets[1].Cells[j, 1]).Interior.Color = objectExport.UnitColor1;
((Range)returnExcel.Sheets[1].Cells[j, 2]).Interior.Color = objectExport.UnitColor1;
((Range)returnExcel.Sheets[1].Cells[j, 3]).Interior.Color = objectExport.UnitColor1;
((Range)returnExcel.Sheets[1].Cells[j, 4]).Interior.Color = objectExport.UnitColor1;
((Range)returnExcel.Sheets[1].Cells[j, 5]).Interior.Color = objectExport.UnitColor1;
((Range)returnExcel.Sheets[1].Cells[j, 6]).Interior.Color = objectExport.UnitColor1;
((Range)returnExcel.Sheets[1].Cells[j, 7]).Interior.Color = objectExport.UnitColor1;
((Range)returnExcel.Sheets[1].Cells[j, 8]).Interior.Color = objectExport.UnitColor1;
((Range)returnExcel.Sheets[1].Cells[j, 9]).Interior.Color = objectExport.UnitColor1;
((Range)returnExcel.Sheets[1].Cells[j, 10]).Interior.Color = objectExport.UnitColor1;
((Range)returnExcel.Sheets[1].Cells[j, 11]).Interior.Color = objectExport.UnitColor1;
((Range)returnExcel.Sheets[1].Cells[j, 12]).Interior.Color = objectExport.UnitColor1;
((Range)returnExcel.Sheets[1].Cells[j, 13]).Interior.Color = objectExport.UnitColor1;
((Range)returnExcel.Sheets[1].Cells[j, 14]).Interior.Color = objectExport.UnitColor1;
((Range)returnExcel.Sheets[1].Cells[j, 15]).Interior.Color = objectExport.UnitColor1;
((Range)returnExcel.Sheets[1].Cells[j, 16]).Interior.Color = objectExport.UnitColor1;
((Range)returnExcel.Sheets[1].Cells[j, 17]).Interior.Color = objectExport.UnitColor1;
((Range)returnExcel.Sheets[1].Cells[j, 18]).Interior.Color = objectExport.UnitColor1;
((Range)returnExcel.Sheets[1].Cells[j, 19]).Interior.Color = objectExport.UnitColor1;
((Range)returnExcel.Sheets[1].Cells[j, 20]).Interior.Color = objectExport.UnitColor1;
((Range)returnExcel.Sheets[1].Cells[j, 21]).Interior.Color = objectExport.UnitColor1;
((Range)returnExcel.Sheets[1].Cells[j, 22]).Interior.Color = objectExport.UnitColor1;
((Range)returnExcel.Sheets[1].Cells[j, 23]).Interior.Color = objectExport.UnitColor1;
((Range)returnExcel.Sheets[1].Cells[j, 24]).Interior.Color = objectExport.UnitColor1;
((Range)returnExcel.Sheets[1].Cells[j, 25]).Interior.Color = objectExport.UnitColor1;
Range titleRange = returnExcel.Sheets[1].Range[returnExcel.Sheets[1].Cells[j, 1], returnExcel.Sheets[1].Cells[j, 26]];
titleRange.Borders.LineStyle = Microsoft.Office.Interop.Excel.XlLineStyle.xlContinuous;//设置边框
titleRange.Borders.Weight = Microsoft.Office.Interop.Excel.XlBorderWeight.xlThin;//边框常规粗细
returnExcel.Sheets[1].Cells[j, 1] = "'"+objectExport.InfoID;
returnExcel.Sheets[1].Cells[j, 2] = objectExport.AirMainNum;
returnExcel.Sheets[1].Cells[j, 3] = objectExport.PartUnitNum;
returnExcel.Sheets[1].Cells[j, 4] ="'"+ objectExport.CustomerRemindNum;
returnExcel.Sheets[1].Cells[j, 5] = objectExport.SenderName;
returnExcel.Sheets[1].Cells[j, 6] = "'" + objectExport.SenderPhoneNum;
returnExcel.Sheets[1].Cells[j, 7] = objectExport.SenderAddress;
returnExcel.Sheets[1].Cells[j, 8] = objectExport.SenderCountry;
returnExcel.Sheets[1].Cells[j, 9] = objectExport.ReceiverName;
returnExcel.Sheets[1].Cells[j, 10] = "'" + objectExport.ReceiverPhoneNum;
returnExcel.Sheets[1].Cells[j, 11] = "'" + objectExport.ReceiverIDCardNum;
returnExcel.Sheets[1].Cells[j, 12] = objectExport.ReceiverAddress;
returnExcel.Sheets[1].Cells[j, 13] = objectExport.ReceiverProvince;
returnExcel.Sheets[1].Cells[j, 14] = "'"+objectExport.PackageNum;
returnExcel.Sheets[1].Cells[j, 15] = "'"+objectExport.PackageWeight;
returnExcel.Sheets[1].Cells[j, 16] = objectExport.PackagePrice;
returnExcel.Sheets[1].Cells[j, 17] = objectExport.InternalNum;
returnExcel.Sheets[1].Cells[j, 18] = objectExport.InternalThingName;
returnExcel.Sheets[1].Cells[j, 19] = objectExport.RegularNum;
returnExcel.Sheets[1].Cells[j, 20] = "'"+objectExport.InternalThingParcelNum;
returnExcel.Sheets[1].Cells[j, 21] = "'"+objectExport.InternalThingNum;
returnExcel.Sheets[1].Cells[j, 22] = objectExport.InternalUnit;
returnExcel.Sheets[1].Cells[j, 23] ="'"+ objectExport.InternalUnitPrice;
returnExcel.Sheets[1].Cells[j, 24] = objectExport.InternalTotalPrice;
returnExcel.Sheets[1].Cells[j, 25] = objectExport.NoteInfo;
returnExcel.Sheets[1].Cells[j, 26] ="'"+ objectExport.AddationalPostCode;
((Range)returnExcel.Sheets[1].Cells[j, 26]).Interior.Color = ConstantData.COLOR_PLANE_GREEN;
j++;
}
returnExcel.Visible = true;
//returnExcel;
Worksheet sheet = new Worksheet();
sheet = (Worksheet)returnExcel.Sheets[1];
sheet.SaveAs("C:/成都奶粉草稿表导出.xls",
Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value);
returnExcel.Quit();
ConstantData.releaseResource(sheet);
ConstantData.releaseResource(returnExcel);
}
catch (Exception e)
{
Console.WriteLine(e.ToString());
}
return true;
}
/*
圆通奶粉的Excel导出
*/
/*
江门奶粉草稿表导出 ,申报清单导出,打单模板导出
*/
public static Boolean produceJiangMenMilkExportInfo(ArrayList importDataInfo, ArrayList sortInfo) {
if (importDataInfo == null || sortInfo == null)
{
return false;
}
else {
try
{
Microsoft.Office.Interop.Excel.Application returnExcel
= new Microsoft.Office.Interop.Excel.Application();
if (returnExcel == null)
{
MessageBox.Show("无法创建Excel对象,可能你的机器没有安装Excel", "信息提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return false;
}
returnExcel.Workbooks.Add(true);
//创建两个工作薄
returnExcel.Sheets.Add(Missing.Value, Missing.Value, Missing.Value, Missing.Value);
returnExcel.Sheets.Add(Missing.Value, Missing.Value, Missing.Value, Missing.Value);
((Microsoft.Office.Interop.Excel.Worksheet)returnExcel.Sheets[1]).Name = "Orders";
((Microsoft.Office.Interop.Excel.Worksheet)returnExcel.Sheets[2]).Name = "Order Items";
ArrayList orderItemsArrayList = null;
//获得orders工作区间的列数
ThreadStart threadStart = new ThreadStart(delegate ()
{
orderItemsArrayList = SortArrayList.getJiangMenOrderItemsExportInfo(importDataInfo);
});
Thread thread1 = new Thread(threadStart);
thread1.Start();//多线程启动匿名方法
thread1.Join();
int columnsOfOrdersHeads = ConstantData.columnsOfJiangMenMilkOrdersCraftExport;
String[] ordersHeadInfo = ConstantData.JIANGMENGEXPORTORDERSCRAFT;
//添加表头信息
for (int i = 1; i <= columnsOfOrdersHeads; i++)
{
returnExcel.Sheets[1].Cells[1, i] = ordersHeadInfo[i - 1];
}
//记录行数
int j = 2;
//添加orders的信息
foreach (JiangMenCraftExport objectExport in sortInfo)
{
((Range)returnExcel.Sheets[1].Cells[j, 1]).Interior.Color = objectExport.UnitColor;
((Range)returnExcel.Sheets[1].Cells[j, 2]).Interior.Color = objectExport.UnitColor;
((Range)returnExcel.Sheets[1].Cells[j, 3]).Interior.Color = objectExport.UnitColor;
((Range)returnExcel.Sheets[1].Cells[j, 4]).Interior.Color = objectExport.UnitColor;
((Range)returnExcel.Sheets[1].Cells[j, 5]).Interior.Color = objectExport.UnitColor;
((Range)returnExcel.Sheets[1].Cells[j, 6]).Interior.Color = objectExport.UnitColor;
((Range)returnExcel.Sheets[1].Cells[j, 7]).Interior.Color = objectExport.UnitColor;
((Range)returnExcel.Sheets[1].Cells[j, 8]).Interior.Color = objectExport.UnitColor;
((Range)returnExcel.Sheets[1].Cells[j, 9]).Interior.Color = objectExport.UnitColor;
((Range)returnExcel.Sheets[1].Cells[j, 10]).Interior.Color = objectExport.UnitColor;
((Range)returnExcel.Sheets[1].Cells[j, 11]).Interior.Color = objectExport.UnitColor;
((Range)returnExcel.Sheets[1].Cells[j, 12]).Interior.Color = objectExport.UnitColor;
((Range)returnExcel.Sheets[1].Cells[j, 13]).Interior.Color = objectExport.UnitColor;
((Range)returnExcel.Sheets[1].Cells[j, 14]).Interior.Color = objectExport.UnitColor;
((Range)returnExcel.Sheets[1].Cells[j, 15]).Interior.Color = objectExport.UnitColor;
((Range)returnExcel.Sheets[1].Cells[j, 16]).Interior.Color = objectExport.UnitColor;
returnExcel.Sheets[1].Cells[j, 1] ="'"+ objectExport.AssociateNum;
returnExcel.Sheets[1].Cells[j, 2] = objectExport.InternalTicketNum;
returnExcel.Sheets[1].Cells[j, 3] = objectExport.PalletNum;
returnExcel.Sheets[1].Cells[j, 4] = objectExport.SenderName;
returnExcel.Sheets[1].Cells[j, 5] = objectExport.SenderAddress;
returnExcel.Sheets[1].Cells[j, 6] = "'"+objectExport.SenderPhoneNum;
returnExcel.Sheets[1].Cells[j, 7] = objectExport.ReceiverName;
returnExcel.Sheets[1].Cells[j, 8] = "'"+objectExport.ReceiverIDCardNum;
returnExcel.Sheets[1].Cells[j, 9] = "'" + objectExport.ReceiverPhoneNum;
returnExcel.Sheets[1].Cells[j, 10] = "'" + objectExport.ReceiverCity;
returnExcel.Sheets[1].Cells[j, 11] = objectExport.ReceiverProvince;
returnExcel.Sheets[1].Cells[j, 12] ="'"+ objectExport.AddationalPostCode;
returnExcel.Sheets[1].Cells[j, 13] = objectExport.ReceiverAddress;
returnExcel.Sheets[1].Cells[j, 14] = objectExport.PackageName;
returnExcel.Sheets[1].Cells[j, 15] ="'" +objectExport.PackageWeight;
returnExcel.Sheets[1].Cells[j, 16] = objectExport.CountrySimName;
Range titleRange = returnExcel.Sheets[1].Range[returnExcel.Sheets[1].Cells[j, 1], returnExcel.Sheets[1].Cells[j, 16]];
titleRange.Borders.LineStyle = Microsoft.Office.Interop.Excel.XlLineStyle.xlContinuous;//设置边框
titleRange.Borders.Weight = Microsoft.Office.Interop.Excel.XlBorderWeight.xlThin;//边框常规粗细
j++;
}
//获取order items工作薄的列数
int columnsOfOrderItemsHeads = ConstantData.columnsOfJiangMenMilkOrderItemsExport;
String[] orderItemsHeadInfo = ConstantData.JIANGMENEXPORTORDERITEMS;
for (int i = 1; i <= columnsOfOrderItemsHeads; i++)
{
returnExcel.Sheets[2].Cells[1, i] = orderItemsHeadInfo[i - 1];
}
//记录行数
j = 2;
foreach (JiangMenAdditionalExport objectItemsExport in orderItemsArrayList)
{
((Range)returnExcel.Sheets[2].Cells[j, 1]).Interior.Color = objectItemsExport.UnitColor;
((Range)returnExcel.Sheets[2].Cells[j, 2]).Interior.Color = objectItemsExport.UnitColor;
((Range)returnExcel.Sheets[2].Cells[j, 3]).Interior.Color = objectItemsExport.UnitColor;
((Range)returnExcel.Sheets[2].Cells[j, 4]).Interior.Color = objectItemsExport.UnitColor;
((Range)returnExcel.Sheets[2].Cells[j, 5]).Interior.Color = objectItemsExport.UnitColor;
((Range)returnExcel.Sheets[2].Cells[j, 6]).Interior.Color = objectItemsExport.UnitColor;
((Range)returnExcel.Sheets[2].Cells[j, 7]).Interior.Color = objectItemsExport.UnitColor;
((Range)returnExcel.Sheets[2].Cells[j, 8]).Interior.Color = objectItemsExport.UnitColor;
((Range)returnExcel.Sheets[2].Cells[j, 9]).Interior.Color = objectItemsExport.UnitColor;
((Range)returnExcel.Sheets[2].Cells[j, 10]).Interior.Color = objectItemsExport.UnitColor;
((Range)returnExcel.Sheets[2].Cells[j, 11]).Interior.Color = objectItemsExport.UnitColor;
((Range)returnExcel.Sheets[2].Cells[j, 12]).Interior.Color = objectItemsExport.UnitColor;
((Range)returnExcel.Sheets[2].Cells[j, 13]).Interior.Color = objectItemsExport.UnitColor;
((Range)returnExcel.Sheets[2].Cells[j, 14]).Interior.Color = objectItemsExport.UnitColor;
((Range)returnExcel.Sheets[2].Cells[j, 15]).Interior.Color = objectItemsExport.UnitColor;
((Range)returnExcel.Sheets[2].Cells[j, 16]).Interior.Color = objectItemsExport.UnitColor;
Range titleRange = returnExcel.Sheets[2].Range[returnExcel.Sheets[2].Cells[j, 1], returnExcel.Sheets[2].Cells[j, 16]];
titleRange.Borders.LineStyle = Microsoft.Office.Interop.Excel.XlLineStyle.xlContinuous;//设置边框
titleRange.Borders.Weight = Microsoft.Office.Interop.Excel.XlBorderWeight.xlThin;//边框常规粗细
returnExcel.Sheets[2].Cells[j, 1] = "'" + objectItemsExport.AssociateNum;
returnExcel.Sheets[2].Cells[j, 2] = "'" + objectItemsExport.GoodsNum;
returnExcel.Sheets[2].Cells[j, 3] = objectItemsExport.GoodsName;
returnExcel.Sheets[2].Cells[j, 4] = objectItemsExport.GoodsSimName;
returnExcel.Sheets[2].Cells[j, 5] = objectItemsExport.RegularType;
returnExcel.Sheets[2].Cells[j, 6] = objectItemsExport.BrandType;
returnExcel.Sheets[2].Cells[j, 7] = objectItemsExport.GoodsCount;
returnExcel.Sheets[2].Cells[j, 8] = "'" + objectItemsExport.GoodsUnit;
returnExcel.Sheets[2].Cells[j, 9] = "'" + objectItemsExport.GoodsEachPrice;
returnExcel.Sheets[2].Cells[j, 10] = objectItemsExport.TypeOfMoney;
returnExcel.Sheets[2].Cells[j, 11] = "'" + objectItemsExport.GoodsTotalWeight;
returnExcel.Sheets[2].Cells[j, 12] = "'" + objectItemsExport.ParcelNum;
returnExcel.Sheets[2].Cells[j, 13] = "'" + objectItemsExport.GoodsTotalValue;
returnExcel.Sheets[2].Cells[j, 14] = "'" + objectItemsExport.ParcelNumSecond;
returnExcel.Sheets[2].Cells[j, 15] = "'" + objectItemsExport.GoodsTaxRate;
returnExcel.Sheets[2].Cells[j, 16] = "'" + objectItemsExport.GoodsTax;
j++;
}
returnExcel.Visible = true;
//returnExcel;
Worksheet sheet = new Worksheet();
sheet = (Worksheet)returnExcel.Sheets[1];
sheet = (Worksheet)returnExcel.Sheets[2];
sheet.SaveAs("C:/奶粉.xls",
Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value);
returnExcel.Quit();
ConstantData.releaseResource(sheet);
ConstantData.releaseResource(returnExcel);
}
catch (Exception e)
{
Console.WriteLine(e.ToString());
}
return true;
}
}
public static Boolean produceTianJinCraftExportInfo(ArrayList importDataInfo, ArrayList sortInfo) {
if (importDataInfo == null || sortInfo == null)
{
return false;
}
else {
try
{
Microsoft.Office.Interop.Excel.Application returnExcel
= new Microsoft.Office.Interop.Excel.Application();
if (returnExcel == null)
{
MessageBox.Show("无法创建Excel对象,可能你的机器没有安装Excel", "信息提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return false;
}
returnExcel.Workbooks.Add(true);
//创建两个工作薄
returnExcel.Sheets.Add(Missing.Value, Missing.Value, Missing.Value, Missing.Value);
returnExcel.Sheets.Add(Missing.Value, Missing.Value, Missing.Value, Missing.Value);
((Microsoft.Office.Interop.Excel.Worksheet)returnExcel.Sheets[1]).Name = "Orders";
((Microsoft.Office.Interop.Excel.Worksheet)returnExcel.Sheets[2]).Name = "Order Items";
ArrayList orderItemsArrayList = null;
//获得orders工作区间的列数
orderItemsArrayList = SortArrayList.getTianJinCraftOrderItemsInfo(importDataInfo);
int columnsOfOrdersHeads = ConstantData.columnsOfTianJinMilkOrdersCraftExport;
String[] ordersHeadInfo = ConstantData.TIANJINEXPORTORDERSCRAFT;
//添加表头信息
for (int i = 1; i <= columnsOfOrdersHeads; i++)
{
returnExcel.Sheets[1].Cells[1, i] = ordersHeadInfo[i - 1];
}
//记录行数
int j = 2;
//添加orders的信息
foreach (TianJinCraftModel objectExport in sortInfo)
{
((Range)returnExcel.Sheets[1].Cells[j, 1]).Interior.Color = objectExport.UnitColor;
((Range)returnExcel.Sheets[1].Cells[j, 2]).Interior.Color = objectExport.UnitColor;
((Range)returnExcel.Sheets[1].Cells[j, 3]).Interior.Color = objectExport.UnitColor;
((Range)returnExcel.Sheets[1].Cells[j, 4]).Interior.Color = objectExport.UnitColor;
((Range)returnExcel.Sheets[1].Cells[j, 5]).Interior.Color = objectExport.UnitColor;
((Range)returnExcel.Sheets[1].Cells[j, 6]).Interior.Color = objectExport.UnitColor;
((Range)returnExcel.Sheets[1].Cells[j, 7]).Interior.Color = objectExport.UnitColor;
((Range)returnExcel.Sheets[1].Cells[j, 8]).Interior.Color = objectExport.UnitColor;
((Range)returnExcel.Sheets[1].Cells[j, 9]).Interior.Color = objectExport.UnitColor;
((Range)returnExcel.Sheets[1].Cells[j, 10]).Interior.Color = objectExport.UnitColor;
((Range)returnExcel.Sheets[1].Cells[j, 11]).Interior.Color = objectExport.UnitColor;
((Range)returnExcel.Sheets[1].Cells[j, 12]).Interior.Color = objectExport.UnitColor;
((Range)returnExcel.Sheets[1].Cells[j, 13]).Interior.Color = objectExport.UnitColor;
((Range)returnExcel.Sheets[1].Cells[j, 14]).Interior.Color = objectExport.UnitColor;
((Range)returnExcel.Sheets[1].Cells[j, 15]).Interior.Color = objectExport.UnitColor;
((Range)returnExcel.Sheets[1].Cells[j, 16]).Interior.Color = objectExport.UnitColor;
returnExcel.Sheets[1].Cells[j, 1] = "'" + objectExport.AssociateNum;
returnExcel.Sheets[1].Cells[j, 2] = objectExport.InternalTicketNum;
returnExcel.Sheets[1].Cells[j, 3] = objectExport.PalletNum;
returnExcel.Sheets[1].Cells[j, 4] = objectExport.SenderName;
returnExcel.Sheets[1].Cells[j, 5] = objectExport.SenderAddress;
returnExcel.Sheets[1].Cells[j, 6] = "'" + objectExport.SenderPhoneNum;
returnExcel.Sheets[1].Cells[j, 7] = objectExport.ReceiverName;
returnExcel.Sheets[1].Cells[j, 8] = "'" + objectExport.ReceiverIDCardNum;
returnExcel.Sheets[1].Cells[j, 9] = "'" + objectExport.ReceiverPhoneNum;
returnExcel.Sheets[1].Cells[j, 10] = objectExport.ReceiverCity;
returnExcel.Sheets[1].Cells[j, 11] = objectExport.ReceiverProvince;
returnExcel.Sheets[1].Cells[j, 12] = "'"+objectExport.AddationalPostCode;
returnExcel.Sheets[1].Cells[j, 13] = objectExport.ReceiverAddress;
returnExcel.Sheets[1].Cells[j, 14] = "'" + objectExport.PackageName;
returnExcel.Sheets[1].Cells[j, 15] ="'"+ objectExport.PackageWeight;
returnExcel.Sheets[1].Cells[j, 16] = objectExport.CountrySimName;
Range titleRange = returnExcel.Sheets[1].Range[returnExcel.Sheets[1].Cells[j, 1], returnExcel.Sheets[1].Cells[j, 16]];
titleRange.Borders.LineStyle = Microsoft.Office.Interop.Excel.XlLineStyle.xlContinuous;//设置边框
titleRange.Borders.Weight = Microsoft.Office.Interop.Excel.XlBorderWeight.xlThin;//边框常规粗细
j++;
}
//获取order items工作薄的列数
int columnsOfOrderItemsHeads = ConstantData.columnsOfTianJinMilkOrderItemsExport;
String[] orderItemsHeadInfo = ConstantData.TIANJINEXPORTORDERITEMS;
for (int i = 1; i <= columnsOfOrderItemsHeads; i++)
{
returnExcel.Sheets[2].Cells[1, i] = orderItemsHeadInfo[i - 1];
}
//记录行数
j = 2;
foreach (TianJinOrderItemModel objectItemsExport in orderItemsArrayList)
{
((Range)returnExcel.Sheets[2].Cells[j, 1]).Interior.Color = objectItemsExport.UnitColor;
((Range)returnExcel.Sheets[2].Cells[j, 2]).Interior.Color = objectItemsExport.UnitColor;
((Range)returnExcel.Sheets[2].Cells[j, 3]).Interior.Color = objectItemsExport.UnitColor;
((Range)returnExcel.Sheets[2].Cells[j, 4]).Interior.Color = objectItemsExport.UnitColor;
((Range)returnExcel.Sheets[2].Cells[j, 5]).Interior.Color = objectItemsExport.UnitColor;
((Range)returnExcel.Sheets[2].Cells[j, 6]).Interior.Color = objectItemsExport.UnitColor;
((Range)returnExcel.Sheets[2].Cells[j, 7]).Interior.Color = objectItemsExport.UnitColor;
((Range)returnExcel.Sheets[2].Cells[j, 8]).Interior.Color = objectItemsExport.UnitColor;
((Range)returnExcel.Sheets[2].Cells[j, 9]).Interior.Color = objectItemsExport.UnitColor;
((Range)returnExcel.Sheets[2].Cells[j, 10]).Interior.Color = objectItemsExport.UnitColor;
((Range)returnExcel.Sheets[2].Cells[j, 11]).Interior.Color = objectItemsExport.UnitColor;
((Range)returnExcel.Sheets[2].Cells[j, 12]).Interior.Color = objectItemsExport.UnitColor;
((Range)returnExcel.Sheets[2].Cells[j, 13]).Interior.Color = objectItemsExport.UnitColor;
((Range)returnExcel.Sheets[2].Cells[j, 14]).Interior.Color = objectItemsExport.UnitColor;
((Range)returnExcel.Sheets[2].Cells[j, 15]).Interior.Color = objectItemsExport.UnitColor;
((Range)returnExcel.Sheets[2].Cells[j, 16]).Interior.Color = objectItemsExport.UnitColor;
Range titleRange = returnExcel.Sheets[2].Range[returnExcel.Sheets[2].Cells[j, 1], returnExcel.Sheets[2].Cells[j, 16]];
titleRange.Borders.LineStyle = Microsoft.Office.Interop.Excel.XlLineStyle.xlContinuous;//设置边框
titleRange.Borders.Weight = Microsoft.Office.Interop.Excel.XlBorderWeight.xlThin;//边框常规粗细
returnExcel.Sheets[2].Cells[j, 1] = "'" + objectItemsExport.AssociateNum;
returnExcel.Sheets[2].Cells[j, 2] = "'" + objectItemsExport.GoodsNum;
returnExcel.Sheets[2].Cells[j, 3] = objectItemsExport.GoodsName;
returnExcel.Sheets[2].Cells[j, 4] = objectItemsExport.GoodsSimName;
returnExcel.Sheets[2].Cells[j, 5] = objectItemsExport.RegularType;
returnExcel.Sheets[2].Cells[j, 6] = objectItemsExport.BrandType;
returnExcel.Sheets[2].Cells[j, 7] = objectItemsExport.GoodsCount;
returnExcel.Sheets[2].Cells[j, 8] = "'" + objectItemsExport.GoodsUnit;
returnExcel.Sheets[2].Cells[j, 9] = "'" + objectItemsExport.GoodsEachPrice;
returnExcel.Sheets[2].Cells[j, 10] = objectItemsExport.TypeOfMoney;
returnExcel.Sheets[2].Cells[j, 11] = "'" + objectItemsExport.GoodsTotalWeight;
returnExcel.Sheets[2].Cells[j, 12] = "'" + objectItemsExport.ParcelNum;
returnExcel.Sheets[2].Cells[j, 13] = "'" + objectItemsExport.GoodsTotalValue;
returnExcel.Sheets[2].Cells[j, 14] = "'" + objectItemsExport.ParcelNumSecond;
returnExcel.Sheets[2].Cells[j, 15] = "'" + objectItemsExport.GoodsTaxRate;
returnExcel.Sheets[2].Cells[j, 16] = "'" + objectItemsExport.GoodsTax;
j++;
}
returnExcel.Visible = true;
//returnExcel;
Worksheet sheet = new Worksheet();
sheet = (Worksheet)returnExcel.Sheets[1];
sheet = (Worksheet)returnExcel.Sheets[2];
sheet.SaveAs("C:/天津草稿模板.xls",
Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value);
returnExcel.Quit();
ConstantData.releaseResource(sheet);
ConstantData.releaseResource(returnExcel);
}
catch (Exception e)
{
Console.WriteLine(e.ToString());
}
return true;
}
}
}
}