Exemple #1
0
        //mot ham add du lieu
        public void addSV(object[] SV)
        {
            DataRow dr = DTSV.NewRow();

            dr.ItemArray = SV;
            DTSV.Rows.Add(dr);
        }
Exemple #2
0
        public void setDataTable(object[] SV)
        {
            DataRow dr = DTSV.NewRow();

            dr.ItemArray = SV;
            DTSV.Rows.Add(dr);
        }
Exemple #3
0
        public void AddDataRowSV(SV s)
        {
            DataRow dr1 = DTSV.NewRow();

            dr1["MSSV"]   = s.MSSV; dr1["Name"] = s.Name;
            dr1["Gender"] = s.Gender; dr1["NS"] = s.NS;
            dr1["ID_Lop"] = s.ID_Lop;
            DTSV.Rows.Add(dr1);
        }
Exemple #4
0
        /*
         * // Trả về DataTable có SV trùng với ID_Lop
         * public DataTable GetSVByIDLop(int id)
         * {
         *  DataTable dt  = new DataTable();
         *  dt.Columns.AddRange(new DataColumn[]
         *  {
         *      new DataColumn("MSSV", typeof(string)),
         *      new DataColumn("NameSV", typeof(string)),
         *      new DataColumn("Gender", typeof(bool)),
         *      new DataColumn("NgaySinh", typeof(DateTime)),
         *      new DataColumn("ID_Lop", typeof(string)),
         *  });
         *  if (id != 0)
         *  {
         *      foreach (DataRow i in DTSV.Rows)
         *      {
         *          DataRow dr = dt.NewRow();
         *          if (Convert.ToInt32(i["ID_Lop"]) == id)
         *          {
         *              dr["MSSV"] = i["MSSV"]; dr["NameSV"] = i["NameSV"];
         *              dr["Gender"] = i["Gender"]; dr["ID_Lop"] = id;
         *              dr["NgaySinh"] = i["NgaySinh"];
         *              dt.Rows.Add(dr);
         *          }
         *      }
         *  } else
         *  {
         *      dt = DTSV;
         *  }
         *  return dt;
         * }
         * // Trả về DataTable có SV trùng với ms
         * public DataTable GetDTSVByMSSV(int ms)
         * {
         *  DataTable dt = new DataTable();
         *  dt.Columns.AddRange(new DataColumn[]
         *  {
         *      new DataColumn("MSSV", typeof(string)),
         *      new DataColumn("NameSV", typeof(string)),
         *      new DataColumn("Gender", typeof(bool)),
         *      new DataColumn("NgaySinh", typeof(DateTime)),
         *      new DataColumn("ID_Lop", typeof(string)),
         *  });
         *  if (ms != 0)
         *  {
         *      foreach (DataRow i in DTSV.Rows)
         *      {
         *          DataRow dr = dt.NewRow();
         *          if (Convert.ToInt32(i["MSSV"]) == ms)
         *          {
         *              dr["MSSV"] = i["MSSV"]; dr["NameSV"] = i["NameSV"];
         *              dr["Gender"] = i["Gender"]; dr["ID_Lop"] = i["ID_Lop"] ;
         *              dr["NgaySinh"] = i["NgaySinh"];
         *              dt.Rows.Add(dr);
         *          }
         *      }
         *  }
         *  else
         *  {
         *      dt = DTSV;
         *  }
         *  return dt;
         * }
         * // Trả về DataTable có SV trùng với name
         * public DataTable GetDTSVByNameSV(string name)
         * {
         *  DataTable dt = new DataTable();
         *  dt.Columns.AddRange(new DataColumn[]
         *  {
         *      new DataColumn("MSSV", typeof(string)),
         *      new DataColumn("NameSV", typeof(string)),
         *      new DataColumn("Gender", typeof(bool)),
         *      new DataColumn("NgaySinh", typeof(DateTime)),
         *      new DataColumn("ID_Lop", typeof(string)),
         *  });
         *  if (name != "")
         *  {
         *      foreach (DataRow i in DTSV.Rows)
         *      {
         *          DataRow dr = dt.NewRow();
         *          if (i["NameSV"].ToString() == name)
         *          {
         *              dr["MSSV"] = i["MSSV"]; dr["NameSV"] = i["NameSV"];
         *              dr["Gender"] = i["Gender"]; dr["ID_Lop"] = i["ID_Lop"];
         *              dr["NgaySinh"] = i["NgaySinh"];
         *              dt.Rows.Add(dr);
         *          }
         *      }
         *  }
         *  else
         *  {
         *      dt = DTSV;
         *  }
         *  return dt;
         * }
         * // Trả về hàng có SV trùng với MSSV
         * public DataRow GetSVByMSSV(string ms)
         * {
         *  DataRow dr = DTSV.NewRow();
         *  try
         *  {
         *      foreach (DataRow i in DTSV.Rows)
         *      {
         *          if (i["MSSV"].ToString() == ms)
         *          {
         *              dr = i;
         *          }
         *      }
         *      return dr;
         *  }
         *  catch (Exception)
         *  {
         *      return null;
         *  }
         * }
         * private bool CheckMSSV(string ms)
         * {
         *  foreach(DataRow i in DTSV.Rows)
         *  {
         *      if (i["MSSV"].ToString() == ms)
         *      {
         *          return true;
         *      }
         *  }
         *  return false;
         * }
         * public bool Add(params object[] data)
         * {
         *  try
         *  {
         *      if (CheckMSSV(data[0].ToString()))
         *      {
         *          return false;
         *      } else
         *      {
         *          DTSV.Rows.Add(new object[]
         *          {
         *            data[0], data[1], data[2], data[3], data[4]
         *          });
         *          return true;
         *      }
         *  }
         *  catch (Exception)
         *  {
         *      return false;
         *  }
         * }
         * public bool Edit(params object[] data)
         * {
         *  bool check = false;
         *  try
         *  {
         *      foreach (DataRow i in DTSV.Rows)
         *      {
         *          if (i["MSSV"].ToString() == data[0].ToString())
         *          {
         *              i["NameSV"] = data[1].ToString();
         *              i["Gender"] = Convert.ToBoolean(data[2].ToString());
         *              i["NgaySinh"] = Convert.ToDateTime(data[3].ToString());
         *              i["ID_Lop"] = data[4].ToString();
         *              check = true;
         *          }
         *      }
         *      return check;
         *  }
         *  catch (Exception)
         *  {
         *      return false;
         *  }
         * }
         * public bool Del(List<string> data)
         * {
         *  try
         *  {
         *      foreach (string j in data)
         *      {
         *          foreach (DataRow i in DTSV.Select())
         *          {
         *              if (i["MSSV"].ToString() == j)
         *              {
         *                  DTSV.Rows.Remove(i);
         *              }
         *          }
         *          DTSV.AcceptChanges();
         *      }
         *      return true;
         *  }
         *  catch (Exception)
         *  {
         *      return false;
         *  }
         * }
         */
        /// KIEU MOI
        public void AddDataRow(SV s)
        {
            DataRow dr = DTSV.NewRow();

            dr["MSSV"]     = s.MSSV; dr["NameSV"] = s.NameSV;
            dr["Gender"]   = s.Gender; dr["ID_Lop"] = s.ID_Lop;
            dr["NgaySinh"] = s.NgaySinh;
            DTSV.Rows.Add(dr);
        }
