📄 form_kckcx.cs
字号:
teau_easy.HeaderText ="教学单元出题量比重(易)";
teau_easy.MappingName ="teau_easy";
teau_easy.Width = 150;
DataGridTextBoxColumn teau_detail = new DataGridTextBoxColumn ();
teau_detail.HeaderText ="教学单元知识点说明";
teau_detail.MappingName ="teau_detail";
teau_detail.Width = 200;
style2.GridColumnStyles.AddRange(new DataGridColumnStyle[]{teau_name,teau_diffcult,teau_normal,teau_easy,teau_detail});
dgd_jxdy.TableStyles.Clear();
dgd_jxdy.TableStyles.Add (style2);
dgd_jxdy.SetDataBinding(dst_kckcx2,"table2");
dgd_jxdy.CurrentRowIndex = 0;
dgd_jxdy.Select(dgd_jxdy.CurrentRowIndex);
}
}
}
private void btn_cx_Click(object sender, System.EventArgs e)
{
if(ckb_sfgljxdy.Checked == true)
{
k = 1;
}
else
{
k =2;
}
this.dst_kckcx1.Clear();
this.dst_kckcx2.Clear();
this.dst_kckcx3.Clear();
try
{
sqlcnt.Open();
}
catch
{
MessageBox.Show("服务器连接出错","阜和教育课程体系试题库系统提示");
return;
}
if (i ==1)
{
sqlcmd.CommandText = "select * from course where cou_kind = " + kind + "and cou_level = " + level;
sqlcmd.Connection = sqlcnt;
sqldpt_kckcx1.SelectCommand = sqlcmd;
sqldpt_kckcx1.Fill(dst_kckcx1,"table1");
if (this.dst_kckcx1.Tables[0].Rows.Count !=0)
{
this.dgd_kc.TableStyles.Clear();
DataGridTableStyle style1=new DataGridTableStyle();
style1.MappingName = "table1";
DataGridTextBoxColumn cou_name = new DataGridTextBoxColumn ();
cou_name.HeaderText = "课程名称";
cou_name.MappingName = "cou_name";
cou_name.Width = 150;
DataGridTextBoxColumn cou_kind = new DataGridTextBoxColumn ();
cou_kind.HeaderText = "课程属类";
cou_kind.MappingName = "cou_kind";
cou_kind.Width = 50;
DataGridTextBoxColumn cou_level = new DataGridTextBoxColumn ();
cou_level.HeaderText ="课程阶段";
cou_level.MappingName = "cou_level";
cou_level.Width =50;
DataGridTextBoxColumn cou_outline = new DataGridTextBoxColumn();
cou_outline.HeaderText = "课程教学大纲说明";
cou_outline.MappingName ="cou_outline";
cou_outline.Width = 200;
DataGridTextBoxColumn cou_material = new DataGridTextBoxColumn ();
cou_material.HeaderText ="参考教材";
cou_material.MappingName = "cou_material";
cou_material.Width = 300;
style1.GridColumnStyles.AddRange(new DataGridColumnStyle[]{cou_name,cou_kind,cou_level,cou_outline,cou_material});
dgd_kc.TableStyles.Clear ();
dgd_kc.TableStyles.Add (style1);
dgd_kc.SetDataBinding(dst_kckcx1,"table1");
dgd_kc.CurrentRowIndex = 0;
dgd_kc.Select(dgd_kc.CurrentRowIndex);
}
this.guanlian();
// if (kind ==1)
// {
// int cou_no = int.Parse(this.dst_kckcx1.Tables[0].Rows[dgd_kc.CurrentRowIndex][0].ToString ());
// sqlcmd.CommandText = "select * from teachingunit where cou_no = "+ cou_no;
// sqlcmd.Connection = sqlcnt;
// this.sqldpt_kckcx2.SelectCommand = sqlcmd;
// this.sqldpt_kckcx2.Fill(dst_kckcx2,"table2");
//
// if (this.dst_kckcx2.Tables[0].Rows.Count != 0 )
// {
//
// this.dgd_jxdy.TableStyles.Clear ();
// DataGridTableStyle style2 = new DataGridTableStyle ();
// style2.MappingName = "table2";
//
// DataGridTextBoxColumn teau_name = new DataGridTextBoxColumn();
// teau_name.HeaderText = "教学单元名称";
// teau_name.MappingName ="teau_name";
// teau_name.Width = 100;
//
// DataGridTextBoxColumn teau_diffcult = new DataGridTextBoxColumn ();
// teau_diffcult.HeaderText = "教学单元出题量比重(难)";
// teau_diffcult.MappingName = "teau_diffcult";
// teau_diffcult.Width = 150;
//
// DataGridTextBoxColumn teau_normal = new DataGridTextBoxColumn ();
// teau_normal.HeaderText ="教学单元出题量比重(中)";
// teau_normal.MappingName ="teau_normal";
// teau_normal.Width = 150;
//
// DataGridTextBoxColumn teau_easy = new DataGridTextBoxColumn ();
// teau_easy.HeaderText ="教学单元出题量比重(易)";
// teau_easy.MappingName ="teau_easy";
// teau_easy.Width = 150;
//
// DataGridTextBoxColumn teau_detail = new DataGridTextBoxColumn ();
// teau_detail.HeaderText ="教学单元知识点说明";
// teau_detail.MappingName ="teau_detail";
// teau_detail.Width = 200;
//
// style2.GridColumnStyles.AddRange(new DataGridColumnStyle[]{teau_name,teau_diffcult,teau_normal,teau_easy,teau_detail});
// dgd_jxdy.TableStyles.Clear();
// dgd_jxdy.TableStyles.Add (style2);
// dgd_jxdy.SetDataBinding(dst_kckcx2,"table2");
//
// dgd_jxdy.CurrentRowIndex = 0;
// dgd_jxdy.Select(dgd_jxdy.CurrentRowIndex);
// }
//
// }
}
if (i == 2)
{
string str = cbb_kcsl.SelectedItem.ToString ();
sqlcmd.CommandText = "select * from teachingunit where cou_no in (select cou_no from teachingability where emp_id = '" + common.emplidstr + "' and cou_no in (select cou_no from course where cou_name = '" + str + "'))";
sqlcmd.Connection = sqlcnt;
this.sqldpt_kckcx3.SelectCommand = sqlcmd;
this.sqldpt_kckcx3.Fill(dst_kckcx3,"table3");
if (dst_kckcx3.Tables[0].Rows.Count != 0)
{
DataGridTableStyle style3 = new DataGridTableStyle ();
style3.MappingName = "table3";
DataGridTextBoxColumn teau_name = new DataGridTextBoxColumn();
teau_name.HeaderText = "教学单元名称";
teau_name.MappingName ="teau_name";
teau_name.Width = 100;
DataGridTextBoxColumn teau_diffcult = new DataGridTextBoxColumn ();
teau_diffcult.HeaderText = "教学单元出题量比重(难)";
teau_diffcult.MappingName = "teau_diffcult";
teau_diffcult.Width = 150;
DataGridTextBoxColumn teau_normal = new DataGridTextBoxColumn ();
teau_normal.HeaderText ="教学单元出题量比重(中)";
teau_normal.MappingName ="teau_normal";
teau_normal.Width = 150;
DataGridTextBoxColumn teau_easy = new DataGridTextBoxColumn ();
teau_easy.HeaderText ="教学单元出题量比重(易)";
teau_easy.MappingName ="teau_easy";
teau_easy.Width = 150;
DataGridTextBoxColumn teau_detail = new DataGridTextBoxColumn ();
teau_detail.HeaderText ="教学单元知识点说明";
teau_detail.MappingName ="teau_detail";
teau_detail.Width = 200;
style3.GridColumnStyles.AddRange(new DataGridColumnStyle[]{teau_name,teau_diffcult,teau_normal,teau_easy,teau_detail});
dgd_jxdy.TableStyles.Clear ();
dgd_jxdy.TableStyles.Add (style3);
dgd_jxdy.SetDataBinding(dst_kckcx3,"table3");
dgd_jxdy.CurrentRowIndex = 0;
dgd_jxdy.Select(dgd_jxdy.CurrentRowIndex);
}
}
sqlcnt.Close ();
}
private void rdb_akccx_CheckedChanged(object sender, System.EventArgs e)
{
this.dst_kckcx1.Clear();
this.dst_kckcx2.Clear();
this.dst_kckcx3.Clear();
if(rdb_akccx.Checked == true)
{
i = 1;
lbl_qsrkcjd.Visible = true;
gpb_kcjd.Visible = true;
lbl_qsrkcsl.Text = "请输入课程属类";
ckb_sfgljxdy.Visible = true;
cbb_kcsl.SelectedIndex = -1;
cbb_kcsl.Items.Clear();
cbb_kcsl.Items.Add("基础课");
cbb_kcsl.Items.Add("公共课");
cbb_kcsl.Items.Add("专业课");
cbb_kcsl.Items.Add("其他");
cbb_kcsl.SelectedIndex = 0;
level = 1;
kind = 1;
if(ckb_sfgljxdy.Checked == true)
{
k =1 ;
dgd_kc.Visible = true;
dgd_jxdy.Visible = true;
dgd_kc.Dock = System.Windows.Forms.DockStyle.None;
dgd_jxdy.Dock = System.Windows.Forms.DockStyle.None;
}
else
{
k =2;
dgd_jxdy.Visible = false;
dgd_kc.Visible = true;
dgd_kc.Dock = System.Windows.Forms.DockStyle.Fill;
}
}
else
{
i = 2;
lbl_qsrkcjd.Visible = false;
gpb_kcjd.Visible = false;
lbl_qsrkcsl.Text = "请输入课程名称";
ckb_sfgljxdy.Visible = false;
dgd_kc.Visible = false;
dgd_jxdy.Visible = true;
dgd_jxdy.Dock = System.Windows.Forms.DockStyle.Fill;
cbb_kcsl.SelectedIndex = -1;
cbb_kcsl.Items.Clear();
int index = this.dst_kckcx.Tables[0].Rows.Count;
int iLoop = 0;
while (iLoop < index)
{
cbb_kcsl.Items.Add(this.dst_kckcx.Tables[0].Rows[iLoop][0].ToString());
iLoop++;
}
cbb_kcsl.SelectedIndex = -1;
}
}
private void ckb_sfgljxdy_CheckedChanged(object sender, System.EventArgs e)
{
if(ckb_sfgljxdy.Checked == true)
{
k = 1;
dgd_kc.Visible = true;
dgd_jxdy.Visible = true;
dgd_kc.Dock = System.Windows.Forms.DockStyle.None;
dgd_jxdy.Dock = System.Windows.Forms.DockStyle.None;
}
else
{
k =2;
dgd_jxdy.Visible = false;
dgd_kc.Visible = true;
dgd_kc.Dock = System.Windows.Forms.DockStyle.Fill;
}
}
private void rdb_dejd_CheckedChanged(object sender, System.EventArgs e)
{
if (rdb_dejd.Checked == true)
{
level = 2;
}
}
private void rdb_dsjd_CheckedChanged(object sender, System.EventArgs e)
{
if (rdb_dsjd.Checked == true)
{
level = 3;
}
}
private void rdb_dyjd_CheckedChanged(object sender, System.EventArgs e)
{
if( rdb_dyjd.Checked == true)
{
level = 1;
}
}
private void cbb_kcsl_SelectedIndexChanged(object sender, System.EventArgs e)
{
kind = cbb_kcsl.SelectedIndex + 1;
}
private void dgd_kc_MouseUp(object sender, System.Windows.Forms.MouseEventArgs e)
{
if (e.Button == System.Windows.Forms.MouseButtons.Left)
{
Point pt = new Point(e.X,e.Y);
DataGrid.HitTestInfo hit = dgd_kc.HitTest(pt);
if(hit.Type == DataGrid.HitTestType.Cell)
{
dgd_kc.Select(hit.Row);
}
this.guanlian ();
}
}
private void dgd_jxdy_MouseUp(object sender, System.Windows.Forms.MouseEventArgs e)
{
if (e.Button == System.Windows.Forms.MouseButtons.Left)
{
Point pt = new Point(e.X,e.Y);
DataGrid.HitTestInfo hit = dgd_jxdy.HitTest(pt);
if(hit.Type == DataGrid.HitTestType.Cell)
{
dgd_jxdy.Select(hit.Row);
}
}
}
private void dgd_kc_MouseDown(object sender, System.Windows.Forms.MouseEventArgs e)
{
}
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -