📄 dialogcjarg.cpp
字号:
pEx->Delete();
return FALSE;
}
catch(CMemoryException* pEx)
{
//WinPrintf("连接数据库失败");
pEx->Delete();
return FALSE;
}
if(pCjargbase.CanUpdate()==FALSE) {
//WinPrintf("db cann't update");
pCjargbase.Close();
return FALSE;
}
if(pCjargbase.CanTransact()==FALSE) {
//WinPrintf("Transact cann't do");
pCjargbase.Close();
return FALSE;
}
try{
sprintf(CjadminSQL, "update t_data_cjadmin set Cb_Count=%d, Max_Count=%d, Max_Ringtime=%d, Bohao_time=%d where Serial='1'",
cjarg.cb_count, cjarg.max_count, cjarg.ringtime, cjarg.bohao_time);
itoa(cjarg.cjtime_one,ls_cjtimeflag,10);
sprintf(Cjtime1SQL, "update t_data_cjtime set Cjtimeflag=\'%s\', Start_Month=%d, End_Month=%d, Start_Day=%d, End_Day=%d, Start_Hour=%d, End_Hour=%d, Start_Minute=%d, End_Minute=%d where Serial='1'",
ls_cjtimeflag, cjarg.cjtime[0].start_month, cjarg.cjtime[0].end_month, cjarg.cjtime[0].start_day, cjarg.cjtime[0].end_day,
cjarg.cjtime[0].start_hour, cjarg.cjtime[0].end_hour, cjarg.cjtime[0].start_minute, cjarg.cjtime[0].end_minute);
itoa(cjarg.cjtime_two,ls_cjtimeflag,10);
sprintf(Cjtime2SQL, "update t_data_cjtime set Cjtimeflag=\'%s\', Start_Month=%d, End_Month=%d, Start_Day=%d, End_Day=%d, Start_Hour=%d, End_Hour=%d, Start_Minute=%d, End_Minute=%d where Serial='2'",
ls_cjtimeflag, cjarg.cjtime[1].start_month, cjarg.cjtime[1].end_month, cjarg.cjtime[1].start_day, cjarg.cjtime[1].end_day,
cjarg.cjtime[1].start_hour, cjarg.cjtime[1].end_hour, cjarg.cjtime[1].start_minute, cjarg.cjtime[1].end_minute);
itoa(cjarg.cjtime_three,ls_cjtimeflag,10);
sprintf(Cjtime3SQL, "update t_data_cjtime set Cjtimeflag=\'%s\', Start_Month=%d, End_Month=%d, Start_Day=%d, End_Day=%d, Start_Hour=%d, End_Hour=%d, Start_Minute=%d, End_Minute=%d where Serial='3'",
ls_cjtimeflag, cjarg.cjtime[2].start_month, cjarg.cjtime[2].end_month, cjarg.cjtime[2].start_day, cjarg.cjtime[2].end_day,
cjarg.cjtime[2].start_hour, cjarg.cjtime[2].end_hour, cjarg.cjtime[2].start_minute, cjarg.cjtime[2].end_minute);
if(pCjargbase.BeginTrans()){
pCjargbase.ExecuteSQL(_T(CjadminSQL));
pCjargbase.ExecuteSQL(_T(Cjtime1SQL));
pCjargbase.ExecuteSQL(_T(Cjtime2SQL));
pCjargbase.ExecuteSQL(_T(Cjtime3SQL));
if(pCjargbase.CommitTrans()) {
TRACE("Transaction Commited");
}
else{
pCjargbase.Rollback();
}
}
else{
pCjargbase.Close();
return FALSE;
}
}
catch(CDBException* e){
e->Delete();
pCjargbase.Close();
return FALSE;
}
catch(CMemoryException* e){
e->Delete();
pCjargbase.Close();
return FALSE;
}
pCjargbase.Close();
return TRUE;
}
BOOL CDialogcjarg::Readcjarg()
{
int i;
CMydatabase pRdCjargbase;
CRecordset pRdCjadminSet(&pRdCjargbase); //t_data_cjadmin催缴设置表
CRecordset pRdCjtimeSet(&pRdCjargbase); //t_data_cjtime催缴时间设置表
char ls_i[10];
char ls_tmparg[10];
char cjrdtimeSQL[200];
CString szcbcount;
CString szmaxcount;
CString szmaxcountflag;
CString szmaxringtime;
CString szbohaotime;
CString szcjtimeflag;
CString szstartmonth;
CString szendmonth;
CString szstartday;
CString szendday;
CString szstarthour;
CString szendhour;
CString szstartminute;
CString szendminute;
try{
if(pRdCjargbase.Open( _T( "XTCJ170" ), FALSE, FALSE, _T( "ODBC;UID=xt170;PWD=VCplus170" ))==FALSE){
//WinPrintf("连接数据库失败");
return FALSE;
}
}
catch(CDBException* pEx)
{
//WinPrintf("连接数据库失败");
pEx->Delete();
return FALSE;
}
catch(CMemoryException* pEx)
{
//WinPrintf("连接数据库失败");
pEx->Delete();
return FALSE;
}
if(pRdCjargbase.CanUpdate()==FALSE) {
//WinPrintf("db cann't update");
pRdCjargbase.Close();
return FALSE;
}
if(pRdCjargbase.CanTransact()==FALSE) {
//WinPrintf("Transact cann't do");
pRdCjargbase.Close();
return FALSE;
}
try{
if(pRdCjadminSet.Open( CRecordset::forwardOnly , _T(cjadminSQL))==0){
pRdCjadminSet.Close();
cjarg.cb_count=1;
cjarg.max_count=3;
cjarg.maxcount_flag=1;
cjarg.ringtime=40;
cjarg.bohao_time=1000;
}
}
catch(CDBException* e){
//WinPrintf("连接数据库失败");
e->Delete();
pRdCjargbase.Close();
return FALSE;
}
catch(CMemoryException* e){
//WinPrintf("连接数据库失败");
e->Delete();
pRdCjargbase.Close();
return FALSE;
}
if(pRdCjadminSet.GetRecordCount()==0){
pRdCjadminSet.Close();
cjarg.cb_count=1;
cjarg.max_count=3;
cjarg.maxcount_flag=1;
cjarg.ringtime=40;
cjarg.bohao_time=1000;
}
if(pRdCjadminSet.IsOpen()){
try{
pRdCjadminSet.GetFieldValue( _T(cb_count) , szcbcount);
if(szcbcount.IsEmpty())
cjarg.cb_count=1;
else{
sprintf(ls_tmparg,szcbcount);
cjarg.cb_count=atoi(ls_tmparg);
}
pRdCjadminSet.GetFieldValue( _T(max_count) , szmaxcount);
if(szmaxcount.IsEmpty())
cjarg.max_count=3;
else{
sprintf(ls_tmparg,szmaxcount);
cjarg.max_count=atoi(ls_tmparg);
}
pRdCjadminSet.GetFieldValue( _T(maxcount_flag) , szmaxcountflag);
if(szmaxcountflag.IsEmpty())
cjarg.maxcount_flag=1;
else{
sprintf(ls_tmparg,szmaxcountflag);
cjarg.maxcount_flag=atoi(ls_tmparg);
}
pRdCjadminSet.GetFieldValue( _T(max_ringtime) , szmaxringtime);
if(szmaxringtime.IsEmpty())
cjarg.ringtime=40;
else{
sprintf(ls_tmparg,szmaxringtime);
cjarg.ringtime=atoi(ls_tmparg);
}
pRdCjadminSet.GetFieldValue( _T(bohao_time) , szbohaotime);
if(szbohaotime.IsEmpty())
cjarg.bohao_time=1000;
else{
sprintf(ls_tmparg,szbohaotime);
cjarg.bohao_time=atoi(ls_tmparg);
}
}
catch(CDBException* e){
//WinPrintf("连接数据库失败");
e->Delete();
pRdCjadminSet.Close();
pRdCjargbase.Close();
return FALSE;
}
catch(CMemoryException* e){
//WinPrintf("连接数据库失败");
e->Delete();
pRdCjadminSet.Close();
pRdCjargbase.Close();
return FALSE;
}
pRdCjadminSet.Close();
}
//读取参数表，并对各参数赋值pCjtimeSet
for(i=1;i<=3;i++){
itoa(i,ls_i,10);
sprintf(cjrdtimeSQL, "select cjtimeflag, start_month, end_month, start_day, end_day, start_hour, end_hour, start_minute, end_minute from t_data_cjtime where serial=\'%s\'",ls_i);
try{
if(pRdCjtimeSet.Open( CRecordset::forwardOnly , _T(cjrdtimeSQL))==FALSE){
pRdCjtimeSet.Close();
switch(i){
case 1:
cjarg.cjtime_one=1;
break;
case 2:
cjarg.cjtime_two=0;
break;
case 3:
cjarg.cjtime_three=0;
break;
}
cjarg.cjtime[i-1].start_month=1;
cjarg.cjtime[i-1].end_month=12;
cjarg.cjtime[i-1].start_day=1;
cjarg.cjtime[i-1].end_day=31;
cjarg.cjtime[i-1].start_hour=0;
cjarg.cjtime[i-1].end_hour=23;
cjarg.cjtime[i-1].start_minute=0;
cjarg.cjtime[i-1].end_minute=59;
continue;
}
}
catch(CDBException* e){
//WinPrintf("连接数据库失败");
//strcpy(errormsg, "数据库错误:");
//strcat(errormsg, e->m_strError);
//AfxMessageBox(errormsg, MB_ICONEXCLAMATION );
e->Delete();
pRdCjargbase.Close();
return FALSE;
}
catch(CMemoryException* e){
//WinPrintf("连接数据库失败");
e->Delete();
pRdCjargbase.Close();
return FALSE;
}
if(pRdCjtimeSet.GetRecordCount()==0){
pRdCjtimeSet.Close();
switch(i){
case 1:
cjarg.cjtime_one=1;
break;
case 2:
cjarg.cjtime_two=0;
break;
case 3:
cjarg.cjtime_three=0;
break;
}
cjarg.cjtime[i-1].start_month=1;
cjarg.cjtime[i-1].end_month=12;
cjarg.cjtime[i-1].start_day=1;
cjarg.cjtime[i-1].end_day=31;
cjarg.cjtime[i-1].start_hour=0;
cjarg.cjtime[i-1].end_hour=23;
cjarg.cjtime[i-1].start_minute=0;
cjarg.cjtime[i-1].end_minute=59;
continue;
}
try{
pRdCjtimeSet.GetFieldValue( _T(cjtimeflag) , szcjtimeflag);
if(szcjtimeflag.IsEmpty()){
switch(i){
case 1:
cjarg.cjtime_one=1;
break;
case 2:
cjarg.cjtime_two=0;
break;
case 3:
cjarg.cjtime_three=0;
break;
}
}
else{
switch(i){
case 1:
sprintf(ls_tmparg,szcjtimeflag);
cjarg.cjtime_one=atoi(ls_tmparg);
break;
case 2:
sprintf(ls_tmparg,szcjtimeflag);
cjarg.cjtime_two=atoi(ls_tmparg);
break;
case 3:
sprintf(ls_tmparg,szcjtimeflag);
cjarg.cjtime_three=atoi(ls_tmparg);
break;
}
}
pRdCjtimeSet.GetFieldValue( _T(start_month) , szstartmonth);
if(szstartmonth.IsEmpty())
cjarg.cjtime[i-1].start_month=1;
else{
sprintf(ls_tmparg,szstartmonth);
cjarg.cjtime[i-1].start_month=atoi(ls_tmparg);
}
pRdCjtimeSet.GetFieldValue( _T(end_month) , szendmonth);
if(szendmonth.IsEmpty())
cjarg.cjtime[i-1].end_month=12;
else{
sprintf(ls_tmparg,szendmonth);
cjarg.cjtime[i-1].end_month=atoi(ls_tmparg);
}
pRdCjtimeSet.GetFieldValue( _T(start_day) , szstartday);
if(szstartday.IsEmpty())
cjarg.cjtime[i-1].start_day=1;
else{
sprintf(ls_tmparg,szstartday);
cjarg.cjtime[i-1].start_day=atoi(ls_tmparg);
}
pRdCjtimeSet.GetFieldValue( _T(end_day) , szendday);
if(szendday.IsEmpty())
cjarg.cjtime[i-1].end_day=31;
else{
sprintf(ls_tmparg,szendday);
cjarg.cjtime[i-1].end_day=atoi(ls_tmparg);
}
pRdCjtimeSet.GetFieldValue( _T(start_hour) , szstarthour);
if(szstarthour.IsEmpty())
cjarg.cjtime[i-1].start_hour=0;
else{
sprintf(ls_tmparg,szstarthour);
cjarg.cjtime[i-1].start_hour=atoi(ls_tmparg);
}
pRdCjtimeSet.GetFieldValue( _T(end_hour) , szendhour);
if(szendhour.IsEmpty())
cjarg.cjtime[i-1].end_hour=23;
else{
sprintf(ls_tmparg,szendhour);
cjarg.cjtime[i-1].end_hour=atoi(ls_tmparg);
}
pRdCjtimeSet.GetFieldValue( _T(start_minute) , szstartminute);
if(szstartminute.IsEmpty())
cjarg.cjtime[i-1].start_minute=0;
else{
sprintf(ls_tmparg,szstartminute);
cjarg.cjtime[i-1].start_minute=atoi(ls_tmparg);
}
pRdCjtimeSet.GetFieldValue( _T(end_minute) , szendminute);
if(szendminute.IsEmpty())
cjarg.cjtime[i-1].end_minute=59;
else{
sprintf(ls_tmparg,szendminute);
cjarg.cjtime[i-1].end_minute=atoi(ls_tmparg);
}
}
catch(CDBException* e){
//WinPrintf("连接数据库失败");
//strcpy(errormsg, "数据库错误:");
//strcat(errormsg, e->m_strError);
//AfxMessageBox(errormsg, MB_ICONEXCLAMATION );
e->Delete();
pRdCjtimeSet.Close();
pRdCjargbase.Close();
return FALSE;
}
catch(CMemoryException* e){
//WinPrintf("连接数据库失败");
e->Delete();
pRdCjtimeSet.Close();
pRdCjargbase.Close();
return FALSE;
}
pRdCjtimeSet.Close();
}
pRdCjargbase.Close();
return TRUE;
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -