/// <summary>
/// 新增主辦單位資料
/// </summary>
/// <param name="myUnitVO">主辦單位資料型別物件</param>
/// <returns>新增主辦單位資料</returns>
public int InsertUnit(VO.UnitVO myUnitVO)
{
SqlParameter[] sqlParams = new SqlParameter[1];
sqlParams[0] = new SqlParameter("@name", SqlDbType.NVarChar, 50);
sqlParams[0].Value = myUnitVO.name;
StringBuilder sb = new StringBuilder();
sb.AppendLine("INSERT Unit (name,active) Values (@name,'Y'); ");
return(SqlHelper.ExecuteNonQuery(MyConn(), CommandType.Text, sb.ToString(), sqlParams));
}
/// <summary>
/// 修改主辦單位資料
/// </summary>
/// <param name="myUnitVO">主辦單位資料型別物件</param>
/// <returns>主辦單位資料</returns>
public int UpdateUnit(VO.UnitVO myUnitVO)
{
SqlParameter[] sqlParams = new SqlParameter[3];
sqlParams[0] = new SqlParameter("@id", SqlDbType.Int);
sqlParams[0].Value = myUnitVO.id;
sqlParams[1] = new SqlParameter("@name", SqlDbType.NVarChar, 50);
sqlParams[1].Value = myUnitVO.name;
sqlParams[2] = new SqlParameter("@active", SqlDbType.NChar, 1);
sqlParams[2].Value = myUnitVO.active;
StringBuilder sb = new StringBuilder();
sb.AppendLine("UPDATE Unit SET name=@name,active=@active WHERE id=@id;");
return(SqlHelper.ExecuteNonQuery(MyConn(), CommandType.Text, sb.ToString(), sqlParams));
}
public int UpdateUnit(VO.UnitVO myUnitVO)
{
DAO.UnitDAO myUnitDAO = new ACMS.DAO.UnitDAO();
return(myUnitDAO.UpdateUnit(myUnitVO));
}
