/// <summary>
/// 导出EXCEL
/// </summary>
/// <param name="day"></param>
/// <param name="pay_state"></param>
/// <param name="order_state"></param>
public void ExportExcel(int day, int pay_state, int order_state)
{
var order_list = OrderCache($"orderlist_{day}", day);
if (order_list.Any())
{
order_list = order_list.Where(n => n.pay_state == pay_state && n.order_state == order_state).ToList();
List <dynamic> list = new List <dynamic>();
if (order_list.Any())
{
foreach (var item in order_list)
{
var one = new
{
item.id,
product_name = item.product.name,
pay_state = Enum.GetName(typeof(Pay_state), item.pay_state),
order_state = Enum.GetName(typeof(Order_state), item.order_state),
user_name = item.user.name,
item.order_number,
item.wx_order_num,
item.user_remark,
item.add_time,
item.pay_time,
item.refund_number,
item.pay_account,
item.count,
item.product.price,
item.order_money
};
list.Add(one);
}
if (list.Any())
{
DataTable dt = ListToDataTable.List2DataTable <dynamic>(list);
if (dt != null && dt.Rows.Count > 0)
{
dt.Columns["id"].ColumnName = "id";
dt.Columns["product_name"].ColumnName = "产品名称";
dt.Columns["user_name"].ColumnName = "用户名称";
dt.Columns["count"].ColumnName = "产品个数";
dt.Columns["price"].ColumnName = "产品价格";
dt.Columns["order_money"].ColumnName = "订单金额";
dt.Columns["pay_state"].ColumnName = "支付状态";
dt.Columns["order_state"].ColumnName = "订单状态";
dt.Columns["order_number"].ColumnName = "订单号";
dt.Columns["wx_order_num"].ColumnName = "微信订单号";
dt.Columns["add_time"].ColumnName = "下单时间";
dt.Columns["pay_time"].ColumnName = "支付时间";
dt.Columns["pay_account"].ColumnName = "付款账号";
dt.Columns["refund_number"].ColumnName = "退单号";
}
bool hh = OfficeHelper.ExportExcelWithAspose(dt, $"{day}天内订单信息{DateTime.Now.ToString("yyyy年MM月dd日HH时mm分ss秒")}", "", true);
}
}
}
}
/// <summary>
/// 导出用户EXCEL
/// </summary>
/// <param name="name"></param>
/// <returns></returns>
public void ExportExcel(string name)
{
var user_list = CacheUser("all_user_list");
if (user_list.Any())
{
if (!string.IsNullOrEmpty(name))
{
user_list = user_list.Where(n => n.name.Contains(name)).ToList();
}
List <dynamic> list = new List <dynamic>();
if (user_list.Any())
{
foreach (var item in user_list)
{
var one = new
{
item.id,
item.name,
item.tel,
parent_user = item.pid == 0 ? "" : user_list.FirstOrDefault(n => n.id == item.pid).name,
item.total_pay,
item.sex,
state = Enum.GetName(typeof(User_state), item.state),
item.wx_user.nickname,
item.wx_user.add_time,
item.total_product_count,
item.usable_score,
item.total_score,
isbuy = Enum.GetName(typeof(Isbuy), item.isbuy),
item.wx_user.city,
item.wx_user.country,
item.wx_user.province,
};
list.Add(one);
}
if (list.Any())
{
DataTable dt = ListToDataTable.List2DataTable <dynamic>(list);
if (dt != null && dt.Rows.Count > 0)
{
dt.Columns["id"].ColumnName = "id";
dt.Columns["name"].ColumnName = "名称";
dt.Columns["nickname"].ColumnName = "微信昵称";
dt.Columns["tel"].ColumnName = "电话号码";
dt.Columns["sex"].ColumnName = "性别";
dt.Columns["city"].ColumnName = "城市";
dt.Columns["province"].ColumnName = "省份";
dt.Columns["country"].ColumnName = "国家";
dt.Columns["add_time"].ColumnName = "加入时间";
dt.Columns["parent_user"].ColumnName = "推荐人";
dt.Columns["total_pay"].ColumnName = "总消费";
dt.Columns["state"].ColumnName = "状态";
dt.Columns["total_product_count"].ColumnName = "产品数量";
dt.Columns["total_score"].ColumnName = "总积分";
dt.Columns["usable_score"].ColumnName = "可用积分";
dt.Columns["isbuy"].ColumnName = "是否购买";
}
bool hh = OfficeHelper.ExportExcelWithAspose(dt, $"用户信息{DateTime.Now.ToString("yyyy年MM月dd日HH时mm分ss秒")}", "", true);
}
}
}
}