Ejemplo n.º 1
0
 private void DoSelect()
 {
     if (!string.IsNullOrEmpty(this.RequestData.Get <string>("TaskId")))
     {
         this.PageState.Add("TaskModel", A_TaskWBS.Find(this.RequestData.Get <string>("TaskId")));
         ents = WorkTimeFact.FindAll(SearchCriterion, Expression.Eq(WorkTimeFact.Prop_TaskId, this.RequestData.Get <string>("TaskId")));
     }
     else
     {
         ents = WorkTimeFact.FindAll(SearchCriterion);
     }
     this.PageState.Add("WorkTimeFactList", ents);
 }
Ejemplo n.º 2
0
        /// <summary>
        /// 查询
        /// </summary>
        private void DoSelect()
        {
            if (RequestData.Get <object>("EditDate") != null)
            {
                ents = WorkTimeFact.FindAll(SearchCriterion, Expression.Eq(WorkTimeFact.Prop_CreateId, this.UserInfo.UserID), Expression.Eq(WorkTimeFact.Prop_CurrentDate, RequestData.Get <DateTime>("EditDate")));
                if (ents.Count > 0)
                {
                    this.PageState.Add("WorkTimeFactList", ents);
                }
                else
                {
                    string sql = @"select 0 Total,Id TaskId,Code TaskCode,TaskName,GetDate() CreateDate,'{2}' CurrentDate from {1}..A_TaskWBS 
where DutyId like '%{0}%' order by Code asc";
                    this.PageState.Add("WorkTimeFactList", DataHelper.QueryDictList(string.Format(sql, this.UserInfo.UserID, db, RequestData.Get <object>("EditDate").ToString().Replace("-", "/"))));
                }
            }
            else
            {
                Response.Redirect("/Aim/Execute/WorkLog.aspx?EditDate=" + DateTime.Now.ToShortDateString().Replace('/', '-'));
                ents = WorkTimeFact.FindAll(SearchCriterion, Expression.Eq(WorkTimeFact.Prop_CreateId, this.UserInfo.UserID));
                this.PageState.Add("WorkTimeFactList", ents);
            }
        }