using?System;
using?System.Collections.Generic;
using?System.Linq;
using?System.Text;
using?System.Data;

namespace?Student_Result_System
{
????///?

????///?業(yè)務(wù)處理類
????///?

????public?class?BLL
????{
????????#region?判斷是否登陸成功
????????public?static?bool?Loginbll（string?name?string?pwd）
????????{
????????????string?sql?=?string.Format（@“select?count（*）?from?[admin]?where?name=‘{0}‘?and?passwd=‘{1}‘“?name?pwd）;
????????????try
????????????{
????????????????return?int.Parse（DBHelper.GetOnly（sql）.ToString（））?>?0;
????????????}
????????????catch?（Exception）
????????????{
????????????????return?false;
????????????}
????????}
????????#endregion

????????#region?學(xué)生信息查詢
????????public?static?DataSet?GetAllStu（）
????????{
????????????string?sql?=?“select?id?as?‘編號‘Name?as?‘姓名‘BJDM?as?‘班級代碼‘?from?student“;
????????????return?DBHelper.GetSet（sql）;
????????}
????????#endregion

????????#region?學(xué)生信息錄入
????????public?static?bool?Stu_inser（string?no?string?name?string?_class）
????????{
????????????string?sql?=?string.Format（@“insert?into?student?values（‘{0}‘‘{1}‘‘{2}‘）“?no?name?_class）;
????????????return?DBHelper.ExecuteSql（sql）;
????????}
????????#endregion

????????#region?學(xué)生信息刪除
????????public?static?bool?Stu_delete（string?no）
????????{
????????????string?sql?=?string.Format（@“delete?student?where?ID=‘{0}‘“no）;
????????????return?DBHelper.ExecuteSql（sql）;
????????}
????????#endregion

????????#region?成績刪除
????????public?static?void?Result_delete（string?no）
????????{
????????????string?sql?=?string.Format（@“delete?cjbiao?where?ID=‘{0}‘“no）;
????????????DBHelper.ExecuteSql（sql）;
????????}
????????#endregion

????????#region?成績查詢
????????public?static?DataSet?GetResultSet（string?where）
????????{
????????????string?sql?=?“select?cjbiao.ID?as?‘編號‘student.Name?as?‘姓名‘kecheng.KCMC?as?‘課程‘BJ.BJMC?as?‘班級‘cjbiao.CJ?from?cjbiaokechengBJstudent?where?cjbiao.KCDM=kecheng.KCDM?and?cjbiao.BJDM=BJ.BJDM?and?student.ID=cjbiao.ID“?+?where;
????????????return?DBHelper.GetSet（sql）;
????????}
????????#endregion

????????#region?班級查詢
????????public?static?DataSet?GetClassSet（）
????????{
????????????string?sql?=?“select?*?from?BJ“;
????????????return?DBHelper.GetSet（sql）;
????????}
????????#endregion

????????#region?課程查詢
????????public?static?DataSet?GetCourseSet（）
????????{
????????????string?sql?=?“select?*?from?kecheng“;
????????????return?DBHelper.GetSet（sql）;
????????}
????????#endregion

????????#region?成績錄入
????????public?static?bool?Result_insert（string?no?string?kcdm?string?bjdm?string?cj）
????????{
????????????string?sql?=?string.Format（@“insert?into?cjbiao?values（‘{0}‘‘{1}‘‘{2}‘‘{3}‘）“?no?kcdm?bjdm?cj）;
????????????return?DBHelper.ExecuteSql（sql）;
????????}
????????#endregion

????????#region?成績修改
????????public?static?bool?Result_update（string?no?string?course?int?result）
????????{
????????????string?sql?=?string.Format（@“updat

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----

?????文件????3496448??2014-06-01?14:35??Student_Result_System（3）\Student_Result_System\Student_Result_System\bin\Debug\Student_Result_System.exe

?????文件?????122368??2014-06-01?14:35??Student_Result_System（3）\Student_Result_System\Student_Result_System\bin\Debug\Student_Result_System.pdb

?????文件??????11600??2014-06-01?14:35??Student_Result_System（3）\Student_Result_System\Student_Result_System\bin\Debug\Student_Result_System.vshost.exe

?????文件????????490??2010-03-17?22:39??Student_Result_System（3）\Student_Result_System\Student_Result_System\bin\Debug\Student_Result_System.vshost.exe.manifest

?????文件???????3304??2013-11-16?13:34??Student_Result_System（3）\Student_Result_System\Student_Result_System\BLL.cs

?????文件???????1420??2013-11-16?13:20??Student_Result_System（3）\Student_Result_System\Student_Result_System\DB\StudentCj.sql

?????文件???????1880??2013-11-14?17:54??Student_Result_System（3）\Student_Result_System\Student_Result_System\DBHelper.cs

?????文件???????2845??2013-11-14?21:55??Student_Result_System（3）\Student_Result_System\Student_Result_System\Frm_Login.cs

?????文件???????4731??2013-11-14?21:52??Student_Result_System（3）\Student_Result_System\Student_Result_System\Frm_Login.Designer.cs

?????文件?????720967??2013-11-14?21:52??Student_Result_System（3）\Student_Result_System\Student_Result_System\Frm_Login.resx

?????文件???????2861??2013-11-16?01:10??Student_Result_System（3）\Student_Result_System\Student_Result_System\Frm_Main.cs

?????文件??????10267??2013-11-14?23:40??Student_Result_System（3）\Student_Result_System\Student_Result_System\Frm_Main.Designer.cs

?????文件?????721165??2013-11-14?23:40??Student_Result_System（3）\Student_Result_System\Student_Result_System\Frm_Main.resx

?????文件???????3616??2013-11-15?00:00??Student_Result_System（3）\Student_Result_System\Student_Result_System\Frm_result_Insert.cs

?????文件???????8755??2013-11-14?23:43??Student_Result_System（3）\Student_Result_System\Student_Result_System\Frm_result_Insert.Designer.cs

?????文件?????720967??2013-11-14?23:43??Student_Result_System（3）\Student_Result_System\Student_Result_System\Frm_result_Insert.resx

?????文件???????2092??2013-11-14?22:40??Student_Result_System（3）\Student_Result_System\Student_Result_System\Frm_result_Select.cs

?????文件???????8625??2013-11-14?21:51??Student_Result_System（3）\Student_Result_System\Student_Result_System\Frm_result_Select.Designer.cs

?????文件?????720967??2013-11-14?21:51??Student_Result_System（3）\Student_Result_System\Student_Result_System\Frm_result_Select.resx

?????文件???????3571??2013-11-16?13:01??Student_Result_System（3）\Student_Result_System\Student_Result_System\Frm_result_Update.cs

?????文件???????7134??2013-11-16?00:37??Student_Result_System（3）\Student_Result_System\Student_Result_System\Frm_result_Update.Designer.cs

?????文件?????720967??2013-11-16?00:37??Student_Result_System（3）\Student_Result_System\Student_Result_System\Frm_result_Update.resx

?????文件???????1702??2013-11-16?13:54??Student_Result_System（3）\Student_Result_System\Student_Result_System\Frm_stu_Delete.cs

?????文件???????4660??2013-11-16?13:11??Student_Result_System（3）\Student_Result_System\Student_Result_System\Frm_stu_Delete.Designer.cs

?????文件?????720967??2013-11-16?13:11??Student_Result_System（3）\Student_Result_System\Student_Result_System\Frm_stu_Delete.resx

?????文件???????2011??2013-11-16?13:50??Student_Result_System（3）\Student_Result_System\Student_Result_System\Frm_stu_Insert.cs

?????文件???????6205??2013-11-16?13:49??Student_Result_System（3）\Student_Result_System\Student_Result_System\Frm_stu_Insert.Designer.cs

?????文件?????720967??2013-11-16?13:49??Student_Result_System（3）\Student_Result_System\Student_Result_System\Frm_stu_Insert.resx

?????文件????????953??2013-11-13?20:22??Student_Result_System（3）\Student_Result_System\Student_Result_System\Frm_stu_Select.cs

?????文件???????3847??2013-11-13?20:22??Student_Result_System（3）\Student_Result_System\Student_Result_System\Frm_stu_Select.Designer.cs

............此處省略45個文件信息