高校网上教材征订系统的设计与实现(7)

来源:xiaoniu168.com 作者:本站原创 添加时间:2012-04-17 点击数:23553

计算机毕业设计介绍:

4.2.3 教材审核
审核是教材征订中非常重要的环节。教师征订书籍后,系主任将进入系统,点击“修改表单”,系统将会以表单形式列出本系未审核的教材,点击表单中的审核,出现教材审核界面,单击审核按钮,系主任可对该教材进行审核。

具体代码如下:
Private void director_Button_Click (object sender, System.EventArgs e)
  {
   string up="";
  up+="update book_order_table set approve='已审核',approver_ID=" +Convert.ToInt32 (Session ["UserId"].ToString ()) +"where countid=" +getCountId ().ToString ();
   Db.ExecuteSql (up);
   showMsg("审核成功!!");
   Cancel_Button_Click (sender, e);
  }
if(iUsId>=3000)       //系主任审核本系未审核表单
sql+="Select c.user_name as '授课人',a.ISBN as 'ISBN号',a.book_name as '教材名',a. publisher as '出版社',a.pub_time as '出版时间',"+
"a.author_name as '作者',b.department_name as '所属院系',d.book_type_name as '教材类型',a.bar_cord as '条形码',a. approve as '审核',a.student_count as '学生数',"+
"a.student_class as '班级',a.approver_ID  as '审核人ID',a.course_name as '课程名','审核' as 操作"+
" From book_order_table a, department_type b, user_info_table c, book_type_table d where a. approve! ='已审核' and a.book_type=d.book_type and a.user_ID=c.user_ID and a.department=b.department_number and c.department=b.department_number ";

〖资料来源:计算机毕业论文 www.xiaoniu168.com

第8页为计算机毕业论文部分......

【联系方式】

【本站信誉】

用心做计算机毕业设计论文网