public JsonResult SaveCheckInDtlForm(string AttendanceCheckInDtlJson)
{
AttendanceCheckInDtlModel AttendanceCheckInDtl = null;
try
{
AttendanceCheckInDtl = JsonConvert.DeserializeObject <AttendanceCheckInDtlModel>(AttendanceCheckInDtlJson);
AttendanceCheckInDtl.CheckInFlag = "1";
AttendanceCheckInDtl.CheckInEmployeeNo = LoginUserInfo.UserId;
AttendanceCheckInDtl.CheckInEmployeeName = LoginUserInfo.UserName;
AttendanceCheckInDtl.CheckInDate = DateTime.Now.ToString("yyyyMMdd");
AttendanceCheckInDtl.CheckInTime = DateTime.Now.ToString("HHmmss");
AttendanceCheckInDtl.CardDate = AttendanceCheckInDtl.CardDate.Replace("-", "");
AttendanceCheckInDtl.CardTime = AttendanceCheckInDtl.CardTime.Replace(":", "");
if (ModelFactory.SaveCheckInDtlForm(AttendanceCheckInDtl))
{
return(Json("1"));
}
else
{
return(Json("0|新增失敗!"));
}
}
catch (Exception ex)
{
return(Json("0|新增失敗!"));
}
}
public AttendanceCheckInDtlModel GetAttendanceCheckInDtl(string SDATE, string EmpNo)
{
AttendanceCheckInDtlModel Obj = new AttendanceCheckInDtlModel();
Obj.Emp = GetEmpAllData(EmpNo);
Obj.CardDate = SDATE;
Obj.CardType = "1";
Obj.CardTime = DateTime.Now.ToString("HH:mm");
Obj.CheckInDescription = "";//補登
return(Obj);
}
/// <summary>
/// 補登出勤紀錄
/// </summary>
/// <returns></returns>
public bool SaveCheckInDtlForm(AttendanceCheckInDtlModel AttendanceCheckInDtlForm)
{
//OutgoingList
DbTransaction objTrans = DbAccess.CreateDbTransaction();
try
{
DbAccess.ExecuteNonQuery("INSERT INTO tbAttendance (EmployeeNo,Company,EmployeeName,EnEmployeeName,DepartMentName,CardType,WriteDate,WriteTime,CardDate,CardTime,CheckInFlag,CheckInEmployeeNo,CheckInDate,CheckInTime,CheckInEmployeeName,CardNo,CheckInDescription) VALUES(@EmployeeNo,@Company,@EmployeeName,@EnEmployeeName,@DepartMentName,@CardType,@WriteDate,@WriteTime,@CardDate,@CardTime,@CheckInFlag,@CheckInEmployeeNo,@CheckInDate,@CheckInTime,@CheckInEmployeeName,@CardNo,@CheckInDescription)", objTrans,
new DbParameter[] {
DataAccess.CreateParameter("EmployeeNo", DbType.String, AttendanceCheckInDtlForm.Emp.EmployeeNo.ToString()),
DataAccess.CreateParameter("Company", DbType.String, AttendanceCheckInDtlForm.Emp.Company.ToString()),
DataAccess.CreateParameter("EmployeeName", DbType.String, AttendanceCheckInDtlForm.Emp.EmployeeName.ToString()),
DataAccess.CreateParameter("EnEmployeeName", DbType.String, AttendanceCheckInDtlForm.Emp.EmployeeEName.ToString()),
DataAccess.CreateParameter("DepartMentName", DbType.String, AttendanceCheckInDtlForm.Emp.DepartMentName.ToString()),
DataAccess.CreateParameter("CardType", DbType.Int16, AttendanceCheckInDtlForm.CardType.ToString()),
DataAccess.CreateParameter("WriteDate", DbType.String, AttendanceCheckInDtlForm.CheckInDate.ToString()),
DataAccess.CreateParameter("WriteTime", DbType.String, AttendanceCheckInDtlForm.CheckInTime.ToString()),
DataAccess.CreateParameter("CardDate", DbType.String, AttendanceCheckInDtlForm.CardDate.ToString()),
DataAccess.CreateParameter("CardTime", DbType.String, AttendanceCheckInDtlForm.CardTime.ToString()),
DataAccess.CreateParameter("CheckInFlag", DbType.Int16, AttendanceCheckInDtlForm.CheckInFlag.ToString()),
DataAccess.CreateParameter("CheckInEmployeeNo", DbType.String, AttendanceCheckInDtlForm.CheckInEmployeeNo),
DataAccess.CreateParameter("CheckInDate", DbType.String, AttendanceCheckInDtlForm.CheckInDate.ToString()),
DataAccess.CreateParameter("CheckInTime", DbType.String, AttendanceCheckInDtlForm.CheckInTime.ToString()),
DataAccess.CreateParameter("CheckInEmployeeName", DbType.String, AttendanceCheckInDtlForm.CheckInEmployeeName.ToString()),
DataAccess.CreateParameter("CardNo", DbType.String, ""),
DataAccess.CreateParameter("CheckInDescription", DbType.String, AttendanceCheckInDtlForm.CheckInDescription.ToString()),
});
objTrans.Commit();
return(true);
}
catch
{
objTrans.Rollback();
return(false);
}
finally
{
if (objTrans != null)
{
objTrans.Dispose();
}
}
}
public JsonResult GetCheckInDtlForm(string SDATE, string EmpNo)
{
AttendanceCheckInDtlModel AttendanceCheckInDtl = ModelFactory.GetAttendanceCheckInDtl(SDATE, EmpNo);
return(Json(AttendanceCheckInDtl));
}
