📄 displaytable.cs
字号:
this.c04.Name = "c04";
this.c04.Size = new System.Drawing.Size(96, 23);
this.c04.TabIndex = 15;
//
// c10
//
this.c10.Font = new System.Drawing.Font("宋体", 14.25F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((System.Byte)(134)));
this.c10.ForeColor = System.Drawing.SystemColors.ActiveCaption;
this.c10.Location = new System.Drawing.Point(48, 328);
this.c10.Name = "c10";
this.c10.Size = new System.Drawing.Size(80, 23);
this.c10.TabIndex = 16;
//
// c11
//
this.c11.Font = new System.Drawing.Font("宋体", 14.25F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((System.Byte)(134)));
this.c11.ForeColor = System.Drawing.SystemColors.ActiveCaption;
this.c11.Location = new System.Drawing.Point(152, 328);
this.c11.Name = "c11";
this.c11.Size = new System.Drawing.Size(72, 23);
this.c11.TabIndex = 17;
//
// c12
//
this.c12.Font = new System.Drawing.Font("宋体", 14.25F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((System.Byte)(134)));
this.c12.ForeColor = System.Drawing.SystemColors.ActiveCaption;
this.c12.Location = new System.Drawing.Point(256, 328);
this.c12.Name = "c12";
this.c12.Size = new System.Drawing.Size(80, 23);
this.c12.TabIndex = 18;
//
// c13
//
this.c13.Font = new System.Drawing.Font("宋体", 14.25F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((System.Byte)(134)));
this.c13.ForeColor = System.Drawing.SystemColors.ActiveCaption;
this.c13.Location = new System.Drawing.Point(368, 328);
this.c13.Name = "c13";
this.c13.Size = new System.Drawing.Size(80, 23);
this.c13.TabIndex = 19;
//
// c14
//
this.c14.Font = new System.Drawing.Font("宋体", 14.25F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((System.Byte)(134)));
this.c14.ForeColor = System.Drawing.SystemColors.ActiveCaption;
this.c14.Location = new System.Drawing.Point(464, 328);
this.c14.Name = "c14";
this.c14.Size = new System.Drawing.Size(96, 23);
this.c14.TabIndex = 20;
//
// c20
//
this.c20.Font = new System.Drawing.Font("宋体", 14.25F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((System.Byte)(134)));
this.c20.ForeColor = System.Drawing.SystemColors.ActiveCaption;
this.c20.Location = new System.Drawing.Point(56, 368);
this.c20.Name = "c20";
this.c20.Size = new System.Drawing.Size(72, 23);
this.c20.TabIndex = 21;
//
// c21
//
this.c21.Font = new System.Drawing.Font("宋体", 14.25F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((System.Byte)(134)));
this.c21.ForeColor = System.Drawing.SystemColors.ActiveCaption;
this.c21.Location = new System.Drawing.Point(152, 368);
this.c21.Name = "c21";
this.c21.Size = new System.Drawing.Size(80, 23);
this.c21.TabIndex = 22;
//
// c22
//
this.c22.Font = new System.Drawing.Font("宋体", 14.25F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((System.Byte)(134)));
this.c22.ForeColor = System.Drawing.SystemColors.ActiveCaption;
this.c22.Location = new System.Drawing.Point(256, 368);
this.c22.Name = "c22";
this.c22.Size = new System.Drawing.Size(80, 23);
this.c22.TabIndex = 23;
//
// c23
//
this.c23.Font = new System.Drawing.Font("宋体", 14.25F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((System.Byte)(134)));
this.c23.ForeColor = System.Drawing.SystemColors.ActiveCaption;
this.c23.Location = new System.Drawing.Point(368, 368);
this.c23.Name = "c23";
this.c23.Size = new System.Drawing.Size(80, 23);
this.c23.TabIndex = 24;
//
// c24
//
this.c24.Font = new System.Drawing.Font("宋体", 14.25F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((System.Byte)(134)));
this.c24.ForeColor = System.Drawing.SystemColors.ActiveCaption;
this.c24.Location = new System.Drawing.Point(464, 368);
this.c24.Name = "c24";
this.c24.Size = new System.Drawing.Size(96, 23);
this.c24.TabIndex = 25;
//
// displayTable
//
this.Controls.Add(this.c24);
this.Controls.Add(this.c23);
this.Controls.Add(this.c22);
this.Controls.Add(this.c21);
this.Controls.Add(this.c20);
this.Controls.Add(this.c14);
this.Controls.Add(this.c13);
this.Controls.Add(this.c12);
this.Controls.Add(this.c11);
this.Controls.Add(this.c10);
this.Controls.Add(this.c04);
this.Controls.Add(this.c03);
this.Controls.Add(this.c02);
this.Controls.Add(this.c01);
this.Controls.Add(this.c00);
this.Controls.Add(this.label10);
this.Controls.Add(this.label9);
this.Controls.Add(this.label8);
this.Controls.Add(this.label7);
this.Controls.Add(this.label6);
this.Controls.Add(this.label5);
this.Controls.Add(this.label4);
this.Controls.Add(this.label3);
this.Controls.Add(this.label2);
this.Controls.Add(this.label1);
this.Controls.Add(this.dataGrid1);
this.Name = "displayTable";
this.Size = new System.Drawing.Size(576, 408);
this.Load += new System.EventHandler(this.displayTable_Load);
((System.ComponentModel.ISupportInitialize)(this.dataGrid1)).EndInit();
this.ResumeLayout(false);
}
#endregion
private void displayTable_Load(object sender, System.EventArgs e)
{
}
private void createTable(string query,string theObject)
{
//MessageBox.Show("afsasdf");
DataColumn newDataColumn;
DataSet obData;
int i = 0;
DataTable obDataTable;
DataRow newDataRow;
Connection c = new Connection();
SqlConnection conn = new SqlConnection(c.getConnectionString);
conn.Open();
switch (theObject)
{
case "class":
//this.dataGrid1.Controls.Clear();
obDataTable = null;
this.dataGrid1.Controls.Clear();
obDataTable = new DataTable("classTable");
newDataColumn = new DataColumn();//1
newDataColumn.DataType = System.Type.GetType("System.String");
newDataColumn.ColumnName = "代号";
obDataTable.Columns.Add(newDataColumn);
newDataColumn = new DataColumn();//2
newDataColumn.DataType = System.Type.GetType("System.String");
newDataColumn.ColumnName = "教师姓名";
obDataTable.Columns.Add(newDataColumn);
newDataColumn = new DataColumn();//3
newDataColumn.DataType = System.Type.GetType("System.String");
newDataColumn.ColumnName = "上课时间";
obDataTable.Columns.Add(newDataColumn);
newDataColumn = new DataColumn();//4
newDataColumn.DataType = System.Type.GetType("System.String");
newDataColumn.ColumnName = "课程名";
obDataTable.Columns.Add(newDataColumn);
newDataColumn = new DataColumn();//5
newDataColumn.DataType = System.Type.GetType("System.String");
newDataColumn.ColumnName = "实际上课人数";
obDataTable.Columns.Add(newDataColumn);
newDataColumn = new DataColumn();//6
newDataColumn.DataType = System.Type.GetType("System.String");
newDataColumn.ColumnName = "班级";
obDataTable.Columns.Add(newDataColumn);
string str = "select * from course";
SqlCommand cmd = new SqlCommand(str,conn);
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
if (this.queryContent == Convert.ToString(dr["classNo"]))
{
i++;
newDataRow = obDataTable.NewRow();
newDataRow["代号"] = i.ToString();
newDataRow["教师姓名"] = this.rTeacherName(Convert.ToString(dr["teacherNo"]));
newDataRow["上课时间"] = this.changeTime(Convert.ToString(dr["classTime"]),Convert.ToInt32(dr["weekCent"]),i.ToString());
newDataRow["课程名"] = Convert.ToString(dr["courseName"]);
newDataRow["实际上课人数"] = Convert.ToInt32(dr["studentNum"]);
newDataRow["班级"] = Convert.ToString(dr["studyClassNo"]);
obDataTable.Rows.Add(newDataRow);
newDataRow = null;
}
}
dr.Close();
obData = new DataSet();
obData.Tables.Add(obDataTable);
try
{
// SqlDataAdapter da = new SqlDataAdapter();
// da.Fill(obData,"novaluation");
this.dataGrid1.DataSource = obData;
this.dataGrid1.DataMember = "classTable";
}
catch(Exception e)
{
MessageBox.Show(e.Message);
}
break;
case "teacher":
obDataTable = null;
this.dataGrid1.Controls.Clear();
obDataTable = new DataTable("teacherTable");
newDataColumn = new DataColumn();//1
newDataColumn.DataType = System.Type.GetType("System.String");
newDataColumn.ColumnName = "代号";
obDataTable.Columns.Add(newDataColumn);
newDataColumn = new DataColumn();//2
newDataColumn.DataType = System.Type.GetType("System.String");
newDataColumn.ColumnName = "教室";
obDataTable.Columns.Add(newDataColumn);
newDataColumn = new DataColumn();//3
newDataColumn.DataType = System.Type.GetType("System.String");
newDataColumn.ColumnName = "上课时间";
obDataTable.Columns.Add(newDataColumn);
newDataColumn = new DataColumn();//4
newDataColumn.DataType = System.Type.GetType("System.String");
newDataColumn.ColumnName = "课程名";
obDataTable.Columns.Add(newDataColumn);
newDataColumn = new DataColumn();//5
newDataColumn.DataType = System.Type.GetType("System.String");
newDataColumn.ColumnName = "实际上课人数";
obDataTable.Columns.Add(newDataColumn);
newDataColumn = new DataColumn();//6
newDataColumn.DataType = System.Type.GetType("System.String");
newDataColumn.ColumnName = "班级";
obDataTable.Columns.Add(newDataColumn);
string strTeacher= "select * from course";
SqlCommand cmd1 = new SqlCommand(strTeacher,conn);
SqlDataReader dr1 = cmd1.ExecuteReader();
while (dr1.Read())
{
if (this.queryContent == Convert.ToString(dr1["teacherNo"]))
{
i++;
newDataRow = obDataTable.NewRow();
newDataRow["代号"] = i.ToString();
newDataRow["教室"] = Convert.ToString(dr1["classNo"]);
newDataRow["上课时间"] = this.changeTime(Convert.ToString(dr1["classTime"]),Convert.ToInt32(dr1["weekCent"]),i.ToString());
newDataRow["课程名"] = Convert.ToString(dr1["courseName"]);
newDataRow["实际上课人数"] = Convert.ToInt32(dr1["studentNum"]);
newDataRow["班级"] = Convert.ToString(dr1["studyClassNo"]);
obDataTable.Rows.Add(newDataRow);
newDataRow = null;
}
}
dr1.Close();
obData = new DataSet();
obData.Tables.Add(obDataTable);
try
{
// SqlDataAdapter da = new SqlDataAdapter();
// da.Fill(obData,"novaluation");
this.dataGrid1.DataSource = obData;
this.dataGrid1.DataMember = "teacherTable";
//MessageBox.Show("afsasdf");
// this.dataGrid1.DataMember = "novaluation";
}
catch(Exception e)
{
MessageBox.Show(e.Message);
}
break;
case "studyClass":
obDataTable = null;
obDataTable = new DataTable("studyTable");
newDataColumn = new DataColumn();//1
newDataColumn.DataType = System.Type.GetType("System.String");
newDataColumn.ColumnName = "代号";
obDataTable.Columns.Add(newDataColumn);
newDataColumn = new DataColumn();//2
newDataColumn.DataType = System.Type.GetType("System.String");
newDataColumn.ColumnName = "教室";
obDataTable.Columns.Add(newDataColumn);
newDataColumn = new DataColumn();//2
newDataColumn.DataType = System.Type.GetType("System.String");
newDataColumn.ColumnName = "教师姓名";
obDataTable.Columns.Add(newDataColumn);
newDataColumn = new DataColumn();//3
newDataColumn.DataType = System.Type.GetType("System.String");
newDataColumn.ColumnName = "上课时间";
obDataTable.Columns.Add(newDataColumn);
newDataColumn = new DataColumn();//4
newDataColumn.DataType = System.Type.GetType("System.String");
newDataColumn.ColumnName = "课程名";
obDataTable.Columns.Add(newDataColumn);
newDataColumn = new DataColumn();//5
newDataColumn.DataType = System.Type.GetType("System.String");
newDataColumn.ColumnName = "实际上课人数";
obDataTable.Columns.Add(newDataColumn);
string strStudy= "select * from course";
SqlCommand cmd2 = new SqlCommand(strStudy,conn);
SqlDataReader dr2 = cmd2.ExecuteReader();
while (dr2.Read())
{
if (this.QueryContent == Convert.ToString(dr2["studyClassNo"]))
{
i++;
newDataRow = obDataTable.NewRow();
newDataRow["代号"] = i.ToString();
newDataRow["教室"] = Convert.ToString(dr2["classNo"]);
newDataRow["教师姓名"] = this.rTeacherName(Convert.ToString(dr2["teacherNo"]));
newDataRow["上课时间"] = this.changeTime(Convert.ToString(dr2["classTime"]),Convert.ToInt32(dr2["weekCent"]),i.ToString());
newDataRow["课程名"] = Convert.ToString(dr2["courseName"]);
newDataRow["实际上课人数"] = Convert.ToInt32(dr2["studentNum"]);
//newDataRow["班级"] = Convert.ToString(dr2["studyClassNo"]);
obDataTable.Rows.Add(newDataRow);
newDataRow = null;
}
}
dr2.Close();
obData = new DataSet();
obData.Tables.Add(obDataTable);
try
{
// SqlDataAdapter da = new SqlDataAdapter();
// da.Fill(obData,"novaluation");
this.dataGrid1.DataSource = obData;
this.dataGrid1.DataMember = "studyTable";
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -