/// <summary>
/// 下载模板
/// </summary>
public void StorerDemoExecl()
{
DataSet ds = new DataSet();
DataTable dt = new DataTable();
DataTable dtDetail = new DataTable();
//主表信息
dt.Columns.Add("StorerKey", typeof(string));
dt.Columns.Add("状态", typeof(string));
dt.Columns.Add("店铺名称", typeof(string));
dt.Columns.Add("SAP代码", typeof(string));
dt.Columns.Add("类型", typeof(string));
dt.Columns.Add("地址1", typeof(string));
dt.Columns.Add("地址2", typeof(string));
dt.Columns.Add("地址3", typeof(string));
dt.Columns.Add("地址4", typeof(string));
dt.Columns.Add("城市", typeof(string));
dt.Columns.Add("州", typeof(string));
dt.Columns.Add("邮编", typeof(string));
dt.Columns.Add("国家", typeof(string));
dt.Columns.Add("国家代码", typeof(string));
dt.Columns.Add("联系人1", typeof(string));
dt.Columns.Add("联系人2", typeof(string));
dt.Columns.Add("联系电话1", typeof(string));
dt.Columns.Add("联系电话2", typeof(string));
dt.Columns.Add("传真1", typeof(string));
dt.Columns.Add("传真2", typeof(string));
dt.Columns.Add("邮箱1", typeof(string));
dt.Columns.Add("邮箱2", typeof(string));
dt.Columns.Add("创建人", typeof(string));
dt.Columns.Add("更新人", typeof(string));
DataRow dr1 = dt.NewRow();
dr1["StorerKey"] = "3602";
dr1["店铺名称"] = "耐克成都双流换季优惠店";
dr1["SAP代码"] = "8006902";
dr1["类型"] = "SELLER";
dr1["地址1"] = "成都市双流区东升街道双楠大道中段633号时代奥特莱斯S-1184,1185,S-2189,2190";
dr1["国家代码"] = "CN";
dr1["联系人1"] = "刘力";
dr1["联系电话1"] = "028-61915601";
dr1["创建人"] = "NIKENFSCD";
dt.Rows.Add(dr1);
ds.Tables.Add(dt);
//明细信息
//dtDetail.Columns.Add("SKU", typeof(string));
//dtDetail.Columns.Add("UPC", typeof(string));
//dtDetail.Columns.Add("UPC名称", typeof(string));
//dtDetail.Columns.Add("UPC类型", typeof(string));
//dtDetail.Columns.Add("UPC数量", typeof(string));
//ds.Tables.Add(dtDetail);
//ExportDataToExcelHelper.ExportDataSetToExcel(ds, "店铺导入模板.xls");//生成Excel
EPPlusOperation.ExportByEPPlus(ds.Tables[0], "店铺导入模板");
}
/// <summary>
/// 导出箱清单
/// </summary>
/// <param name="id">orderid</param>
/// <param name="type">1</param>
/// <param name="OrderID">0</param>
public void ExportBoxDetail(string id, string type, string OrderID)
{
DataSet ds = new OrderManagementService().ExportBoxDetailsYXDR(id.ToString());
DataTable dt = ds.Tables[0];
//这段代码我承认写的很lj
if (dt.Rows.Count > 0)
{
DataTable dtheader = new DataTable(); //订单主信息
DataTable dtBoxdetail = new DataTable(); //箱明细信息
dtheader.Columns.Add("dc1", typeof(string));
dtheader.Columns.Add("dc2", typeof(string));
dtheader.Columns.Add("dc3", typeof(string));
dtheader.Columns.Add("dc4", typeof(string));
dtheader.Columns.Add("dc5", typeof(string));
dtheader.Columns.Add("dc6", typeof(string));
dtheader.Columns.Add("dc7", typeof(string));
dtheader.Columns.Add("dc8", typeof(string));
dtheader.Columns.Add("dc9", typeof(string));
dtheader.Columns.Add("dc10", typeof(string));
dtheader.Columns.Add("dc11", typeof(string));
dtheader.Columns.Add("dc12", typeof(string));
dtheader.Columns.Add("dc13", typeof(string));
#region 先把一单的头信息加上
//第一行
DataRow dr = dtheader.NewRow();
dr["dc1"] = "箱清单";
dr["dc2"] = "订单号:";
dr["dc3"] = dt.Rows[0]["ExternOrderNumber"].ToString().Trim();
dr["dc4"] = "货主:";
dr["dc5"] = "Haddad";
dr["dc6"] = "门店代码:";
dr["dc7"] = dt.Rows[0]["str4"].ToString().Trim();
dr["dc8"] = "门店名称:";
dr["dc9"] = dt.Rows[0]["Company"].ToString();
dr["dc10"] = "门店地址:";
dr["dc11"] = dt.Rows[0]["AddressLine1"].ToString();
dr["dc12"] = "出货日期:";
dr["dc13"] = DateTime.Now;
dtheader.Rows.Add(dr);
//第二行明细列
DataRow dr2 = dtheader.NewRow();
dr2["dc1"] = "箱唛号";
dr2["dc2"] = "箱号";
dr2["dc3"] = "款号";
dr2["dc4"] = "描述";
dr2["dc5"] = "尺码";
dr2["dc6"] = "数量";
dr2["dc7"] = "订单号";
dr2["dc8"] = "条形码";
dr2["dc9"] = "";
dr2["dc10"] = "";
dr2["dc11"] = "";
dtheader.Rows.Add(dr2);
#endregion
List <string> list = new List <string>();
int boxnumber = 1; //箱号
int packageSumQty = 0; //每箱总数
string packagenumber = ""; //箱唛号
for (int i = 0; i < dt.Rows.Count; i++)
{
DataRow dr3 = dtheader.NewRow();
if (i == 0)
{
packagenumber = dt.Rows[i]["PackageNumber"].ToString();
dr3["dc1"] = dt.Rows[i]["ShippingMark"].ToString();
dr3["dc2"] = boxnumber.ToString();
dr3["dc3"] = dt.Rows[i]["Atrcle"].ToString();
dr3["dc4"] = dt.Rows[i]["GoodsName"].ToString();
dr3["dc5"] = dt.Rows[i]["Size"].ToString();
dr3["dc6"] = dt.Rows[i]["Qty"].ToString();
dr3["dc7"] = dt.Rows[i]["ExternOrderNumber"].ToString();
dr3["dc8"] = dt.Rows[i]["SKU"].ToString();
}
else
{
if (packagenumber != dt.Rows[i]["PackageNumber"].ToString())
{
DataRow dr4 = dtheader.NewRow();
dr4["dc1"] = "箱总数:";
dr4["dc2"] = packageSumQty.ToString(".00");
dr4["dc3"] = "";
dr4["dc4"] = "";
dr4["dc5"] = "";
dr4["dc6"] = "";
dr4["dc7"] = "";
dr4["dc8"] = "";
dtheader.Rows.Add(dr4);
packagenumber = dt.Rows[i]["PackageNumber"].ToString();
packageSumQty = 0;
boxnumber++;
}
dr3["dc1"] = dt.Rows[i]["ShippingMark"].ToString();
dr3["dc2"] = boxnumber;
dr3["dc3"] = dt.Rows[i]["Atrcle"].ToString();
dr3["dc4"] = dt.Rows[i]["GoodsName"].ToString();
dr3["dc5"] = dt.Rows[i]["Size"].ToString();
dr3["dc6"] = dt.Rows[i]["Qty"].ToString();
dr3["dc7"] = dt.Rows[i]["ExternOrderNumber"].ToString();
dr3["dc8"] = dt.Rows[i]["SKU"].ToString();
}
dtheader.Rows.Add(dr3);
packageSumQty += Convert.ToInt32(Convert.ToDouble(dt.Rows[i]["Qty"].ToString()));
}
DataRow dr5 = dtheader.NewRow();
dr5["dc1"] = "箱总数:";
dr5["dc2"] = packageSumQty.ToString(".00");
dr5["dc3"] = "";
dr5["dc4"] = "";
dr5["dc5"] = "";
dr5["dc6"] = "";
dr5["dc7"] = "";
dr5["dc8"] = "";
dtheader.Rows.Add(dr5);
//ExportDataToExcelHelper.ExportDataSetToExcel(dtheader, "箱清单" + DateTime.Now.ToString("yyyy-MM-dd"), "");
EPPlusOperation.ExportByEPPlus(dtheader, "箱清单" + DateTime.Now.ToString("yyyy-MM-dd"));
}
else
{
//ExportDataToExcelHelper.ExportDataSetToExcel(dt, "箱清单" + DateTime.Now.ToString("yyyy-MM-dd"), "");
EPPlusOperation.ExportByEPPlus(dt, "箱清单" + DateTime.Now.ToString("yyyy-MM-dd"));
}
}