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