/// <summary>
/// 取得活動的自訂欄位設定
/// </summary>
/// <param name="activity_id">活動代號</param>
/// <returns>取得活動的自訂欄位設定</returns>
public List <VO.CustomFieldVO> SelectByActivity_id(Guid activity_id)
{
SqlParameter[] sqlParams = new SqlParameter[1];
sqlParams[0] = new SqlParameter("@activity_id", SqlDbType.UniqueIdentifier);
sqlParams[0].Value = activity_id;
StringBuilder sb = new StringBuilder();
sb.AppendLine("SELECT activity_id, field_id, field_name, field_control,CASE field_control WHEN 'textbox' THEN 'false' ELSE 'true' END as IsShowEdit ");
sb.AppendLine("FROM CustomField WHERE (activity_id = @activity_id) ");
SqlConnection aconn = MyConn();
SqlDataReader MyDataReader = SqlHelper.ExecuteReader(aconn, CommandType.Text, sb.ToString(), sqlParams);
List <VO.CustomFieldVO> myCustomFieldVOList = new List <ACMS.VO.CustomFieldVO>();
while (MyDataReader.Read())
{
VO.CustomFieldVO myCustomFieldVO = new ACMS.VO.CustomFieldVO();
myCustomFieldVO.activity_id = (Guid)MyDataReader["activity_id"];
myCustomFieldVO.field_id = (int)MyDataReader["field_id"];
myCustomFieldVO.field_name = (string)MyDataReader["field_name"];
myCustomFieldVO.field_control = (string)MyDataReader["field_control"];
myCustomFieldVO.isShowEdit = Convert.ToBoolean(MyDataReader["IsShowEdit"]);
myCustomFieldVOList.Add(myCustomFieldVO);
}
MyDataReader.Close();
aconn.Close();
if (MyDataReader != null)
{
MyDataReader.Dispose();
}
if (aconn != null)
{
aconn.Dispose();
}
return(myCustomFieldVOList);
}
/// <summary>
/// 取得活動的自訂欄位設定
/// </summary>
/// <param name="activity_id">活動代號</param>
/// <returns>取得活動的自訂欄位設定</returns>
public List<VO.CustomFieldVO> SelectByActivity_id(Guid activity_id)
{
SqlParameter[] sqlParams = new SqlParameter[1];
sqlParams[0] = new SqlParameter("@activity_id", SqlDbType.UniqueIdentifier);
sqlParams[0].Value = activity_id;
StringBuilder sb = new StringBuilder();
sb.AppendLine("SELECT activity_id, field_id, field_name, field_control,CASE field_control WHEN 'textbox' THEN 'false' ELSE 'true' END as IsShowEdit ");
sb.AppendLine("FROM CustomField WHERE (activity_id = @activity_id) ");
SqlConnection aconn = MyConn();
SqlDataReader MyDataReader = SqlHelper.ExecuteReader(aconn, CommandType.Text, sb.ToString(), sqlParams);
List<VO.CustomFieldVO> myCustomFieldVOList = new List<ACMS.VO.CustomFieldVO>();
while (MyDataReader.Read())
{
VO.CustomFieldVO myCustomFieldVO = new ACMS.VO.CustomFieldVO();
myCustomFieldVO.activity_id = (Guid)MyDataReader["activity_id"];
myCustomFieldVO.field_id = (int)MyDataReader["field_id"];
myCustomFieldVO.field_name = (string)MyDataReader["field_name"];
myCustomFieldVO.field_control = (string)MyDataReader["field_control"];
myCustomFieldVO.isShowEdit = Convert.ToBoolean(MyDataReader["IsShowEdit"]);
myCustomFieldVOList.Add(myCustomFieldVO);
}
MyDataReader.Close();
aconn.Close();
if (MyDataReader != null) MyDataReader.Dispose();
if (aconn != null) aconn.Dispose();
return myCustomFieldVOList;
}
