/// <summary> /// 取得活動資料 /// </summary> /// <param name="id">活動代號</param> /// <returns>取得活動資料</returns> public VO.ActivatyVO SelectActivatyByID(Guid id) { SqlParameter[] sqlParams = new SqlParameter[1]; sqlParams[0] = new SqlParameter("@id", SqlDbType.UniqueIdentifier); sqlParams[0].Value = id; StringBuilder sb = new StringBuilder(); sb.AppendLine("SELECT *"); sb.AppendLine("FROM Activity "); sb.AppendLine("WHERE 1=1 "); sb.AppendLine("AND id=@id "); SqlConnection aconn=MyConn (); SqlDataReader MyDataReader = SqlHelper.ExecuteReader(aconn, CommandType.Text, sb.ToString(), sqlParams); VO.ActivatyVO myActivatyVO = new ACMS.VO.ActivatyVO(); while (MyDataReader.Read()) { myActivatyVO.id = (Guid)MyDataReader["id"]; myActivatyVO.activity_type = (string)MyDataReader["activity_type"]; myActivatyVO.activity_info = (string)MyDataReader["activity_info"]; myActivatyVO.org_id = (string)MyDataReader["org_id"]; myActivatyVO.activity_name = (string)MyDataReader["activity_name"]; myActivatyVO.people_type = (string)MyDataReader["people_type"]; myActivatyVO.activity_startdate = (DateTime?)(MyDataReader["activity_startdate"] == DBNull.Value ? null : MyDataReader["activity_startdate"]); myActivatyVO.activity_enddate = (DateTime?)(MyDataReader["activity_enddate"] == DBNull.Value ? null : MyDataReader["activity_enddate"]); myActivatyVO.limit_count = (int?)(MyDataReader["limit_count"] == DBNull.Value ? null : MyDataReader["limit_count"]); myActivatyVO.limit2_count = (int?)(MyDataReader["limit2_count"] == DBNull.Value ? null : MyDataReader["limit2_count"]); myActivatyVO.team_member_max = (int?)(MyDataReader["team_member_max"] == DBNull.Value ? null : MyDataReader["team_member_max"]); myActivatyVO.team_member_min = (int?)(MyDataReader["team_member_min"] == DBNull.Value ? null : MyDataReader["team_member_min"]); myActivatyVO.regist_startdate = (DateTime?)(MyDataReader["regist_startdate"] == DBNull.Value ? null : MyDataReader["regist_startdate"]); myActivatyVO.regist_deadline = (DateTime?)(MyDataReader["regist_deadline"] == DBNull.Value ? null : MyDataReader["regist_deadline"]); myActivatyVO.cancelregist_deadline = (DateTime?)(MyDataReader["cancelregist_deadline"] == DBNull.Value ? null : MyDataReader["cancelregist_deadline"]); myActivatyVO.is_showfile = (string)MyDataReader["is_showfile"]; myActivatyVO.is_showprogress = (string)MyDataReader["is_showprogress"]; myActivatyVO.is_showperson_fix1 = (string)MyDataReader["is_showperson_fix1"]; myActivatyVO.is_showperson_fix2 = (string)MyDataReader["is_showperson_fix2"]; myActivatyVO.personextcount_max = (int?)(MyDataReader["personextcount_max"] == DBNull.Value ? null : MyDataReader["personextcount_max"]); myActivatyVO.personextcount_min = (int?)(MyDataReader["personextcount_min"] == DBNull.Value ? null : MyDataReader["personextcount_min"]); myActivatyVO.is_showidno = (string)MyDataReader["is_showidno"]; myActivatyVO.is_showremark = (string)MyDataReader["is_showremark"]; myActivatyVO.remark_name = (string)MyDataReader["remark_name"]; myActivatyVO.is_showteam_fix1 = (string)MyDataReader["is_showteam_fix1"]; myActivatyVO.is_showteam_fix2 = (string)MyDataReader["is_showteam_fix2"]; myActivatyVO.teamextcount_max = (int?)(MyDataReader["teamextcount_max"] == DBNull.Value ? null : MyDataReader["teamextcount_max"]); myActivatyVO.teamextcount_min = (int?)(MyDataReader["teamextcount_min"] == DBNull.Value ? null : MyDataReader["teamextcount_min"]); myActivatyVO.is_grouplimit = (string)MyDataReader["is_grouplimit"]; myActivatyVO.notice = (string)MyDataReader["notice"]; try { myActivatyVO.Send1DayMail = (bool)MyDataReader["Send1DayMail"]; } catch { myActivatyVO.Send1DayMail = false; } try { myActivatyVO.Send3DayMail = (bool)MyDataReader["Send3DayMail"]; } catch { myActivatyVO.Send3DayMail = false ; } try { myActivatyVO.SendUnregist = (bool)MyDataReader["SendUnregist"]; } catch { myActivatyVO.SendUnregist = false; } } MyDataReader.Close(); aconn.Close(); if (MyDataReader != null) MyDataReader.Dispose(); if (aconn != null) aconn.Dispose(); return myActivatyVO; }
/// <summary> /// 取得活動資料 /// </summary> /// <param name="id">活動代號</param> /// <returns>取得活動資料</returns> public VO.ActivatyVO SelectActivatyByID(Guid id) { SqlParameter[] sqlParams = new SqlParameter[1]; sqlParams[0] = new SqlParameter("@id", SqlDbType.UniqueIdentifier); sqlParams[0].Value = id; StringBuilder sb = new StringBuilder(); sb.AppendLine("SELECT *"); sb.AppendLine("FROM Activity "); sb.AppendLine("WHERE 1=1 "); sb.AppendLine("AND id=@id "); SqlConnection aconn = MyConn(); SqlDataReader MyDataReader = SqlHelper.ExecuteReader(aconn, CommandType.Text, sb.ToString(), sqlParams); VO.ActivatyVO myActivatyVO = new ACMS.VO.ActivatyVO(); while (MyDataReader.Read()) { myActivatyVO.id = (Guid)MyDataReader["id"]; myActivatyVO.activity_type = (string)MyDataReader["activity_type"]; myActivatyVO.activity_info = (string)MyDataReader["activity_info"]; myActivatyVO.org_id = (string)MyDataReader["org_id"]; myActivatyVO.activity_name = (string)MyDataReader["activity_name"]; myActivatyVO.people_type = (string)MyDataReader["people_type"]; myActivatyVO.activity_startdate = (DateTime?)(MyDataReader["activity_startdate"] == DBNull.Value ? null : MyDataReader["activity_startdate"]); myActivatyVO.activity_enddate = (DateTime?)(MyDataReader["activity_enddate"] == DBNull.Value ? null : MyDataReader["activity_enddate"]); myActivatyVO.limit_count = (int?)(MyDataReader["limit_count"] == DBNull.Value ? null : MyDataReader["limit_count"]); myActivatyVO.limit2_count = (int?)(MyDataReader["limit2_count"] == DBNull.Value ? null : MyDataReader["limit2_count"]); myActivatyVO.team_member_max = (int?)(MyDataReader["team_member_max"] == DBNull.Value ? null : MyDataReader["team_member_max"]); myActivatyVO.team_member_min = (int?)(MyDataReader["team_member_min"] == DBNull.Value ? null : MyDataReader["team_member_min"]); myActivatyVO.regist_startdate = (DateTime?)(MyDataReader["regist_startdate"] == DBNull.Value ? null : MyDataReader["regist_startdate"]); myActivatyVO.regist_deadline = (DateTime?)(MyDataReader["regist_deadline"] == DBNull.Value ? null : MyDataReader["regist_deadline"]); myActivatyVO.cancelregist_deadline = (DateTime?)(MyDataReader["cancelregist_deadline"] == DBNull.Value ? null : MyDataReader["cancelregist_deadline"]); myActivatyVO.is_showfile = (string)MyDataReader["is_showfile"]; myActivatyVO.is_showprogress = (string)MyDataReader["is_showprogress"]; myActivatyVO.is_showperson_fix1 = (string)MyDataReader["is_showperson_fix1"]; myActivatyVO.is_showperson_fix2 = (string)MyDataReader["is_showperson_fix2"]; myActivatyVO.personextcount_max = (int?)(MyDataReader["personextcount_max"] == DBNull.Value ? null : MyDataReader["personextcount_max"]); myActivatyVO.personextcount_min = (int?)(MyDataReader["personextcount_min"] == DBNull.Value ? null : MyDataReader["personextcount_min"]); myActivatyVO.is_showidno = (string)MyDataReader["is_showidno"]; myActivatyVO.is_showremark = (string)MyDataReader["is_showremark"]; myActivatyVO.remark_name = (string)MyDataReader["remark_name"]; myActivatyVO.is_showteam_fix1 = (string)MyDataReader["is_showteam_fix1"]; myActivatyVO.is_showteam_fix2 = (string)MyDataReader["is_showteam_fix2"]; myActivatyVO.teamextcount_max = (int?)(MyDataReader["teamextcount_max"] == DBNull.Value ? null : MyDataReader["teamextcount_max"]); myActivatyVO.teamextcount_min = (int?)(MyDataReader["teamextcount_min"] == DBNull.Value ? null : MyDataReader["teamextcount_min"]); myActivatyVO.is_grouplimit = (string)MyDataReader["is_grouplimit"]; myActivatyVO.notice = (string)MyDataReader["notice"]; try { myActivatyVO.Send1DayMail = (bool)MyDataReader["Send1DayMail"]; } catch { myActivatyVO.Send1DayMail = false; } try { myActivatyVO.Send3DayMail = (bool)MyDataReader["Send3DayMail"]; } catch { myActivatyVO.Send3DayMail = false; } try { myActivatyVO.SendUnregist = (bool)MyDataReader["SendUnregist"]; } catch { myActivatyVO.SendUnregist = false; } } MyDataReader.Close(); aconn.Close(); if (MyDataReader != null) { MyDataReader.Dispose(); } if (aconn != null) { aconn.Dispose(); } return(myActivatyVO); }