Exemplo n.º 1
0
 private void UpdateALL()
 {
     daPlacement = helper.adapter(strSelect_Placement_Data);
     daPlacement.Update(dtPlacement);
     daTeacher = helper.adapter(strSelect_Teachers_Data);
     daTeacher.Update(dtTeachers);
     daTeacher.Update(dtSupervisor);
     daSpareTime = helper.adapter(strSelect_SpareTime_Data);
     daSpareTime.Update(dtSpareTime);
     Main.fm.SetStatusText("自动生成听课安排成功!", 0);
     Main.fm.flashListview();
 }
        public void insert(MessageInfo info)
        {
            DataTable dt = helper.getDs("select * from Logs_Data", "Logs_Data").Tables[0];
            DataRow   dr = dt.NewRow();

            dr[0] = frmMain.IpAndName[info.Address];
            dr[1] = info.Allmessage;
            dr[2] = DateTimeToStamp(info.Time);
            dr[3] = info.Type;
            dt.Rows.Add(dr);
            OleDbDataAdapter oledbadapter = helper.adapter("select * from Logs_Data");

            oledbadapter.Update(dt);
        }
Exemplo n.º 3
0
        private void NoIdTeacher()
        {
            SqlHelper help = new SqlHelper();
            DataTable dtClass = help.getDs("select * from Classes_Data","Classes_Data").Tables[0];
            DataRow[] NoIDteacher = dtClass.Select("Teacher_ID='" + "0000000000" + "' ");
            daTeachers = help.adapter("select * from Teachers_Data");
            dtTeachers = new System.Data.DataTable();
            daTeachers.Fill(dtTeachers);
            daTeachers.FillSchema(dtTeachers, SchemaType.Source);
            List<string> teachers = new List<string> { };
            DataTable Idteacher_dt = dtTeachers.Copy();   //  获取Class_Data的架构
            Idteacher_dt.Clear();
            for (int i = 0; i < NoIDteacher.Length; i++)
            {
                teachers.Add(NoIDteacher[i][2].ToString());
            }
            string[] newteachers = teachers.Distinct<string>().ToArray();
            teachers.Clear();
            for (int i = 0; i < dtTeachers.Rows.Count;i++ )
            {
                teachers.Add(dtTeachers.Rows[i][1].ToString());
            }
            string[] oldteachers = teachers.Distinct<string>().ToArray();
            for (int z = 0; z < newteachers.Length; z++)
            {
                for (int i = 0; i < oldteachers.Length;i++ )
                {
                    if (newteachers[z].ToString().Equals(oldteachers[i].ToString()))
                    {
                        newteachers[z] = "";
                    }

                }

            }

            for (int i = 0; i < newteachers.Length;i++ )
            {   if(newteachers[i]!=""){
                DataRow dr_teacher = Idteacher_dt.NewRow();
                dr_teacher[1] = newteachers[i].ToString();
                dr_teacher[0] = newteachers[i].ToString();
                dr_teacher[7] = 0;
                dr_teacher[8] = 0;
                dr_teacher[9] = 0;
                dr_teacher[10] = 0;
                Idteacher_dt.Rows.Add(dr_teacher);
               }
            }

            dtTeachers.Merge(Idteacher_dt, true);
            daTeachers.Update(dtTeachers);
        }
Exemplo n.º 4
0
        private void buttonItem12_Click(object sender, EventArgs e)
        {
            if (listView1.CheckedItems.Count == 1)
            {
                SqlHelper help = new SqlHelper();
                DataTable dt = help.getDs("select * from Placement_Data", "Placement_Data").Tables[0];
                DataRow[] dr = dt.Select("Teacher like '%" + listView1.CheckedItems[0].SubItems[6].Text + "%'" + " and " + "Class_week= '" + listView1.CheckedItems[0].SubItems[7].Text + "'");//+ " and " + "Class_week= '" + listView1.CheckedItems[0].SubItems[7].Text + "'" +
                DataTable dtcheck = help.getDs("select * from CheckPlacement_Data", "CheckPlacement_Data").Tables[0];
                DataRow drc = dtcheck.NewRow();
                for (int i = 0; i < dt.Columns.Count; i++)
                {
                    drc[i] = dr[0][i];
                }
                dtcheck.Rows.Add(drc);
                OleDbDataAdapter da = help.adapter("select * from CheckPlacement_Data");
                try
                {
                    da.Update(dtcheck);
                    MessageBox.Show("保存成功");
                }
                catch (OleDbException)
                {
                    MessageBox.Show("记录已存在,请删除后再保存");
                }
                finally
                {

                }
            }
        }
