public Employee selectLogin(String employeeLogin, String employeePassword) { String sql =""; Employee item = new Employee(); DataTable dt = new DataTable(); sql = "Select * From " + emp.table + " Where " + emp.empUsername + "='" + employeeLogin + "' and " + emp.empPassword + " = '" + employeePassword + "' and " + emp.empActive + "='1'"; dt = conn.selectData(sql); if (dt.Rows.Count > 0) { item.pkField = dt.Rows [0][emp.pkField].ToString(); item.empActive = dt.Rows[0][emp.empActive].ToString(); item.empName = dt.Rows[0][emp.empName ].ToString(); item.empId = dt.Rows[0][emp.empId].ToString(); item.empNameE = dt.Rows[0][emp.empNameE ].ToString(); item.empUsername = dt.Rows[0][emp.empUsername ].ToString(); item.empSSN = dt.Rows[0][emp.empSSN].ToString(); item.empPassword = dt.Rows[0][emp.empPassword].ToString(); } return item; }
private void initConfig() { emp = new Employee(); emp.companyId = "company_id"; emp.departId = "depart_id"; emp.empActive = "emp_active"; emp.empHoliday = "emp_holiday"; emp.empId = "emp_id"; emp.empName = "emp_name"; emp.empNameE = "emp_name_e"; emp.empNickName = "emp_nickname"; emp.empPassword = "******"; emp.empPrivilege = "emp_privilege"; emp.empRealDay = "emp_realday"; emp.empSSN = "emp_ssn"; emp.empTimeRule = "emp_timerule"; emp.empType = "emp_type"; emp.empWorkType = "emp_worktype"; emp.id = "id"; emp.pkField = "emp_id"; emp.sited = ""; emp.empUsername = "******"; emp.table = "b_employee"; }