using?System;
using?System.Data;
using?System.Data.SqlClient;
using?System.Windows.Forms;

namespace?SSMS
{
????class?Data
????{
????????public?static?int?classCount;
????????public?static?bool?ok?=?false;
????????public?static?string[]?s?=?new?string[100];
????????public?static?string?connectionString?=?“server=WB-PC\\testDB;database=ASchool;Integrated?Security=True“;

????????public?static?string?loginID;

????????//Login表的表名，列名
????????public?static?string?t_login?=?“Login“;
????????public?static?string?c_login_username?=?“userID“;
????????public?static?string?c_login_password?=?“password“;
????????public?static?string?c_login_role?=?“role“;

????????//SC表的表名，列名
????????public?static?string?t_sc?=?“SC“;
????????public?static?string?c_sc_snum?=?“snum“;
????????public?static?string?c_sc_cnum?=?“cnum“;
????????public?static?string?c_sc_score?=?“score“;

????????//TableCourse表的表名，列名
????????public?static?string?t_course?=?“TableCourse“;
????????public?static?string?c_course_cnum?=?“cnum“;
????????public?static?string?c_course_cname?=?“cname“;
????????public?static?string?c_course_tnum?=?“tnum“;

????????//TableStudent表的表名，列名
????????public?static?string?t_student?=?“TableStudent“;
????????public?static?string?c_student_snum?=?“snum“;
????????public?static?string?c_student_sname?=?“sname“;
????????public?static?string?c_student_sclass?=?“sclass“;

????????//TableTeacher表的表名，列名
????????public?static?string?t_teacher?=?“TableTeacher“;
????????public?static?string?c_teacher_tnum?=?“tnum“;
????????public?static?string?c_teacher_tname?=?“tname“;
????????public?static?string?c_teacher_cname?=?“cname“;
????????public?static?string?c_teacher_cnum?=?“cnum“;

????????//Enroll表的表名，列名?選課開關
????????public?static?string?t_enroll?=?“Enroll“;
????????public?static?string?c_enroll_switch?=?“switch“;

????????//兩個視圖的名稱
????????public?static?string?v_score?=?“S_C_Score_View“;
????????public?static?string?v_class?=?“Class_View“;

????????//DeleteStudent存儲過程?名稱、參數
????????public?static?string?sp_delStudent?=?“spDeleteStudent“;
????????public?static?string?sp_delStudent_para?=?“@snum“;

????????//DeleteTeacher存儲過程?名稱、參數
????????public?static?string?sp_delTeacher?=?“spDeleteTeacher“;
????????public?static?string?sp_delTeacher_para?=?“@tnum“;


????????///?

????????///?自動調整列寬，以適應表格大小
????????///?

????????///?需要被調整的DataGridView對象
????????public?static?void?columnAutoAdapter（DataGridView?dv）
????????{
????????????int?totalWidth?=?0;
????????????for?（int?i?=?0;?i?????????????{
????????????????totalWidth?+=?dv.Columns[i].Width;//記錄整個DataGridView的寬度
????????????}
????????????for?（int?i?=?0;?i?????????????{
????????????????dv.Columns[i].FillWeight?=?（dv.Columns[i].Width?*?100）?/?totalWidth;
????????????}
????????????dv.AutoSizeColumnsMode?=?DataGridViewAutoSizeColumnsMode.Fill;
????????}


????????///?