protected void Page_Load(object sender, EventArgs e)
{
if (Session["User"] == null) Response.Redirect("Default.aspx");
Display disp = new Display();
Date dt = new Date();
SAPDB db = new SAPDB();
SQLDB sql = new SQLDB();
PeriodDB perdb = new PeriodDB();
Person user = (Person)Session["User"];
//List<Role> rol = user.Roles;
//foreach (Role r in rol)
// Response.Write(r.RoleID + " = " + r.RoleName);
if (!IsPostBack)
{
fillMonths();
if (Request.QueryString["data"] == null)
period.SelectedValue = dt.getMonthToday();
}
year = period.SelectedItem.Text.Substring(period.SelectedItem.Text.Length - 4);
month = period.SelectedItem.Value;
string fio = "";
string tab_number = "";
string post = "";
check = false;
closed = false;
count_days = dt.getCountDays(Convert.ToInt32(month), Convert.ToInt32(year));
if (Request.QueryString["type"] != null) role = Request.QueryString["type"].ToString();
Period per = perdb.getPeriod(Convert.ToInt32(month), Convert.ToInt32(year));
if (per.IsClosed == 1)
{
lbStatus.Text = "������";
Traffic.Text = "<img alt='' src='App_Resources/red.bmp' style='position:relative; top:4px;' />";
closed = true;
}
else Traffic.Text = "<img alt='' src='App_Resources/green.bmp' style='position:relative; top:4px;' />";
if (Request.QueryString["data"] != null)
{
EncryptedQueryString QueryString = new EncryptedQueryString(Request.QueryString["data"]);
if (QueryString["fio"] != null) fio = QueryString["fio"];
if (QueryString["tab"] != null) tab_number = QueryString["tab"];
if (QueryString["post"] != null) post = QueryString["post"];
if (QueryString["role"] != null) role = QueryString["role"];
if (QueryString["check"] != null) check = true;
if (!QueryString["month"].Equals(period.SelectedItem.Value))
{
fio = "";
tab_number = "";
post = "";
check = false;
}
}
//Response.Write(month);
//Response.Write("fio=" + fio + "tab=" + tab_number + " - " + month + "<br>");
//Response.Write(post + "<br>");
string start_date = dt.getSAPStartPeriodDate(month, year);
string end_date = dt.getSAPEndPeriodDate(month, year);
StartDateOfPeriod = start_date;
EndDateOfPeriod = end_date;
//Response.Write(start_date + end_date);
Label lb = new Label();
lb.Text = disp.DisplayDaysTabel(count_days, 18);
days.Controls.Add(lb);
//Response.Write(start_date + end_date);
//Period period_time = perdb.getPeriod(Convert.ToInt32(month), Convert.ToInt32(year));
setButtons(role);
//Response.Write(start_date + "-" + end_date + "<br>");
this.employees = null;/// db.getEmployeeList(start_date, end_date, user.TabNum, this.role);
EmployeeList emp_list = new EmployeeList();
List<Post> post_list = null;/// pl.getPosts(db.getPostList(start_date, end_date, user.TabNum, this.role));
if (post_list != null)
{
fillPosts(post_list);
}
else
{
ListItem li = new ListItem("�������� ���������");
ddl_post.Items.Add(li);
}
/*if (post != "")
{
if (post != "���")
{
EmployeeList empl = new EmployeeList();
// this.employees = empl.getEmployeesOnCurrentPost(post, employees);
}
}
if (fio != "")
{
EmployeeList emp_fio = new EmployeeList();
this.employees = emp_fio.getEmployeesByFIO(fio, employees);
}
if (tab_number != "")
{
EmployeeList emp_tab = new EmployeeList();
this.employees = emp_tab.getEmployeesByTab(tab_number, employees);
}*/
if (check)
{
EmployeeList emp_check = new EmployeeList();
/////this.employees = emp_check.getWrongCheckedEmployees(employees, count_days, hours, overhours);
}
if (employees != null)
{
DepartmentList department_list = new DepartmentList();
List<Department> departments = department_list.getDepartments(employees);
foreach (Department dep in departments)
{
Label depart = new Label();
depart.Text = disp.DisplayDepartmentName(dep.DepartmentName, dep.DepartmentID, StartDateOfPeriod);
content.Controls.Add(depart);
Label lbEmps = new Label();
lbEmps.Text = "<div id='" + dep.DepartmentID + "' style='display:none'>";
// �������� ���� �������� ��� �������� ��������
/*EmployeeList emp_list = new EmployeeList();
List<Employee> emps = emp_list.getEmployeesOfDepartment(dep.DepartmentID, employees);
EmployeeComparerByPostASC cmpByPostASC = new EmployeeComparerByPostASC();
emps.Sort(cmpByPostASC);
//for (int j = 0; j < 100; j++)
foreach (Employee em in emps)
{
lbEmps.Text += "<table cellpadding='0' cellspacing='0' border='0' class='employee'><tr><td class='main_info_left_no'> </td><td class='employee_post'>" + em.Post + "</td><td class='employee_id'>" + em.EmployeeID + "</td><td class='employee_name'><img src='App_Resources/person.gif' style='cursor: hand; cursor: pointer;'> <span style='cursor: hand; cursor: pointer;' onclick='window.open(\"" + getCardUrl(em.EmployeeID) +"\",\"displayWindow\",\"menubar=no,width=800,height=600,resizable=yes,scrollbars=yes\")'>" + em.FullName + "</span></td><td class='employee_grid_line_center'> </td><td>" + disp.DisplaySchedules(count_days, 18, em.EmployeeID, dep.DepartmentID, hours, overhours, em.Schedule, em.ScheduleDeflection, role, check, closed) + "</td><td class='main_info_right_no'></td></tr></table>";
}*/
lbEmps.Text += "</div>";
content.Controls.Add(lbEmps);
}
}
// ajax �� �������� ������ ����������� ������������� �������������
string cbReference = Page.ClientScript.GetCallbackEventReference(this, "arg", "ClientCallback", "context");
string func_name = "FillEmployeesCallback";
string cbScript = "function " + func_name + "(arg, context)" + "{" + cbReference + ";" + "}";
Page.ClientScript.RegisterClientScriptBlock(this.GetType(), func_name, cbScript, true);
}
public void GetReportTimeboard(List<Employee> all_employees, Period per)
{
SQLDB sql = new SQLDB();
Date dt = new Date();
OpenReportExcelFile(@"C:\Inetpub\wwwroot\timeboard\Reports\ReportTimeboard.xls");
Excel.Workbook workbook = (Excel.Workbook)thisApplication.Workbooks["ReportTimeboard.xls"];
Excel.Worksheet worksheet = (Excel.Worksheet)workbook.Worksheets["Sheet1"];
NightHoursDB nightdb = new NightHoursDB();
List<NightHours> nighthours = nightdb.getNightHours();
EmployeeComparerByFullnameASC emp_comp = new EmployeeComparerByFullnameASC();
all_employees.Sort(emp_comp);
int count_days = dt.getCountDays(per.MonthID, per.Year);
worksheet.Cells[1, 1] = "Таб. номер";
worksheet.Cells[1, 2] = "ФИО";
int j = 2;
int i = 1;
for (i = 1; i <= count_days; i++)
{
worksheet.Cells[1, ++j] = i;
worksheet.Cells[1, ++j] = i + "a";
}
i = 2;
foreach (Employee emp in all_employees)
{
worksheet.Cells[i, 1] = DeleteZeroFromEmployeeID(emp.EmployeeID);
worksheet.Cells[i, 2] = emp.FullName;
j = 2;
int day = 1;
EmployeeList emp_list = new EmployeeList();
List<HRHours> hr_current = sql.getHRHours(emp.EmployeeID, emp.StartPeriod, emp.BeginDate, emp.EndDate);
List<Schedule> schedule = sql.getSchedule(emp.EmployeeID, emp.StartPeriod, emp.BeginDate, emp.EndDate);
List<ScheduleDeflection> dschedule = sql.getScheduleDeflection(emp.EmployeeID, emp.StartPeriod, emp.BeginDate, emp.EndDate);
foreach (Schedule sch in schedule)
{
j++;
decimal all_hours = 0;
decimal night_hours = 0;
int d = Convert.ToInt32(sch.DayPeriod);
// если у нас день не совпадает с днем в графике, заполняю пустым квадратом
HRHours hr = hr_current.Find(delegate(HRHours hrh) { return Convert.ToInt32(hrh.Day) == day; });
if (hr != null)
{
all_hours += hr.DayOverHours + hr.NightOverHours;
night_hours += hr.NightOverHours;
}
while (d != day)
{
if (day == count_days) break;
if (all_hours != 0) worksheet.Cells[i, j] = all_hours.ToString();
if (night_hours != 0) worksheet.Cells[i, ++j] = night_hours.ToString();
else j++;
j++;
day++;
}
ScheduleDeflection sd = dschedule.Find(delegate(ScheduleDeflection dsch) { return Convert.ToInt32(dsch.DayPeriod) == day; });
if (sd != null)
{
//time = CheckDecimalNumber(sd.CodeT13);
decimal diversity = sch.TimeHours - sd.TimeHours;
if (diversity != 0)
{
if (diversity > 0)
{
all_hours = diversity;
}
else
{
all_hours = sd.TimeHours;
}
}
if (all_hours != 0) worksheet.Cells[i, j] = all_hours.ToString();
if (night_hours != 0) worksheet.Cells[i, ++j] = night_hours.ToString();
else j++;
}
else
{
// если выходной или изменение на выходной то пишем в отклонения по выходному дню
if (((sch.DaySchedule == "FREE") && (Convert.ToInt32(sch.TimeHours) == 0)) || (sch.DayScheduleVar == "F"))
{
if (all_hours != 0) worksheet.Cells[i, j] = all_hours.ToString();
if (night_hours != 0) worksheet.Cells[i, ++j] = night_hours.ToString();
else j++;
}
else
{
//decimal hour_start = Convert.ToInt32(sch.TimeBegin.Substring(0, 2));
//decimal hour_end = Convert.ToInt32(sch.TimeEnd.Substring(0, 2));
//decimal minute_start = Convert.ToDecimal(sch.TimeBegin.Substring(2, 2));
//decimal minute_end = Convert.ToDecimal(sch.TimeEnd.Substring(2, 2));
//if (hour_start == 0) hour_start = 24;
//if (hour_end == 0) hour_end = 24;\
/*
hour_start += minute_start / 60;
hour_end += minute_end / 60;
if (sch.TimeHours != 0)
{
if ((hour_start > 6) && (hour_end < 22))
all_hours += sch.TimeHours;
if (hour_start <= 6)
{
night_hours += 6 - hour_start - 1;
all_hours += sch.TimeHours;
}
if (hour_end >= 22)
{
night_hours += hour_end - 22;
all_hours += sch.TimeHours;
}
}*/
all_hours += sch.TimeHours;
NightHours nhour = nighthours.Find(delegate(NightHours nh) { return nh.DaySchedule.ToUpper() == sch.DaySchedule.ToUpper(); });
if (nhour != null)
{
night_hours += nhour.Night_Hours;
}
//day_hours += (night_hours + sch.TimeHours);
if (all_hours != 0) worksheet.Cells[i, j] = all_hours.ToString();
if (night_hours != 0) worksheet.Cells[i, ++j] = night_hours.ToString();
else j++;
}
}
day++;
}
while (day <= count_days)
{
decimal all_hours = 0;
decimal night_hours = 0;
//HRHours hr = hr_current.Find(delegate(HRHours hrh) { return Convert.ToInt32(hrh.Day) == day; });
if (all_hours != 0) worksheet.Cells[i, j] = all_hours.ToString();
if (night_hours != 0) worksheet.Cells[i, ++j] = night_hours.ToString();
else j++;
j++;
day++;
}
worksheet.Cells[i, ++j] = getCompany(emp.Department);
worksheet.Cells[i, ++j] = getPath(emp.Department);
worksheet.Cells[i, ++j] = getDepartment(emp.Department);
i++;
}
SaveReportToExcel();
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["User"] == null) Response.Redirect("Default.aspx");
Date dt = new Date();
SAPDB db = new SAPDB();
SQLDB sql = new SQLDB();
PeriodDB perdb = new PeriodDB();
NightHoursDB nightdb = new NightHoursDB();
Person user = (Person)Session["User"];
string role = "";
string month_id = "";
string year = "";
string start_date = "";
string end_date = "";
if (Request.QueryString["rtb"] != null)
{
EncryptedQueryString QueryString = new EncryptedQueryString(Request.QueryString["rtb"]);
if (QueryString["role"] != null) role = QueryString["role"].ToString();
if (QueryString["month_id"] != null) month_id = QueryString["month_id"].ToString();
if (QueryString["year"] != null) year = QueryString["year"].ToString();
if (QueryString["start_date"] != null) start_date = QueryString["start_date"].ToString();
if (QueryString["end_date"] != null) end_date = QueryString["end_date"].ToString();
}
List<NightHours> nighthours = nightdb.getNightHours();
Period per = perdb.getPeriod(Convert.ToInt32(month_id), Convert.ToInt32(year));
EmployeeList emp_list = new EmployeeList();
List<Employee> all_employees = db.getEmployeeListForReports(start_date, end_date, user.TabNum, role);
if (all_employees == null)
{
MessageBox.Show("Невозможно сформировать отчет! Список сотрудников за период пуст!");
return;
}
EmployeeComparerByFullnameASC emp_comp = new EmployeeComparerByFullnameASC();
all_employees.Sort(emp_comp);
Response.Clear();
Response.Charset = "utf-8";
Response.ContentType = "application/vnd.ms-excel";
string str = @"<table cellspacing='0' cellpadding='0' border='1'>
<tr>
<td width='30px' style='font-weight: bold;' align='center' valign='middle'>
Таб. номер
</td>
<td width='100px' style='font-weight: bold;' align='center' valign='middle'>
ФИО
</td>";
int count_days = dt.getCountDays(per.MonthID, per.Year);
for (int i = 1; i <= count_days; i++)
str += "<td width='20px' style='font-weight: bold;' align='center'>" + i.ToString() + "</td><td width='20px' style='background-color: #99CCFF; font-weight: bold;' align='center' >" + i.ToString() + "a</td>";
str += "<td> </td><td> </td><td> </td></tr>";
foreach (Employee emp in all_employees)
{
str += "<tr>";
str += "<td width='30px' align='center'>" + DeleteZeroFromEmployeeID(emp.EmployeeID) + "</td>";
str += "<td width='100px' align='center'>" + emp.FullName + "</td>";
int day = 1;
List<HRHours> hr_current = sql.getHRHours(emp.EmployeeID, emp.StartPeriod, emp.BeginDate, emp.EndDate);
List<Schedule> schedule = sql.getSchedule(emp.EmployeeID, emp.StartPeriod, emp.BeginDate, emp.EndDate);
List<ScheduleDeflection> dschedule = sql.getScheduleDeflection(emp.EmployeeID, emp.StartPeriod, emp.BeginDate, emp.EndDate);
foreach (Schedule sch in schedule)
{
decimal all_hours = 0;
decimal night_hours = 0;
int d = Convert.ToInt32(sch.DayPeriod);
// если у нас день не совпадает с днем в графике, заполняю пустым квадратом
//TimekeeperHours tkh = tkh_current.Find(delegate(TimekeeperHours h) { return Convert.ToInt32(h.Day) == day; });
HRHours hr = hr_current.Find(delegate(HRHours hrh) { return Convert.ToInt32(hrh.Day) == day; });
if (hr != null)
{
all_hours += hr.DayOverHours + hr.NightOverHours;
night_hours += hr.NightOverHours;
}
while (d != day)
{
if (day == count_days) break;
if (all_hours != 0) str += "<td width='20px' align='center'>" + all_hours.ToString() + "</td>";
else str += "<td width='20px' align='center'> </td>";
if (night_hours != 0) str += "<td width='20px' style='background-color: #99CCFF;' align='center'>" + night_hours.ToString() + "</td>";
else str += "<td width='20px' style='background-color: #99CCFF;' align='center'> </td>";
day++;
}
ScheduleDeflection sd = dschedule.Find(delegate(ScheduleDeflection dsch) { return Convert.ToInt32(dsch.DayPeriod) == day; });
if (sd != null)
{
//time = CheckDecimalNumber(sd.CodeT13);
decimal diversity = sch.TimeHours - sd.TimeHours;
if (diversity != 0)
{
if (diversity > 0)
{
all_hours = diversity;
}
else
{
all_hours = sd.TimeHours;
}
}
if (all_hours != 0) str += "<td width='20px' align='center'>" + all_hours.ToString() + "</td>";
else str += "<td width='20px' align='center'> </td>";
if (night_hours != 0) str += "<td width='20px' style='background-color: #99CCFF;' align='center'>" + night_hours.ToString() + "</td>";
else str += "<td width='20px' style='background-color: #99CCFF;' align='center'> </td>";
}
else
{
// если выходной или изменение на выходной то пишем в отклонения по выходному дню
if (((sch.DaySchedule == "FREE") && (Convert.ToInt32(sch.TimeHours) == 0)) || (sch.DayScheduleVar == "F"))
{
if (all_hours != 0) str += "<td width='20px' align='center'>" + all_hours.ToString() + "</td>";
else str += "<td width='20px' align='center'> </td>";
if (night_hours != 0) str += "<td width='20px' style='background-color: #99CCFF;' align='center'>" + night_hours.ToString() + "</td>";
else str += "<td width='20px' style='background-color: #99CCFF;' align='center'> </td>";
}
else
{
//decimal hour_start = Convert.ToInt32(sch.TimeBegin.Substring(0, 2));
//decimal hour_end = Convert.ToInt32(sch.TimeEnd.Substring(0, 2));
//decimal minute_start = Convert.ToDecimal(sch.TimeBegin.Substring(2, 2));
//decimal minute_end = Convert.ToDecimal(sch.TimeEnd.Substring(2, 2));
//if (hour_start == 0) hour_start = 24;
//if (hour_end == 0) hour_end = 24;\
/*
hour_start += minute_start / 60;
hour_end += minute_end / 60;
if (sch.TimeHours != 0)
{
if ((hour_start > 6) && (hour_end < 22))
all_hours += sch.TimeHours;
if (hour_start <= 6)
{
night_hours += 6 - hour_start - 1;
all_hours += sch.TimeHours;
}
if (hour_end >= 22)
{
night_hours += hour_end - 22;
all_hours += sch.TimeHours;
}
}
*/
all_hours += sch.TimeHours;
NightHours nhour = nighthours.Find(delegate(NightHours nh) { return nh.DaySchedule.ToUpper() == sch.DaySchedule.ToUpper(); });
if (nhour != null)
{
night_hours += nhour.Night_Hours;
}
//day_hours += (night_hours + sch.TimeHours);
if (all_hours != 0) str += "<td width='20px' align='center'>" + all_hours.ToString() + "</td>";
else str += "<td width='20px' align='center'> </td>";
if (night_hours != 0) str += "<td width='20px' style='background-color: #99CCFF;' align='center'>" + night_hours.ToString() + "</td>";
else str += "<td width='20px' style='background-color: #99CCFF;' align='center'> </td>";
}
}
day++;
}
while (day <= count_days)
{
decimal all_hours = 0;
decimal night_hours = 0;
//HRHours hr = hr_current.Find(delegate(HRHours hrh) { return Convert.ToInt32(hrh.Day) == day; });
if (all_hours != 0) str += "<td width='20px' align='center'>" + all_hours.ToString() + "</td>";
else str += "<td width='20px' align='center'> </td>";
if (night_hours != 0) str += "<td width='20px' style='background-color: #99CCFF;' align='center'>" + night_hours.ToString() + "</td>";
else str += "<td width='20px' style='background-color: #99CCFF;' align='center'> </td>";
day++;
}
str += "<td>" + getCompany(emp.Department) + "</td><td>" + getPath(emp.Department) + "</td><td>" + getDepartment(emp.Department) + "</td>";
str += "</tr>";
}
str += "</table>";
Response.Write(str);
Response.End();
}
