/// <summary> /// 更新ClassM某筆資料 /// </summary> /// <returns>Boolean</returns> public bool Update(ClassMInfo ClassM) { Database db = DatabaseFactory.CreateDatabase(); StringBuilder sqlStatement = new StringBuilder(); sqlStatement.Append("UPDATE class_m SET "); sqlStatement.Append("name = @name"); sqlStatement.Append(" WHERE id = @id"); DbCommand dbCommand = db.GetSqlStringCommand(sqlStatement.ToString()); db.AddInParameter(dbCommand, "@id", DbType.String, ClassM.Id); db.AddInParameter(dbCommand, "@name", DbType.String, ClassM.Name); bool result = false; try { db.ExecuteNonQuery(dbCommand); result = true; } catch (DbException ex) { LogController.WriteLog("ClassMDB.Update", ex.ToString()); throw (ex); } return(result); }
/// <summary> /// 新增ClassM1筆資料 /// </summary> /// <param name="ClassM"> /// ClassM新資料 /// </param> /// <returns>Boolean</returns> public bool AddNew(ClassMInfo ClassM) { Database db = DatabaseFactory.CreateDatabase(); StringBuilder sqlStatement = new StringBuilder(); sqlStatement.Append("INSERT INTO class_m "); sqlStatement.Append("(id,name)"); sqlStatement.Append("VALUES(@id,@name)"); DbCommand dbCommand = db.GetSqlStringCommand(sqlStatement.ToString()); db.AddInParameter(dbCommand, "@id", DbType.String, ClassM.Id); db.AddInParameter(dbCommand, "@name", DbType.String, ClassM.Name); bool result = false; try { db.ExecuteNonQuery(dbCommand); result = true; } catch (DbException ex) { LogController.WriteLog("ClassMDB.AddNew", ex.ToString()); throw (ex); } return(result); }
private ClassMInfo BindInfo(IDataReader dr) { ClassMInfo myInfo = new ClassMInfo(); try { if (!dr["id"].Equals(DBNull.Value)) { myInfo.Id = dr["id"].ToString(); } if (!dr["name"].Equals(DBNull.Value)) { myInfo.Name = dr["name"].ToString(); } } catch (Exception ex) { LogController.WriteLog("ClassMDB.BindInfo", ex.ToString()); throw (ex); } return(myInfo); }
/// <summary> /// 讀取ClassM1筆資料 /// </summary> /// <param name="Id"> /// 班級代碼 /// </param> /// <returns>ClassMInfo</returns> public ClassMInfo GetInfo(string Id) { Database db = DatabaseFactory.CreateDatabase(); StringBuilder sqlStatement = new StringBuilder(); sqlStatement.Append("SELECT * FROM class_m WHERE id = @id"); DbCommand dbCommand = db.GetSqlStringCommand(sqlStatement.ToString()); db.AddInParameter(dbCommand, "@id", DbType.String, Id); ClassMInfo myInfo = new ClassMInfo(); IList <ClassMInfo> myList = new List <ClassMInfo>(); myList = GetList(db, dbCommand); if (myList.Count > 0) { myInfo = myList[0]; } return(myInfo); }
/// <summary> /// 更新ClassM某筆資料 /// </summary> /// <param name="ClassM"> /// ClassM的某筆資料 /// </param> /// <returns>Boolean</returns> public static bool Update(ClassMInfo ClassM) { return(myDB.Update(ClassM)); }
/// <summary> /// 新增ClassM1筆資料 /// </summary> /// <param name="ClassM"> /// ClassM的新資料 /// </param> /// <returns>Boolean</returns> public static bool AddNew(ClassMInfo ClassM) { return(myDB.AddNew(ClassM)); }