public int update(string tablename,Object ObjMember) { int SuccessFlag; switch (tablename) { case "Logs_Data": record = (EmailRecordInfo)ObjMember; string dtLog = string.Format(@"UPDATE " + tablename + " SET Email_Receiver='{0}', Teacher_Identity='{1}',Email_Theme='{2}',Time_Now='{3}',Email_Type='{4}', File_State'{5}',Enclosure_Path='{6}' WHERE Time_Now='{7}'" ,record.Email_Receiver,record.Teacher_Identity,record.Email_Receiver,record.Time_Now,record.Email_Type,record.File_State,record.Enclosure_Path,record.Time_Now); SuccessFlag = Oledbcommand(dtLog); return SuccessFlag; case "SpareTime_Data": supervisor = (SupervisorInfo)ObjMember; string dtSpareTime = string.Format(@"insert into " + tablename + " values('{0}','{1}','{2}' ,{3},{4},{5},{6})", supervisor.SpareID, supervisor.SupervisorId, supervisor.SupervisorName, supervisor.SpareWeek, supervisor.SpareDay, supervisor.SpareNumber, supervisor.Isassigned); SuccessFlag = Oledbcommand(dtSpareTime); return SuccessFlag; case "Teachers_Data": teacher = (TeacherInfo)ObjMember; string dtTeacher = string.Format(@"UPDATE "+tablename+" SET Teacher_ID ='{0}', Teacher ='{1}', Email ='{2}', Phone ='{3}', Title ='{4}', IsSupervisor ={5}, Teaching_Section ='{6}', Accept_ClassNumber ={7}, Class_Totality ={8}, Class_WeekNumber ={9}, Class_DayNumber ={10} WHERE Teacher ='{11}'" , teacher.TeacherId.ToString(), teacher.TeacherName.ToString(), teacher.Email.ToString(), teacher.Phone.ToString(), teacher.Title.ToString(), teacher.IsSupervisor, teacher.TeachingSection.ToString(), teacher.AcceptClassNumber, teacher.ClassTotality, teacher.ClassWeekNumber, teacher.ClassDayNumber,teacher.TeacherName ); SuccessFlag = Oledbcommand(dtTeacher); return SuccessFlag; case "Placement_Data": placement = (PlacementInfo)ObjMember; string dtPlacement = string.Format(@"UPDATE " + tablename + " SET Class_ID='{0}',Teacher_ID='{1}',Teacher='{2}',Class_week={3},Class_Day={4},Class_Number={5},Supervisor_Name='{6}',Class_Address='{7}',Class_Content='{8}',Class_Name='{9}',Class_Type='{10}',Spcialty='{11}',Grade={12} WHERE Class_ID='{13}'" , placement.ClassId, placement.TeacherId, placement.TeacherName, placement.ClassWeek, placement.ClassDay, placement.ClassNumber, placement.SupervisorsName, placement.ClassAddress, placement.ClassContent, placement.ClassName, placement.ClassType, placement.Spcialty, placement.Grade,placement.ClassId ); SuccessFlag = Oledbcommand(dtPlacement); return SuccessFlag; } return 0; }
private void buttonX3_Click(object sender, EventArgs e) { PlacementInfo placement = new PlacementInfo(listView2.CheckedItems[0].SubItems[5].Text, label1.Text, cmbName.SelectedItem.ToString(), Convert.ToInt32(textBox1.Text.Trim()), Convert.ToInt32(textBox2.Text.Trim()), Convert.ToInt32(comboBox7.SelectedItem.ToString()), label13.Text, listView2.CheckedItems[0].SubItems[0].Text, listView2.CheckedItems[0].SubItems[1].Text, listView2.CheckedItems[0].SubItems[4].Text , listView2.CheckedItems[0].SubItems[2].Text, listView2.CheckedItems[0].SubItems[3].Text, 0); SqlHelper help = new SqlHelper(); DataTable dtPlacement = help.getDs("select * from Placement_Data", "Placement_Data").Tables[0]; if (string.IsNullOrEmpty(id)) { if (dtPlacement.Select("Class_ID='" + listView2.CheckedItems[0].SubItems[5].Text + "'").Length == 0) { if (help.Insert(placement, "Placement_Data") > 0) { Main.fm.flashListview(); foreach (string supervisor in Supervisor) { string SpareTimeCommand = "update SpareTime_Data set IsAssigned=true where Supervisor='" + supervisor + "'" + " and Spare_Number= '" + intclassnumber + "'" + " and Spare_Day=" + day + "" + " and Spare_Week=" + week + ""; string TeacherCommand = "update Teachers_Data set Class_Totality=Class_Totality+1 where Teacher='" + supervisor + "'"; help.Oledbcommand(SpareTimeCommand); help.Oledbcommand(TeacherCommand); } MessageBox.Show("添加成功"); } else { MessageBox.Show("添加失败"); } } else { MessageBox.Show("请勿重复添加"); } } else { if (help.update("Placement_Data", placement) >= 0) { DistinctSupervisor(olds, oldsupervisors); List<string> s = new List<string>(); List<string> j = new List<string>(); foreach (string a in oldsupervisors) { s.Add(a); } foreach (string b in Supervisor) { j.Add(b); } foreach (string old in oldsupervisors) { foreach (string news in Supervisor) { if (old.IndexOf(news) != -1 || news.IndexOf(old) != -1) { s.Remove(old); j.Remove(news); } } } foreach (string supervisor in j) { string SpareTimeCommand = "update SpareTime_Data set IsAssigned=true where Supervisor='" + supervisor + "'" + " and Spare_Number= " + intclassnumber + "" + " and Spare_Day=" + day + "" + " and Spare_Week=" + week + ""; string TeacherCommand = "update Teachers_Data set Class_Totality=Class_Totality+1 where Teacher='" + supervisor + "'"; help.Oledbcommand(SpareTimeCommand); help.Oledbcommand(TeacherCommand); } //对应的督导安排情况和总听课次数做相应的修改。 foreach (string old in s) { string SpareTimeCommand = "update SpareTime_Data set IsAssigned=false where Supervisor like '" + "%" + old + "%" + "'" + " and Spare_Number= " + intclassnumber + "" + " and Spare_Day=" + day + "" + " and Spare_Week=" + week + ""; string TeacherCommand = "update Teachers_Data set Class_Totality=Class_Totality-1 where Teacher like '" + "%" + old + "%" + "'"; help.Oledbcommand(SpareTimeCommand); help.Oledbcommand(TeacherCommand); } Main.fm.flashListview(); MessageBox.Show("修改成功!"); oldsupervisors.Clear(); olds = label13.Text; flashui(); } else { MessageBox.Show("修改失败!"); } } }
public int Insert(Object ObjMember,string Flag) { int SuccessFlag; switch (Flag) { case "Classes_Data": classes = (ClassInfo)ObjMember; string dtClass = string.Format(@"insert into " + Flag + " values('{0}','{1}','{2}' ,{3},{4},{5},'{6}','{7}','{8}','{9}','{10}')" ,classes.ClassId,classes.TeacherId,classes.TeacherName,classes.ClassWeek,classes.ClassDay,classes.ClassNumber,classes.ClassName, classes.ClassContent,classes.ClassType,classes.Spcialty); SuccessFlag=Oledbcommand(dtClass); return SuccessFlag; case "SpareTime_Data": supervisor = (SupervisorInfo)ObjMember; string dtSpareTime = string.Format(@"insert into " + Flag + " values('{0}','{1}','{2}',{3},{4},{5},{6})",supervisor.SpareID, supervisor.SupervisorId,supervisor.SupervisorName,supervisor.SpareWeek,supervisor.SpareDay,supervisor.SpareNumber,supervisor.Isassigned); SuccessFlag = Oledbcommand(dtSpareTime); return SuccessFlag; case "Teachers_Data": teacher = (TeacherInfo)ObjMember; string dtTeacher = string.Format(@"insert into " + Flag + " values('{0}','{1}','{2}' ,'{3}','{4}',{5},'{6}',{7},{8},{9},{10})" ,teacher.TeacherId.ToString(),teacher.TeacherName.ToString(),teacher.Email.ToString(),teacher.Phone.ToString(),teacher.Title.ToString(),teacher.IsSupervisor,teacher.TeachingSection.ToString(), teacher.AcceptClassNumber,teacher.ClassTotality,teacher.ClassWeekNumber,teacher.ClassDayNumber ); SuccessFlag = Oledbcommand(dtTeacher); return SuccessFlag; case "Placement_Data": placement = (PlacementInfo)ObjMember; string dtPlacement = string.Format(@"insert into " + Flag + " values('{0}','{1}','{2}',{3},{4},'{5}','{6}','{7}','{8}','{9}','{10}','{11}',{12})" ,placement.ClassId,placement.TeacherId,placement.TeacherName,placement.ClassWeek,placement.ClassDay,placement.ClassNumber,placement.SupervisorsName, placement.ClassAddress,placement.ClassContent,placement.ClassName,placement.ClassType,placement.Spcialty,placement.Grade ); SuccessFlag = Oledbcommand(dtPlacement); return SuccessFlag; case "Logs_Data": record = (EmailRecordInfo)ObjMember; string dtLog = string.Format(@"insert into "+Flag+" values('{0}','{1}','{2}','{3}','{4}','{5}','{6}')",record.Email_Receiver,record.Teacher_Identity,record.Email_Theme ,record.Time_Now,record.Email_Type,record.File_State,record.Enclosure_Path); SuccessFlag = Oledbcommand(dtLog); return SuccessFlag; } return 0; }