Beispiel #1
0
        protected void Page_Load(object sender, EventArgs e)
        {
            try
            {
                var chooseDateString = Request.QueryString["chooseDate"];
                if (!string.IsNullOrEmpty(chooseDateString))
                {
                    chooseDate = DateTime.Parse(chooseDateString);
                }
                user = UserInfoBLL.GetUserInfo(GetLoginUserId());
                if (!string.IsNullOrEmpty(Request.QueryString["isSeven"]))
                {
                    isSeven = true;
                }
                if (!string.IsNullOrEmpty(Request.QueryString["isShowDetai"]))
                {
                    isShowDetai = true;
                }

                var id = Request.QueryString["id"];
                if (!string.IsNullOrEmpty(id))
                {
                    thisProject = new pro_project_dal().FindNoDeleteById(long.Parse(id));
                    if (thisProject != null)
                    {
                        taskList   = new sdk_task_dal().GetProTask(thisProject.id, " and type_id in (1807,1808,1812)");
                        proCalList = new pro_project_calendar_dal().GetCalByPro(thisProject.id);
                    }
                }
                if (!string.IsNullOrEmpty(Request.QueryString["isAll"]))
                {
                    isAll = true;
                }
                if (isAll)
                {
                    taskList = new sdk_task_dal().FindListBySql($"select* from sdk_task where delete_time = 0 and type_id in (1807,1808,1812)");
                    var ppDal = new DAL.pro_project_dal();
                    proCalList = new pro_project_calendar_dal().FindListBySql($"SELECT * from pro_project_calendar where delete_time = 0");
                    const string proLimitJson    = "{\"row\":\"7\",\"t1\":\"p\",\"col1\":\"0\",\"col2\":\"0\"}";
                    var          projectLimitSql = Convert.ToString(ppDal.GetSingle($"select f_rpt_getsql_limit('{proLimitJson}',{LoginUserId.ToString()})"));
                    projectList = ppDal.FindListBySql("select* from pro_project p where p.delete_time =0 " + projectLimitSql);
                }
            }
            catch (Exception msg)
            {
                Response.End();
            }
        }