public string getDateInfo(string userId, string startDay1, string endData1) { string couw = ""; try { DateTime startDay = DateTime.Parse(startDay1); DateTime endData = DateTime.Parse(endData1); //用户的计划包括个人计划和项目任务,而且数据 userId = commons.RequestSafeString(userId, 50); startDay = DateTime.Parse(startDay.ToString("yyyy-MM-dd") + " 00:00:00"); endData = DateTime.Parse(endData.ToString("yyyy-MM-dd") + " 23:59:59"); DateTime s = DateTime.Parse(startDay.ToString("yyyy-MM-dd")); DateTime e = DateTime.Parse(endData.ToString("yyyy-MM-dd")); int i = int.Parse(commons.DateDiff(s, e)); if (i >= 0) { for (int j = 0; j <= i; j++) { DateTime s1 = DateTime.Parse(s.AddDays(j).ToString("yyyy-MM-dd") + " 00:00:00"); //DateTime e1 = DateTime.Parse(s.AddDays(j).ToString("yyyy-MM-dd") + " 23:59:59"); couw = couw + "<day date=\"" + s.AddDays(j).ToString("yyyy-MM-dd") + "\">"; couw = couw + getPersonal_Plan(userId, s1); couw = couw + getProject_Plan(userId, s1); couw = couw + "</day>"; } } } catch { } return(couw); }
/// <summary> /// 根据用户组的ID,获取到当个用户组的 /// </summary> /// <param name="groupid"></param> /// <returns></returns> private DataTable getRolesSig(string groupid) { DataTable coutw = new DataTable(); try { groupid = common.RequestSafeString(groupid, 50); mugroups = bugroups.GetModel(groupid); if (mugroups != null) { //根据找到的用户组,找出所有的权限点 string rolelist = mugroups.ROLE.ToString(); string sqlin = ""; string sql = ""; if (rolelist.Contains(",")) { sqlin = common.makeSqlIn(rolelist, ','); sql = "select ID,Roles,Types,upRoles from vUSER_Role where DELFLAG='0' AND ID in " + sqlin; coutw = pageControl.doSql(sql).Tables[0]; } else { if (rolelist.Length > 0) { sql = "select ID,Roles,Types,upRoles from vUSER_Role where DELFLAG='0' AND ID='" + rolelist + "'"; coutw = pageControl.doSql(sql).Tables[0]; } } } } catch { } return(coutw); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { // 默认NEWS if (String.IsNullOrEmpty(_foritems)) { _foritems = "NEWS"; } if (Request.Params["PARENTID"] != null && !String.IsNullOrEmpty(Request["PARENTID"])) { _parentid = common.RequestSafeString(Request["PARENTID"], 50); } if (_parentid == "3") { _foritems = "DEPARTMENT"; } else if (_parentid == "4" || _parentid == "5") { _foritems = "NEWS"; } GetddlPARENTID(); GetrblLimitsChoose(); BindDataList(); } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { string id = common.RequestSafeString(Request["id"].ToString(), 50); BindData(id); } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { if (Request.Params["id"] != null && !String.IsNullOrEmpty(Request["id"])) { _id = common.RequestSafeString(Request["id"], 50); } BindData(); } }
protected void Page_Load(object sender, EventArgs e) { if (Session["USER_Users"] == null) { string coutws = "<script language=\"javascript\" type=\"text/javascript\">alert(\"您目前已经登录超时!请重新登录!谢谢!\");location.href='/login.aspx';</script>"; Response.Write(coutws); return; } if (!IsPostBack) { string id = common.RequestSafeString(Request["id"].ToString(), 50); BindData(id); } }
/// <summary> /// 按项目筛选触发事件 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void DropDownList_myProject_change(object sender, EventArgs e) { try { string oldsession = Session["Work_ProjectId"].ToString(); string projectid = commons.RequestSafeString(DropDownList_myProject.SelectedValue.ToString(), 50); Session["Work_ProjectId"] = projectid; setProjectStatusName(projectid);//设置项目的状态 string urls = Request.RawUrl; //项目任务 if (urls.Contains("/Admin/personalProjectManage/OAtask/")) { urls = "/Admin/personalProjectManage/OAtask/manage.aspx"; }//项目经费 else if (urls.Contains("/Admin/personalProjectManage/OACashApply/")) { urls = "/Admin/personalProjectManage/OACashApply/manageCashApply.aspx"; }//项目资源 else if (urls.Contains("/Admin/personalProjectManage/OAapply/")) { urls = "/Admin/personalProjectManage/OAapply/manage.aspx"; }//项目消息 else if (urls.Contains("/Admin/personalProjectManage/OANews/")) { urls = "/Admin/personalProjectManage/OANews/manage.aspx"; }//项目文档 else if (urls.Contains("/Admin/DocumentManage/")) { urls = "/Admin/DocumentManage/manage.aspx"; }//人员分配 else if (urls.Contains("/Admin/personalProjectManage/OADepartMent/")) { urls = "/Admin/personalProjectManage/OADepartMent/manage.aspx"; } Response.Redirect(urls); // Response.Redirect("/Admin/personalProjectManage/OAtask/manage.aspx"); } catch { } }
/// <summary> /// 根据条件构建数据 /// </summary> /// <param name="groupname"></param> protected void BindData(string status) { try { ddlStatas.SelectedValue = status; string projectid = common.RequestSafeString(HiddenField_projectid.Value.ToString(), 50); string strSQL = "SELECT * FROM vCash_Apply WHERE projectid='" + projectid + "' and statas='" + status + "' order by getdatetime desc"; DataTable dt = new DataTable(); dt = pageControl.doSql(strSQL).Tables[0]; HiddenField_totals.Value = "0"; mProject = bProject.GetModel(int.Parse(projectid)); if (dt.Rows.Count > 0) { GridView1.Visible = true; GridView1.DataSource = dt; //指定GridView1的数据是dv GridView1.DataBind(); //将上面指定的信息绑定到GridView1上 notice.Text = ""; tag.Text = "总计: " + HiddenField_totals.Value.ToString() + " 元"; Label_tongji.Text = mProject.NAMES.ToString() + " 的预计经费为: " + mProject.CashTotal.ToString() + "元<br/>共 " + dt.Rows.Count.ToString() + " 条记录!<br/>总计 " + HiddenField_totals.Value.ToString() + " 元"; } else { GridView1.Visible = false; notice.Text = "*没有符合条件的结果!"; tag.Text = ""; Label_tongji.Text = "暂无统计信息!"; } } catch { tag.Text = ""; Label_tongji.Text = "暂无统计信息!"; } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { this.Button_sumbit.Visible = true; id = common.RequestSafeString(Request["id"].ToString(), 50); //获取所属预算报告列表信息 GetDDLBudget(); //获取所属部门的列表信息 GetddlDepartmentID(); //获取持卡人的列表信息 GetddlCardholderID(); //获取所属项目的列表信息 GetddlProjectID(); //获取审批人的列表信息 GetddlApprover(); ShowInitInfo(id); /*设置模板页中的管理值*/ (Master.FindControl("Label_navigation") as Label).Text = "管理 > 财务管理 > 资金卡"; } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { //设置项目状态 if (Request.QueryString["status"] == null) { DDL_Status.SelectedValue = ""; } else { DDL_Status.SelectedValue = Request.QueryString["status"].ToString(); } //项目ID string projectid = Request["ID"]; if (projectid != null && projectid != "")//如果项目的ID存在,则做切换 { projectid = commons.RequestSafeString(projectid.ToString(), 50); Session["Work_ProjectId"] = projectid; } Session["Session_Project_linkshow"] = "LinkButton_task";//定义过来后要显示任务的按钮 Model.USER_Users user_model = (Model.USER_Users)Session["USER_Users"]; //判断此项目的项目负责人是否为现在操作的人员(因为操作人员可分为“项目负责人”和“项目参与人员”) //如果不是项目负责人在操作,则不能进行新增,编辑,删除的相关操作 string sql = " SELECT LeaderID,SendUserID FROM Project_Projects where ID= " + Session["Work_ProjectId"]; DataTable DT_leaderID = new DataTable(); DT_leaderID = pageControl.doSql(sql).Tables[0]; if (DT_leaderID.Rows.Count > 0) { string LeaderID = DT_leaderID.Rows[0]["LeaderID"].ToString(); string SendUserID = DT_leaderID.Rows[0]["SendUserID"].ToString(); if (!LeaderID.Equals(user_model.ID) && !SendUserID.Equals(user_model.ID))//说明不是项目负责人 { Button_add.Visible = false; Button_modify.Visible = false; Button_delete.Visible = false; //这里设这个session是为了“设为已完成”,“设为进行中”,“设为延期”三个功能用的 //因为项目负责人进行以上三个功能操作时只需要改变相应任务中的status即可 //而项目参与人员则必须同时修改掉UserIDs中对应着自己的ID号的status Session["isProjectLeader"] = false; } else { Session["isProjectLeader"] = true; } } //以上 string pageindex = null;//这里是为分页服务的 pageindex = Request["pageindex"]; string count = dtrowsHidden.Value.ToString(); if (count.Length == 0) { setRowCout();//获取当前状态下有多少条数据记录,为分页提供页数和全部条数服务 count = dtrowsHidden.Value.ToString(); } else { count = "0"; } int countint = int.Parse(count); if (pageindex == null || pageindex == "") { pageindex = "1"; } int pageindex_int = int.Parse(pageindex); ShowTaskList(pageindex_int); //设置模板页中的管理值 (Master.FindControl("Label_navigation") as Label).Text = "项目 > 我的项目 > 任务管理 > 任务列表 "; //设置模板页中的管理值 //if (null != Request["status"]) //{ // for (int i = 0; i < DDL_Status.Items.Count; i++) // { // if (DDL_Status.Items[i].Value.ToString().Equals(Request["status"].ToString())) // { // DDL_Status.Items[i].Selected = true; // } // } //} //项目状态 bool Project_Status = BProject_Status.ProjectStatus(Session["Work_ProjectId"].ToString()); //根据项目状态设置页面按钮状态 if (Project_Status == false) { Button_add.Enabled = Project_Status; Button_modify.Enabled = Project_Status; Button_delete.Enabled = Project_Status; Button_setfinish.Enabled = Project_Status; Button_setpostpone.Enabled = Project_Status; } } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { if (Request.Params["PARENTID"] != null && !String.IsNullOrEmpty(Request["PARENTID"])) { _parentid = common.RequestSafeString(Request["PARENTID"], 50); } if (Request.Params["status"] != null && !String.IsNullOrEmpty(Request["status"])) { _boxtype = Request["status"]; } else { if (Request.Params["PARENTID"].ToString().Equals("5")) { _boxtype = "1"; } else { _boxtype = "2"; } } //GetddlMailBox(); string count = dtrowsHidden.Value.ToString(); if (count.Length == 0) { if (_boxtype == "1") { setRowCout1();//发件箱 } else { setRowCout();//获取当前状态下有多少条数据记录,为分页提供页数和全部条数服务 } count = dtrowsHidden.Value.ToString(); } else { count = "0"; } int countint = int.Parse(count); string pageindex = null;//这里是为分页服务的 if (pageindex == null || pageindex == "") { pageindex = "1"; } int pageindex_int = int.Parse(pageindex); if (_boxtype == "1") { this.Button_add.Visible = true; this.Button_modify.Visible = true; BindData1(pageindex_int);//发件箱 } else { this.Button_add.Visible = false; this.Button_modify.Visible = false; BindData(pageindex_int);//收件箱 } } }