private void InitExcelData()
{
try
{
DataSet ds;
DataTable dt = new DataTable();
string startime = Request.Form["startime"]; // this.startime.Text;
string endtime = Request.Form["endtime"]; //this.endtime.Text;
string str = "";
if (startime != "" || endtime != "")
{
str = "updateTime between '" + startime + "' and '" + endtime + "' order by id desc";
}
else
{
str = "";
}
ds = bllorder.GetList(str);
dt = ds.Tables[0];
if (dt != null && dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
excel.RowStart();
excel.CellWithoutFormula("String", dt.Rows[i]["order_num"].ToString());
excel.CellWithoutFormula("String", getUserName(Convert.ToInt32(dt.Rows[i]["user_id"].ToString())));
excel.CellWithoutFormula("String", dt.Rows[i]["quantity_sum"].ToString());
excel.CellWithoutFormula("String", Convert.ToDecimal(dt.Rows[i]["price_sum"]).ToString("0.00"));
excel.CellWithoutFormula("String", dt.Rows[i]["integral_sum"].ToString());
excel.CellWithoutFormula("String", getOrderStaute(dt.Rows[i]["order_status"].ToString()));
excel.CellWithoutFormula("String", dt.Rows[i]["note"].ToString());
excel.CellWithoutFormula("String", dt.Rows[i]["updateTime"].ToString());
excel.RowEnd();
excelRows++;
}
excel.CreateExcelWithMode(excelRows, excelColumns, DateTime.Now.ToShortDateString() + "-DBE积分兑换订单报表");
}
else
{
JscriptMsg("没有符合的数据信息！", "orderlist.aspx", "Error");
}
}
catch
{
}
}