You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
472 lines
17 KiB
472 lines
17 KiB
using System;
|
|
using System.Collections.Generic;
|
|
using System.Data;
|
|
using System.Linq;
|
|
using System.Web;
|
|
using System.Web.UI;
|
|
using System.Web.UI.WebControls;
|
|
using Syncfusion.XlsIO;
|
|
|
|
namespace QW2021C.Resultate
|
|
{
|
|
public partial class Auswertungen : System.Web.UI.Page
|
|
{
|
|
protected void Page_Load(object sender, EventArgs e)
|
|
{
|
|
//if (Page.IsPostBack == false) return;
|
|
//Ort_checkboxes();
|
|
}
|
|
|
|
//public void Ort_checkboxes()
|
|
//{
|
|
// clsDB db = new clsDB();
|
|
// db.Get_Tabledata("select ortnr, ort from res_ort order by sort asc", false, true);
|
|
// int i;
|
|
// i = 0;
|
|
// this.CheckBox1.Visible = false;
|
|
// this.CheckBox2.Visible = false;
|
|
// this.CheckBox3.Visible = false;
|
|
// this.CheckBox4.Visible = false;
|
|
// this.CheckBox5.Visible = false;
|
|
// this.CheckBox6.Visible = false;
|
|
// this.CheckBox7.Visible = false;
|
|
// this.CheckBox8.Visible = false;
|
|
|
|
// foreach (DataRow r in db.dsdaten.Tables[0].Rows)
|
|
// {
|
|
// i += 1;
|
|
|
|
|
|
// switch (i)
|
|
// {
|
|
// case 1:
|
|
// this.CheckBox1.Text = r["ort"].ToString();
|
|
// this.CheckBox1.Visible = true;
|
|
// break;
|
|
// case 2:
|
|
// this.CheckBox2.Text = r["ort"].ToString();
|
|
// this.CheckBox2.Visible = true;
|
|
// break;
|
|
// case 3:
|
|
// this.CheckBox3.Text = r["ort"].ToString();
|
|
// this.CheckBox3.Visible = true;
|
|
// break;
|
|
// case 4:
|
|
// this.CheckBox4.Text = r["ort"].ToString();
|
|
// this.CheckBox4.Visible = true;
|
|
// break;
|
|
// case 5:
|
|
// this.CheckBox5.Text = r["ort"].ToString();
|
|
// this.CheckBox5.Visible = true;
|
|
// break;
|
|
// case 6:
|
|
// this.CheckBox6.Text = r["ort"].ToString();
|
|
// this.CheckBox6.Visible = true;
|
|
// break;
|
|
// case 7:
|
|
// this.CheckBox7.Text = r["ort"].ToString();
|
|
// this.CheckBox7.Visible = true;
|
|
// break;
|
|
// case 8:
|
|
// this.CheckBox8.Text = r["ort"].ToString();
|
|
// this.CheckBox8.Visible = true;
|
|
|
|
// break;
|
|
// }
|
|
|
|
// }
|
|
//}
|
|
|
|
private DataTable Get_Orttabelle(string orte)
|
|
{
|
|
DataTable ortdata = new DataTable();
|
|
ortdata.Columns.Add("Ort");
|
|
string[] Ortlist = orte.Split(';');
|
|
for (int i = 0; i < Ortlist.Length; i = i + 1)
|
|
{
|
|
DataRow dr = ortdata.NewRow();
|
|
dr[0] = Ortlist[i].ToString();
|
|
ortdata.Rows.Add(dr);
|
|
}
|
|
return ortdata;
|
|
}
|
|
|
|
|
|
|
|
|
|
protected void btnAufbereiten_Click(object Sender, Syncfusion.JavaScript.Web.ButtonEventArgs e)
|
|
{
|
|
string s = "";
|
|
for (int i = 0; i < this.CheckBoxList1.Items.Count; i = i + 1)
|
|
{
|
|
if (this.CheckBoxList1.Items[i].Selected == true)
|
|
{
|
|
if (s != "") s = s + ";";
|
|
s = s + this.CheckBoxList1.Items[i].Value.ToString();
|
|
}
|
|
}
|
|
|
|
string orte = s;
|
|
string U1012 = "N";
|
|
string erdgas = "N";
|
|
string vierkampf = "N";
|
|
int ortnr = 0;
|
|
|
|
if (this.cbu10U12.Checked == true)
|
|
{
|
|
U1012 = "J";
|
|
}
|
|
|
|
DataSet ds = new DataSet();
|
|
clsDB db = new clsDB();
|
|
db.Get_Reportdata(orte, U1012, erdgas, vierkampf,ortnr,-1);
|
|
string dataname = DateTime.Now.ToString("ddMMyyyyHHmmss") + "_Rpt.xml";
|
|
|
|
DataTable ortdata = Get_Orttabelle(orte);
|
|
|
|
//ortdata.Columns.Add("Ort");
|
|
//string[] Ortlist = orte.Split(';');
|
|
//for (int i = 0;i < Ortlist.Length; i=i+1)
|
|
//{
|
|
// DataRow dr = ortdata.NewRow();
|
|
// dr[0] = Ortlist[i].ToString();
|
|
// ortdata.Rows.Add(dr);
|
|
//}
|
|
db.dsdaten.Tables[0].TableName = "_data";
|
|
ds.Tables.Add(ortdata);
|
|
ds.Tables.Add(db.dsdaten.Tables[0].Copy());
|
|
ds.WriteXml(Server.MapPath("~\\Workdir\\"+dataname));
|
|
Session["ReportDaten"] = Server.MapPath("~\\Workdir\\" + dataname);
|
|
Session["Report"] = "";
|
|
|
|
this.pnlreports.Visible = true;
|
|
string newpage ="~\\Resultate\\Report.aspx";
|
|
|
|
}
|
|
|
|
protected void btnAufbereitenEinzelort_Click(object Sender, Syncfusion.JavaScript.Web.ButtonEventArgs e)
|
|
{
|
|
string U1012 = "N";
|
|
string erdgas = "N";
|
|
string vierkampf = "N";
|
|
string s;
|
|
string orte;
|
|
int ortnr = 0;
|
|
s = this.selEinzelauswertung.Text.ToString();
|
|
clsDB db = new clsDB();
|
|
db.Get_Tabledata("Select * from res_ort where ort='" + s.ToString() + "'", false, true);
|
|
if (db.dsdaten.Tables[0].Rows.Count == 0) return;
|
|
ortnr = Convert.ToInt32(db.dsdaten.Tables[0].Rows[0][0]);
|
|
db.dsdaten.Tables.Clear();
|
|
|
|
|
|
|
|
orte = s;
|
|
DataTable ortdata = Get_Orttabelle(orte);
|
|
if (this.cbu10u12Einzel.Checked == true) U1012 = "J";
|
|
|
|
DataSet ds = new DataSet();
|
|
//clsDB db = new clsDB();
|
|
db.Get_Reportdata(orte, U1012, erdgas, vierkampf,ortnr,-1);
|
|
string dataname = DateTime.Now.ToString("ddMMyyyyHHmmss") + "_Rpt.xml";
|
|
|
|
db.dsdaten.Tables[0].TableName = "_data";
|
|
ds.Tables.Add(ortdata);
|
|
ds.Tables.Add(db.dsdaten.Tables[0].Copy());
|
|
ds.WriteXml(Server.MapPath("~\\Workdir\\" + dataname));
|
|
Session["ReportDaten"] = Server.MapPath("~\\Workdir\\" + dataname);
|
|
Session["Report"] = "";
|
|
this.pnlEinzelreport.Visible = true;
|
|
|
|
}
|
|
|
|
protected void btnAufbereitenVierkampf_Click(object Sender, Syncfusion.JavaScript.Web.ButtonEventArgs e)
|
|
{
|
|
Session["Kopfzeile1"] = this.Kopfzeile1.Text;
|
|
Session["Titel"] = this.Titel.Text;
|
|
Session["Stadion"] = this.Stadion.Text;
|
|
Session["Organisator"] = this.Organisator.Text;
|
|
Session["Datum"] = this.Datum.Text;
|
|
Session["Wettkampfnr"] = this.Wettkampfnr.Text;
|
|
Session["Anzahl_Athleten"] = this.txtanzahl.Text.ToString();
|
|
string U1012 = "N";
|
|
string erdgas = "N";
|
|
string vierkampf = "J";
|
|
string s;
|
|
string s1;
|
|
string orte;
|
|
string Anzahl_Athleten = this.txtanzahl.Text.ToString();
|
|
int anz_athleten = 0;
|
|
if ( Anzahl_Athleten != "")
|
|
{
|
|
anz_athleten = Convert.ToInt32(Anzahl_Athleten);
|
|
}
|
|
else
|
|
{
|
|
anz_athleten = -1;
|
|
}
|
|
int ortnr = 0;
|
|
s = this.selUBSErdgas.Value.ToString();
|
|
try {
|
|
s1 = this.selUBSErdgas1.Value.ToString();
|
|
}
|
|
catch {
|
|
s1 = "";
|
|
}
|
|
|
|
if (s == "") return;
|
|
|
|
clsDB db = new clsDB();
|
|
db.Get_Tabledata("Select * from res_ort where ort='" + s.ToString() + "'", false, true);
|
|
if (db.dsdaten.Tables[0].Rows.Count == 0) return;
|
|
ortnr = Convert.ToInt32(db.dsdaten.Tables[0].Rows[0][0]);
|
|
db.dsdaten.Tables.Clear();
|
|
|
|
|
|
orte = s;
|
|
DataTable ortdata = Get_Orttabelle(orte);
|
|
if (this.cbu10u12Einzel.Checked == true) U1012 = "J";
|
|
|
|
if (s1!="") { orte = orte + ";" + s1; };
|
|
|
|
DataSet ds = new DataSet();
|
|
db.Get_Reportdata(orte, U1012, erdgas, vierkampf,ortnr, anz_athleten);
|
|
string dataname = DateTime.Now.ToString("ddMMyyyyHHmmss") + "_Rpt.xml";
|
|
|
|
db.dsdaten.Tables[0].TableName = "_mehrkampf";
|
|
ds.Tables.Add(ortdata);
|
|
ds.Tables.Add(db.dsdaten.Tables[0].Copy());
|
|
ds.WriteXml(Server.MapPath("~\\Workdir\\" + dataname));
|
|
Session["ReportDaten"] = Server.MapPath("~\\Workdir\\" + dataname);
|
|
Session["Report"] = "";
|
|
Session["xmldata"] = Session["ReportDaten"];
|
|
this.PnlVierkampfUBS.Visible = true;
|
|
}
|
|
|
|
protected void btnAufbereitenUKC_Click(object Sender, Syncfusion.JavaScript.Web.ButtonEventArgs e)
|
|
{
|
|
Session["Kopfzeile1"] = this.Kopfzeile1.Text;
|
|
Session["Titel"] = this.Titel.Text;
|
|
Session["Stadion"] = this.Stadion.Text;
|
|
Session["Organisator"] = this.Organisator.Text;
|
|
Session["Datum"] = this.Datum.Text;
|
|
Session["Wettkampfnr"] = this.Wettkampfnr.Text;
|
|
string U1012 = "N";
|
|
string erdgas = "J";
|
|
string vierkampf = "N";
|
|
string s;
|
|
string orte;
|
|
int ortnr = 0;
|
|
s = this.selUBSErdgas.Text.ToString();
|
|
clsDB db = new clsDB();
|
|
db.Get_Tabledata("Select * from res_ort where ort='" + s.ToString() + "'", false, true);
|
|
if (db.dsdaten.Tables[0].Rows.Count == 0) return;
|
|
ortnr = Convert.ToInt32(db.dsdaten.Tables[0].Rows[0][0]);
|
|
db.dsdaten.Tables.Clear();
|
|
|
|
orte = s;
|
|
|
|
DataTable ortdata = Get_Orttabelle(orte);
|
|
if (this.cbu10u12Einzel.Checked == true) U1012 = "J";
|
|
|
|
DataSet ds = new DataSet();
|
|
|
|
db.Get_Reportdata(orte, U1012, erdgas, vierkampf,ortnr,-1);
|
|
string dataname = DateTime.Now.ToString("ddMMyyyyHHmmss") + "_Rpt.xml";
|
|
|
|
db.dsdaten.Tables[0].TableName = "_mehrkampf";
|
|
ds.Tables.Add(ortdata);
|
|
ds.Tables.Add(db.dsdaten.Tables[0].Copy());
|
|
ds.WriteXml(Server.MapPath("~\\Workdir\\" + dataname));
|
|
Session["ReportDaten"] = Server.MapPath("~\\Workdir\\" + dataname);
|
|
Session["Report"] = "";
|
|
this.PnlVierkampfUBS.Visible = true;
|
|
}
|
|
|
|
|
|
//protected void btn_aufbereiten_Statistik1(object Sender, Syncfusion.JavaScript.Web.ButtonEventArgs e)
|
|
protected void btn_aufbereiten_Statistik1(object sender, EventArgs e)
|
|
|
|
{
|
|
Session["Kopfzeile1"] = this.StatistikTitel.Text.ToString();
|
|
Session["Titel"] = this.Titel.Text;
|
|
Session["Stadion"] = this.Stadion.Text;
|
|
Session["Organisator"] = this.Organisator.Text;
|
|
Session["Datum"] = this.Datum.Text;
|
|
Session["Wettkampfnr"] = this.Wettkampfnr.Text;
|
|
Session["Anzahl_Athleten"] = this.txtanzahl.Text.ToString();
|
|
string U1012 = "N";
|
|
string erdgas = "N";
|
|
string vierkampf = "J";
|
|
string s;
|
|
string s1;
|
|
string orte;
|
|
string Anzahl_Athleten = this.StatistikAnzAthleten.Text.ToString();
|
|
int anz_athleten = 0;
|
|
if (Anzahl_Athleten != "")
|
|
{
|
|
anz_athleten = Convert.ToInt32(Anzahl_Athleten);
|
|
}
|
|
else
|
|
{
|
|
anz_athleten = -1;
|
|
}
|
|
int ortnr = 0;
|
|
s = this.Statistikort1.Value.ToString();
|
|
try
|
|
{
|
|
s1 = this.Statistikort2.Value.ToString();
|
|
}
|
|
catch
|
|
{
|
|
s1 = "";
|
|
}
|
|
|
|
if (s == "") return;
|
|
|
|
clsDB db = new clsDB();
|
|
db.Get_Tabledata("Select * from res_ort where ort='" + s.ToString() + "'", false, true);
|
|
if (db.dsdaten.Tables[0].Rows.Count == 0) return;
|
|
ortnr = Convert.ToInt32(db.dsdaten.Tables[0].Rows[0][0]);
|
|
db.dsdaten.Tables.Clear();
|
|
|
|
|
|
orte = s;
|
|
DataTable ortdata = Get_Orttabelle(orte);
|
|
if (this.StatistikU10inU12.Checked == true) U1012 = "J";
|
|
|
|
if (s1 != "") { orte = orte + ";" + s1; };
|
|
|
|
DataSet ds = new DataSet();
|
|
db.Get_Reportdata(orte, U1012, erdgas, vierkampf, ortnr, anz_athleten);
|
|
string dataname = DateTime.Now.ToString("ddMMyyyyHHmmss") + "_Rpt.xml";
|
|
|
|
db.dsdaten.Tables[0].TableName = "_mehrkampf";
|
|
ds.Tables.Add(ortdata);
|
|
ds.Tables.Add(db.dsdaten.Tables[0].Copy());
|
|
ds.WriteXml(Server.MapPath("~\\Workdir\\" + dataname));
|
|
Session["ReportDaten"] = Server.MapPath("~\\Workdir\\" + dataname);
|
|
Session["Report"] = "";
|
|
Session["ReportName"] = "Statistik1.frx";
|
|
Session["xmldata"] = Session["ReportDaten"];
|
|
Session["param1"] = "Punkteauswertung Team/Verein";
|
|
Session["param2"] = orte;
|
|
Session["param3"] = anz_athleten.ToString();
|
|
Session["param4"] = "";
|
|
Session["param5"] = "";
|
|
string excelname = "";
|
|
using (ExcelEngine excelEngine = new ExcelEngine())
|
|
{
|
|
//Initialize Application
|
|
IApplication application = excelEngine.Excel;
|
|
|
|
//Set the default application version as Excel 2016
|
|
application.DefaultVersion = ExcelVersion.Excel2016;
|
|
|
|
//Create a new workbook
|
|
IWorkbook workbook = application.Workbooks.Create(1);
|
|
|
|
//Access first worksheet from the workbook instance
|
|
IWorksheet worksheet = workbook.Worksheets[0];
|
|
|
|
//Exporting DataTable to worksheet
|
|
|
|
DataTable dataTable = db.dsdaten.Tables[0];
|
|
worksheet.ImportDataTable(dataTable, true, 1, 1);
|
|
worksheet.UsedRange.AutofitColumns();
|
|
|
|
//Save the workbook to disk in xlsx format
|
|
string targetFolder = HttpContext.Current.Server.MapPath("~/Downloads");
|
|
//this.Button1.Enabled = false;
|
|
|
|
dataname = "";
|
|
excelname = DateTime.Now.ToString("ddMMyyyyHHmmss") + "_";
|
|
dataname = DateTime.Now.ToString("ddMMyyyyHHmmss") + "_";
|
|
excelname = excelname + "Exceldata.xlsx";
|
|
dataname = dataname + "XMLData.xml";
|
|
|
|
|
|
workbook.SaveAs(targetFolder + "\\" + excelname);
|
|
workbook.Close();
|
|
|
|
}
|
|
|
|
|
|
this.pnlpunkteauswertung.Visible = true;
|
|
this.HyperLink6.NavigateUrl = "~/Reporting/Reporting.aspx";
|
|
this.HyperLink6.Target = "_blank";
|
|
this.HyperLink6.Text = "PDF-Report";
|
|
this.HyperLink6.Visible = true;
|
|
|
|
this.HyperLink7.NavigateUrl = "~/Administration/Downloader.aspx?fn=" + excelname;
|
|
this.HyperLink7.Target = "_blank";
|
|
this.HyperLink7.Text = "Download";
|
|
|
|
|
|
}
|
|
protected void btn_aufbereiten_Statistik2(object sender, EventArgs e)
|
|
|
|
{
|
|
Session["Kopfzeile1"] = this.StatistikTitel.Text.ToString();
|
|
Session["Titel"] = this.Titel.Text;
|
|
Session["Stadion"] = this.Stadion.Text;
|
|
Session["Organisator"] = this.Organisator.Text;
|
|
Session["Datum"] = this.Datum.Text;
|
|
Session["Wettkampfnr"] = this.Wettkampfnr.Text;
|
|
Session["Anzahl_Athleten"] = this.txtanzahl.Text.ToString();
|
|
string U1012 = "N";
|
|
string erdgas = "N";
|
|
string vierkampf = "J";
|
|
string s;
|
|
string s1;
|
|
string orte;
|
|
string Anzahl_Athleten = this.StatistikAnzAthleten.Text.ToString();
|
|
int anz_athleten = 0;
|
|
if (Anzahl_Athleten != "")
|
|
{
|
|
anz_athleten = Convert.ToInt32(Anzahl_Athleten);
|
|
}
|
|
else
|
|
{
|
|
anz_athleten = -1;
|
|
}
|
|
int ortnr = 0;
|
|
s = this.Statistikort1.Value.ToString();
|
|
try
|
|
{
|
|
s1 = this.Statistikort2.Value.ToString();
|
|
}
|
|
catch
|
|
{
|
|
s1 = "";
|
|
}
|
|
|
|
if (s == "") return;
|
|
|
|
clsDB db = new clsDB();
|
|
db.Get_Tabledata("Select * from res_ort where ort='" + s.ToString() + "'", false, true);
|
|
if (db.dsdaten.Tables[0].Rows.Count == 0) return;
|
|
ortnr = Convert.ToInt32(db.dsdaten.Tables[0].Rows[0][0]);
|
|
db.dsdaten.Tables.Clear();
|
|
|
|
|
|
orte = s;
|
|
DataTable ortdata = Get_Orttabelle(orte);
|
|
if (this.StatistikU10inU12.Checked == true) U1012 = "J";
|
|
|
|
if (s1 != "") { orte = orte + ";" + s1; };
|
|
|
|
DataSet ds = new DataSet();
|
|
db.Get_Reportdata(orte, U1012, erdgas, vierkampf, ortnr, anz_athleten);
|
|
|
|
db.dsdaten.Tables[0].TableName = "_mehrkampf";
|
|
ds.Tables.Add(ortdata);
|
|
ds.Tables.Add(db.dsdaten.Tables[0].Copy());
|
|
|
|
|
|
|
|
}
|
|
}
|
|
|
|
|
|
} |