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