public ResponseStatus GetActivities(Container_List_Activity conta_Activity, bool isHasNoActive, bool isResume)
{
dalBase.sql = isHasNoActive ?
"SELECT * FROM db_activity WHERE publishTime <= CURDATE() AND overEnd >=CURDATE() ORDER BY publishTime DESC" :
"SELECT * FROM db_activity WHERE isactive=1 AND publishTime <= CURDATE() AND overEnd >=CURDATE() ORDER BY publishTime DESC";
dalBase.sql += isResume ? " LIMIT 0,5" : "";
bool isSuccess = dalBase.Run(Behavious.SELECT_WITHOUT_PARAM, false);
return(this.JudgeDBResult(isSuccess,
() =>
{
conta_Activity.activities = new List <Activity>();
while (dalBase.DataRead.Read())
{
object a = dalBase.DataRead["preStart"];
conta_Activity.activities.Add(new Activity()
{
ID = Convert.ToInt32(dalBase.DataRead["id"]),
Content = dalBase.DataRead["content"].ToString(),
IsActive = Convert.ToByte(dalBase.DataRead["isactive"]),
IsVisitApply = Convert.ToByte(dalBase.DataRead["isVisitApply"]),
PublishTime = dalBase.DataRead["publishTime"] != DBNull.Value ? Convert.ToDateTime(dalBase.DataRead["publishTime"]) : GLB.initTime,
PreStart = dalBase.DataRead["preStart"] != DBNull.Value ? Convert.ToDateTime(dalBase.DataRead["preStart"]) : GLB.initTime,
OverEnd = dalBase.DataRead["overEnd"] != DBNull.Value ? Convert.ToDateTime(dalBase.DataRead["overEnd"]) : GLB.initTime,
ContentDetails = dalBase.DataRead["contentDetails"].ToString()
}
);
}
}, null));
}
public void GetDataForPersonalHome(HttpRequestBase req, Container_Notices_MyWorks_TeamWorks_Activities
conTa_Notices_MyWorks_TeamWorks_Activities)
{
NoticeDAL noticeDal = new NoticeDAL();
bool isResume = true;
noticeDal.GetNotices(isResume, null, NoticeType.NONE);
noticeDal.ReturnUnitToPool();
conTa_Notices_MyWorks_TeamWorks_Activities.list_Notice = noticeDal.ListNotice;
Container_List_Activity conta_Activity = new Container_List_Activity();
ActivityDAL activityDal = new ActivityDAL();
activityDal.GetActivities(conta_Activity, false, true);
activityDal.ReturnUnitToPool();
conTa_Notices_MyWorks_TeamWorks_Activities.list_Activity = conta_Activity.activities;
List <Work> works = new List <Work>();
List <Work> m_works = new List <Work>();
WorkDAL workDal = new WorkDAL();
for (int i = 0; i < req.Cookies.Count; ++i)
{
if (req.Cookies[i].Name.Contains(GLB.activity))
{
workDal.GetWorks(Convert.ToInt32(req.Cookies[GLB.depId].Value), Convert.ToInt32(req.Cookies[i].Value), works, null);
workDal.GetWorks(Convert.ToInt32(req.Cookies[GLB.depId].Value), Convert.ToInt32(req.Cookies[i].Value),
m_works, Convert.ToInt32(req.Cookies[GLB.id].Value));
}
}
workDal.ReturnUnitToPool();
conTa_Notices_MyWorks_TeamWorks_Activities.list_TeamWork = works;
conTa_Notices_MyWorks_TeamWorks_Activities.list_MyWork = m_works;
}
public ResponseStatus GetActivities(Container_List_Activity conta_Activity, bool isHasNoActive)
{
activityDal = new ActivityDAL();
ResponseStatus resp = activityDal.GetActivities(conta_Activity, isHasNoActive, false);
activityDal.ReturnUnitToPool();
return(resp);
}
public ActivityController()
{
activityService = ServiceBuilder.BuildActivityService();
conta_Activity = new Container_List_Activity();
}
