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