mainch.asp

一个管理系统全部

         call document.main.zdm.AddItem("姓名") 
         call document.main.zdm.AddItem("性别") 
         call document.main.zdm.AddItem("年龄") 
         call document.main.zdm.AddItem("民族") 
         call document.main.zdm.AddItem("文化程度") 
         call document.main.zdm.AddItem("政治面貌") 
         call document.main.zdm.AddItem("职务") 
          
    case  "职工_代表大会委员会名单" 
         call document.main.zdm.AddItem("大会代码") 
         call document.main.zdm.AddItem("委员会名称") 
         call document.main.zdm.AddItem("主任") 
         call document.main.zdm.AddItem("副主任") 
         call document.main.zdm.AddItem("委员") 
        
          
    case  "职工_代表团团长和专门工作委员会联席会议登记" 
         call document.main.zdm.AddItem("项目序号") 
         call document.main.zdm.AddItem("大会代码") 
         call document.main.zdm.AddItem("时间") 
         call document.main.zdm.AddItem("地点") 
         call document.main.zdm.AddItem("缺席人") 
         call document.main.zdm.AddItem("议题") 
         call document.main.zdm.AddItem("结果")  
    case  "职工_代表巡视检查机关处室建设" 
         call document.main.zdm.AddItem("大会代码") 
         call document.main.zdm.AddItem("处室名称") 
         call document.main.zdm.AddItem("参加人员") 
         call document.main.zdm.AddItem("打分结果") 
         call document.main.zdm.AddItem("汇总名次") 
         call document.main.zdm.AddItem("开始时间") 
         call document.main.zdm.AddItem("结束时间") 
    case  "职工_二级职代会情况一览表" 
         call document.main.zdm.AddItem("大会代码") 
         call document.main.zdm.AddItem("单位") 
         call document.main.zdm.AddItem("时间") 
         call document.main.zdm.AddItem("职工代表人数") 
         call document.main.zdm.AddItem("女代表人数") 
    case  "职工_工会历年表彰文明家庭名单"  
          call document.main.zdm.AddItem("年度") 
          call document.main.zdm.AddItem("单位") 
          call document.main.zdm.AddItem("名单") 
    case  "职工_历届提交职代会审议方案" 
          call document.main.zdm.AddItem("时间") 
          call document.main.zdm.AddItem("大会代码") 
          call document.main.zdm.AddItem("主要议案") 
          call document.main.zdm.AddItem("是否决议") 
    case  "职工_历届职代会情况一览表" 
         call document.main.zdm.AddItem("大会代码") 
         call document.main.zdm.AddItem("时间") 
         call document.main.zdm.AddItem("主要议题") 
                  
    case  "职工_优秀工会工作者一览表" 
         call document.main.zdm.AddItem("年度") 
         call document.main.zdm.AddItem("类别") 
         call document.main.zdm.AddItem("单位") 
         call document.main.zdm.AddItem("工作者名称") 
    case  "职工_职代会提案登记" 
         call document.main.zdm.AddItem("大会代码") 
         call document.main.zdm.AddItem("年份") 
         call document.main.zdm.AddItem("月份") 
         call document.main.zdm.AddItem("提案分类") 
         call document.main.zdm.AddItem("提案内容") 
         call document.main.zdm.AddItem("提案人姓名") 
         call document.main.zdm.AddItem("提案人单位") 
         call document.main.zdm.AddItem("落实部门") 
         call document.main.zdm.AddItem("是否落实未落实原因") 
    case  "职工_专门工作委员会会议" 
         call document.main.zdm.AddItem("项目序号") 
         call document.main.zdm.AddItem("大会代码") 
         call document.main.zdm.AddItem("委员会名称") 
         call document.main.zdm.AddItem("时间") 
         call document.main.zdm.AddItem("地点") 
         call document.main.zdm.AddItem("议题") 
         call document.main.zdm.AddItem("结果") 
    case  "组织_工会会员档案" 
         call document.main.zdm.AddItem("姓名") 
         call document.main.zdm.AddItem("性别") 
         call document.main.zdm.AddItem("出生年月") 
         call document.main.zdm.AddItem("籍贯") 
         call document.main.zdm.AddItem("民族") 
         call document.main.zdm.AddItem("政治面貌") 
         call document.main.zdm.AddItem("文化程度") 
         call document.main.zdm.AddItem("职称") 
         call document.main.zdm.AddItem("参加工作时间") 
         call document.main.zdm.AddItem("入会时间") 
         call document.main.zdm.AddItem("单位") 
    case  "组织_工会委员一览表" 
         call document.main.zdm.AddItem("主席") 
         call document.main.zdm.AddItem("副主席") 
         call document.main.zdm.AddItem("常委") 
         call document.main.zdm.AddItem("委员") 
         call document.main.zdm.AddItem("大会代码") 
    case  "组织_基层工会委员组织机构一览表" 
    case  "组织_先进职工之家" 
         call document.main.zdm.AddItem("年度") 
         call document.main.zdm.AddItem("类别") 
         call document.main.zdm.AddItem("家庭名称") 
          
    case  "组织_优秀工会工作者一览表" 
         call document.main.zdm.AddItem("年度") 
         call document.main.zdm.AddItem("类别") 
         call document.main.zdm.AddItem("单位") 
         call document.main.zdm.AddItem("姓名") 
    case else       
      Alert "此表不存在,请重新输入"       
   end select             
