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