Exemplo n.º 5
0
      public int ReadExcel(string ExcelPath)
      {
          try
          {
              int[] name = new int[7];   //确定Excel的所需字段值所在的列---
              daClass = helper.adapter(strSelect_Class_Data);
              dtClass = new System.Data.DataTable();
              daClass.Fill(dtClass);
              daClass.FillSchema(dtClass, SchemaType.Source);
              ExcelConnection(ExcelPath);
              //MessageBox.Show(Excel_dt.Columns[0].ToString());

              string classname = Excel_dt.Rows[1][0].ToString();              //课程名称
              string spcialty  = Excel_dt.Rows[1][4].ToString().Substring(3); //专业
              string banji     = Excel_dt.Rows[2][4].ToString();
              for (int q = 0; q < Excel_dt.Columns.Count; q++)
              {
                  switch (Excel_dt.Rows[4][q].ToString())
                  {
                  case "周次": name[0] = q; break;

                  case "星期": name[1] = q; break;

                  case "节次": name[2] = q; break;

                  case "上课地点": name[3] = q; break;

                  case "授课教师": name[4] = q; break;

                  case "授课内容": name[5] = q; break;

                  case "授课方式": name[6] = q; break;
                  }
              }

              dt = dtClass.Copy();      //  获取Class_Data的架构
              dt.Clear();
              for (int i = 5; i < Excel_dt.Rows.Count; i++)
              {
                  // dr = dt.Rows[i];//获取Excel的当前操作行的数据
                  if (!(Excel_dt.Rows[i][name[0]].ToString() == "周次" || Excel_dt.Rows[i][name[0]].ToString() == ""))
                  {
                      string teachername = Excel_dt.Rows[i][name[4]].ToString(); //获取授课老师列的数据
                      int    k           = Teacher(teachername) + 1;             //判断有多少位老师上同一节课
                      for (int m = 1; m <= k; m++)                               //有几位老师,就循环几次
                      {
                          string teachernamepick;                                //定义截取的老师名字
                          //以逗号为分界点,把多位老师的名字分成各自的名字
                          if ((k == 1) || (m == k))
                          {
                              teachernamepick = teachername;
                          }
                          else
                          {
                              int index2 = teachername.IndexOf(",");
                              teachernamepick = teachername.Substring(0, index2);
                              teachername     = teachername.Remove(0, index2 + 1);
                          }


                          int j;
                          //判断星期几,返回对应的数字
                          switch (Excel_dt.Rows[i][name[1]].ToString().Substring(0, 1))
                          {
                          case "一": j = 1; break;

                          case "二": j = 2; break;

                          case "三": j = 3; break;

                          case "四": j = 4; break;

                          case "五": j = 5; break;

                          default: j = 0; break;
                          }
                          if (teachernamepick != null && teachernamepick != "")
                          {
                              DataRow drClass_information = dt.NewRow();
                              drClass_information["Class_Day"] = j;
                              //获取节次
                              string strclassname  = Excel_dt.Rows[i][name[2]].ToString();
                              int    classnumindex = strclassname.IndexOf("-");
                              drClass_information["Teacher"]       = teachernamepick;
                              drClass_information["Class_ID"]      = teachernamepick + Excel_dt.Rows[i][name[0]].ToString() + j.ToString() + strclassname.Substring(0, classnumindex) + strclassname.Substring(classnumindex + 1) + classname.Substring(5) + Excel_dt.Rows[i][name[3]] + banji;
                              drClass_information["Teacher_ID"]    = "0000000000";
                              drClass_information["Class_Week"]    = Excel_dt.Rows[i][name[0]];
                              drClass_information["Class_Number"]  = Convert.ToInt32(strclassname.Substring(0, classnumindex) + strclassname.Substring(classnumindex + 1));
                              drClass_information["Class_Address"] = Excel_dt.Rows[i][name[3]];
                              drClass_information["Class_Name"]    = classname.Substring(5);
                              drClass_information["Class_Content"] = Excel_dt.Rows[i][name[5]];
                              drClass_information["Class_Type"]    = Excel_dt.Rows[i][name[6]];
                              drClass_information["Spcialty"]      = spcialty;

                              dt.Rows.Add(drClass_information);
                          }
                          else
                          {
                              return(0);
                          }
                      }
                  }
              }
              dtClass.Merge(dt, true);

              daClass.Update(dtClass);
              return(1);
          }catch (Exception) {
              return(0);
          }
      }