SAS.ClassSet.FunctionTools.Placement.RePlacement C# (CSharp) Méthode

RePlacement() public méthode

public RePlacement ( SAS.ClassSet.FunctionTools.PlacementConfig config ) : void
config SAS.ClassSet.FunctionTools.PlacementConfig
Résultat void
        public void RePlacement(PlacementConfig config)
        {
            string deletecommand = "delete * from Placement_Data";
            helper.Oledbcommand(deletecommand);
            dtTeachers = helper.getDs(strSelect_Teachers_Data, "Teachers_Data").Tables[0];
            for (int i = 0; i < dtTeachers.Rows.Count;i++ )
            {
                dtTeachers.Rows[i][7] = 0;
                dtTeachers.Rows[i][8] = 0;
                dtTeachers.Rows[i][9] = 0;
                dtTeachers.Rows[i][10] = 0;

            }
            System.Diagnostics.Debug.WriteLine(DateTime.Now.ToString());
            dtSpareTime = helper.getDs(strSelect_SpareTime_Data, "SpareTime").Tables[0];
            DataRow[] DrIsAssigned = dtSpareTime.Select("IsAssigned='"+"true"+"'");
            for (int i = 0; i < DrIsAssigned.Length; i++)
            {
                DrIsAssigned[i]["IsAssigned"] = false;
            }
            daSpareTime = helper.adapter(strSelect_SpareTime_Data);
            daSpareTime.Update(dtSpareTime);
            daTeacher = helper.adapter(strSelect_Teachers_Data);
            daTeacher.Update(dtTeachers);
            MakePlacement(config);
        }

Usage Example

Exemple #1
0
        private void buttonX2_Click(object sender, EventArgs e)
        {
            SqlHelper help = new SqlHelper();
            DataTable dtsparetime = help.getDs("select * from SpareTime_Data", "SpareTime_Data").Tables[0];
            DataTable dtclass = help.getDs("select * from Classes_Data", "Classes_Data").Tables[0];
            DataTable dtteacher = help.getDs("select * from Teachers_Data", "Teachers_Data").Tables[0];
            if (checkType())
            {
                if (cnumpeo_max >= cnumpeo_min)
                {
                    if (dtsparetime.Rows.Count != 0 && dtclass.Rows.Count != 0 && dtteacher.Rows.Count != 0)
                    {
                        Main.fm.SetStatusText("正在工作中,请耐心等待~~", 1);
                        //MessageBox.Show("OK");

                        PlacementConfig pc = new PlacementConfig(cbegin_week, cbegin_day, cnumclass_week, cnumpeo_max, cnumpeo_min, proportion);
                        Placement doplacement = new Placement();
                        doplacement.RePlacement(pc);
                    }
                    else
                    {
                        MessageBox.Show("请导入数据后重试");
                    }
                }
                else
                {
                    MessageBox.Show("最大人数不能小于最小人数");
                }

            }
        }