/// <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));
}