end sub         
 
sub cs_click() 
ret=true 
if main.zdm.Value="" then 
msgbox"字段名不能为空！",48,"兰州工会MIS" 
ret=false 
end if 
if main.czf.Value="" then 
msgbox"操作符不能为空！",48,"兰州工会MIS" 
ret=false 
end if 
if ret=true then 
if xx2="like" then     
xx="select * from "+main.bdm.Value+" where "+main.zdm.Value +" like "+" '%"+main.zhi.value+"%'"  
else     
xx="select * from "+main.bdm.Value+" where "+main.zdm.Value +" "+xx2+" '"+main.zhi.value+"'"  
end if     
main.t1.value=xx                                   
xy=" "+main.zdm.value+" "+main.czf.value+"  "+main.zhi.value                                    
main.xs.value=xy                                                                                                  
                                                                        
main.cs.enabled=false                                                                         
main.bq.enabled=true                                                                         
main.hz.enabled=true                                                                         
main.qktj.enabled=true                                                                         
main.xsjg.enabled=true                                                                         

end if                                                                  
end sub      
 
sub bq_click() 
if xx2="like" then     
xx=xx+" and "+main.zdm.value+" "+xx2+" '%"+main.zhi.value+"%' " 
else     
xx=xx+" and "+xx1+" "+xx2+" '"+main.zhi.value+"' " 
end if     
main.t1.value=xx                                   
xy=xy+chr(13)+" " +main.zdm.value+" "+main.czf.value+"  "+main.zhi.value                                    
main.xs.value=xy                                                                                                  

main.cs.enabled=false                                                                         
main.bq.enabled=true                                                                         
main.hz.enabled=true                                                                         
main.qktj.enabled=true                                                                         
main.xsjg.enabled=true                                                                         

end sub      
 
sub hz_click() 
if xx2="like" then     
xx=xx+" or "+main.zdm.value+" "+xx2+" '%"+main.zhi.value+"%' " 
else     
xx=xx+" or "+xx1+" "+xx2+" '"+main.zhi.value+"' " 
end if     
main.t1.value=xx                                   
xy=xy+chr(13)+" " +main.zdm.value+" "+main.czf.value+"  "+main.zhi.value                                    
main.xs.value=xy                                                                                                  

main.cs.enabled=false                                                                         
main.bq.enabled=true                                                                         
main.hz.enabled=true                                                                         
main.qktj.enabled=true                                                                         
main.xsjg.enabled=true                                                                         

end sub 
 
sub qktj_click() '清空按钮点击事件                                                                                                    
main.t1.value=""                                   
main.xs.value=""                                                                                                           

main.cs.enabled=true                                                                         
main.bq.enabled=false                                                                         
main.hz.enabled=false                                                                         
main.qktj.enabled=false                                                                         
main.xsjg.enabled=false  
main.zhi.Value=""                                                                        

end sub                                                                          
 
sub xsjg_click()  '显示按钮点击事件                                                                        
main.submit                                                                         
end sub 
 
sub fh_click() 
top.location.href="../../index.htm" 
end sub 
</script>                   
</html>