public static List <ActivityCalendar> SelectCurrentDayActivity(SqlConnection connection) { var activityList = new List <ActivityCalendar>(); var sql = @" SELECT DISTINCT AD.Owner , AD.BeginDate , AD.EndDate , AD.ActivityTitle FROM dbo.Activity_Detail AS AD WITH ( NOLOCK ) WHERE DATEDIFF(dd, AD.BeginDate, GETDATE()) >= 0 AND DATEDIFF(dd, AD.EndDate, GETDATE()) <= 0"; using (var reader = SqlHelper.ExecuteReader(connection, CommandType.Text, sql)) { while (reader.Read()) { var activity = new ActivityCalendar(); activity.Owner = reader.GetTuhuString(0); activity.BeginDate = reader.GetTuhuValue <DateTime>(1); activity.EndDate = reader.GetTuhuValue <DateTime>(2); activity.ActivityTitle = reader.GetTuhuString(3); activityList.Add(activity); } } return(activityList); }
/// <summary> /// 根据活动标题查询活动具体安排内容 /// </summary> /// <param name="title">活动标题</param> public static List <ActivityCalendar> SelectActivityDetailData(SqlConnection connection, string title, string date) { var activityDetailList = new List <ActivityCalendar>(); var parameters = new[] { new SqlParameter("@Title", title), new SqlParameter("@Date", date) }; using ( var reader = SqlHelper.ExecuteReader(connection, CommandType.StoredProcedure, "Activity_SelectActivityDetailDataByTitle", parameters)) { while (reader.Read()) { var activityDetail = new ActivityCalendar(); activityDetail.Owner = reader.GetTuhuString(0); activityDetail.BeginDate = reader.GetTuhuValue <DateTime>(1); activityDetail.EndDate = reader.GetTuhuValue <DateTime>(2); activityDetail.ActivityTitle = reader.GetTuhuString(3); activityDetail.ActivityContent = reader.GetTuhuString(4); activityDetail.ActivityUrl = reader.GetTuhuString(5); activityDetailList.Add(activityDetail); } } return(activityDetailList); }
public static ActivityCalendar GetActivity_Detail(SqlConnection connection, int pkid) { ActivityCalendar activityDetail = null; var parameters = new[] { new SqlParameter("@PKID", pkid) }; using (var dataReader = SqlHelper.ExecuteReader(connection, CommandType.StoredProcedure, "procSelectActivity_Detail", parameters)) { if (dataReader.Read()) { activityDetail = new ActivityCalendar(); activityDetail.Pkid = dataReader.GetTuhuValue <int>(0); activityDetail.Owner = dataReader.GetTuhuString(1); activityDetail.OwnerType = dataReader.GetTuhuString(2); activityDetail.BeginDate = dataReader.GetTuhuValue <System.DateTime>(3); activityDetail.EndDate = dataReader.GetTuhuNullableValue <DateTime>(4); activityDetail.ActivityTitle = dataReader.GetTuhuString(5); activityDetail.ActivityContent = dataReader.GetTuhuString(6); activityDetail.ActivityUrl = dataReader.GetTuhuString(7); activityDetail.ScheduleType = dataReader.GetTuhuString(8); activityDetail.CreateDate = dataReader.GetTuhuValue <System.DateTime>(9); activityDetail.CreateBy = dataReader.GetTuhuString(10); activityDetail.DataFrom = dataReader.GetTuhuString(11); activityDetail.DataFromId = dataReader.GetTuhuNullableValue <int>(12); activityDetail.IsActive = dataReader.GetTuhuValue <bool>(13); } } return(activityDetail); }
public IActionResult DownloadCalendar(int groupId) { var groupActivities = _context.GroupActivities.Where(g => g.GroupId == groupId).ToList(); var calendarString = ActivityCalendar.DownloadCalendar(groupActivities); var fileContents = Encoding.ASCII.GetBytes(calendarString); var contentType = "text/calendar"; var fileDownloadName = "GroupActivity.ics"; return(File(fileContents, contentType, fileDownloadName)); }
public static void Add(SqlConnection connection, ActivityCalendar activityDetail) { var parameters = new[] { new SqlParameter("@Owner", activityDetail.Owner ?? string.Empty), new SqlParameter("@OwnerType", activityDetail.OwnerType ?? string.Empty), new SqlParameter("@BeginDate", activityDetail.BeginDate), new SqlParameter("@EndDate", activityDetail.EndDate), new SqlParameter("@ActivityTitle", activityDetail.ActivityTitle ?? string.Empty), new SqlParameter("@ActivityContent", activityDetail.ActivityContent ?? string.Empty), new SqlParameter("@ActivityUrl", activityDetail.ActivityUrl ?? string.Empty), new SqlParameter("@ScheduleType", activityDetail.ScheduleType ?? string.Empty), new SqlParameter("@CreateDate", activityDetail.CreateDate), new SqlParameter("@CreateBy", activityDetail.CreateBy ?? string.Empty), new SqlParameter("@DataFrom", activityDetail.DataFrom ?? string.Empty), new SqlParameter("@DataFromID", activityDetail.DataFromId.HasValue? (object)activityDetail.DataFromId.Value : DBNull.Value), new SqlParameter("@IsActive", activityDetail.IsActive) }; SqlHelper.ExecuteNonQuery(connection, CommandType.StoredProcedure, "ActivityDetail_InsertActivityDetail", parameters); }
public static List <ActivityCalendar> SelectActivityByCondition(SqlConnection connection, string sqlWhere) { var activityList = new List <ActivityCalendar>(); var parameters = new[] { new SqlParameter("@sqlWhere", sqlWhere) }; using (var dataReader = SqlHelper.ExecuteReader(connection, CommandType.StoredProcedure, "Actovity_SelectActivityDetail", parameters)) { while (dataReader.Read()) { var activityDetail = new ActivityCalendar { Pkid = dataReader.GetTuhuValue <int>(0), Owner = dataReader.GetTuhuString(1), OwnerType = dataReader.GetTuhuString(2), BeginDate = dataReader.GetTuhuValue <System.DateTime>(3), EndDate = dataReader.GetTuhuNullableValue <DateTime>(4), ActivityTitle = dataReader.GetTuhuString(5), ActivityContent = dataReader.GetTuhuString(6), ActivityUrl = dataReader.GetTuhuString(7), ScheduleType = dataReader.GetTuhuString(8), CreateDate = dataReader.GetTuhuValue <System.DateTime>(9), CreateBy = dataReader.GetTuhuString(10), DataFrom = dataReader.GetTuhuString(11), DataFromId = dataReader.GetTuhuNullableValue <int>(12), IsActive = dataReader.GetTuhuValue <bool>(13), LastUpdateDate = dataReader.GetTuhuValue <DateTime>(14) }; activityList.Add(activityDetail); } } return(activityList); }