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