Exemple #5
0
        public void AddDr(SV s)
        {
            DataRow dr = DTSV.NewRow();

            dr["MSSV"]   = s.MSSV;
            dr["Name"]   = s.Name;
            dr["NS"]     = s.NS;
            dr["Gender"] = s.Gender;
            dr["ID_Lop"] = s.ID_Lop;
        }
Exemple #6
0
        public void AddNewRow(SV a)
        {
            DataRow b = DTSV.NewRow();

            b["MSSV"]   = a.MSSV;
            b["NameSV"] = a.NameSV;
            b["Gender"] = a.Gender;
            b["ID_Lop"] = a.ID_Lop;
            b["NS"]     = a.NS.ToString().Split(' ')[0];
            DTSV.Rows.Add(b);
        }
Exemple #7
0
        public void AddDataRow(SV s)
        {
            DataRow row8 = DTSV.NewRow();

            row8["MSSV"]     = s.MSSV;
            row8["NameSV"]   = s.NameSV;
            row8["Gender"]   = s.Gender;
            row8["Birthday"] = s.NS;
            row8["ClassID"]  = s.ID_Lop;
            DTSV.Rows.Add(row8);
        }
Exemple #8
0
 public void DeleteDataRow(string MSSV)
 {
     foreach (DataRow i in DTSV.Select())
     {
         if (i["MSSV"].ToString() == MSSV)
         {
             DTSV.Rows.Remove(i);
         }
     }
     DTSV.AcceptChanges();
 }
Exemple #9
0
 public void CapNhatDSSV(List <SV> sv)
 {
     DTSV.Rows.Clear();
     foreach (SV i in sv)
     {
         DataRow dataRow = DTSV.NewRow();
         dataRow["MSSV"]   = i.MSSV;
         dataRow["Name"]   = i.Name;
         dataRow["Gender"] = i.Gender;
         dataRow["NS"]     = i.NS;
         dataRow["ID_Lop"] = i.ID_Lop;
         DTSV.Rows.Add(dataRow);
     }
 }
