/// <summary>
/// 绑定数据源
/// </summary>
private void DataBindGrid(bool isQuery = false)
{
VehicleManager vehicleManager = new VehicleManager();
int count = 0;
int pageIndex = isQuery ? 1 : PageControl1.PageIndex;
KeyValuePair <StringBuilder, IList <SqlParam> > keyValue = InitCondition();
DataTable dt = vehicleManager.GetVehicleInfoPage(keyValue.Key, keyValue.Value, pageIndex, PageControl1.PageSize, ref count);
ControlBindHelper.BindRepeaterList(dt, rp_Item);
this.PageControl1.PageIndex = pageIndex;
this.PageControl1.RecordCount = Convert.ToInt32(count);
this.PageControl1.PageChecking();
}
protected void lbtExport_Click(object sender, EventArgs e)
{
VehicleManager vehicleManager = new VehicleManager();
int count = 0;
int pageIndex = 1;
KeyValuePair <StringBuilder, IList <SqlParam> > keyValue = InitCondition();
DataTable dt = vehicleManager.GetVehicleInfoPage(keyValue.Key, keyValue.Value, pageIndex, 1000000000, ref count);
StringBuilder s = new StringBuilder();
s.AppendLine("<meta http-equiv=\"Content-Type\" content=\"text/html; charset=utf-8\">");
s.AppendLine("<table cellspacing=\"0\" cellpadding=\"5\" rules=\"all\" border=\"1\">");
//写出列名
s.AppendLine("<tr style=\"font-weight: bold; white-space: nowrap;\">");
s.AppendLine("<td>车辆名称</td><td>型号</td><td>车牌号</td><td>电量</td><td>所属平台</td><td>所属城市</td><td>使用状态</td><td>车辆状态</td><td>电源状态</td><td>在线状态</td><td>最近更新</td>");
s.AppendLine("</tr>");
//写数据
foreach (DataRow row in dt.Rows)
{
s.Append("<tr>");
s.Append("<td>'").Append(row["Name"].ToString()).Append("</td>");
s.Append("<td>").Append(row["modelName"].ToString()).Append("</td>");
s.Append("<td>'").Append(row["LicenseNumber"].ToString());
s.Append("<td>'").Append(row["Electricity"].ToString()).Append("</td>");
s.Append("<td>").Append(row["Platform"].ToString()).Append("</td>");
s.Append("<td>").Append(row["VehicleCityName"].ToString()).Append("</td>");
s.Append("<td>").Append(Asiasofti.SmartVehicle.Common.EnumHelper.GetEnumShowName(typeof(Asiasofti.SmartVehicle.Common.Enum.VehicleUseState), Convert.ToInt32(row["UseState"].ToString()))).Append("</td>");
s.Append("<td>").Append(Asiasofti.SmartVehicle.Common.EnumHelper.GetEnumShowName(typeof(Asiasofti.SmartVehicle.Common.Enum.VehicleState), Convert.ToInt32(row["VehicleState"].ToString()))).Append("</td>");
s.Append("<td>").Append(row["LockState"].ToString() == "lock" ? "已关" : "已开").Append("</td>");
s.Append("<td>").Append(row["LightState"].ToString() == "on" ? "已开灯" : "已关灯").Append("</td>");
s.Append("<td>").Append(int.Parse(row["diffminutes"].ToString()) < 5 ? "在线" : "离线").Append("</td>");
s.Append("<td>").Append(row["LastUpdateTime"].ToString()).Append("</td>");
s.AppendLine("</tr>");
}
s.AppendLine("</table>");
this.Page.Response.ContentType = "application/vnd.ms-excel";
this.Page.Response.ContentEncoding = System.Text.Encoding.UTF8;
this.Page.Response.Charset = "utf-8";
string filename = "车辆列表_" + DateTime.Now.ToString("yyyyMMddHHmmss") + ".xls";
this.Page.Response.AppendHeader("Content-Disposition", "attachment;filename=" + HttpUtility.UrlEncode(filename));
this.Page.Response.Write(s.ToString());
this.Page.Response.End();
}
