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