/// <summary> /// 写入一条考勤记录 /// </summary> /// <param name="ClockAttendance"></param> /// <returns></returns> public bool InsertClockAttendance(Model.ClockAttendance ClockAttendance) { const string sql = @"INSERT INTO ClockAttendance(UsersId,RealName,Createtime,Address,CheckAddress) VALUES(@UsersId,@RealName,GETDATE(),@Address,@CheckAddress)"; return(Factory.DBHelper.ExecSQL(SQLConString, sql.ToString(), new DynamicParameters(new { ClockAttendance.UsersId, ClockAttendance.RealName, ClockAttendance.Address, ClockAttendance.CheckAddress, }))); }
public ActionResult AddClockAttendanceInfo() { Business.Sys_UserAdmin Sys_UserAdmin = new Business.Sys_UserAdmin(); Model.ClockAttendance ClockAttendance = new Model.ClockAttendance() { UsersId = Utility.ChangeText.GetUsersId(), Address = Request["Address"], RealName = Utility.ChangeText.GetRealName(), CheckAddress = Sys_UserAdmin.GetUserAdminByUserId(Utility.ChangeText.GetUsersId()).CheckAddress }; Business.Sys_ClockAttendance Sys_ClockAttendance = new Business.Sys_ClockAttendance(); if (Sys_ClockAttendance.InsertClockAttendance(ClockAttendance)) { return(Content("1")); } return(Content("2")); }