/// <summary>
/// 新增一筆活動資料
/// </summary>
/// <param name="myActivatyVO">活動資料型別物件</param>
/// <returns>新增一筆活動資料</returns>
public int INSERT_NewOne(VO.ActivatyVO myActivatyVO)
{
SqlParameter[] sqlParams = new SqlParameter[4];
sqlParams[0] = new SqlParameter("@id", SqlDbType.UniqueIdentifier);
sqlParams[0].Value = myActivatyVO.id;
sqlParams[1] = new SqlParameter("@activity_type", SqlDbType.NChar, 1);
sqlParams[1].Value = myActivatyVO.activity_type;
sqlParams[2] = new SqlParameter("@activity_info", SqlDbType.NText);
sqlParams[2].Value = myActivatyVO.activity_info;
sqlParams[3] = new SqlParameter("@emp_id", SqlDbType.NVarChar, myActivatyVO.emp_id.Length);
sqlParams[3].Value = myActivatyVO.emp_id;
StringBuilder sb = new StringBuilder();
//sb.AppendLine("INSERT Activity ");
//sb.AppendLine("([id],[activity_info],[activity_name],[activity_type],[people_type],[activity_startdate],[activity_enddate],[limit_count],[limit2_count],[team_member_max],[team_member_min],[regist_deadline],[cancelregist_deadline],[is_showfile],[is_showprogress],[is_showextpeoplecount],[is_showremark],[is_grouplimit]) ");
//sb.AppendLine("SELECT ");
//sb.AppendLine("(@id,@activity_info,@activity_name,@activity_type,@people_type,@activity_startdate,@activity_enddate,@limit_count,@limit2_count,@team_member_max,@team_member_min,@regist_deadline,@cancelregist_deadline,@is_showfile,@is_showprogress,@is_showextpeoplecount,@is_showremark,@is_grouplimit) ");
sb.AppendLine("INSERT Activity ");
sb.AppendLine("([id],[activity_type],[activity_info],[org_id],[activity_name],[people_type],[activity_startdate],[activity_enddate],[limit_count],[limit2_count],[team_member_max],[team_member_min],[regist_startdate],[regist_deadline],[cancelregist_deadline],[is_showfile],[is_showprogress],[is_showperson_fix1],[is_showperson_fix2],[personextcount_max],[personextcount_min],[is_showidno],[is_showremark],[remark_name],[is_showteam_fix1],[is_showteam_fix2],[teamextcount_max],[teamextcount_min],[is_grouplimit],[notice],[active],[emp_id]) ");
sb.AppendLine("VALUES ");
sb.AppendLine("(@id,@activity_type,'','','','',null,null,null,null,null,null,null,null,null,'N','N','N','N',null,null,'N','N','','N','N',null,null,'N','',null,@emp_id) ");
return(SqlHelper.ExecuteNonQuery(MyConn(), CommandType.Text, sb.ToString(), sqlParams));
}
/// <summary>
/// 修改一筆活動資料
/// </summary>
/// <param name="myActivatyVO">活動資料型別物件</param>
/// <returns>修改一筆活動資料</returns>
public int UpdateActivaty(VO.ActivatyVO myActivatyVO)
{
SqlParameter[] sqlParams = new SqlParameter[34];
sqlParams[0] = new SqlParameter("@id", SqlDbType.UniqueIdentifier);
sqlParams[0].Value = myActivatyVO.id;
sqlParams[1] = new SqlParameter("@activity_type", SqlDbType.NChar, 1);
sqlParams[1].Value = myActivatyVO.activity_type;
sqlParams[2] = new SqlParameter("@activity_info", SqlDbType.NText);
sqlParams[2].Value = myActivatyVO.activity_info;
sqlParams[3] = new SqlParameter("@org_id", SqlDbType.NVarChar, 50);
sqlParams[3].Value = myActivatyVO.org_id;
sqlParams[4] = new SqlParameter("@activity_name", SqlDbType.NVarChar, 50);
sqlParams[4].Value = myActivatyVO.activity_name;
sqlParams[5] = new SqlParameter("@people_type", SqlDbType.NVarChar, 50);
sqlParams[5].Value = myActivatyVO.people_type;
sqlParams[6] = new SqlParameter("@activity_startdate", SqlDbType.DateTime);
if (myActivatyVO.activity_startdate == null || myActivatyVO.activity_startdate == DateTime.Today)
{
sqlParams[6].Value = DBNull.Value;
}
else
{
sqlParams[6].Value = myActivatyVO.activity_startdate;
}
sqlParams[7] = new SqlParameter("@activity_enddate", SqlDbType.DateTime);
if (myActivatyVO.activity_enddate == null || myActivatyVO.activity_enddate == DateTime.Today)
{
sqlParams[7].Value = DBNull.Value;
}
else
{
sqlParams[7].Value = myActivatyVO.activity_enddate;
}
sqlParams[8] = new SqlParameter("@limit_count", SqlDbType.Int);
if (myActivatyVO.activity_startdate == DateTime.Today)
{
sqlParams[8].Value = DBNull.Value;
}
else
{
sqlParams[8].Value = myActivatyVO.limit_count;
}
sqlParams[9] = new SqlParameter("@limit2_count", SqlDbType.Int);
if (myActivatyVO.activity_startdate == DateTime.Today)
{
sqlParams[9].Value = DBNull.Value;
}
else
{
sqlParams[9].Value = myActivatyVO.limit2_count;
}
sqlParams[10] = new SqlParameter("@team_member_max", SqlDbType.Int);
sqlParams[10].Value = myActivatyVO.team_member_max;
sqlParams[11] = new SqlParameter("@team_member_min", SqlDbType.Int);
sqlParams[11].Value = myActivatyVO.team_member_min;
sqlParams[12] = new SqlParameter("@regist_startdate", SqlDbType.DateTime);
if (myActivatyVO.regist_startdate == null)
{
sqlParams[12].Value = DBNull.Value;
}
else
{
sqlParams[12].Value = myActivatyVO.regist_startdate;
}
sqlParams[13] = new SqlParameter("@regist_deadline", SqlDbType.DateTime);
if (myActivatyVO.regist_deadline == null)
{
sqlParams[13].Value = DBNull.Value;
}
else
{
sqlParams[13].Value = myActivatyVO.regist_deadline;
}
sqlParams[14] = new SqlParameter("@cancelregist_deadline", SqlDbType.DateTime);
if (myActivatyVO.cancelregist_deadline == null)
{
sqlParams[14].Value = DBNull.Value;
}
else
{
sqlParams[14].Value = myActivatyVO.cancelregist_deadline;
}
sqlParams[15] = new SqlParameter("@is_showfile", SqlDbType.NChar, 1);
sqlParams[15].Value = myActivatyVO.is_showfile;
sqlParams[16] = new SqlParameter("@is_showprogress", SqlDbType.NChar, 1);
sqlParams[16].Value = myActivatyVO.is_showprogress;
sqlParams[17] = new SqlParameter("@is_showperson_fix1", SqlDbType.NChar, 1);
sqlParams[17].Value = myActivatyVO.is_showperson_fix1;
sqlParams[18] = new SqlParameter("@is_showperson_fix2", SqlDbType.NChar, 1);
sqlParams[18].Value = myActivatyVO.is_showperson_fix2;
sqlParams[19] = new SqlParameter("@personextcount_max", SqlDbType.Int);
sqlParams[19].Value = myActivatyVO.personextcount_max;
sqlParams[20] = new SqlParameter("@personextcount_min", SqlDbType.Int);
sqlParams[20].Value = myActivatyVO.personextcount_min;
sqlParams[21] = new SqlParameter("@is_showidno", SqlDbType.NChar, 1);
sqlParams[21].Value = myActivatyVO.is_showidno;
sqlParams[22] = new SqlParameter("@is_showremark", SqlDbType.NChar, 1);
sqlParams[22].Value = myActivatyVO.is_showremark;
sqlParams[23] = new SqlParameter("@remark_name", SqlDbType.NVarChar, 50);
sqlParams[23].Value = myActivatyVO.remark_name;
sqlParams[24] = new SqlParameter("@is_showteam_fix1", SqlDbType.NChar, 1);
sqlParams[24].Value = myActivatyVO.is_showteam_fix1;
sqlParams[25] = new SqlParameter("@is_showteam_fix2", SqlDbType.NChar, 1);
sqlParams[25].Value = myActivatyVO.is_showteam_fix2;
sqlParams[26] = new SqlParameter("@teamextcount_max", SqlDbType.Int);
sqlParams[26].Value = myActivatyVO.teamextcount_max;
sqlParams[27] = new SqlParameter("@teamextcount_min", SqlDbType.Int);
sqlParams[27].Value = myActivatyVO.teamextcount_min;
sqlParams[28] = new SqlParameter("@is_grouplimit", SqlDbType.NChar, 1);
sqlParams[28].Value = myActivatyVO.is_grouplimit;
sqlParams[29] = new SqlParameter("@notice", SqlDbType.NText);
sqlParams[29].Value = myActivatyVO.notice;
sqlParams[30] = new SqlParameter("@active", SqlDbType.NChar, 1);
if (myActivatyVO.active == "Y")
{
sqlParams[30].Value = myActivatyVO.active;
}
else
{
sqlParams[30].Value = DBNull.Value;
}
if (myActivatyVO.Send3DayMail)
{
sqlParams[31] = new SqlParameter("@Send3DayMail", true);
}
else
{
sqlParams[31] = new SqlParameter("@Send3DayMail", false);
}
if (myActivatyVO.Send1DayMail)
{
sqlParams[32] = new SqlParameter("@Send1DayMail", true);
}
else
{
sqlParams[32] = new SqlParameter("@Send1DayMail", false);
}
if (myActivatyVO.SendUnregist)
{
sqlParams[33] = new SqlParameter("@SendUnregist", true);
}
else
{
sqlParams[33] = new SqlParameter("@SendUnregist", false);
}
StringBuilder sb = new StringBuilder();
sb.AppendLine("UPDATE Activity ");
sb.AppendLine("SET id=@id ");
sb.AppendLine(",activity_type=@activity_type ");
sb.AppendLine(",activity_info=@activity_info ");
sb.AppendLine(",org_id=@org_id ");
sb.AppendLine(",activity_name=@activity_name ");
sb.AppendLine(",people_type=@people_type ");
sb.AppendLine(",activity_startdate=@activity_startdate ");
sb.AppendLine(",activity_enddate=@activity_enddate ");
sb.AppendLine(",limit_count=@limit_count ");
sb.AppendLine(",limit2_count=@limit2_count ");
sb.AppendLine(",team_member_max=@team_member_max ");
sb.AppendLine(",team_member_min=@team_member_min ");
sb.AppendLine(",regist_startdate=@regist_startdate ");
sb.AppendLine(",regist_deadline=@regist_deadline ");
sb.AppendLine(",cancelregist_deadline=@cancelregist_deadline ");
sb.AppendLine(",is_showfile=@is_showfile ");
sb.AppendLine(",is_showprogress=@is_showprogress ");
sb.AppendLine(",is_showperson_fix1=@is_showperson_fix1 ");
sb.AppendLine(",is_showperson_fix2=@is_showperson_fix2 ");
sb.AppendLine(",personextcount_max=@personextcount_max ");
sb.AppendLine(",personextcount_min=@personextcount_min ");
sb.AppendLine(",is_showidno=@is_showidno ");
sb.AppendLine(",is_showremark=@is_showremark ");
sb.AppendLine(",remark_name=@remark_name ");
sb.AppendLine(",is_showteam_fix1=@is_showteam_fix1 ");
sb.AppendLine(",is_showteam_fix2=@is_showteam_fix2 ");
sb.AppendLine(",teamextcount_max=@teamextcount_max ");
sb.AppendLine(",teamextcount_min=@teamextcount_min ");
sb.AppendLine(",is_grouplimit=@is_grouplimit ");
sb.AppendLine(",notice=@notice ");
sb.AppendLine(",active=@active ");
sb.AppendLine(",Send3DayMail=@Send3DayMail ");
sb.AppendLine(",Send1DayMail=@Send1DayMail ");
sb.AppendLine(",SendUnregist=@SendUnregist ");
sb.AppendLine("WHERE 1=1 ");
sb.AppendLine("AND id=@id ");
return(SqlHelper.ExecuteNonQuery(MyConn(), CommandType.Text, sb.ToString(), sqlParams));
}
