我希望在我的项目中管理Attendece ...但我如何管理我的项目的Monthy，Yearly Attendence [英] I Want To Managed Attendece In My Project...But How I Managed Monthy,Yearly Attendence For My Project

问题描述

我的关注表字段是

 创建  TABLE  [dbo]。[TblAttendence]（
 [AttendenceId] [ int ]  IDENTITY （ 1 ， 1 ） NOT   NULL ，
 [EmployeeId] [ int ]  NOT   NULL ，
 [LoginTime] [ datetime ]  NOT   NULL ，
 [LastLogoutTime] [ datetime ]  NULL ，
 [IpAddress] [ varchar ]（ 100 ） NOT   NULL ，
 [IsActive] [位<​​/ span>]  NOT   NULL ，
 [IsDelete] [位] 不  NULL ，
 [CreateDate] [ datetime ]  NOT   NULL ，
 [ModifyDate] [ datetime ]  NULL ，
  CONSTRAINT  [PK_TblAttendence]  PRIMARY   KEY   CLUSTERED  

我如何管理我的每月注意力

解决方案

HTT p：//www.c-sharpcorner.com/Forums/Thread/170258/how-to-count-total-days-attendance-in-particular-month-for-c.aspx [ ^ ]



http://social.msdn.microsoft.com/Forums/en-US/259485d8 -ab00-4775-a30e-932fc87ca723 / how-to-maintain-employee-attendance-in-sql-database？forum = csharpgeneral [ ^

my attendence table field is

CREATE TABLE [dbo].[TblAttendence](
    [AttendenceId] [int] IDENTITY(1,1) NOT NULL,
    [EmployeeId] [int] NOT NULL,
    [LoginTime] [datetime] NOT NULL,
    [LastLogoutTime] [datetime] NULL,
    [IpAddress] [varchar](100) NOT NULL,
    [IsActive] [bit] NOT NULL,
    [IsDelete] [bit] NOT NULL,
    [CreateDate] [datetime] NOT NULL,
    [ModifyDate] [datetime] NULL,
 CONSTRAINT [PK_TblAttendence] PRIMARY KEY CLUSTERED

how i managed my monthly attendence from it

解决方案

http://www.c-sharpcorner.com/Forums/Thread/170258/how-to-count-total-days-attendance-in-particular-month-for-c.aspx[^]

http://social.msdn.microsoft.com/Forums/en-US/259485d8-ab00-4775-a30e-932fc87ca723/how-to-maintain-employee-attendance-in-sql-database?forum=csharpgeneral[^]

这篇关于我希望在我的项目中管理Attendece ...但我如何管理我的项目的Monthy，Yearly Attendence的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！