//创建ExcelHelper 该EXCEL是用于存放SKU数据
private ExcelHelper CreateExcelForBanggoSku(string sheetName)
{
FileHelper.CreateDirectory(Resource.SysConfig_Sku);
string filePath = @"Sku\{0} banggoSku.xls".StringFormat(DateTime.Now.ToString("yyyy-MM-dd"));
var excel = new ExcelHelper(filePath)
{
Imex = "0", Hdr = "YES"
};
if (File.Exists(filePath))
{
if (SysUtils.CheckTableExsit(excel, sheetName))
{
return(excel);
}
}
var dic = new Dictionary <string, string>
{
{ "产品地址", "varchar(255)" },
{ "款号", "Double" },
{ "售价", "Double" },
{ "库存", "Double" },
{ "SKU", "text" },
{ "售完", "Double" }
};
excel.WriteTable(sheetName, dic);
return(excel);
}
//创建ExcelHelper 该EXCEL是用于存放SKU数据
private ExcelHelper CreateExcelForSell(string sheetName)
{
FileHelper.CreateDirectory("Sell");
string filePath = @"Sell\{0} 销售.xls".StringFormat(DateTime.Now.ToString("yyyy-MM-dd"));
var excel = new ExcelHelper(filePath)
{
Imex = "0", Hdr = "YES"
};
if (File.Exists(filePath))
{
if (SysUtils.CheckTableExsit(excel, sheetName))
{
return(excel);
}
}
var dic = new Dictionary <string, string>
{
{ "订单编号", "varchar(255)" },
{ "卖出时间", "varchar(255)" },
{ "货源", "varchar(255)" },
{ "购买人", "varchar(255)" },
{ "款号", "Double" },
{ "颜色", "varchar(255)" },
{ "尺码", "varchar(255)" },
{ "商品属性", "varchar(255)" },
{ "原价", "Double" },
{ "买家应付邮费", "Double" },
{ "单件售价", "Double" },
{ "购买数量", "Double" },
{ "支出邮费", "Double" },
{ "销售金额", "Double" },
{ "付款金额", "Double" },
{ "退款金额", "Double" },
{ "利润", "varchar(255)" },
{ "结帐情况", "varchar(255)" },
{ "结帐时间", "varchar(255)" },
{ "购买帐号", "varchar(255)" },
{ "备注", "varchar(255)" },
};
excel.WriteTable(sheetName, dic);
return(excel);
}
//创建ExcelHelper
private static ExcelHelper CreateExcelForRivalPrice(string sheetName)
{
FileHelper.CreateDirectory("Sku");
string filePath = @"Sku\{0} 分析淘宝.xls".StringFormat(DateTime.Now.ToString("yyyy-MM-dd"));
var excel = new ExcelHelper(filePath);
excel.Imex = "0";
excel.Hdr = "YES";
if (File.Exists(filePath))
{
if (SysUtils.CheckTableExsit(excel, sheetName))
{
return(excel);
}
}
Dictionary <string, string> dic = new Dictionary <string, string>();
dic.Add("款号", "double");
dic.Add("售价", "double");
dic.Add("成本价", "double");
dic.Add("利润", "double");
dic.Add("价格", "double");
dic.Add("邮费", "double");
dic.Add("总价", "double");
dic.Add("销量", "double");
dic.Add("评价数", "double");
dic.Add("用户名", "varchar(255)");
dic.Add("地点", "varchar(255)");
dic.Add("标题", "varchar(255)");
dic.Add("网址", "varchar(255)");
dic.Add("SKU", "varchar(255)");
dic.Add("成交记录", "text");
excel.WriteTable(sheetName, dic);
return(excel);
}
