//新增員工資料到DB
public void InsertEmployee(Employee emp)
{
string str = "insert into [AMS_Employee] values(@EmployeeID,@Password,@Name,@JobTitle,@RoleID,@departmentID,@DutyDate," +
"@Birthday,@EXT,@Email,@PhoneNumber,@Address,@Image,@StartDate,@EndDate)";
DatabaseTier dt = new DatabaseTier();
dt.SQLHelperNonQuery(str, new Dictionary <string, object>()
{
{ "@EmployeeID", emp.EmployeeID },
{ "@Password", emp.Password },
{ "@Name", emp.EmployeeName },
{ "@JobTitle", emp.JobTitle },
{ "@RoleID", emp.RoleID },
{ "@departmentID", emp.DepatmentID },
{ "@DutyDate", emp.DutyDate },
{ "@Birthday", emp.Birthday },
{ "@EXT", emp.EXT },
{ "@Email", emp.Email },
{ "@PhoneNumber", emp.Cellphone },
{ "@Address", emp.Address },
{ "@Image", emp.ImageBytes },
{ "@StartDate", emp.StartDate },
{ "@EndDate", emp.EndDate }
});
}
//修改員工資料到DB
public void UpdateEmployee(Employee emp)
{
string str = "update [AMS_Employee] set Name=@Name,JobTitle=@JobTitle,RoleID=@RoleID,departmentID=@departmentID,DutyDate=@DutyDate," +
"Birthday=@Birthday,EXT=@EXT,Email=@Email,PhoneNumber=@PhoneNumber,Address=@Address,Password=@Password," +
"Image=@Image, StartDate=@StartDate,EndDate=@EndDate where EmployeeID=@EmployeeID;";
DatabaseTier dt = new DatabaseTier();
dt.SQLHelperNonQuery(str, new Dictionary <string, object>()
{
{ "@Name", emp.EmployeeName },
{ "@JobTitle", emp.JobTitle },
{ "@RoleID", emp.RoleID },
{ "@departmentID", emp.DepatmentID },
{ "@DutyDate", emp.DutyDate },
{ "@Birthday", emp.Birthday },
{ "@EXT", emp.EXT },
{ "@Email", emp.Email },
{ "@PhoneNumber", emp.Cellphone },
{ "@Address", emp.Address },
{ "@EmployeeID", emp.EmployeeID },
{ "@Password", emp.Password },
{ "@Image", emp.ImageBytes },
{ "@StartDate", emp.StartDate },
{ "@EndDate", emp.EndDate }
});
}
//新增員工個別權限至DB
public void InsertEmployeePermission(EmployeePermissions employeePermission)
{
string str = "insert into [AMS_EmployeePermission] values(@EmployeeID,@SiteId,@Enable)";
DatabaseTier dt = new DatabaseTier();
dt.SQLHelperNonQuery(str, new Dictionary <string, object>()
{
{ "@EmployeeID", employeePermission.EmployeeId },
{ "@SiteId", employeePermission.SiteId },
{ "@Enable", employeePermission.Enable },
});
}
