主程序文件-需要根据您的环境配置数据库，请阅读***说明
upload_5xsoft.inc
asofttykq36.mdb
admovie.jpg
Arrow002.gif
greybg.gif
loginLine.gif
main_04.gif
main_07.gif
main_09.gif
main_10.gif
main_12.gif
main_14.gif
main_19.gif
main_21.gif
main_bg.gif
nav_back.gif
qd_main.swf
spacer.gif
titlebg.gif
top_logo.png
upload_browse.png
addmenber.gif
annadd.gif
anndel.gif
annedit.gif
annlist.gif
annouce.gif
attachment.gif
attachment0.gif
autoclear.gif
autorun.gif
cancel.gif
checkarticle.gif
check_error.gif
check_error_big.gif
check_right.gif
check_right_big.gif
datePicker.gif
deletemenber.gif
deletemenber_no.gif
delplugin.gif
delsta.gif
editdata.gif
editmenber.gif
finish.gif
getpass.gif
inf_add.gif
inf_del.gif
inf_edit.gif
inf_list.gif
loadcon.gif
loading.gif
lock_scr.gif
login_button.gif
mailback.gif
mail_add.gif
mail_delete.gif
mail_readed.gif
mail_torecl.gif
mail_unreaded.gif
msg_admin.gif
msg_menber.gif
msg_otherworktypemenber.gif
msg_shenhe.gif
msg_thisworktypemenber.gif
myinfo.gif
noshenhemenber_del.gif
plugin.gif
qdedit.gif
qdlist.gif
qdzadd.gif
qjhelp.gif
qjlc_add.gif
qjlc_del.gif
qjlc_edit.gif
qj_add.gif
qj_del.gif
qj_list.gif
qj_notpass.gif
recycle.gif
reduce.gif
reflash.gif
reg_button.gif
reload.gif
reload.png
rpointer.gif
search.gif
serverinfo.gif
setsta.gif
shenhemenber.gif
stopplugin.gif
switch.gif
toexcel.gif
Top_Pic001.gif
Top_Pic003.gif
type_down.gif
type_up.gif
upload.gif
uploadcancel.png
webset.gif
worklog.gif
worklog_Add.gif
worklog_del.gif
worklog_edit.gif
worksta.gif
worksta_fy.gif
zaiban.gif
ui-bg_flat_0_aaaaaa_40x100.png
ui-bg_flat_55_fbec88_40x100.png
ui-bg_flat_75_ffffff_40x100.png
ui-bg_glass_55_fbf9ee_1x400.png
ui-bg_glass_65_ffffff_1x400.png
ui-bg_glass_75_d0e5f5_1x400.png
ui-bg_glass_75_dadada_1x400.png
ui-bg_glass_75_e6e6e6_1x400.png
ui-bg_glass_85_dfeffc_1x400.png
ui-bg_glass_95_fef1ec_1x400.png
ui-bg_gloss-wave_55_5c9ccc_500x100.png
ui-bg_highlight-soft_75_cccccc_1x100.png
ui-bg_inset-hard_100_f5f8f9_1x100.png
ui-bg_inset-hard_100_fcfdfd_1x100.png
ui-icons_217bc0_256x240.png
ui-icons_x240.png
ui-icons_2e83ff_256x240.png
ui-icons_x240.png
ui-icons_469bdd_256x240.png
ui-icons_6da8d5_256x240.png
ui-icons_x240.png
ui-icons_cd0a0a_256x240.png
ui-icons_d8e7f3_256x240.png
ui-icons_f9bd01_256x240.png
asoft_logo.png
login_bottom.png
login_center_left.png
login_center_right.png
login_top.png
list_img.gif
loginout.gif
system.gif
update.gif
nowait.gif
Page_First.gif
Page_First_0.gif
Page_Last.gif
Page_Last_0.gif
Page_Next.gif
Page_Next_0.gif
Page_Previous.gif
Page_Previous_0.gif
asoft_tools
jquery-css
ui-bg_flat_0_aaaaaa_40x100.png
ui-bg_flat_55_fbec88_40x100.png
ui-bg_flat_75_ffffff_40x100.png
ui-bg_glass_55_fbf9ee_1x400.png
ui-bg_glass_65_ffffff_1x400.png
ui-bg_glass_75_d0e5f5_1x400.png
ui-bg_glass_75_dadada_1x400.png
ui-bg_glass_75_e6e6e6_1x400.png
ui-bg_glass_85_dfeffc_1x400.png
ui-bg_glass_95_fef1ec_1x400.png
ui-bg_gloss-wave_55_5c9ccc_500x100.png
ui-bg_highlight-soft_75_cccccc_1x100.png
ui-bg_inset-hard_100_f5f8f9_1x100.png
ui-bg_inset-hard_100_fcfdfd_1x100.png
ui-icons_217bc0_256x240.png
ui-icons_x240.png
ui-icons_2e83ff_256x240.png
ui-icons_x240.png
ui-icons_469bdd_256x240.png
ui-icons_6da8d5_256x240.png
ui-icons_x240.png
ui-icons_cd0a0a_256x240.png
ui-icons_d8e7f3_256x240.png
ui-icons_f9bd01_256x240.png
jquery-ui-1.7.1.custom.css
uploadify.css
jquery-uploadify
expressInstall.swf
uploadify.swf
xheditor_emot
biggrin.gif
handshake.gif
shocked.gif
titter.gif
tongue.gif
victory.gif
xheditor_skin
spacer.gif
tag-address.png
tag-div.png
tag-h1.png
tag-h2.png
tag-h3.png
tag-h4.png
tag-h5.png
tag-h6.png
tag-pre.png
toolsbg.gif
iframe.css
foot-inc.inc
head-inc.inc
签到初始化插件.xml
asoft_login.css
asoft_main.css
asoft_reset.css
jquery-ui-1.7.1.custom.css
uploadify.css
3.6正式版***说明.txt
Asoft签到管理系统图文操作说明for-3.6.doc
v3.6正式版升级详情.txt
配套数据库***、升级指引.zip
&!--#include file=&conn.asp&--&
&!--#include file=&checklogin.asp&--&
'##############################
'# 程序名：Asoft 签到管理系统
'# 版本：V3.6 正式版 build [发布 ]
'#############################
作者提供有偿修改服务
'#############################
'# 作者：野马
'# QQ：2643148
'# E-mail：
'# 开发方网站：/
'#############################
签到签退迟到早退旷工记录
'#############################
if judgeqx(&308,309,310,311&,&0&,0)=false then
call systemevent(&err&,2,&警告&,2)
response.end
act=request(&act&)
if act=&& then
&!DOCTYPE html PUBLIC &-//W3C//DTD XHTML 1.0 Strict//EN& &http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd&&
&html xmlns=&http://www.w3.org/1999/xhtml&&
&!--{{{ 标题 }}}--&
&title&&%=webname%& - 考勤记录&/title&
&!--{{{ CSS pack}}}--&
&!--#include file=&./jsinc/head-inc.inc&--&
&!--#include file=&./ajaxinc/top.asp&--&
&div id=&main_div&&
&div id=&right_div&&
&div id=&guidance&&
&%=Guidance1%&
&span class=&white&& → 查询/导出考勤记录/处理申辩申请&/span&&/span&
&%=Guidance2%&
&div id=&right_font&&&img src=&./images/icon/search.gif&/&
&%if act&&&dft& then%&
onclick=&location.href='menberqdqt.asp';&
style=&cursor:pointer& asoft_tips='返回查询页面'&重新查询&/span&
&%end if%&
&!--guidance end--&
id=&right_content&&
&!--内容区 start--&
if act=&dft& then
thisyear=year(date())
thismonth=month(date())
thisday=day(date())
kq_check_form = &&form name='checkqdqt' method='post' action='?act=checkqdqt'&&
kq_check_form = kq_check_form & &&table class='asoft_table' style='width:70%;margin:0 auto'&&
kq_check_form = kq_check_form & &&tr&&td
class='thgray' &&img src='./images/icon/checkarticle.gif'& 查询/导出考勤记录/处理申辩申请&/td&&/tr&&
kq_check_form = kq_check_form & &&tr&&td style='text-align:'&&strong&查询条件: &label&&input type='radio' name='selectcx' onclick='doselectcx(this.value);' value='name' &按真实姓名&/label& &&&&label&&input type='radio' name='selectcx' onclick='doselectcx(this.value);' value='ftime' checked='checked'&按日期&/label&&&&&&label&&input type='radio' name='selectcx' onclick='doselectcx(this.value);' value='multime' &按时间段&/label&&
if judgeqx(&309&,&0&,0) then
kq_check_form = kq_check_form & &&&&&span class='little_bfont'&部门限定 &&type_list(0,-1,&-1&,&0&)&&&&&&&
elseif judgeqx(&308&,&0&,0) then
kq_check_form = kq_check_form & &&&&&span class='little_bfont'&部门限定 &&type_list(0,2,&-1&,&0&)&&&&&&&
kq_check_form = kq_check_form & &
查询类别&/span&&select
name='checktype_option' class='select_box'&&option value='所有'&所有&/option&&
if request.QueryString(&opt_sel&)=&sb& then
kq_check_form = kq_check_form & &&option value='申辩' selected='selected'&申辩&/option&&
kq_check_form = kq_check_form & &&option value='申辩'&申辩&/option&&
kq_check_form = kq_check_form & &&option value='签到'&签到&/option&&option value='签退'&签退&/option&&option value='迟到'&迟到&/option&&option value='早退'&早退&/option&&option value='旷工'&旷工&/option&&option value='请假'&请假&/option&&option value='加班'&加班&/option&&/select&&hr size='1'&&/td&&/tr&&
kq_check_form = kq_check_form & &&tr&&td style='display:text-align:' id='cx_text_tr' &&input type='text' name='tj' class='text_dftbox' value='输入查询条件' onclick='doselectcxsubmit();' onkeyup='doselectcxsubmit();'
size='35' &&/td&&/tr&&
kq_check_form = kq_check_form & &&td
style='display:;text-align:' id='cx_sintime_tr' &点选日期：&input name='sintime'
class='calendar_box' readonly onclick=&&SelectDate(this,'yyyy-MM-dd')&& value='&&Format_Time(date(),2)&&'&&/td&&/tr&&
kq_check_form = kq_check_form & &&tr&&td
style='display:text-align:' id='cx_multime_tr'
& 点选时间段：&input type='text' class='calendar_box'
size='20' readonly='readonly' onclick=&&javascript:SelectDate(this,'yyyy-MM-dd~hh:mm:ss')&&
name='starttime' id='starttime'&-&input type='text' class='calendar_box'
size='20' readonly='readonly' onclick=&&javascript:SelectDate(this,'yyyy-MM-dd~hh:mm:ss')&& name='endtime' id='endtime'&
&input type='button'
onclick='doselectcxsubmit2()' value='Check' class='text_dftbox' name='check'&&/td&&/tr&&
kq_check_form = kq_check_form & &&tr&&td
colspan='2'
class='td3' text-align:&&input type='submit' name='suba' class='text_dftbox' value='提交'& &input type=reset name='res' class='text_dftbox' value='重置'&&/td&&/tr&&/table&&/form&&
response.write kq_check_form
'########################################
预留功能：签到记录删除
'########################################
if judgeqx(&307&,&0&,0) then
response.write&&br /&&br /& &br /&&form
name='qdqtdel'
method='post' action='?act=qdqtdel' &&
response.write&&table class='asoft_table' style='width:70%;margin:0 auto'&&
response.write&&tr&&td
class='thgray' &&img src='./images/icon/uploadcancel.png'& &span class='little_red_font'&删除&/span&考勤纪录&/td&&/tr&&
response.write&&tr&&td style='text-align:'&&strong&&span class='little_red_font'&删除&/span&条件:
&label&&input type='radio' name='selectcxdel' onclick='doselectdel(this.value);' value='delname' &按用户真实姓名&/label& &&&label&&input type='radio' name='selectcxdel' onclick='doselectdel(this.value);' value='delftime' checked='checked'&按日期&/label&&&&&label&&input type='radio' name='selectcxdel' onclick='doselectdel(this.value);' value='delmultime' &按时间段&/label& &
if judgeqx(&309&,&0&,0) then
response.write&&&&&span class='little_bfont'&部门限定 &&type_list(0,-1,&-1&,&0&)&&&&&&&
elseif judgeqx(&308&,&0&,0) then
response.write&&&&&span class='little_bfont'&部门限定 &&type_list(0,2,&-1&,&0&)&&&&&&&
response.write&&span class='little_red_font'&删除&/span&类别&/span&&select
name='checktype_option' class='select_box'&&option value='所有'&所有&/option&&option value='签到'&签到&/option&&option value='签退'&签退&/option&&option value='迟到'&迟到&/option&&option value='早退'&早退&/option&&option value='旷工'&旷工&/option&&option value='请假'&请假&/option&&option value='加班'&加班&/option&&/select&&hr size='1'&&/td&&/tr&&
response.write&&tr&&td style='display:text-align:' id='del_text_tr'&&input type='text' name='tjdel' class='text_dftbox' value='输入删除条件' size='35'onclick='doselectcxsubmit3();' onkeyup='doselectcxsubmit3();'
&&/td&&/tr&&
response.write&&tr&&td style='display:;text-align:' id='del_sintime_tr'&点选日期：&input name='sintime'
class='calendar_box' readonly onclick=&&SelectDate(this,'yyyy-MM-dd')&& value='&&Format_Time(date(),2)&&' &&/td&&/tr&&
response.write&&tr&&td style='display:text-align:' id='del_multime_tr'& 点选时间段：&input type='text' size=20 class='calendar_box'
readonly onclick=&&SelectDate(this,'yyyy-MM-dd~hh:mm:ss')&&
name='starttimedel' id='starttimedel' &-&input type='text'
class='calendar_box'
size=20 readonly onclick=&&SelectDate(this,'yyyy-MM-dd~hh:mm:ss')&& name='endtimedel' id='endtimedel'&
&input type='button'
onclick='doselectcxsubmit4()' value='Check' class='text_dftbox' name='okdel'&&/td&&/tr&&
colspan='2'
class='td3' &&input type='submit' name='subadel' class='text_dftbox' value='删除！'
onclick=&{if(confirm('确定删除吗?\n\n删除后数据不可恢复！')){}}&& &input type=reset name='resdel' class='text_dftbox' value='重置'&&/td&&/tr&&/table&&/form&
'end of cookies(&qx&)=1
'########################################
预留功能：签到记录删除
'########################################
if act=&checkqdqt& then
selectcxradio=request(&selectcx&)
checktype_option=request(&checktype_option&)
request_sdate=replace(request(&starttime&),&~&,& &)
request_edate=replace(request(&endtime&),&~&,& &)
request_sdate_char=request(&starttime&)
request_edate_char=request(&endtime&)
if(request_sdate&&empty and request_edate&&empty) then isaddtime=&ok& else isaddtime=&no& end if
request_sdateview=Format_Time(request_sdate, 1)
request_edateview=Format_Time(request_edate, 1)
order_by = & order by qdtime DESC,menbertype ASC&
and thisqd_sb is not null
if dbtype=2 then
= & and not isnull(thisqd_sb) &
'构建部门限定 SQL 语句 start
menbertype = &
and menbertype&0 &
if request.Form(&user_worktype&)&&empty then
if int(request.Form(&user_worktype&))=0 then
if judgeqx(&308&,&0&,0) then
menbertype = & and charindex(quotename([menbertype],'`'),'`&&user_comtype&&`')&0 &
if dbtype=2 then menbertype = & and instr('`&&user_comtype&&`','`'&menbertype&'`')&0 &
menbertype = & and menbertype=&&int(request.Form(&user_worktype&))
if judgeqx(&309&,&0&,0) then
if int(request.Form(&user_worktype&))&0 then menbertype = & and menbertype=&&int(request.Form(&user_worktype&))
menbertype = & and charindex(quotename([menbertype],'`'),'`&&user_comtype&&`')&0 &
if dbtype=2 then menbertype = & and instr('`&&user_comtype&&`','`'&menbertype&'`')&0 &
'构建部门限定 SQL 语句 end
if selectcxradio=&name& then
selecttjtext=trim(request(&tj&))
asoft_rs.open &select * from ct_sql where realname='&&selecttjtext&&'&,cn,1,1
if not asoft_rs.eof then
menberid=asoft_rs(&id&)
response.write &&script &alert('查无此人！');history.back();&/script&&
asoft_rs.close
menberid_sql = & and menberid=&&menberid
if isaddtime=&ok& then
addtime_sql = & and qdtime&='&&request_sdate&&' and qdtime&='&&request_edate&&' &
if dbtype=2 then
addtime_sql = & and qdtime&=#&&request_sdate&&# and qdtime&=#&&request_edate&&# &
if checktype_option=&所有& then
session(&qdqt_sql&) = &select * from qdzxrec where 1=1 & & menberid_sql & addtime_sql & menbertype & order_by
checktype_option=&申辩& then
session(&qdqt_sql&) = &select * from qdzxrec where
1=1 & & menberid_sql & addtime_sql & is_null & menbertype & order_by
elseif checktype_option=&签到& then
session(&qdqt_sql&) = &select * from qdzxrec where
1=1 & & menberid_sql && and
(qdzt like '%正常%' or qdzt like '%迟到%')
&& addtime_sql & menbertype & order_by
checktype_option=&签到（含签退、迟到）&
session(&qdqt_sql&) = &select * from qdzxrec where
1=1 & & menberid_sql && and
qdzt like '%&&checktype_option&&%'
&& addtime_sql & menbertype & order_by
if checktype_option=&所有& then
session(&qdqt_sql&) = &select * from qdzxrec where
1=1 & & menberid_sql & menbertype & order_by
elseif checktype_option=&签到& then
session(&qdqt_sql&) = &select * from qdzxrec where
1=1 & & menberid_sql && and
(qdzt like '%正常%' or qdzt like '%迟到%') & & menbertype & order_by
checktype_option=&签到（含签退、迟到）&
session(&qdqt_sql&) = &select * from qdzxrec where 1=1 & & menberid_sql && and
qdzt like '%&&checktype_option&&%' & & menbertype & order_by
if checktype_option=&所有& then
session(&alert_hy&) = &察看 &&selecttjtext&& 的签到签退迟到早退旷工纪录&
session(&alert_hy&) =
&察看 &&selecttjtext&& 的&&checktype_option&&纪录&
session(&excel_dc&) = &&a target='_blank' onmousemove=&&window.status='Asoft签到管理系统：数据导出'&& href=&&ajaxinc/toexcel.asp?exceltype=output_menberqdqt&selecttjtext=&&selecttjtext&&&selectcxradio=name&menberid=&&menberid&&&checktype_option=&&GBtoUTF8(checktype_option)&&&starttime=&&request_sdate_char&&&endtime=&&request_edate_char&&&& &&
session(&no_data&) = &&span class='little_bfont'&没有&&&checktype_option&&&记录！&
elseif selectcxradio=&ftime& then
request_date=request(&cxtime&)
if request_date=empty then
request_date=Format_Time(request.form(&sintime&), 2)
request_dateview=Format_Time(request_date, 4)
checktype_option=request(&checktype_option&)
addtime_sql = & and qddate='&&request_date&&' &
if dbtype=2 then addtime_sql = & and qddate=#&&request_date&&# &
if checktype_option=&所有& then
session(&alert_hy&) = &察看 &&request_dateview&& 的签到签退迟到早退旷工纪录&
session(&qdqt_sql&) = &select * from qdzxrec where 1=1 && addtime_sql
& menbertype & order_by
elseif checktype_option=&申辩& then
session(&alert_hy&) = &察看 &&request_dateview&& 的申辩纪录&
session(&qdqt_sql&) = &select * from qdzxrec where 1=1 && addtime_sql & is_null & menbertype & order_by
elseif checktype_option=&签到& then
session(&alert_hy&) = &察看 &&request_dateview&& 的签到（含签退、迟到）纪录&
session(&qdqt_sql&) = &select * from qdzxrec where 1=1 && addtime_sql &&
and (qdzt like '%正常%' or qdzt like '%迟到%') &
& menbertype & order_by
session(&alert_hy&) =
&察看 &&request_dateview&& 的&&checktype_option&&纪录&
session(&qdqt_sql&) = &select * from qdzxrec where 1=1 && addtime_sql && and qdzt like '%&&checktype_option&&%' &
& menbertype & order_by
session(&excel_dc&) = &&a target='_blank' onmousemove=&&window.status='Asoft签到管理系统：数据导出'&& href=&&ajaxinc/toexcel.asp?exceltype=output_menberqdqt&cxtime=&&request_date&&&checktype_option=&&GBtoUTF8(checktype_option)&&&selectcxradio=ftime&& &&
session(&no_data&) = &数据库没有&&request_dateview&&的&&&checktype_option&&&纪录!&
elseif selectcxradio=&multime& then
request_sdate=replace(request(&starttime&),&~&,& &)
request_edate=replace(request(&endtime&),&~&,& &)
request_sdate_char=request(&starttime&)
request_edate_char=request(&endtime&)
request_sdateview=Format_Time(request_sdate, 1)
request_edateview=Format_Time(request_edate, 1)
checktype_option=request(&checktype_option&)
addtime_sql = & and qdtime&='&&request_sdate&&' and qdtime&='&&request_edate&&' &
if dbtype=2 then addtime_sql = & and qdtime&=#&&request_sdate&&# and qdtime&=#&&request_edate&&# &
if checktype_option=&所有& then
session(&alert_hy&) =
&察看 &&request_sdateview&&到 &&request_edateview&& 的签到签退迟到早退旷工纪录&
session(&qdqt_sql&) = &select * from qdzxrec where 1=1 & & addtime_sql & menbertype & order_by
elseif checktype_option=&申辩& then
session(&alert_hy&) =
&察看 &&request_sdateview&&到 &&request_edateview&& 的申辩纪录&
session(&qdqt_sql&) = &select * from qdzxrec where 1=1 & & addtime_sql & is_null & menbertype & order_by
elseif checktype_option=&签到& then
session(&alert_hy&) =
&察看 &&request_sdateview&&到 &&request_edateview&& 的签到纪录（含签退、迟到）&
session(&qdqt_sql&) = &select * from qdzxrec where 1=1 & & addtime_sql&& and (qdzt like '%正常%' or qdzt like '%迟到%') & & menbertype & order_by
session(&alert_hy&) =
&察看 &&request_sdateview&&到 &&request_edateview&& 的&&checktype_option&&纪录&
session(&qdqt_sql&) = &select * from qdzxrec where 1=1 & & addtime_sql&&
qdzt like '%&&checktype_option&&%' & & menbertype & order_by
session(&excel_dc&) =
&&a target='_blank' onmousout=&&window.status='Asoft签到管理系统：数据导出'&& href=&&ajaxinc/toexcel.asp?exceltype=output_menberqdqt&selectcxradio=multime&starttime=&&request_sdate_char&&&endtime=&&request_edate_char&&&checktype_option=&&GBtoUTF8(checktype_option)&&&& &&
session(&no_data&) = &数据库没有该时段的&&&checktype_option&&&纪录!&
response.write &&div id='qdqtcdkg_div'&&img src='images/icon/loading.gif' /&&/div&&
response.write &&script&asoft_ajax_getData('thisform','ajaxinc/ajax_getDataList.asp?datatype=show_qdqtcdztkg&qdqtviewnum_perpage=&&qdmana_perpage&&&page=1','get','qdqtcdkg_div');&/script&&
'###############################
执行删除操作！
'################################
if act=&qdqtdel& then
selectcxradio=request(&selectcxdel&)
checktype_option=request(&checktype_option&)
request_sdate=replace(request(&starttimedel&),&~&,& &)
request_edate=replace(request(&endtimedel&),&~&,& &)
if(request_sdate&&empty and request_edate&&empty) then isaddtime=&ok& else isaddtime=&no& end if
request_sdateview=Format_Time(request_sdate, 1)
request_edateview=Format_Time(request_edate, 1)
'构建部门限定 SQL 语句 start
menbertype = &
and menbertype&0 &
if request.Form(&user_worktype&)&&empty then
if int(request.Form(&user_worktype&))=0 then
if judgeqx(&308&,&0&,0) then
menbertype = & and charindex(quotename([menbertype],'`'),'`&&user_comtype&&`')&0 &
if dbtype=2 then menbertype = & and instr('`&&user_comtype&&`','`'&menbertype&'`')&0 &
menbertype = & and menbertype=&&int(request.Form(&user_worktype&))
if judgeqx(&309&,&0&,0) then
if int(request.Form(&user_worktype&))&0 then menbertype = & and menbertype=&&int(request.Form(&user_worktype&))
menbertype = & and charindex(quotename([menbertype],'`'),'`&&user_comtype&&`')&0 &
if dbtype=2 then menbertype = & and instr('`&&user_comtype&&`','`'&menbertype&'`')&0 &
'构建部门限定 SQL 语句 end
if selectcxradio=&delname&
selecttjtext=trim(request(&tjdel&))
asoft_rs.open &select * from ct_sql where realname='&&selecttjtext&&'&,cn,1,1
if not asoft_rs.eof then
menberid=asoft_rs(&id&)
response.write &&script &alert('系统并无此人的&&&checktype_option&&&记录！');history.back();&/script&&
response.end
asoft_rs.close
menberid_sql = & and menberid=&&menberid
add_time_sql = & and qdtime&='&&request_sdateview&&' and qdtime&='&&request_edateview&&' &
if dbtype=2 then add_time_sql = & and qdtime&=#&&request_sdateview&&# and qdtime&=#&&request_edateview&&# &
if checktype_option=&所有& then
if isaddtime=&ok& then
cur_cl_sql
= & qdzxrec where 1=1 & & menberid_sql & add_time_sql & menbertype
fk_hy = &删除用户&&&selecttjtext&&&从&&&request_sdateview&&&到&&&request_edateview&&&的&&&checktype_option&&&记录成功&
elseif isaddtime=&no& then
cur_cl_sql
= & qdzxrec where 1=1 & & menberid_sql
& menbertype
fk_hy = &删除用户&&&selecttjtext&&&的&&&checktype_option&&&记录成功&
if isaddtime=&ok& then
cur_cl_sql
= & qdzxrec where 1=1 & & menberid_sql &&
qdzt like '%&&checktype_option&&%' & & add_time_sql
& menbertype
fk_hy = &删除用户&&&selecttjtext&&&从&&&request_sdateview&&&到&&&request_edateview&&&的&&&checktype_option&&&记录成功&
elseif isaddtime=&no& then
cur_cl_sql
qdzxrec where 1=1 & & menberid_sql &&
qdzt like '%&&checktype_option&&%'& & menbertype
fk_hy = &删除用户&&&selecttjtext&&&的&&&checktype_option&&&记录成功&
elseif selectcxradio=&delftime& then
request_date=Format_Time(request.form(&sintime&),2)
checktype_option=request(&checktype_option&)
date_sql = & and qddate='&&request_date&&' &
if dbtype=2 then
date_sql = & and qddate=#&&request_date&&# &
if checktype_option=&所有& then
cur_cl_sql
qdzxrec where 1=1 & & date_sql
& menbertype
cur_cl_sql
= & qdzxrec where 1=1 & & date_sql &&
qdzt like '%&&checktype_option&&%'&
& menbertype
fk_hy = &删除指定日期&&&request_date&&&的用户&&&checktype_option&&&记录成功&
elseif selectcxradio=&delmultime& then
request_sdate=replace(request(&starttimedel&),&~&,& &)
request_edate=replace(request(&endtimedel&),&~&,& &)
request_sdate_char=request(&starttimedel&)
request_edate_char=request(&starttimedel&)
request_sdateview=Format_Time(request_sdate, 1)
request_edateview=Format_Time(request_edate, 1)
checktype_option=request(&checktype_option&)
add_time_sql = & and qdtime&='&&request_sdateview&&' and qdtime&='&&request_edateview&&' &
& menbertype
if dbtype=2 then add_time_sql = & and qdtime&=#&&request_sdateview&&# and qdtime&=#&&request_edateview&&# &
& menbertype
if checktype_option=&所有& then
cur_cl_sql
qdzxrec where 1=1 & & add_time_sql
& menbertype
cur_cl_sql
qdzxrec where 1=1 & & add_time_sql &&
qdzt like '%&&checktype_option&&%'& & menbertype
fk_hy = &删除选定时间段&&&request_sdate&&~&&request_edate&&&的用户&&&checktype_option&&&记录成功&
'_______________________________________________________________
'删除照片
asoft_rs.open &select thisqd_img from & & cur_cl_sql,cn,1,1
if not asoft_rs.eof then
Set Asoft_Fso = CreateObject(&Scripting.FileSystemObject&)
do while not asoft_rs.eof
cur_img_list = server.Mappath(&./attachments/_qdphoto_/& & asoft_rs(&thisqd_img&) &&.jpg&)
If (Asoft_Fso.FileExists(cur_img_list)) Then Set Files = Asoft_Fso.GetFile(cur_img_list):Files.Delete(True)
asoft_rs.movenext
Set Asoft_Fso = nothing
asoft_rs.close
'_______________________________________________________________
'删除数据 & 善后
cn.Execute &delete from & & cur_cl_sql
call systemevent(fk_hy,2,&正常&,0)
response.write &&script&alert('删除完毕！');location.href='menberqdqt.asp';&/script&&
response.write cur_cl_sql
&/div&&!--内容区 end--&
&!--right end--&
&/div& &!--maindiv end end--&
&!--#include file=&./jsinc/foot-inc.inc&--&
&!--{{{ diy page-js}}}--&
&script src=&./jsinc/selectcheck.js&&&/script&
function submit_sb(qdmana_perpage,curpage){asoft_ajax_saveData($(&#thisqd_sb_form&).serialize(),'ajaxinc/ajax_saveDataList.asp?datatype=thisqd_sb','post','asoftnew_con','asoftnew_div','ajaxinc/ajax_getDataList.asp?datatype=show_qdqtcdztkg&qdqtviewnum_perpage='+qdmana_perpage+'&page='+curpage,'qdqtcdkg_div');}
function submit_sbcl(qdmana_perpage,curpage){asoft_ajax_saveData($(&#thisqd_sb_form&).serialize(),'ajaxinc/ajax_saveDataList.asp?datatype=thisqd_sbcl','post','asoftnew_con','asoftnew_div','ajaxinc/ajax_getDataList.asp?datatype=show_qdqtcdztkg&qdqtviewnum_perpage='+qdmana_perpage+'&page='+curpage,'qdqtcdkg_div');}
Copyright(C)
OKBASE.NET All Rights Reserved 好库网 版权所有