public bool GetGrd(int id) { dalBase.sql = "SELECT * FROM db_grade WHERE grdid=@grdid"; dalBase.Param = new MySqlParameter("@grdid", id); if (dalBase.Run(Behavious.SELECT_WITH_SINGLEPARAM, false)) { grdInfo = new Grade() { ID = Convert.ToInt32(dalBase.DataRead["grdid"]), Name = dalBase.DataRead["grdname"].ToString() }; dalBase.CloseConnect(); return true; } else { dalBase.CloseConnect(); return false; } }
public bool GetGrds() { dalBase.sql = "SELECT * FROM db_grade"; if (dalBase.Run(Behavious.SELECT_WITHOUT_PARAM, false)) { while (dalBase.DataRead.Read()) { grdInfo = new Grade() { ID = Convert.ToInt32(dalBase.DataRead["grdid"]), Name = dalBase.DataRead["grdname"].ToString() }; list_GrdInfo.Add(grdInfo); } dalBase.CloseConnect(); return true; } else { dalBase.CloseConnect(); return false; } }
public bool UpdateGrd(Grade grd) { dalBase.sql = "UPDATE db_grade SET grdname=@grdname WHERE grdid=@grdid"; dalBase.List_param = new List<MySqlParameter>() { new MySqlParameter("@grdname", grd.Name), new MySqlParameter("@grdid", grd.ID) }; return dalBase.Run(Behavious.INSERT_OR_UPDATE_OR_DELETE, true); }
public bool InsertGrd(Grade grd) { dalBase.sql = "INSERT INTO db_grade VALUES (@grdname)"; dalBase.Param = new MySqlParameter("@grdname", grd.Name); return dalBase.Run(Behavious.INSERT_OR_UPDATE_OR_DELETE, true); }