/// <summary>
/// 导出
/// </summary>
/// <param name="dt"></param>
public void ToExcel1(DataTable dt)
{
AppLibrary.WriteExcel.XlsDocument doc = new AppLibrary.WriteExcel.XlsDocument();
doc.FileName = DateTime.Now.ToString("yyyyMMdd") + ".xls";
string SheetName = "Sheet1";
//记录条数
int mCount = dt.Rows.Count;
Worksheet sheet = doc.Workbook.Worksheets.Add(SheetName);
Cells cells = sheet.Cells;
//第一行表头
for (int i = 0; i < title.Length; i++)
{
cells.Add(1, i + 1, title[i].Trim());
}
for (int m = 0; m < mCount; m++)
{
for (int j = 0; j < title.Length; j++)
{
//可以直接取图片的地址
string filename = Server.MapPath("~/" + dt.Rows[m]["Img"].ToString());
byte[] filedata = getImageByte(filename);;
System.IO.MemoryStream ms = new System.IO.MemoryStream(filedata);
System.Drawing.Image img = System.Drawing.Image.FromStream(ms);
img.Save(filename);
// cells.Add(m + 2, j + 1, dt.Rows[m][j].ToString());
cells.Add(m + 2, j + 1, img);
}
}
doc.Send();
Response.End();
}
/// <summary>
/// 导出
/// </summary>
/// <param name="dt"></param>
public void ToExcel(DataTable dt)
{
AppLibrary.WriteExcel.XlsDocument doc = new AppLibrary.WriteExcel.XlsDocument();
doc.FileName = DateTime.Now.ToString("yyyyMMdd") + ".xls";
string SheetName = "Sheet1";
//记录条数
int mCount = dt.Rows.Count;
Worksheet sheet = doc.Workbook.Worksheets.Add(SheetName);
Cells cells = sheet.Cells;
//第一行表头
for (int i = 0; i < title.Length; i++)
{
cells.Add(1, i + 1, title[i].Trim());
}
for (int m = 0; m < mCount; m++)
{
for (int j = 0; j < title.Length; j++)
{
cells.Add(m + 2, j + 1, dt.Rows[m][j].ToString());
}
}
doc.Send();
Response.End();
}
public void Export()
{
//俱乐部名称
var clubname = HttpContext.Current.Request.QueryString["clubname"].ToString();
//类型
var saleactivitytypeid = HttpContext.Current.Request.QueryString["saleactivitytypeid"].ToString();
var begindate = HttpContext.Current.Request.QueryString["begindate"].ToString();
var enddate = HttpContext.Current.Request.QueryString["enddate"].ToString();
IDatabase database = DataFactory.Database();
IRepository <ActivityViewModel> re = new Repository <ActivityViewModel>();
DataTable data = new DataTable();
string strwhere = " IsDelete=0 ";
if (!string.IsNullOrEmpty(clubname))
{
strwhere += " and ClubName like '%" + clubname + "%'";
}
if (!string.IsNullOrEmpty(saleactivitytypeid))
{
strwhere += " and ClubActivityTypeId=" + saleactivitytypeid;
}
if (!string.IsNullOrEmpty(begindate))
{
strwhere += " and ActivityDate>='" + begindate + "'";
}
if (!string.IsNullOrEmpty(enddate))
{
strwhere += " and ActivityDate<='" + enddate + "'";
}
data = database.FindTableBySql("select [clubactivityinfoid],[clubname],[clubactivitytypeid],[activitydate],[activitycost],[createtime],[createuserid],[isshow] ,[isdelete],[createusername],[clubactivitytypename] from C_ClubActivityInfoView where " + strwhere + " order by ClubActivityInfoId desc");
AppLibrary.WriteExcel.XlsDocument doc = new AppLibrary.WriteExcel.XlsDocument();
// HttpContext.Current.Response.Write();
doc.FileName = DateTime.Now.ToString("yyyyMMddHHmmss") + ".xls";
string sheetname = "SHEET";
Worksheet sheet = doc.Workbook.Worksheets.Add(sheetname);
Cells cells = sheet.Cells;
XF XFstyle = doc.NewXF();
XFstyle.HorizontalAlignment = HorizontalAlignments.Centered;
cells.Add(1, 1, "车主俱乐部名称");
cells.Add(1, 2, "活动类别");
cells.Add(1, 3, "日期");
cells.Add(1, 4, "活动成本");
int f = 1;
for (int i = 0; i < data.Rows.Count; i++)
{
f++;
cells.Add(f, 1, data.Rows[i]["clubname"]);
cells.Add(f, 2, data.Rows[i]["clubactivitytypename"]);
cells.Add(f, 3, DateTime.Parse(data.Rows[i]["activitydate"].ToString()).ToString("yyyy-MM-dd"));
cells.Add(f, 4, data.Rows[i]["activitycost"]);
}
doc.Send();
HttpContext.Current.Response.Flush();
HttpContext.Current.Response.End();
}
public void Print()
{
//区域
var activitareaid = HttpContext.Current.Request.QueryString["activitareaid"].ToString();
//经销商
var agencyid = HttpContext.Current.Request.QueryString["agencyid"].ToString();
//类型
var saleactivitytypeid = HttpContext.Current.Request.QueryString["saleactivitytypeid"].ToString();
var begindate = HttpContext.Current.Request.QueryString["begindate"].ToString();
var enddate = HttpContext.Current.Request.QueryString["enddate"].ToString();
IDatabase database = DataFactory.Database();
IRepository <ActivityViewModel> re = new Repository <ActivityViewModel>();
DataTable data = new DataTable();
string strwhere = "";
if (!string.IsNullOrEmpty(activitareaid))
{
strwhere += " and ActivitAreaId=" + activitareaid;
}
if (!string.IsNullOrEmpty(agencyid))
{
strwhere += " and AgencyId=" + agencyid;
}
if (!string.IsNullOrEmpty(saleactivitytypeid))
{
strwhere += " and SaleActivityTypeId=" + saleactivitytypeid;
}
if (!string.IsNullOrEmpty(begindate))
{
strwhere += " and ActivityDate>='" + begindate + "'";
}
if (!string.IsNullOrEmpty(enddate))
{
strwhere += " and ActivityDate<='" + enddate + "'";
}
data = database.FindTableBySql("select * from View_Activity where IsDelete=0 " + strwhere + "");
var newd = data.Columns.Add("publishwaycontent", typeof(String));
var list = new Utilities.PublishWay().ToSelectListItem();
for (int i = 0; i < data.Rows.Count; i++)
{
string str = data.Rows[i]["publishway"].ToString();
if (!string.IsNullOrEmpty(str))
{
string[] arrstr = str.Split(',');
string publishwaycontent = "";
if (!string.IsNullOrEmpty(str))
{
foreach (var item in list)
{
foreach (var item1 in arrstr)
{
if (item.Value == item1)
{
publishwaycontent += item.Text + ",";
}
}
}
}
data.Rows[i]["publishwaycontent"] = publishwaycontent.Substring(0, publishwaycontent.Length - 1);
}
else
{
data.Rows[i]["publishwaycontent"] = "";
}
}
AppLibrary.WriteExcel.XlsDocument doc = new AppLibrary.WriteExcel.XlsDocument();
// HttpContext.Current.Response.Write();
doc.FileName = DateTime.Now.ToString("yyyyMMddHHmmss") + ".xls";
string sheetname = "SHEET";
Worksheet sheet = doc.Workbook.Worksheets.Add(sheetname);
Cells cells = sheet.Cells;
XF XFstyle = doc.NewXF();
XFstyle.HorizontalAlignment = HorizontalAlignments.Centered;
cells.Add(1, 1, "经销商名称");
cells.Add(1, 2, "区域");
cells.Add(1, 3, "日期");
cells.Add(1, 4, "活动类别");
cells.Add(1, 5, "活动客流量");
cells.Add(1, 6, "活动潜客量");
cells.Add(1, 7, "活动车主量");
cells.Add(1, 8, "活动现场订单量");
cells.Add(1, 9, "活动成本金额");
cells.Add(1, 10, "活动后续订单量");
cells.Add(1, 11, "宣传类型");
int f = 1;
for (int i = 0; i < data.Rows.Count; i++)
{
f++;
cells.Add(f, 1, data.Rows[i]["agencyname"]);
cells.Add(f, 2, data.Rows[i]["activityareaname"]);
cells.Add(f, 3, DateTime.Parse(data.Rows[i]["activitydate"].ToString()).ToString("yyyy-MM-dd"));
cells.Add(f, 4, data.Rows[i]["saleactivitytypename"]);
cells.Add(f, 5, data.Rows[i]["passengerflow"]);
cells.Add(f, 6, data.Rows[i]["latentpassengerflow"]);
cells.Add(f, 7, data.Rows[i]["carowner"]);
cells.Add(f, 8, data.Rows[i]["orderquantity"]);
cells.Add(f, 9, data.Rows[i]["primecost"]);
cells.Add(f, 10, data.Rows[i]["laterorderquantity"]);
cells.Add(f, 11, data.Rows[i]["publishwaycontent"]);
}
doc.Send();
HttpContext.Current.Response.Flush();
HttpContext.Current.Response.End();
}