//修改員工資料(個人)
public static void UpdateInfo(YenEmployee e)
{
using (SqlConnection cn = new SqlConnection(Common.DBConnectionString))
{
SqlCommand command = new SqlCommand("update Employee set Password=@Password, Mobile=@Mobile, Address=@Address, Birthdate=@Birthdate, ImageFileName=@ImageFileName where EmployeeID = @EmployeeID", cn);
command.Parameters.AddWithValue("@EmployeeID", e.EmployeeID);
command.Parameters.AddWithValue("@Password", e.Password);
if (e.Mobile != null)
{
command.Parameters.AddWithValue("@Mobile", e.Mobile);
}
else
{
command.Parameters.AddWithValue("@Mobile", DBNull.Value);
}
if (e.Email != null)
{
command.Parameters.AddWithValue("@Email", e.Email);
}
else
{
command.Parameters.AddWithValue("@Email", DBNull.Value);
}
if (e.Address != null)
{
command.Parameters.AddWithValue("@Address", e.Address);
}
else
{
command.Parameters.AddWithValue("@Address", DBNull.Value);
}
if (e.BirthDate != null)
{
command.Parameters.AddWithValue("@BirthDate", e.BirthDate);
}
else
{
command.Parameters.AddWithValue("@BirthDate", DBNull.Value);
}
if (e.ImageFileName != null)
{
command.Parameters.AddWithValue("@ImageFileName", e.ImageFileName);
}
else
{
command.Parameters.AddWithValue("@ImageFileName", DBNull.Value);
}
cn.Open();
command.ExecuteNonQuery();
cn.Close();
}
}
//根據id修改員工資料(人事)
public static void UpdateEmployeeByID(YenEmployee e)
{
using (SqlConnection cn = new SqlConnection(Common.DBConnectionString))
{
SqlCommand command = new SqlCommand("update Employee set Password = @Password, LastName=@LastName, FirstName=@FirstName," +
" Gender=@Gender,DepartmentName=@DepartmentName,DepartmentID=@DepartmentID, AuthorizationLevel=@AuthorizationLevel, Salary=@Salary, ResignedDate=@ResignedDate," +
"Mobile=@Mobile, Address=@Address where EmployeeID = @EmployeeID", cn);
command.Parameters.AddWithValue("@EmployeeID", e.EmployeeID);
//command.Parameters.AddWithValue("@Email", e.Email);
command.Parameters.AddWithValue("@Password", e.Password);
command.Parameters.AddWithValue("@LastName", e.LastName);
command.Parameters.AddWithValue("@FirstName", e.FirstName);
command.Parameters.AddWithValue("@Gender", e.Gender);
command.Parameters.AddWithValue("@DepartmentName", e.DepartmentName);
command.Parameters.AddWithValue("@DepartmentID", e.DepartmentID);
command.Parameters.AddWithValue("@AuthorizationLevel", e.AuthorizationLevel);
command.Parameters.AddWithValue("@Salary", e.Salary);
if (e.ResignedDate != null)
{
command.Parameters.AddWithValue("@ResignedDate", e.ResignedDate);
}
else
{
command.Parameters.AddWithValue("@ResignedDate", DBNull.Value);
}
if (e.Mobile != null)
{
command.Parameters.AddWithValue("@Mobile", e.Mobile);
}
else
{
command.Parameters.AddWithValue("@Mobile", DBNull.Value);
}
if (e.Address != null)
{
command.Parameters.AddWithValue("@Address", e.Address);
}
else
{
command.Parameters.AddWithValue("@Address", DBNull.Value);
}
cn.Open();
command.ExecuteNonQuery();
cn.Close();
}
}
//修改員工資料
public static void InsertEmployee(YenEmployee e)
{
using (SqlConnection cn = new SqlConnection(Common.DBConnectionString))
{
SqlCommand cmd = new SqlCommand(
"insert into Employee (Email, Password, LastName, FirstName, Gender, DepartmentID, DepartmentName, AuthorizationLevel, HiredDate, Salary)"
+ "values(@Email, @Password, @LastName, @FirstName, @Gender, @DepartmentID, @DepartmentName, @AuthorizationLevel, @HiredDate, @Salary)",
cn);
cmd.Parameters.AddWithValue("@Email", e.Email);
cmd.Parameters.AddWithValue("@Password", e.Password);
cmd.Parameters.AddWithValue("@LastName", e.LastName);
cmd.Parameters.AddWithValue("@FirstName", e.FirstName);
cmd.Parameters.AddWithValue("@Gender", e.Gender);
cmd.Parameters.AddWithValue("@DepartmentID", e.DepartmentID);
cmd.Parameters.AddWithValue("@DepartmentName", e.DepartmentName);
cmd.Parameters.AddWithValue("@AuthorizationLevel", e.AuthorizationLevel);
cmd.Parameters.AddWithValue("@HiredDate", e.HiredDate);
cmd.Parameters.AddWithValue("@Salary", e.Salary);
cn.Open();
cmd.ExecuteNonQuery();
}
}
//取回員工頭貼檔名
public static string GetImageFileName(int id)
{
YenEmployee emp = GetEmployeeByID(id);
return(emp.ImageFileName);
}
