public void Save(Employee emp) { try { if (emp.EmpID == null || emp.EmpID.Equals("")) { empDAO.addEmp(emp, "N001"); } else { empDAO.updateEmp(emp, "N001"); } } catch (DAOException) { throw; } }
private void Save(Employee emp, SqlTransaction trans) { try { if (emp.EmpID == null || emp.EmpID.Equals("")) { empDAO.addEmp(trans, emp, "N001"); } else { empDAO.updateEmp(trans, emp, "N001"); } } catch (DAOException) { throw; } }
private void cmbEmp_SelectedIndexChanged(object sender, EventArgs e) { txtSaleEmpType.Text = string.Empty; if (null == cmbEmp.SelectedItem) { return; } Employee emp = new Employee(); emp = iemployee.getEmployee((cmbEmp.SelectedItem as ExtItem).Tag.ToString()); txtSaleEmpType.Text = iemployee.getEmpTypeByEmpTypeID(emp.EmpTypeID).Name; }
private bool CanItemShow(Employee emp, string quickSearch, bool searchCode) { if (quickSearch == null || quickSearch.Equals("")) { return true; } else if (searchCode) { return emp.EmpID.Contains(quickSearch); } else { return emp.Name.Contains(quickSearch); } }
private void DataRowToEmployee(DataRow dr, Employee emp) { emp.EmpID = dr["EmpID"].ToString(); emp.LastName = dr["LastName"].ToString(); emp.FirstName = dr["FirstName"].ToString(); emp.TelNum = dr["TelNum"].ToString(); emp.Address = dr["Address"].ToString(); emp.ZipCode = dr["ZipCode"].ToString(); emp.IdCardNum = dr["IdCardNum"].ToString(); emp.EmpTypeID = dr["EmpTypeID"].ToString(); if (dr["EntryTime"].Equals(DBUtil.MinSqlDateTime)) { emp.EntryTime = DateTime.MinValue; } else { emp.EntryTime = Convert.ToDateTime(dr["EntryTime"]); } if (dr["LeaveTime"].Equals(DBUtil.MinSqlDateTime)) { emp.LeaveTime = DateTime.MinValue; } else { emp.LeaveTime = Convert.ToDateTime(dr["LeaveTime"]); } emp.WorkStatus = Convert.ToInt32(dr["WorkStatus"]); emp.InsurBase = Convert.ToDouble(dr["InsuBase"]); }
public int addEmp(Employee emp, string currentUser) { string sqlStr = dbUtil.getSqlStatement("SQL_EMP_Emp_Insert"); SqlParameter[] sqlParms = BuildEmpParam(emp, currentUser, true); try { return (int)DAO.DBAccess.ExecuteNonQuery(DAO.DBAccess.SQLConnectionString, CommandType.Text, sqlStr, sqlParms); } catch (Exception ex) { throw new DAOException("E0001", ex); } }
private SqlParameter[] BuildEmpParam(Employee emp, string currentUser, bool isInsertOP) { List<SqlParameter> paras = new List<SqlParameter>(); paras.Add(new SqlParameter("@EmpID",SqlDbType.VarChar,20)); paras.Add(new SqlParameter("@lastName",SqlDbType.NVarChar,20)); paras.Add(new SqlParameter("@firstName",SqlDbType.NVarChar,20)); paras.Add(new SqlParameter("@telNum",SqlDbType.VarChar,20)); paras.Add(new SqlParameter("@address",SqlDbType.NVarChar,100)); paras.Add(new SqlParameter("@zipCode",SqlDbType.VarChar,20)); paras.Add(new SqlParameter("@idCardNum",SqlDbType.VarChar,20)); paras.Add(new SqlParameter("@EmpTypeID",SqlDbType.VarChar,20)); paras.Add(new SqlParameter("@entryTime",SqlDbType.DateTime)); paras.Add(new SqlParameter("@leaveTime",SqlDbType.DateTime)); paras.Add(new SqlParameter("@WorkStatus", SqlDbType.Int)); paras.Add(new SqlParameter("@InsuBase", SqlDbType.Float)); paras.Add(new SqlParameter("@UpdateUser", SqlDbType.VarChar, 20)); paras[0].Value = emp.EmpID; paras[1].Value = emp.LastName; paras[2].Value = emp.FirstName; paras[3].Value = emp.TelNum; paras[4].Value = emp.Address; paras[5].Value = emp.ZipCode; paras[6].Value = emp.IdCardNum; paras[7].Value = emp.EmpTypeID; if (emp.EntryTime.Equals(DateTime.MinValue)) { paras[8].Value = DBUtil.MinSqlDateTime; } else { paras[8].Value = emp.EntryTime; } if (emp.LeaveTime.Equals(DateTime.MinValue)) { paras[9].Value = DBUtil.MinSqlDateTime; } else { paras[9].Value = emp.LeaveTime; } paras[10].Value = emp.WorkStatus; paras[11].Value = emp.InsurBase; paras[12].Value = currentUser; if (isInsertOP) { paras.Add(new SqlParameter("@CreateUser", SqlDbType.VarChar, 20)); paras[13].Value = currentUser; } return paras.ToArray(); }
public int updateEmp(SqlTransaction trans, Employee emp, string currentUser) { string sqlStr = dbUtil.getSqlStatement("SQL_EMP_Emp_Update"); SqlParameter[] sqlParms = BuildEmpParam(emp, currentUser, false); try { return (int)DAO.DBAccess.ExecuteNonQuery(trans, CommandType.Text, sqlStr, sqlParms); } catch (Exception ex) { throw new DAOException("E0001", ex); } }
public List<Employee> searchEmpByMultiFilter(Hashtable hashTable) { string sqlStr = dbUtil.getSqlStatement("SQL_Emp_SearchByMultiFilter"); ArrayList listParms = GetEmpMultiFilterParams(ref sqlStr, hashTable, dbUtil); SqlParameter[] sqlParms = (SqlParameter[])listParms.ToArray(typeof(SqlParameter)); foreach (SqlParameter parm in sqlParms) { parm.Value = hashTable[parm.ParameterName]; } try { List<Employee> empList = new List<Employee>(); DataSet searchResult = DAO.DBAccess.ExecuteAdapter(DAO.DBAccess.SQLConnectionString, CommandType.Text, sqlStr, sqlParms); foreach (DataTable dt in searchResult.Tables) { foreach (DataRow dr in dt.Rows) { Employee emp = new Employee(); DataRowToEmployee(dr, emp); empList.Add(emp); } } return empList; } catch (Exception ex) { throw new DAOException("E0001", ex); } }
public Employee searchEmpByEmpId(string strEmpID) { string sqlStr = dbUtil.getSqlStatement("SQL_Emp_SearchByEmpId"); SqlParameter[] sqlParms = { new SqlParameter("@EmpID",SqlDbType.VarChar,20) }; sqlParms[0].Value = strEmpID; try { DataSet resultSet = DAO.DBAccess.ExecuteAdapter(DAO.DBAccess.SQLConnectionString, CommandType.Text, sqlStr, sqlParms); UtilService utilService = new UtilService(); if (!utilService.isNullDataset(resultSet)) { Employee emp = new Employee(); DataRowToEmployee(resultSet.Tables[0].Rows[0], emp); return emp; } return null; } catch (Exception ex) { throw new DAOException("E0001", ex); } }
public List<Employee> searchEmpAll() { string sqlStr = dbUtil.getSqlStatement("SQL_Emp_SearchAll"); try { List<Employee> empList = new List<Employee>(); DataSet searchResult = DAO.DBAccess.ExecuteAdapter(DAO.DBAccess.SQLConnectionString, CommandType.Text, sqlStr, null); foreach (DataTable dt in searchResult.Tables) { foreach (DataRow dr in dt.Rows) { Employee emp = new Employee(); DataRowToEmployee(dr, emp); empList.Add(emp); } } return empList; } catch (Exception ex) { throw new DAOException("E0001", ex); } }