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;
}
// получаем список сотрудников на конкретной должности
public List<EmployeeAttrib> getEmployeesOnCurrentPost(string postName, List<EmployeeAttrib> emp_attribs)
{
if (emp_attribs == null) return null;
SQLDB db = new SQLDB();
List<EmployeeAttrib> emps = new List<EmployeeAttrib>();
foreach (EmployeeAttrib em in emp_attribs)
{
Employee employee = db.getEmployee(em.EmployeeID, em.StartPeriod, em.BeginDate, em.EndDate);
if (employee.Post.Equals(postName)) emps.Add(em);
}
return emps;
}
// получаем список сотрудников по первым буквам фамилии
public List<EmployeeAttrib> getEmployeesByFIO(string fio, List<EmployeeAttrib> emp_attribs)
{
if (emp_attribs == null) return null;
SQLDB db = new SQLDB();
List<EmployeeAttrib> emps = new List<EmployeeAttrib>();
foreach (EmployeeAttrib em in emp_attribs)
{
Employee employee = db.getEmployee(em.EmployeeID, em.StartPeriod, em.BeginDate, em.EndDate);
string fam = employee.FullName.Substring(0, employee.FullName.IndexOf(' '));
if (fam.ToLower().StartsWith(fio.ToLower())) emps.Add(em);
}
return emps;
}
public Employee getEmployee(EmployeeAttrib emp_attrib)
{
SQLDB db = new SQLDB();
Employee emp = db.getEmployee(emp_attrib.EmployeeID, emp_attrib.StartPeriod, emp_attrib.BeginDate, emp_attrib.EndDate);
return emp;
}