基于C++的企业考勤管理系统的设计代码(8)

 

* 60;

* 60;

}

 

 

twotemp = two.GetSecond() + two.GetMinute() * 60 + two.GetHour() * 60

if ((onetemp - twotemp) < 0) { } else { }

CTime time (yy,mm,dd,h,m,s); return time;

h = (onetemp - twotemp) / 60 / 60;

m = ((onetemp - twotemp) - h * 60 * 60) / 60; s = ((onetemp - twotemp) - h * 60 * 60) - m * 60; h = m = s = 0;

void CCheckManage::UpdateList() {

this->UpdateData(); CString str; if (m_check)

36

 

 

else {

str.Format(

CString Starttime,EndTime;

Starttime = m_yy +

EndTime.Format(if (m_emp == 全部)

str.Format(

*

From

tab_check

where

checkdate

between

'%s'

and %s

 

 

else

str.Format(

and %s

 

CADODataSet dataset;

dataset.SetConnection(::GetConnection()); dataset.Open(str); m_list.DeleteAllItems();

for (int i = 0 ; i < dataset.GetRecordCount() ; i++) {

int n = 0;

long data = dataset.GetFields()->Item[m_list.InsertItem(i,}

37

 

}

}

m_list.SetItemData(i,data);

m_list.SetItemText(i,n++,(_bstr_t)dataset.GetFields()->Item[m_list.SetItemText(i,n++,(_bstr_t)dataset.GetFields()->Item[m_list.SetItemText(i,n++,(_bstr_t)dataset.GetFields()->Item[m_list.SetItemText(i,n++,(_bstr_t)dataset.GetFields()->Item[m_list.SetItemText(i,n++,(_bstr_t)dataset.GetFields()->Item[m_list.SetItemText(i,n++,(_bstr_t)dataset.GetFields()->Item[m_list.SetItemText(i,n++,(_bstr_t)dataset.GetFields()->Item[m_list.SetItemText(i,n++,(_bstr_t)dataset.GetFields()->Item[m_list.SetItemText(i,n++,(_bstr_t)dataset.GetFields()->Item[m_list.SetItemText(i,n++,(_bstr_t)dataset.GetFields()->Item[m_list.SetItemText(i,n++,(_bstr_t)dataset.GetFields()->Item[m_list.SetItemText(i,n++,(_bstr_t)dataset.GetFields()->Item[dataset.Next();

 

BOOL CCheckManage::OnInitDialog() {

CDialog::OnInitDialog();

int i = 0;

m_list.InsertColumn(i,人员姓名

38

 

 

m_list.SetColumnWidth(i++,100);

m_list.InsertColumn(i,上班时间m_list.SetColumnWidth(i++,100);

m_list.InsertColumn(i,下班时间m_list.SetColumnWidth(i++,100);

m_list.InsertColumn(i,上班考勤时间m_list.SetColumnWidth(i++,100);

m_list.InsertColumn(i,下班考勤时间m_list.SetColumnWidth(i++,100);

m_list.InsertColumn(i,请假类别m_list.SetColumnWidth(i++,100);

m_list.InsertColumn(i,请假起始时间m_list.SetColumnWidth(i++,100);

m_list.InsertColumn(i,请假结束时间m_list.SetColumnWidth(i++,100);

39

 

 

m_list.InsertColumn(i,迟到时间m_list.SetColumnWidth(i++,100);

m_list.InsertColumn(i,早退时间m_list.SetColumnWidth(i++,100);

m_list.InsertColumn(i,备注m_list.SetColumnWidth(i++,100);

m_list.InsertColumn(i,考勤日期m_list.SetColumnWidth(i++,130);

m_list.SetExtendedStyle(LVS_EX_FULLROWSELECT|LVS_EX_GRIDLINES);

m_check = true;

this->UpdateData(false); int curyear,curmonth;

CTime time(CTime::GetCurrentTime()); curyear = time.GetYear(); curmonth = time.GetMonth();

char value[10];

for (int y = 2000; y < 2100 ;y++)

40