/// <summary>
/// 員工新增
/// </summary>
/// <param name="employee"></param>
/// <returns></returns>
public int AddEmployee(tEmployee employee)
{
int fEmpId = 0;
using (SqlConnection conn = new SqlConnection(ConnectionString))
{
using (SqlCommand cmd = new SqlCommand("usp_PR_Employee_Insert", conn))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@fName", SqlDbType.NVarChar, 10);
cmd.Parameters.Add("@fPhone", SqlDbType.VarChar, 10);
cmd.Parameters.Add("@fDepId", SqlDbType.Int);
cmd.Parameters.Add("@fEmpId", SqlDbType.Int).Direction = ParameterDirection.Output;
cmd.Parameters["@fName"].Value = employee.fName;
cmd.Parameters["@fPhone"].Value = employee.fPhone;
cmd.Parameters["@fDepId"].Value = employee.fDepId;
conn.Open();
cmd.ExecuteNonQuery();
fEmpId = Convert.ToInt32(cmd.Parameters["@fEmpId"].Value);
conn.Close();
}
}
return(fEmpId);
}
/// <summary>
/// 依員工編號查詢員工資料
/// </summary>
/// <param name="fEmpId">員工編號</param>
/// <returns></returns>
public tEmployee GetEmployeesByEmpID(int fEmpId)
{
DataTable dt = new DataTable();
tEmployee Emp = new tEmployee();
using (SqlConnection conn = new SqlConnection(ConnectionString))
{
using (SqlCommand cmd = new SqlCommand("usp_GetEmployeeByEmpID", conn))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@fEmpId", SqlDbType.Int);
cmd.Parameters["@fEmpId"].Value = fEmpId;
conn.Open();
using (var dr = cmd.ExecuteReader())
{
if (dr.Read())
{
Emp.fDepId = Convert.ToInt32(dr["fDepId"]);
Emp.fEmpId = Convert.ToInt32(dr["fEmpId"]);
Emp.fName = Convert.ToString(dr["fName"]);
Emp.fPhone = Convert.ToString(dr["fPhone"]);
}
}
conn.Close();
}
}
return(Emp);
}
/// <summary>
/// 員工編輯
/// </summary>
/// <param name="employee"></param>
public void UpdateEmployee(tEmployee employee)
{
using (SqlConnection conn = new SqlConnection(ConnectionString))
{
using (SqlCommand cmd = new SqlCommand("usp_PR_Employee_UpdateByPK", conn))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@fEmpId", SqlDbType.Int);
cmd.Parameters.Add("@fName", SqlDbType.NVarChar, 10);
cmd.Parameters.Add("@fPhone", SqlDbType.VarChar, 10);
cmd.Parameters.Add("@fDepId", SqlDbType.Int);
cmd.Parameters["@fEmpId"].Value = employee.fEmpId;
cmd.Parameters["@fName"].Value = employee.fName;
cmd.Parameters["@fPhone"].Value = employee.fPhone;
cmd.Parameters["@fDepId"].Value = employee.fDepId;
conn.Open();
cmd.ExecuteNonQuery();
conn.Close();
}
}
}
