//模糊查询
private void Click_QueryOnly(object sender, EventArgs e)
{
FrmInputs inputs = new FrmInputs("模糊查询", new string[] { "班级编号", "班级名称", "学院编号" }, new Dictionary <string, HZH_Controls.TextInputType>()
{
{ "班级编号", HZH_Controls.TextInputType.Regex }, { "班级名称", HZH_Controls.TextInputType.Regex }, { "学院编号", HZH_Controls.TextInputType.Regex }
}, new Dictionary <string, string>()
{
{ "班级编号", @"^\d+$" }, { "班级名称", @"^[\u4E00-\u9FFF0-9]+$" }, { "学员编号", @"^\d+$" }
});
inputs.ShowDialog();
var values = inputs.Values;
T_ClassDAL dal = new T_ClassDAL();
string t_sql = "FulzySearchInT_Class";
SqlParameter[] pars = new SqlParameter[] {
new SqlParameter("@classID", SqlDbType.VarChar)
{
Value = "%" + values[0] + "%"
},
new SqlParameter("@className", SqlDbType.VarChar)
{
Value = "%" + values[1] + "%"
},
new SqlParameter("@collegeID", SqlDbType.VarChar)
{
Value = "%" + values[2] + "%"
}
};
dataGridView1.DataSource = dal.FulzySearch(t_sql, CommandType.StoredProcedure, pars);
}
//加载树
private void LoadTreeNodes()
{
T_CollegeDAL collegeDal = new T_CollegeDAL();
T_ClassDAL classDal = new T_ClassDAL();
var collegeRes = collegeDal.LoadCollege();
TreeNode[] nodes = new TreeNode[collegeRes.Count];
for (int i = 0; i < collegeRes.Count; i++)
{
TreeNode node = new TreeNode();
node.Text = collegeRes[i].CollegeName;
node.Tag = collegeRes[i];
nodes[i] = node;
var classRes = classDal.LoadClass(collegeRes[i].CollegeID);
if (classRes == null)
{
continue;
}
foreach (var item in classRes)
{
TreeNode node1 = new TreeNode(item.ClassName);
node1.Tag = item;
nodes[i].Nodes.Add(node1);
}
}
trvEx1.Nodes.AddRange(nodes);
}
private void LoadClass()
{
T_ClassDAL dal = new T_ClassDAL();
List <T_Class> @class = dal.LoadClass();
comClass.DataSource = @class;
comClass.SelectedIndexChanged += ComClass_SelectedIndexChanged;
ComClass_SelectedIndexChanged(comClass, null);
}
//插入数据
private void Click_OpenInsertDataInforamtion(object sender, EventArgs e)
{
FrmInputs inputs = new FrmInputs("插入班级信息", new string[] { "班级名称", "学院编号" }, new Dictionary <string, HZH_Controls.TextInputType>()
{
{ "班级名称", HZH_Controls.TextInputType.Regex }, { "学院编号", HZH_Controls.TextInputType.Regex }
}, new Dictionary <string, string>()
{
{ "班级名称", @"^[\u4E00-\u9FFF0-9]+$" }, { "学员编号", @"^\d+$" }
});
inputs.ShowDialog();
var values = inputs.Values;
foreach (var item in values)
{
if (item == null || item == string.Empty)
{
return;
}
}
string t_sql = "InsertintoT_Class";
SqlParameter[] pars = new SqlParameter[] {
new SqlParameter("@className", SqlDbType.VarChar, 20)
{
Value = values[0]
},
new SqlParameter("@collegeID", SqlDbType.Int)
{
Value = values[1]
},
};
T_ClassDAL dal = new T_ClassDAL();
int temp1 = curIndex;
int temp2 = collegeID;
try
{
var res = (int)dal.ExecuteScalar(t_sql, CommandType.StoredProcedure, pars);
if (res == 1)
{
curIndex = 1;
dataGridView1.DataSource = dal.LoadPagiation(curIndex, dataLength, collegeID);
FrmDialog.ShowDialog(this, "保存成功");
}
else
{
throw new Exception();
}
}
catch
{
curIndex = temp1;
collegeID = temp2;
FrmDialog.ShowDialog(this, "保存失败,请检查输入是否正确");
}
}
//查询所有
private void Click_QueryAll(object sender, EventArgs e)
{
T_ClassDAL dal = new T_ClassDAL();
try
{
var res = dal.LoadPagiation(1, dataLength, -1);
dataGridView1.DataSource = res;
curIndex = 1;
collegeID = -1;
}
catch
{
}
}
//下一页
private void Click_JumpNextPage(object sender, EventArgs e)
{
int temp = curIndex;
curIndex += 1;
T_ClassDAL dal = new T_ClassDAL();
var res = dal.LoadPagiation(curIndex, dataLength, collegeID);
if (res == null)
{
curIndex = temp;
return;
}
dataGridView1.DataSource = res;
}
private void FrmInsertedClassSetUpCourse_Load(object sender, EventArgs e)
{
//加载学院
T_CollegeDAL dal = new T_CollegeDAL();
comCollege.DataSource = dal.LoadCollege();
//事件触发加载班级
comCollege.SelectedIndexChanged += ComCollege_SelectedIndexChanged;
comCollege.SelectedIndex = 0;
T_ClassDAL classDal = new T_ClassDAL();
comClass.DataSource = classDal.LoadClass();
comCourse.DataSource = new T_CourseDAL().ExecuteListCourseName();
comTeach.DataSource = new T_TeachDAL().GetTeches();
}
private void Click_DeleteDataInforamtion(object sender, EventArgs e)
{
//删除信息
var rows = dataGridView1.SelectedRows;
if (rows.Count == 0)
{
FrmDialog.ShowDialog(this, "请选择一行");
return;
}
var row = rows[0].DataBoundItem as T_Class;
if (row == null)
{
return;
}
string t_sql = "DeleteIntoT_Class";
SqlParameter par = new SqlParameter("@classID", SqlDbType.Int)
{
Value = row.ClassID
};
T_ClassDAL dal = new T_ClassDAL();
int temp1 = curIndex;
int temp2 = collegeID;
try
{
var res = (int)dal.ExecuteScalar(t_sql, CommandType.StoredProcedure, par);
if (res == 1)
{
dataGridView1.DataSource = dal.LoadPagiation(curIndex, dataLength, collegeID);
FrmDialog.ShowDialog(this, "保存成功");
}
else
{
throw new Exception();
}
}
catch
{
curIndex = temp1;
collegeID = temp2;
FrmDialog.ShowDialog(this, "保存失败,请检查输入是否正确");
}
}
private void ucBtnSave_BtnClick(object sender, EventArgs e)
{
var b1 = verNameValidate.Verification();
var b2 = verCollegeIDValidate.Verification();
if (b1 == false || b2 == false)
{
return;
}
//验证通过，提交修改
T_ClassDAL dal = new T_ClassDAL();
string t_sql = "ModifyIntoT_Class";
SqlParameter[] pars = new SqlParameter[] {
new SqlParameter("@classID", SqlDbType.Int)
{
Value = txtUPclassID.Text
},
new SqlParameter("@className", SqlDbType.VarChar, 20)
{
Value = txtUPClassName.Text
},
new SqlParameter("@collegeID", SqlDbType.Int)
{
Value = txtUPCollegeID.Text
}
};
try
{
var res = (int)dal.ExecuteScalar(t_sql, CommandType.StoredProcedure, pars);
if (res == 1)
{
FrmDialog.ShowDialog(this, "保存成功", "提示");
}
else
{
throw new Exception();
}
}
catch
{
FrmDialog.ShowDialog(this, "保存失败", "提示");
}
}
private void FrmClassMana_Load(object sender, EventArgs e)
{
try
{
LoadNavMenuItem();
LoadTreeNodes();
//首先我们加载所有学生信息，以分页的方式显示出来
var res = new T_ClassDAL().LoadPagiation(curIndex, dataLength, collegeID);
if (res == null)
{
return;
}
dataGridView1.DataSource = res;
dataGridView1.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;
dataGridView1.Columns[0].HeaderText = "班级编号";
dataGridView1.Columns[1].HeaderText = "班级名";
dataGridView1.Columns[2].HeaderText = "学院编号";
}
catch {
MessageBox.Show("错误");
}
}
private void trvEx1_AfterSelect(object sender, TreeViewEventArgs e)
{
var college = e.Node.Tag as T_College;
if (college == null)
{
return;
}
T_ClassDAL classDAL = new T_ClassDAL();
int cur = 1;
try
{
var res = classDAL.LoadClass(college.CollegeID);
dataGridView1.DataSource = res;
cur = 1;
collegeID = college.CollegeID;
}
catch
{
cur = curIndex;
}
curIndex = cur;
}
