protected void Page_Load(object sender, EventArgs e)
{
string Type=Request.Form.Get("type");
//Section "Восстановить у пользователя"
if (Type == DOWNLOAD_FILE_RECOVER_USER)
{
if (Request.Form.Get("dataBlockId") != null)
{
int dataBlockId = Convert.ToInt32(Request.Form.Get("dataBlockId"));
string connectionString = ConfigurationManager.AppSettings["fleetnetbaseConnectionString"];
DataBlock dataBlock = new DataBlock(connectionString, ConfigurationManager.AppSettings["language"]);
dataBlock.OpenConnection();
byte[] fileBytes = dataBlock.GetDataBlock_BytesArray(dataBlockId);
string fileName = dataBlock.GetDataBlock_FileName(dataBlockId);
dataBlock.CloseConnection();
Response.Clear();
Response.AddHeader("Content-Disposition", String.Format("attachment;filename=\"{0}\"", fileName));
Response.AddHeader("Content-Length", fileBytes.Length.ToString());
Response.ContentType = "application/octet-stream";
Response.OutputStream.Write(fileBytes, 0, fileBytes.Length);
Response.End();
return;
}
}
//Section "PLF Файлы"
if (Type == GET_PLF_REPORT)
{
string CardID=Request.Form.Get("CardID");
string PLFID=Request.Form.Get("PLFID");
string UserName = Request.Form.Get("UserName");
string Format = Request.Form.Get("Format");
string ReportType = Request.Form.Get("ReportType");
if (string.IsNullOrEmpty(ReportType))
{
ReportType = "Полный отчет";
}
int dataBlockId = int.Parse(PLFID);
List<int> dataBlockIDS = new List<int>();
dataBlockIDS.Add(dataBlockId);
int cardID = int.Parse(CardID);
string connectionString = System.Configuration.ConfigurationManager.AppSettings["fleetnetbaseConnectionString"];
BLL.DataBlock dataBlock = new BLL.DataBlock(connectionString, ConfigurationManager.AppSettings["language"]);
dataBlock.OpenConnection();
DateTime from = new DateTime();
from = dataBlock.plfUnitInfo.Get_START_PERIOD(dataBlockId);
DateTime to = new DateTime();
to = dataBlock.plfUnitInfo.Get_END_PERIOD(dataBlockId);
string vehicle = dataBlock.plfUnitInfo.Get_VEHICLE(dataBlockId);
string deviceID = dataBlock.plfUnitInfo.Get_ID_DEVICE(dataBlockId);
DataSet dataset = new DataSet();
int userId = dataBlock.usersTable.Get_UserID_byName(UserName);
List<PLFUnit.PLFRecord> records = new List<PLFUnit.PLFRecord>();
dataset = ReportDataSetLoader.Get_PLF_ALLData(dataBlockIDS,
new DateTime(from.Year, from.Month, from.Day), new DateTime(to.Year, to.Month, to.Day),
cardID, userId, ref records);
dataBlock.CloseConnection();
//gets table PlfHeader_1
DataTable dt = dataset.Tables[0];
//gets the first row
DataRow dr = dt.Rows[0];
string driverName = dr["Имя водителя"].ToString();
//load needed template
string path = HttpContext.Current.Server.MapPath("~/templates_plf") + "\\";
XtraReport report = new XtraReport();
report.LoadLayout(path + ReportType+".repx");
report.DataSource = dataset;
MemoryStream reportStream = new MemoryStream();
switch (Format)
{
case "html": report.ExportToHtml(reportStream); break;
case "pdf": report.ExportToPdf(reportStream); break;
case "rtf": report.ExportToRtf(reportStream); break;
case "png": report.ExportToImage(reportStream,ImageFormat.Png); break;
}
Response.Clear();
Response.AddHeader("Content-Disposition", String.Format("attachment;filename=\"{0}\"", "Отчет " + driverName + " " +
new DateTime(from.Year, from.Month, from.Day).ToString("dd_MM_yyyy") + "-" + new DateTime(to.Year, to.Month, to.Day).ToString("dd_MM_yyyy") + "." + Format));
Response.AddHeader("Content-Length", reportStream.GetBuffer().Length.ToString());
Response.ContentType = "application/octet-stream";
Response.OutputStream.Write(reportStream.GetBuffer(), 0, reportStream.GetBuffer().Length);
Response.End();
return;
}
if (Type == GET_PLF_REPORT_FOR_PERIOD)
{
string CardID = Request.Form.Get("CardID");
string StartDate = Request.Form.Get("StartDate");
string EndDate = Request.Form.Get("EndDate");
string UserName = Request.Form.Get("UserName");
string Format = Request.Form.Get("Format");
string ReportType = Request.Form.Get("ReportType");
if (string.IsNullOrEmpty(ReportType))
{
ReportType = "Полный отчет";
}
int cardID = int.Parse(CardID);
string connectionString = System.Configuration.ConfigurationManager.AppSettings["fleetnetbaseConnectionString"];
BLL.DataBlock dataBlock = new BLL.DataBlock(connectionString, ConfigurationManager.AppSettings["language"]);
dataBlock.OpenConnection();
DateTime from = DateTime.Parse(StartDate);
DateTime to = DateTime.Parse(EndDate);
DataSet dataset = new DataSet();
List<int> dataBlockIDS = dataBlock.cardsTable.GetAllDataBlockIds_byCardId(cardID);
int userId = dataBlock.usersTable.Get_UserID_byName(UserName);
List<PLFUnit.PLFRecord> records = new List<PLFUnit.PLFRecord>();
dataset = ReportDataSetLoader.Get_PLF_ALLData(dataBlockIDS,
new DateTime(from.Year, from.Month, from.Day), new DateTime(to.Year, to.Month, to.Day),
cardID, userId, ref records);
dataBlock.CloseConnection();
//gets table PlfHeader_1
DataTable dt = dataset.Tables[0];
//gets the first row
DataRow dr = dt.Rows[0];
string driverName = dr["Имя водителя"].ToString();
//load needed template
string path = HttpContext.Current.Server.MapPath("~/templates_plf") + "\\";
XtraReport report = new XtraReport();
report.LoadLayout(path + ReportType + ".repx");
report.DataSource = dataset;
MemoryStream reportStream = new MemoryStream();
switch (Format)
{
case "html": report.ExportToHtml(reportStream); break;
case "pdf": report.ExportToPdf(reportStream); break;
case "rtf": report.ExportToRtf(reportStream); break;
case "png": report.ExportToImage(reportStream, ImageFormat.Png); break;
}
Response.Clear();
Response.AddHeader("Content-Disposition", String.Format("attachment;filename=\"{0}\"", "Отчет " + driverName + " " +
new DateTime(from.Year, from.Month, from.Day).ToString("dd_MM_yyyy") + "-" + new DateTime(to.Year, to.Month, to.Day).ToString("dd_MM_yyyy") + "." + Format));
Response.AddHeader("Content-Length", reportStream.GetBuffer().Length.ToString());
Response.ContentType = "application/octet-stream";
Response.OutputStream.Write(reportStream.GetBuffer(), 0, reportStream.GetBuffer().Length);
Response.End();
return;
}
//Section "Транспортные средства"
if (Type == GET_DDD_REPORT)
{
string DataBlockID = Request.Form.Get("DataBlockID");
string UserName = Request.Form.Get("UserName");
string Format = Request.Form.Get("Format");
string ReportType = Request.Form.Get("ReportType");
if (string.IsNullOrEmpty(ReportType))
{
ReportType = "Полный отчет";
}
int dataBlockId = int.Parse(DataBlockID);
List<int> dataBlockIDS = new List<int>();
dataBlockIDS.Add(dataBlockId);
string connectionString = System.Configuration.ConfigurationManager.AppSettings["fleetnetbaseConnectionString"];
DataBlock dataBlock = new DataBlock(connectionString, ConfigurationManager.AppSettings["language"]);
dataBlock.OpenConnection();
DataSet dataset = new DataSet();
string VIN = dataBlock.vehicleUnitInfo.Get_VehicleOverview_IdentificationNumber(dataBlockId).ToString();
string RegNumb = dataBlock.vehicleUnitInfo.Get_VehicleOverview_RegistrationIdentification(dataBlockId).vehicleRegistrationNumber.ToString();
int vehicleId = dataBlock.vehiclesTables.GetVehicleId_byVinRegNumbers(VIN, RegNumb);
List<DateTime> vehsCardPeriod = dataBlock.vehicleUnitInfo.Get_StartEndPeriod(dataBlockId);
int userId = dataBlock.usersTable.Get_UserID_byName(UserName);
dataset = ReportDataSetLoader.Get_Vehicle_ALLDate(vehicleId,
dataBlockIDS, vehsCardPeriod[0], vehsCardPeriod[1], userId);
dataBlock.CloseConnection();
//load needed template
string path = HttpContext.Current.Server.MapPath("~/templates_ddd") + "\\";
XtraReport report = new XtraReport();
report.LoadLayout(path + ReportType + ".repx");
report.DataSource = dataset;
MemoryStream reportStream = new MemoryStream();
switch (Format)
{
case "html": report.ExportToHtml(reportStream); break;
case "pdf": report.ExportToPdf(reportStream); break;
case "rtf": report.ExportToRtf(reportStream); break;
case "png": report.ExportToImage(reportStream, ImageFormat.Png); break;
}
Response.Clear();
Response.AddHeader("Content-Disposition", String.Format("attachment;filename=\"{0}\"", "Отчет " + VIN + "_" + RegNumb + " " +
vehsCardPeriod[0].ToString("dd_MM_yyyy") + "-" + vehsCardPeriod[1].ToString("dd_MM_yyyy") + "." + Format));
Response.AddHeader("Content-Length", reportStream.GetBuffer().Length.ToString());
Response.ContentType = "application/octet-stream";
Response.OutputStream.Write(reportStream.GetBuffer(), 0, reportStream.GetBuffer().Length);
Response.End();
return;
}
//Section "Транспортные средства"
if (Type == GET_DDD_REPORT_FOR_PERIOD)
{
string CardID = Request.Form.Get("CardID");
string StartDate = Request.Form.Get("StartDate");
string EndDate = Request.Form.Get("EndDate");
string UserName = Request.Form.Get("UserName");
string Format = Request.Form.Get("Format");
string ReportType = Request.Form.Get("ReportType");
if (string.IsNullOrEmpty(ReportType))
{
ReportType = "Полный отчет";
}
string connectionString = System.Configuration.ConfigurationManager.AppSettings["fleetnetbaseConnectionString"];
DataBlock dataBlock = new DataBlock(connectionString, ConfigurationManager.AppSettings["language"]);
dataBlock.OpenConnection();
DataSet dataset = new DataSet();
int cardId = int.Parse(CardID);
string VIN = dataBlock.vehiclesTables.GetVehicleVin(cardId);
string RegNumb = dataBlock.vehiclesTables.GetVehicleGOSNUM(cardId);
int vehicleId = dataBlock.vehiclesTables.GetVehicle_byCardId(cardId);
List<int> dataBlockIDS = dataBlock.cardsTable.GetAllDataBlockIds_byCardId(cardId);
int userId = dataBlock.usersTable.Get_UserID_byName(UserName);
DateTime from = DateTime.Parse(StartDate);
DateTime to = DateTime.Parse(EndDate);
dataset = ReportDataSetLoader.Get_Vehicle_ALLDate(vehicleId,
dataBlockIDS, from, to, userId);
dataBlock.CloseConnection();
//load needed template
string path = HttpContext.Current.Server.MapPath("~/templates_ddd") + "\\";
XtraReport report = new XtraReport();
report.LoadLayout(path + ReportType + ".repx");
report.DataSource = dataset;
MemoryStream reportStream = new MemoryStream();
switch (Format)
{
case "html": report.ExportToHtml(reportStream); break;
case "pdf": report.ExportToPdf(reportStream); break;
case "rtf": report.ExportToRtf(reportStream); break;
case "png": report.ExportToImage(reportStream, ImageFormat.Png); break;
}
Response.Clear();
Response.AddHeader("Content-Disposition", String.Format("attachment;filename=\"{0}\"", "Отчет " + VIN + "_" + RegNumb + " " +
from.ToString("dd_MM_yyyy") + "-" + to.ToString("dd_MM_yyyy") + "." + Format));
Response.AddHeader("Content-Length", reportStream.GetBuffer().Length.ToString());
Response.ContentType = "application/octet-stream";
Response.OutputStream.Write(reportStream.GetBuffer(), 0, reportStream.GetBuffer().Length);
Response.End();
return;
}
}