本文整理汇总了C#中SQLDB.getEmployee方法的典型用法代码示例。如果您正苦于以下问题：C# SQLDB.getEmployee方法的具体用法？C# SQLDB.getEmployee怎么用？C# SQLDB.getEmployee使用的例子？那么, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类SQLDB的用法示例。
在下文中一共展示了SQLDB.getEmployee方法的4个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: Page_Load
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;
}示例2: getEmployeesOnCurrentPost
// получаем список сотрудников на конкретной должности
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;
}示例3: getEmployeesByFIO
// получаем список сотрудников по первым буквам фамилии
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;
}示例4: getEmployee
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;
}