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);
}
}
