protected void Page_Load(object sender, EventArgs e)
{
string html = "";
int month = 0;
int year = 0;
int person_id = 0;
SQLDB sql = new SQLDB();
Date dt = new Date();
MonthDB mdb = new MonthDB();
if (Request.QueryString["month"] != null)
month = Convert.ToInt32(Request.QueryString["month"]);
if (Request.QueryString["year"] != null)
year = Convert.ToInt32(Request.QueryString["year"]);
if (Request.QueryString["id"] != null)
person_id = Convert.ToInt32(Request.QueryString["id"]);
Employee emp = sql.getEmployee(person_id);
lbEmployeeName.Text = emp.FIO;
lbPeriodName.Text = mdb.getMonthName(month).ToUpper() + " " + year.ToString();
string start_period = dt.getDataToSAP(1, month, year);
List<CheckedHours> hours = sql.getCheckedSchedule(start_period, person_id);
if (hours.Count > 0)
{
html = @"<table cellpadding='0' cellspacing='0' class='main_table' width='270px'>
<tr style='background: url(App_Resources/header.bmp) repeat-x;' >
<td class='header_table' width='70px' style='border-left: solid 1px #999999; border-top: solid 1px #999999;' >Дата</td>
<td class='header_table' width='100px' style='border-top: solid 1px #999999;'>IT</td>
<td class='header_table' width='100px' style='border-top: solid 1px #999999;'>SAP</td>
</tr>";
foreach (CheckedHours ch in hours)
{
html += "<tr><td width='70px' style='border-left: solid 1px #999999;'>" + ch.DayDate + "</td><td width='100px'>" + ch.IT_Hours.ToString() + "</td><td width='100px'>" + ch.SAP_Hours.ToString() + "</td><tr>";
}
html += "</table>";
}
else
{
string msg = "";
if (dt.isOpen(month, year))
msg = "Введенный график совпадает с графиком SAP";
else
msg = "Нет данных";
html = "<div class='check_personal' style='width: 270px; height:50px; color: DarkRed;'>" + msg + "</div>";
}
lbTable.Text = html;
}