Exemple #10
0
 /*public void addSV(List<SV> listsv)
  * {
  *  DTSV.Rows.Clear();
  *  foreach (var s in listsv)
  *  {
  *      DataRow dr = DTSV.NewRow();
  *      dr["NameSV"] = s.NameSV;
  *      dr["MSSV"] = s.MSSV;
  *      dr["Gender"] = s.Gender;
  *      dr["LopSH"] = s.ID_Lop;
  *      dr["ns"] = s.NS;
  *      DTSV.Rows.Add(dr);
  *  }
  *
  * }*/
 /*public void addSV(SV s)
  * {
  *
  *      DataRow dr = DTSV.NewRow();
  *      dr["NameSV"] = s.NameSV;
  *      dr["MSSV"] = s.MSSV;
  *      dr["Gender"] = s.Gender;
  *      dr["LopSH"] = s.ID_Lop;
  *      dr["ns"] = s.NS;
  *      DTSV.Rows.Add(dr);
  *
  * }*/
 public void setSV(List <SV> listsv) // tao  1 csdl moi sau khi thao tac
 {
     DTSV.Rows.Clear();
     foreach (var s in listsv)
     {
         DataRow sv = DTSV.NewRow();
         sv["MSSV"]   = s.MSSV;
         sv["NameSV"] = s.NameSV;
         sv["Gender"] = s.Gender;
         sv["NS"]     = s.NS;
         sv["LopSH"]  = s.ID_Lop;
         DTSV.Rows.Add(sv);
     }
 }
 public void setDTSV(List <SV> s)
 {
     DTSV.Rows.Clear();
     foreach (SV i in s)
     {
         DataRow dr = DTSV.NewRow();
         dr["MSSV"]     = i.MSSV;
         dr["HoTen"]    = i.HoTen;
         dr["GioiTinh"] = i.GioiTinh;
         dr["ID_Lop"]   = i.ID_Lop;
         dr["NgaySinh"] = i.NgaySinh;
         DTSV.Rows.Add(dr);
     }
 }
Exemple #12
0
 public void DeleteDataRow(SV s)
 {
     try
     {
         foreach (DataRow i in DTSV.Rows)
         {
             if (i["MSSV"].ToString() == s.MSSV)
             {
                 DTSV.Rows.Remove(i);
             }
         }
         DTSV.AcceptChanges();
     }
     catch (Exception)
     {
     }
 }
Exemple #13
0
 public void EditDataSV(SV s)
 {
     for (int i = 0; i < DTSV.Rows.Count; ++i)
     {
         if (DTSV.Rows[i]["MSSV"].ToString() == s.MSSV)
         {
             DTSV.Rows.RemoveAt(i);
             DataRow d = DTSV.NewRow();
             d["MSSV"]   = s.MSSV;
             d["NameSV"] = s.NameSV;
             d["NS"]     = s.NS.ToString();
             d["Gender"] = s.Gender.ToString();
             d["ID_Lop"] = s.ID_Lop.ToString();
             DTSV.Rows.InsertAt(d, i);
             return;
         }
     }
 }
Exemple #14
0
        public void sortForDemand(string demand)

        {
            DataRow temp = DTSV.NewRow();

            for (int i = 0; i < DTSV.Rows.Count - 1; i++)
            {
                for (int j = i; j < DTSV.Rows.Count; j++)
                {
                    if (String.Compare(DTSV.Rows[i][demand].ToString(), DTSV.Rows[j][demand].ToString()) > 0)
                    {
                        temp.ItemArray         = DTSV.Rows[i].ItemArray;
                        DTSV.Rows[i].ItemArray = DTSV.Rows[j].ItemArray;
                        DTSV.Rows[j].ItemArray = temp.ItemArray;
                    }
                }
            }
        }
Exemple #15
0
        public void sortForDemand(string demand)
        {
            DataRow dr = DTSV.NewRow();
            string  a  = "";
            string  b  = "";

            for (int i = 0; i < DTSV.Rows.Count - 1; i++)
            {
                for (int j = i + 1; j < DTSV.Rows.Count; j++)
                {
                    if (String.Compare(DTSV.Rows[i][demand].ToString(), DTSV.Rows[j][demand].ToString()) > 0)
                    {
                        dr.ItemArray           = DTSV.Rows[i].ItemArray;
                        DTSV.Rows[i].ItemArray = DTSV.Rows[j].ItemArray;
                        DTSV.Rows[j].ItemArray = dr.ItemArray;
                    }
                }
            }
        }