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