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