jimmy.cs

学生类：Student 教师类：Teacher 主任：AdminTeacher 班主任：MasterTeacher 授课老师： PrelectTeacher 班级类：classTeam 班

		{
			char stuSex = (student.StuSex)? '1' : '0';
			char stuAt_School = (student.StuAt_School)? '1' : '0';
			string select = "insert StudentInfo values('" + student.StuName
				+ "'," + stuSex + ",'" + student.StuOrigin + "','" + student.StuNation
				+ "','" + student.StuTelephone + "','" + student.StuAddress
				+ "','" + student.StuPostcode + "','" + student.StuGrade1 
				+ "','" + student.StuGrade2 + "','" + student.StuGrade3
				+ "'," + stuAt_School + ",'" + student.StuRemark + "')";
			jimmy.DoSqlString(select);
		}

		//返回新的学员编号
		public static int GetNewStuID()
		{
			string select = "select stuID = Max(stuID) + 1 from studentInfo";
			return (int)jimmy.GetObjectBySqlString(select);
		}

		//获得学员实例，更新数据库中的相关内容
		public static void UpdateStudentInfo(Student student)
		{
			char stuSex = (student.StuSex)? '1' : '0';
			char stuAt_School = (student.StuAt_School)? '1' : '0';
			string select = "Update StudentInfo set stuName = '" + student.StuName
				+ "',stuSex = " + stuSex + ",stuOrigin = '" + student.StuOrigin
				+ "',stuNation = '" + student.StuNation + "',stuTelephone = '" 
				+ student.StuTelephone + "',stuAddress = '" + student.StuAddress
				+ "',stuPostcode = '" + student.StuPostcode + "',stuGrade1 = '" 
				+ student.StuGrade1 + "'stuGrade2 = ,'" + student.StuGrade2 
				+ "',stuGrade3 = '" + student.StuGrade3 + "',stuAt_School = " + stuAt_School 
				+ ",stuRemark = '" + student.StuRemark + "' where stuID = " + student.StuID.ToString();
			jimmy.DoSqlString(select);
		}

		//获得学员编号和考试编号，返回学员考试信息表中相应数据
		public static SqlDataReader GetStuExamInfoByStuIDExamID(int stuID,int examID)
		{
			string select = "select * from StudentExamInfo where stuID = "
				+ stuID.ToString() + " and examID = " + examID.ToString();
			return jimmy.GetDataReaderBySqlString(select);
		}

		//获得学员缺勤编号，返回学员缺勤信息表中相应数据
		public static SqlDataReader GetStuDutyInfoByAfdID(int afdID)
		{
			string select = "select * from StudentAFDInfo where afdID = " + afdID.ToString();
			return jimmy.GetDataReaderBySqlString(select);
		}

		//返回所有教室使用信息
		public static DataTable GetAllClassRoomUserInfo()
		{
			string select = "select * from View_ClassRoomUserInfo";
			return jimmy.GetDataTableBySqlString(select);
		}

		//获得班级编号，返回教室使用信息表
		public static DataTable GetClassRoomUserByClaID(string claID)
		{
			string select = "select * from View_ClassRoomUserInfo where claID = '" + claID + "'";
			return jimmy.GetDataTableBySqlString(select);
		}

		//获得教室编号，返回教室使用信息表
		public static DataTable GetClassRoomUserByCrID(string crID)
		{
			string select = "select * from View_ClassRoomUserInfo where crID = '" + crID + "'";
			return jimmy.GetDataTableBySqlString(select);
		}

		//为教师基本信息表DataGrid控件定制样式
		public static void CreateTeacherInfoStyle(DataGrid dg,string styleName)
		{
			//如果已经创建过了需要的风格，就退出
			foreach(DataGridTableStyle dgts in dg.TableStyles)
			{
				if(dgts.MappingName.Equals(styleName))
				{
					return;
				}
			}

			DataGridTableStyle style =new DataGridTableStyle();
			style.MappingName = styleName;
			style.AlternatingBackColor = Color.Bisque;
			style.BackColor = Color.GreenYellow;
			style.HeaderBackColor = Color.LightSteelBlue;
			style.HeaderForeColor = Color.Red;
			style.HeaderFont = new Font("Microsoft Sans Serif",9F,FontStyle.Bold,
				GraphicsUnit.Point,((System.Byte)(0)));
			style.GridLineColor = Color.DarkGray;
			style.PreferredRowHeight = 22;
	


			DataGridTextBoxColumn teaID = new DataGridTextBoxColumn();
			teaID.MappingName = "teaID";
			teaID.HeaderText = "编号";
			teaID.Width = 40;
			teaID.Alignment = HorizontalAlignment.Center;

			DataGridTextBoxColumn teaLimit = new DataGridTextBoxColumn();
			teaLimit.MappingName = "teaLimit";
			teaLimit.HeaderText = "职务";
			teaLimit.Width = 75;
			teaLimit.Alignment = HorizontalAlignment.Center;

			DataGridTextBoxColumn teaName = new DataGridTextBoxColumn();
			teaName.MappingName = "teaName";
			teaName.HeaderText = "姓名";
			teaName.Width = 50;
			teaName.Alignment = HorizontalAlignment.Center;

			DataGridTextBoxColumn teaSex = new DataGridTextBoxColumn();
			teaSex.MappingName = "teaSex";
			teaSex.HeaderText = "性别";
			teaSex.Width = 40;
			teaSex.Alignment = HorizontalAlignment.Center;
 
			DataGridTextBoxColumn teaOrigin = new DataGridTextBoxColumn();		
			teaOrigin.MappingName = "teaOrigin";
			teaOrigin.HeaderText = "籍贯";
			teaOrigin.Width = 50;
			teaOrigin.Alignment = HorizontalAlignment.Center;

			DataGridTextBoxColumn teaNation = new DataGridTextBoxColumn();
			teaNation.MappingName = "teaNation";
			teaNation.HeaderText = "民族";
			teaNation.Width = 40;
			teaNation.Alignment = HorizontalAlignment.Center;

			DataGridTextBoxColumn teaTelephone = new DataGridTextBoxColumn();
			teaTelephone.MappingName = "teaTelephone";
			teaTelephone.HeaderText = "联系电话";
			teaTelephone.Width = 80;
			teaTelephone.Alignment = HorizontalAlignment.Center;

			DataGridTextBoxColumn teaAddress = new DataGridTextBoxColumn();
			teaAddress.MappingName = "teaAddress";
			teaAddress.HeaderText = "住址";
			teaAddress.Width = 90;
			teaAddress.Alignment = HorizontalAlignment.Center;

			DataGridTextBoxColumn teaPostcode = new DataGridTextBoxColumn();
			teaPostcode.MappingName = "teaPostcode";
			teaPostcode.HeaderText = "邮政编码";
			teaPostcode.Width = 60;
			teaPostcode.Alignment = HorizontalAlignment.Center;

			DataGridTextBoxColumn teaPicture = new DataGridTextBoxColumn();
			teaPicture.MappingName = "teaPicture";
			teaPicture.HeaderText = "相片路径";
			teaPicture.Width = 85;
			teaPicture.Alignment = HorizontalAlignment.Center;

			DataGridTextBoxColumn teaIn_Service = new DataGridTextBoxColumn();
			teaIn_Service.MappingName = "teaIn_Service";
			teaIn_Service.HeaderText = "是否在职";
			teaIn_Service.Width = 60;
			teaIn_Service.Alignment = HorizontalAlignment.Center;

			DataGridTextBoxColumn teaRemark = new DataGridTextBoxColumn();
			teaRemark.MappingName = "teaRemark";
			teaRemark.HeaderText = "备注";
			teaRemark.Width = 80;
			teaRemark.Alignment = HorizontalAlignment.Center;


			style.GridColumnStyles.AddRange(new DataGridColumnStyle[]{teaID,teaLimit,teaName,teaSex,teaOrigin,teaNation,
																		 teaTelephone,teaAddress,teaPostcode,teaPicture,teaIn_Service,teaRemark });
			dg.TableStyles.Add(style);
		}

		//为班级基本信息表DataGrid控件定制样式
		public static void CreateClassInfoStyle(DataGrid dg,string styleName)
		{
			//如果已经创建过了需要的风格，就退出
			foreach(DataGridTableStyle dgts in dg.TableStyles)
			{
				if(dgts.MappingName.Equals(styleName))
				{
					return;
				}
			}

			DataGridTableStyle style =new DataGridTableStyle();
			style.MappingName = styleName;
			style.AlternatingBackColor = Color.Bisque;
			style.BackColor = Color.GreenYellow;
			style.HeaderBackColor = Color.LightSteelBlue;
			style.HeaderForeColor = Color.Red;
			style.HeaderFont = new Font("Microsoft Sans Serif",9F,FontStyle.Bold,
				GraphicsUnit.Point,((System.Byte)(0)));
			style.GridLineColor = Color.DarkGray;
			style.PreferredRowHeight = 22;
	


			DataGridTextBoxColumn claID = new DataGridTextBoxColumn();
			claID.MappingName = "claID";
			claID.HeaderText = "班级编号";
			claID.Width = 80;
			claID.Alignment = HorizontalAlignment.Center;

			DataGridTextBoxColumn claMasterID = new DataGridTextBoxColumn();
			claMasterID.MappingName = "claMasterID";
			claMasterID.HeaderText = "班主任";
			claMasterID.Width = 75;
			claMasterID.Alignment = HorizontalAlignment.Center;

			DataGridTextBoxColumn claMonitorID = new DataGridTextBoxColumn();
			claMonitorID.MappingName = "claMonitorID";
			claMonitorID.HeaderText = "班长";
			claMonitorID.Width = 60;
			claMonitorID.Alignment = HorizontalAlignment.Center;

			DataGridTextBoxColumn claStartDate = new DataGridTextBoxColumn();
			claStartDate.MappingName = "claStartDate";
			claStartDate.HeaderText = "开课日期";
			claStartDate.Width = 100;
			claStartDate.Alignment = HorizontalAlignment.Center;
 
			DataGridTextBoxColumn claCeaseDate = new DataGridTextBoxColumn();		
			claCeaseDate.MappingName = "claCeaseDate";
			claCeaseDate.HeaderText = "结课日期";
			claCeaseDate.Width = 100;
			claCeaseDate.Alignment = HorizontalAlignment.Center;

			DataGridTextBoxColumn claHours = new DataGridTextBoxColumn();
			claHours.MappingName = "claHours";
			claHours.HeaderText = "课时";
			claHours.Width = 40;
			claHours.Alignment = HorizontalAlignment.Center;

			DataGridTextBoxColumn claStudentNumber = new DataGridTextBoxColumn();
			claStudentNumber.MappingName = "claStudentNumber";
			claStudentNumber.HeaderText = "人数";
			claStudentNumber.Width = 40;
			claStudentNumber.Alignment = HorizontalAlignment.Center;

			DataGridTextBoxColumn claRemark = new DataGridTextBoxColumn();
			claRemark.MappingName = "claRemark";
			claRemark.HeaderText = "备注";
			claRemark.Width = 80;
			claRemark.Alignment = HorizontalAlignment.Center;


			style.GridColumnStyles.AddRange(new DataGridColumnStyle[]{claID,claMasterID,claMonitorID,claStartDate,claCeaseDate,claHours,
																		 claStudentNumber,claRemark });
			dg.TableStyles.Add(style);
		}

		//为教室基本信息表DataGrid控件定制样式
		public static void CreateClassRoomUserInfoStyle(DataGrid dg,string styleName)
		{
			//如果已经创建过了需要的风格，就退出
			foreach(DataGridTableStyle dgts in dg.TableStyles)
			{
				if(dgts.MappingName.Equals(styleName))
				{
					return;
				}
			}

			DataGridTableStyle style =new DataGridTableStyle();
			style.MappingName = styleName;
			style.AlternatingBackColor = Color.Bisque;
			style.BackColor = Color.GreenYellow;
			style.HeaderBackColor = Color.LightSteelBlue;
			style.HeaderForeColor = Color.Red;
			style.HeaderFont = new Font("Microsoft Sans Serif",9F,FontStyle.Bold,
				GraphicsUnit.Point,((System.Byte)(0)));
			style.GridLineColor = Color.DarkGray;
			style.PreferredRowHeight = 22;
	


			DataGridTextBoxColumn claID = new DataGridTextBoxColumn();
			claID.MappingName = "claID";
			claID.HeaderText = "班级编号";
			claID.Width = 80;
			claID.Alignment = HorizontalAlignment.Center;

			DataGridTextBoxColumn crID = new DataGridTextBoxColumn();
			crID.MappingName = "crID";
			crID.HeaderText = "教室编号";
			crID.Width = 75;
			crID.Alignment = HorizontalAlignment.Center;

			DataGridTextBoxColumn cuDay = new DataGridTextBoxColumn();
			cuDay.MappingName = "cuDay";
			cuDay.HeaderText = "日期";
			cuDay.Width = 80;
			cuDay.Alignment = HorizontalAlignment.Center;

			DataGridTextBoxColumn cuTime = new DataGridTextBoxColumn();
			cuTime.MappingName = "cuTime";
			cuTime.HeaderText = "时段";
			cuTime.Width = 100;
			cuTime.Alignment = HorizontalAlignment.Center;

			DataGridTextBoxColumn cuRemark = new DataGridTextBoxColumn();
			cuRemark.MappingName = "cuRemark";
			cuRemark.HeaderText = "备注";
			cuRemark.Width = 80;
			cuRemark.Alignment = HorizontalAlignment.Center;


			style.GridColumnStyles.AddRange(new DataGridColumnStyle[]{claID,crID,cuDay,cuTime,cuRemark });
			dg.TableStyles.Add(style);
		}
	}
}