/// <summary> /// 页面初始化加载 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> 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 (!Page.IsPostBack) { string time = this.Request.QueryString["time"].ToString(); ParseTime(time); string changeyear = string.Empty; if (!string.IsNullOrEmpty(year)) { changeyear += ChangeYear(year); } if (!string.IsNullOrEmpty(year) && !string.IsNullOrEmpty(toyear)) { changeyear = changeyear + "-" + ChangeYear(toyear); } this.lblYear.Text = changeyear; bindDataToGV(); this.lblCount.Text = pageControl.doSql("select count(1) from dbo.USER_Users").Tables[0].Rows[0][0].ToString(); if (this.GridView1.Rows.Count == 0) { Response.Write("没有符合条件的数据!"); } else { //导出Excel exportExcel(); } } }
/// <summary> /// 获取所属预算报告列表 /// </summary> private void GetDDLBudget() { try { DDL_Budget.Items.Clear(); DataTable DT = new DataTable(); string sql = "SELECT ID, NAMES FROM Cash_SF_Order WHERE (Delflag = 0) AND (Status = 1) ORDER BY ADDTIME DESC "; DT = pageControl.doSql(sql).Tables[0]; if (DT.Rows.Count > 0) { DDL_Budget.DataSource = DT; DDL_Budget.DataTextField = "NAMES"; DDL_Budget.DataValueField = "ID"; DDL_Budget.DataBind(); } else { ListItem li = new ListItem("-暂无预算报告-", ""); DDL_Budget.Items.Add(li); //没有预算报告不能创建资金卡 Button_sumbit.Enabled = false; tag.Text = "暂无预算报告,不能创建资金卡!"; } } catch { } }
/// <summary> /// 会议室列表 /// </summary> protected void ShowListInfo() { try { DataTable dt = new DataTable(); string sql = "SELECT * FROM Project_RoomList WHERE (DELFLAG = 0)"; dt = pagecontrol.doSql(sql).Tables[0]; if (dt.Rows.Count > 0) { GridView1.Visible = true; GridView1.DataSource = dt; //指定GridView1的数据是DT GridView1.DataBind(); //将上面指定的信息绑定到GridView1上 } else { GridView1.Visible = false; Button_Check.Enabled = false; notice.Text = "*暂无可供预订的会议室信息!"; } } catch { } }
/// <summary> /// 显示出当前各个按钮的数据条数 /// </summary> /// <returns></returns> private string countnums(LinkButton lib, string types, string condition) { string coutw = ""; try { string sqlwhere = SQLCondition_tag2(types, "0", condition); string strSQL = "SELECT count(ID) as nums FROM FaceShowMessage WHERE " + sqlwhere; DataTable dt = new DataTable(); dt = pageControl.doSql(strSQL).Tables[0]; if (dt.Rows.Count > 0) { coutw = dt.Rows[0]["nums"].ToString(); } else { coutw = dtrowsHidden.Value.ToString(); } } catch { } return(coutw); }
/// <summary> /// /// </summary> /// <param name="groupname"></param> protected void BindData() { try { DateTime dtBegin = new DateTime(Int32.Parse(txtBeginDate.Value.Split('-')[0]), Int32.Parse(txtBeginDate.Value.Split('-')[1]), Int32.Parse(txtBeginDate.Value.Split('-')[2]), 0, 0, 0); DateTime dtEnd = new DateTime(Int32.Parse(txtEndTime.Value.Split('-')[0]), Int32.Parse(txtEndTime.Value.Split('-')[1]), Int32.Parse(txtEndTime.Value.Split('-')[2]), 23, 59, 59); string strSQL = @"Select a.DateDay From (Select datename(yyyy, GetDateTime)+datename(mm, GetDateTime)+datename(dd, GetDateTime) as DateDay From Cash_Apply Where GetDateTime between '" + dtBegin + "' and '" + dtEnd + "') a Group By a.DateDay"; DataTable dt = new DataTable(); dt = pageControl.doSql(strSQL).Tables[0]; if (dt.Rows.Count > 0) { //当获取到的数据集不为空的时候,显示在GridView1中 this.DataList1.Visible = true; this.DataList1.DataSource = dt; //指定GridView1的数据是dv this.DataList1.DataBind(); //将上面指定的信息绑定到GridView1上 tag.Text = ""; } else { this.DataList1.Visible = false; tag.Text = "*没有符合条件的结果!"; } } catch { } }
/// <summary> /// 页面初始化加载 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { string time = this.Request.QueryString["time"].ToString(); ParseTime(time); string changeyear = string.Empty; if (!string.IsNullOrEmpty(year)) { changeyear += ChangeYear(year); } if (!string.IsNullOrEmpty(year) && !string.IsNullOrEmpty(toyear)) { changeyear = changeyear + "-" + ChangeYear(toyear); } this.lblYear.Text = changeyear; bindDataToGV(); this.lblCount.Text = pageControl.doSql("select count(1) from dbo.USER_Users").Tables[0].Rows[0][0].ToString(); if (this.GridView1.Rows.Count == 0) { Response.Write("没有符合条件的数据!"); } else { //导出Excel exportExcel(); } } }
/// <summary> /// 获取到当前数据集中总共有多少条记录 /// </summary> private void setRowCout() { try { DataTable DT = new DataTable(); Model.USER_Users user_model = (Model.USER_Users)Session["USER_Users"]; string sendid = ""; if (null != user_model) { sendid = user_model.ID; } else { sendid = "1"; } string sqlWhere = "SELECT * FROM vProject_UserList WHERE (DELFLAG = '0') and status='1'and ProjectID='" + Session["Work_ProjectId"].ToString() + "'"; DT = pageControl.doSql(sqlWhere).Tables[0]; if (DT.Rows.Count > 0) { dtrowsHidden.Value = DT.Rows.Count.ToString(); } else { dtrowsHidden.Value = "0"; } } catch { } }
private void GetddlProjectID() { try { DataTable dt = new DataTable(); //string strSQL = "Select distinct(ProjectID),ProjectName From vProject_UserList Where ProjectID=" + _projectid; string strSQL = "Select distinct(ID) as ProjectID,NAMES as ProjectName From Project_Projects Where ID=" + _projectid; dt = pageControl.doSql(strSQL).Tables[0]; if (dt.Rows.Count > 0) { this.ddlProjectID.DataSource = dt; this.ddlProjectID.DataTextField = "ProjectName"; this.ddlProjectID.DataValueField = "ProjectID"; this.ddlProjectID.DataBind(); Button_sumbit.Enabled = true; } else { Button_sumbit.Enabled = false; } } catch { Button_sumbit.Enabled = false; } }
/// <summary> /// 获取到当前数据集中总共有多少条记录 /// </summary> /// <param name="depart">部门</param> /// <param name="workstatus">工作状态</param> private void setRowCout(string depart, string workstatus) { try { DataTable DT = new DataTable(); string sql = "SELECT * FROM vUSER_Users WHERE 1=1"; if (null != depart && depart != "") { sql = sql + " and DepartMentID like '%" + depart + "%'"; } if (null != workstatus && workstatus != "") { sql = sql + " and WorkStats = '" + workstatus + "'"; } DT = pageControl.doSql(sql).Tables[0]; if (DT.Rows.Count > 0) { dtrowsHidden.Value = DT.Rows.Count.ToString(); } else { dtrowsHidden.Value = "0"; } } catch { } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { string id = Request["id"].ToString(); foritems = Request["ForItems"].ToString(); parentid = Request["PARENTID"].ToString(); limitschoose = Request["LimitsChooseID"].ToString(); // 默认NEWS if (String.IsNullOrEmpty(_foritems)) { _foritems = "NEWS"; } DataTable dt = new DataTable(); string sql = "SELECT UserID FROM News_LimitUser WHERE NewsID=" + id; dt = pageControl.doSql(sql).Tables[0]; Session["UserID"] = dt; mNews_News = new Dianda.Model.News_News(); mNews_News = bNews_News.GetModel(Int32.Parse(id)); this.txtNAME.Text = mNews_News.NAME; this.FCKeditor_neirong.Value = mNews_News.CONTENTS; GetddlPARENTID(); GetrblLimitsChoose(); BindDataList(); } }
/// <summary> /// 获取业务申请列表信息 /// </summary> public void ShowApplyList(string type, string projectid) { try { HiddenField_projectid.Value = projectid; DataTable DT = new DataTable(); string sqlWhere1 = "select * from vProject_Apply where DELFLAG=0 and ProjectID=" + projectid + " and AppType = '" + type + "' order by datetime desc"; DT = pageControl.doSql(sqlWhere1).Tables[0]; if (DT.Rows.Count > 0) { //当获取到的数据集不为空的时候,显示在GridView1中 GridView1.Visible = true; GridView1.DataSource = DT; //指定GridView1的数据是DT GridView1.DataBind(); //将上面指定的信息绑定到GridView1上 notice.Text = ""; tongji(DT); } else { GridView1.Visible = false; notice.Text = "*没有符合条件的结果!"; Label_tongji.Text = "暂无统计信息!"; } } catch { GridView1.Visible = false; notice.Text = "*进入业务申请列表发生错误!"; Label_tongji.Text = "暂无统计信息!"; } if (type == "orderSignet") { GridView1.HeaderRow.Cells[1].Text = "预订日期"; } if (DDL_type.SelectedValue.ToString().Equals("orderSignet")) { if (GridView1.Visible != false) { GridView1.HeaderRow.Cells[1].Text = "预订日期"; } } else { if (GridView1.Visible != false) { GridView1.HeaderRow.Cells[1].Text = "使用日期"; GridView1.Columns[4].Visible = false; } } }
/// <summary> /// 获取到当前数据集中总共有多少条记录 /// </summary> /// <param name="projectname">项目名称</param> /// <param name="leadername">项目负责人</param> /// <param name="depart">部门</param> /// <param name="starttime">开始时间</param> /// <param name="endtime">结束时间</param> private void setRowCout(string projectname, string leadername, string depart, string starttime, string endtime) { try { DataTable DT = new DataTable(); string sql = "SELECT * FROM vProject_Projects WHERE (Status=1 or Status=3 or Status=5) and DELFLAG = 0 "; //项目名称 if (null != projectname && !projectname.Equals("")) { sql = sql + " AND NAMES LIKE '%" + projectname + "%' "; } //项目负责人 if (null != leadername && !leadername.Equals("")) { sql = sql + " AND ( LeaderRealName LIKE '%" + leadername + "%' OR LeaderUserName LIKE '%" + leadername + "%')"; } //参与部门 if (null != depart && !depart.Equals("")) { sql = sql + " AND DepartmentNames LIKE '%" + depart + "%' "; } //开始时间 if (null != starttime && !starttime.Equals("")) { sql = sql + " AND StartTime >='" + Convert.ToDateTime(starttime) + "'"; } //结束时间 if (null != endtime && !endtime.Equals("")) { sql = sql + " AND EndTime <='" + Convert.ToDateTime(endtime) + "'"; } DT = pageControl.doSql(sql).Tables[0]; if (DT.Rows.Count > 0) { dtrowsHidden.Value = DT.Rows.Count.ToString(); } else { dtrowsHidden.Value = "0"; } } catch { } }
protected void ShowInitInfo(string ID) { try { string sql = " SELECT * FROM vCash_CardsDetail WHERE CardID='" + common.SafeString(ID) + "' order by id"; DataTable DT = new DataTable(); DT = pageControl.doSql(sql).Tables[0]; if (DT.Rows.Count > 0) { //资金卡名称 LB_Name.Text = DT.Rows[0]["CardName"].ToString(); //所属项目 LB_Project.Text = DT.Rows[0]["ProjectName"].ToString(); //持卡人 LB_Holder.Text = DT.Rows[0]["HolderRealName"].ToString(); //审批人 LB_Checker.Text = DT.Rows[0]["CheckRealName"].ToString(); //资金卡编号 LB_CardNum.Text = DT.Rows[0]["CardNum"].ToString(); //所属专项资金 LB_SpecialFundsName.Text = DT.Rows[0]["SpecialFundsName"].ToString(); //所属帐户 LB_AccountName.Text = DT.Rows[0]["AccountName"].ToString(); //所属预算报告 LB_SFOrderName.Text = "<a href='" + DT.Rows[0]["BudgetList"].ToString() + "' target='_blank'>" + DT.Rows[0]["SFOrderName"].ToString() + "</a>"; LB_Info.Text = " 可用金额调整情况:<br>" + DT.Rows[0]["TEMP0"].ToString(); DList_YSJE.DataSource = DT; DList_YSJE.DataBind(); DList_YSJE.RepeatColumns = DT.Rows.Count; DList_KYJE.DataSource = DT; DList_KYJE.DataBind(); DList_KYJE.RepeatColumns = DT.Rows.Count; DList_DQYE.DataSource = DT; DList_DQYE.DataBind(); DList_DQYE.RepeatColumns = DT.Rows.Count; } else { LB_MSG.Text = "暂无该资金卡的相关信息!"; } } catch { } }
/// <summary> /// /// </summary> /// <param name="groupname"></param> public void BindData() { try { string strSQL = "SELECT * FROM vUSER_Users WHERE " + SQLCondition(); DataTable dt = new DataTable(); dt = pageControl.doSql(strSQL).Tables[0]; if (dt.Rows.Count > 0) { //当获取到的数据集不为空的时候,显示在GridView1中 GridView1.Visible = true; GridView1.DataSource = dt; //指定GridView1的数据是dv GridView1.DataBind(); //将上面指定的信息绑定到GridView1上 notice.Text = ""; } else { GridView1.Visible = false; notice.Text = "*没有符合条件的结果!"; } } catch { } }
/// <summary> /// 给指定的KEY放置值 /// </summary> /// <param name="tableName"></param> /// <returns></returns> private object setValue(string tableNameKEY) { object coutw = new object(); try { Dianda.COMMON.staticApp.Remove((object)tableNameKEY);//先删除 //如果tableNameKEY中包含“|”则表示有查询条件限制 string tablename = tableNameKEY; string tiaojian = ""; if (tableNameKEY.Contains("|")) { string[] arrays = tableNameKEY.Split('|'); tablename = arrays[0].ToString(); tiaojian = arrays[1].ToString(); } string sql = "select * from " + tablename + " " + tiaojian; DataSet ds = dosqls.doSql(sql); coutw = (object)ds; Dianda.COMMON.staticApp.SetValue((object)tableNameKEY, coutw); } catch { } return(coutw); }
protected void btnReport_Click(object sender, EventArgs e) { DataTable DT = new DataTable(); DT = pageControl.doSql("select * from vBudget_Department_Statistical").Tables[0]; DataTable dt = DT; this.GridView2.DataSource = dt; this.GridView2.DataBind(); this.GridView2.Visible = true; Response.Clear(); Response.AddHeader("content-disposition", "attachment;filename=" + HttpUtility.UrlEncode("部门经费统计" + "_" + DateTime.Now.ToString("yyyyMMddhhmmss") + ".xls", Encoding.UTF8).ToString()); Response.Charset = "gb2312"; Response.ContentType = "application/ms-excel"; this.EnableViewState = false; System.IO.StringWriter stringWrite = new System.IO.StringWriter(); System.Web.UI.HtmlTextWriter htmlWrite = new HtmlTextWriter(stringWrite); GridView2.RenderControl(htmlWrite); string strExcel = stringWrite.ToString(); //去除超链接 strExcel = Regex.Replace(strExcel, "<a (.*?)>", "", RegexOptions.Compiled); strExcel = Regex.Replace(strExcel, "</a>", ""); Response.Write(strExcel); Response.End(); }
private void BindData() { DataTable dt = new DataTable(); string sql = "Select * From vCash_Apply Where ID=" + _id; dt = pageControl.doSql(sql).Tables[0]; if (dt.Rows.Count > 0) { this.lblApplierRealName.Text = dt.Rows[0]["ApplierRealName"].ToString(); this.lblApplyCount.Text = dt.Rows[0]["ApplyCount"].ToString(); this.lblProjectName.Text = dt.Rows[0]["ProjectName"].ToString(); this.lblGetDateTime.Text = dt.Rows[0]["GetDateTime"].ToString(); this.lblCardName.Text = dt.Rows[0]["CardName"].ToString(); this.lblUseFor.Text = dt.Rows[0]["UseFor"].ToString(); this.lblApplierTel.Text = dt.Rows[0]["ApplierTel"].ToString(); this.lblDATETIME.Text = dt.Rows[0]["DATETIME"].ToString(); string Statas = dt.Rows[0]["Statas"].ToString(); if (Statas == "0") { this.lblStatas.Text = "待审核"; } else if (Statas == "1") { this.lblStatas.Text = "审核通过"; } else if (Statas == "2") { this.lblStatas.Text = "<font color='red'>审核不通过</font>"; } else if (Statas == "3") { this.lblStatas.Text = "审核完成"; } } }
/// <summary> /// 显示印章种类 /// </summary> protected void ShowDDLInfo() { try { DataTable dt = new DataTable(); string sql = "SELECT ID, SignetName FROM Project_SignetList WHERE DELFLAG = 0 "; dt = pageControl.doSql(sql).Tables[0]; //ListItem li = new ListItem("-请选择-",""); //DDL_Signet.Items.Add(li); if (dt.Rows.Count > 0) { for (int i = 0; i < dt.Rows.Count; i++) { ListItem li1 = new ListItem(dt.Rows[i]["SignetName"].ToString(), dt.Rows[i]["ID"].ToString()); DDL_Signet.Items.Add(li1); } } } catch { } }
public void BindData() { DataTable dt = new DataTable(); string strSQL = "Select * From vCash_Cards Where id=" + _id; dt = pageControl.doSql(strSQL).Tables[0]; if (dt.Rows.Count > 0) { this.lblCardName.Text = dt.Rows[0]["CardName"].ToString(); this.lblCardNum.Text = dt.Rows[0]["CardNum"].ToString(); this.lblCardholderRealName.Text = dt.Rows[0]["CardholderRealName"].ToString(); this.lblDepartmentName.Text = dt.Rows[0]["DepartmentName"].ToString(); this.lblProjectName.Text = dt.Rows[0]["ProjectName"].ToString(); this.lblLimitNums.Text = dt.Rows[0]["LimitNums"].ToString(); this.lblApproverRealName.Text = dt.Rows[0]["ApproverRealName"].ToString(); this.lblStatas.Text = dt.Rows[0]["Statas"].ToString(); //这里是不是多复制了? this.lblCardName.Text = dt.Rows[0]["CardName"].ToString(); this.lblCardName.Text = dt.Rows[0]["CardName"].ToString(); this.lblCardName.Text = dt.Rows[0]["CardName"].ToString(); this.lblCardName.Text = dt.Rows[0]["CardName"].ToString(); this.lblCardName.Text = dt.Rows[0]["CardName"].ToString(); this.lblCardName.Text = dt.Rows[0]["CardName"].ToString(); } }
/// <summary> /// 分页显示 /// </summary> /// <param name="pageindex">页码</param> /// <param name="keys">搜索条件</param> protected void ShowKcList() { try { if (Session["USERID_SYSUSER"].ToString().Length > 0) { DataTable DT = new DataTable(); string sqlWhere1 = "select top 6 * from DOC_transport_To where TOUSER='******' and delflag='0' order by ISREAD ASC,DATETIME DESC"; DT = PageControl.doSql(sqlWhere1).Tables[0]; if (DT.Rows.Count > 0) { //当获取到的数据集不为空的时候,显示在GridView1中 GridView1.Visible = true; GridView1.DataSource = DT; //指定GridView1的数据是DT GridView1.DataBind(); //将上面指定的信息绑定到GridView1上 notice.Text = ""; } else { GridView1.Visible = false; notice.Text = "*您暂时没有文件可以访问!"; } } } catch { } }
/// <summary> /// 获取资金卡的列表 /// </summary> private void GetddlCardName() { try { string Dtime = DateTime.Now.ToString("yyyy-MM-dd"); DataTable dt = new DataTable(); //string strSQL = "Select CardName+'['+CardNum+','+cast (LimitNums as varchar)+']' as CardName,ID From Cash_Cards Where Statas=1 and ProjectID=" + this.ddlProjectID.SelectedValue + " order by ID"; string strSQL = "select CardName+'[ 编号: '+CardNum+' , 金额:'+cast (LimitNums as varchar)+']' + case when datediff(dd,cast('" + Dtime + " 00:00:00' as datetime),isnull(endtime,''))<0 then '(已过期)' else '' end as CardName,ID from Cash_Cards where statas=1 and ProjectID= " + this.ddlProjectID.SelectedValue + " order by id"; dt = pageControl.doSql(strSQL).Tables[0]; if (dt.Rows.Count > 0) { this.ddlCardName.DataSource = dt; this.ddlCardName.DataTextField = "CardName"; this.ddlCardName.DataValueField = "ID"; this.ddlCardName.DataBind(); } else { this.ddlCardName.Items.Clear(); //this.ddlCardName.Items.Add(new ListItem("无资金卡", "")); } } catch { } }
/// <summary> /// 返回指定ID用户的在开始时间和结束时间范围内的项目任务 /// </summary> /// <param name="userId"></param> /// <param name="startDay"></param> /// <param name="endData"></param> /// <returns></returns> private string getProject_Plan(string userId, DateTime startDay) { string couw = ""; try { userModel = usersBll.GetModel(userId); if (userModel != null) { string sql = "select * from vProject_Task where Pro_DELFLAG='0' and Pro_Status=1 and '" + startDay.ToString("yyyy-MM-dd") + "' BETWEEN CAST(CONVERT(varchar(10), StartTime, 120) + ' 00:00:00' AS datetime) AND CAST(CONVERT(varchar(10), endTime, 120) + ' 23:59:59' AS datetime) and delflag = '0' and Status <> 2 and userInfo Like '%" + userModel.REALNAME.ToString() + "(" + userModel.USERNAME.ToString() + ")" + "%' order by StartTime asc"; DataTable dt = dosql.doSql(sql).Tables[0]; if (dt != null && dt.Rows.Count > 0) { couw = "<task>"; for (int i = 0; i < dt.Rows.Count; i++) { couw = couw + "<info startTime=\"" + DateTime.Parse(dt.Rows[i]["StartTime"].ToString()).ToString("yyyy-MM-dd HH:mm:ss") + "\" endTime=\"" + DateTime.Parse(dt.Rows[i]["endTime"].ToString()).ToString("yyyy-MM-dd HH:mm:ss") + "\" url=\"/Admin/personalProjectManage/OAtask/manage.aspx?ID=" + dt.Rows[i]["ProjectID"].ToString() + "\" status=\"" + dt.Rows[i]["Status"].ToString() + "\">" + dt.Rows[i]["NAMES"].ToString() + "</info>"; } couw = couw + "</task>"; } } } catch { } return(couw); }
private void BindData(string id) { DataTable dt = new DataTable(); string strSQL = "Select * From vCash_Message Where ID=" + common.SafeString(id); dt = pageControl.doSql(strSQL).Tables[0]; if (dt.Rows.Count > 0) { lblCardName.Text = dt.Rows[0]["CardName"].ToString(); lblCardholderRealName.Text = dt.Rows[0]["CardholderRealName"].ToString(); lblDepartmentName.Text = dt.Rows[0]["DepartmentName"].ToString(); lblProjectName.Text = dt.Rows[0]["ProjectName"].ToString(); lblLimitNums.Text = dt.Rows[0]["LimitNums"].ToString(); lblApproverRealName.Text = dt.Rows[0]["ApproverRealName"].ToString(); lblDATETIME.Text = dt.Rows[0]["DATETIME"].ToString(); if (dt.Rows[0]["IsRead"].ToString() == "0") { lblIsRead.Text = "未读"; } else { lblIsRead.Text = "已读"; } lblReadTime.Text = dt.Rows[0]["ReadTime"].ToString(); lblDoUserID.Text = dt.Rows[0]["DoUserID"].ToString(); txtDoNotes.Text = dt.Rows[0]["DoNotes"].ToString(); } }
/// <summary> /// 获取到当前数据集中总共有多少条记录 /// </summary> private void setRowCout(string status) { try { Model.USER_Users user_model = (Model.USER_Users)Session["USER_Users"]; DataTable DT = new DataTable(); string sql = " SELECT * FROM vProject_Budget WHERE (BudgetList <> '') AND (BudgetList IS NOT NULL) AND (DELFLAG = 0) AND (Status = 1) "; string role = Request["role"].ToString(); //如果是领导进入的预算管理,那么他只能看属于自己审批的项目的预算情况,如果是秘书或是财务的话,那么他们则能看到所有审批通过的预算管理情况。 if (role.Equals("manager")) { sql = sql + " AND (DoUserID = '" + user_model.ID + "') "; } sql = sql + " AND (TEMP1 = '" + status + "') "; DT = pageControl.doSql(sql).Tables[0]; if (DT.Rows.Count > 0) { dtrowsHidden.Value = DT.Rows.Count.ToString(); } else { dtrowsHidden.Value = "0"; } } catch { } }
/// <summary> /// 显示项目详情 /// </summary> /// <param name="id"></param> protected void ShowApplyInfo(string id) { try { DataTable DT = new DataTable(); string sql = "SELECT * FROM vProject_Apply_OrderSignet WHERE ID = " + id; DT = pageControl.doSql(sql).Tables[0]; if (DT.Rows.Count > 0) { //项目名称 Label_ProjectName.Text = DT.Rows[0]["ProjectNames"].ToString(); Session["ProjectNames"] = DT.Rows[0]["ProjectNames"].ToString(); //提交申请时间 Label_DATETIME.Text = Convert.ToDateTime(DT.Rows[0]["DATETIME"].ToString()).ToString("yyyy-MM-dd hh:mm"); //用印类型 Label_SignetName.Text = DT.Rows[0]["SignetName"].ToString(); Session["SignetName"] = DT.Rows[0]["SignetName"].ToString(); //预订申请人 Label_SendUserID.Text = DT.Rows[0]["SendRealName"].ToString() + "[" + DT.Rows[0]["SendUserName"].ToString() + "]"; Session["Signet_ApplyUserName"] = "******" + DT.Rows[0]["SendRealName"].ToString() + ")"; //申请部门 Label_DepartmentID.Text = DT.Rows[0]["DepartmentName"].ToString(); //项目概要 Label_Overviews.Text = DT.Rows[0]["Overviews"].ToString(); //用印份数 Label_SignetNums.Text = DT.Rows[0]["Nums"].ToString(); Session["Signet_Nums"] = DT.Rows[0]["Nums"].ToString(); //审核意见 string DoNote = DT.Rows[0]["DoNote"].ToString(); if (null != DoNote && !DoNote.Equals("")) { TB_DoNote.Text = DoNote; } else { TB_DoNote.Text = ""; } //审批状态 string status = DT.Rows[0]["Status"].ToString(); if (null != status && !status.Equals("0")) { RadioButtonList_Check.SelectedValue = status; } else { RadioButtonList_Check.SelectedValue = "1"; } } } catch { } }
/// <summary> /// 获取到当前数据集中总共有多少条记录 /// </summary> private void setRowCout(string status) { try { Model.USER_Users user_model = (Model.USER_Users)Session["USER_Users"]; DataTable DT = new DataTable(); string sql = "SELECT * FROM vProject_Projects WHERE DELFLAG = 0 "; if (null != status && !status.Equals("")) { if (status.Equals("9")) { sql = sql + " AND (ID IN (SELECT ProjectID FROM Project_ShenheList WHERE (UserID = '" + user_model.ID + "') AND (Isturn = 2) AND (Status = 0))) "; } else//如果查看的是待审或是不通的项目,只有在新建项目时所选择的审核人才能查看这些项目 { sql = sql + " AND Status=" + status; //只有在新建项目时所选择的审核人才能查看这些项目 sql = sql + " AND (DoUserID = '" + user_model.ID + "')"; } } else { sql = sql + " AND (Status=0 or Status=2)"; //只有在新建项目时所选择的审核人才能查看这些项目 sql = sql + " AND (DoUserID = '" + user_model.ID + "')"; } DT = pageControl.doSql(sql).Tables[0]; if (DT.Rows.Count > 0) { dtrowsHidden.Value = DT.Rows.Count.ToString(); } else { dtrowsHidden.Value = "0"; } } catch { } }
/// <summary> /// 获取到当前数据集中总共有多少条记录 /// </summary> private void setRowCout() { try { string strSQL = "SELECT ID FROM vCash_Apply2 WHERE " + SQLCondition(); DataTable dt = new DataTable(); dt = pageControl.doSql(strSQL).Tables[0]; if (dt.Rows.Count > 0) { dtrowsHidden.Value = dt.Rows.Count.ToString(); } else { dtrowsHidden.Value = "0"; } } catch { } }
/// <summary> /// 绑定年份 /// </summary> private void bindDataToddlYear() { DataTable dt = pageControl.doSql("select distinct CONVERT(varchar(4) , [DATETIME], 112 ) as [year] from FaceShowMessage order by [year]").Tables[0]; this.ddlYear.DataSource = dt; this.ddlYear.DataTextField = "year"; this.ddlYear.DataValueField = "year"; this.ddlYear.DataBind(); this.ddltoYear.DataSource = dt; this.ddltoYear.DataTextField = "year"; this.ddltoYear.DataValueField = "year"; this.ddltoYear.DataBind(); }
private void GetddlProjectID() { DataTable dt = new DataTable(); string sql = "Select NAMES,ID From Project_Projects Where DELFLAG=0 and [Status]=1";//项目的状态 1表示正常运行中,0表示待审核,2表示审核不通过,3暂停,4表示草稿箱中,5表示完成 dt = pageControl.doSql(sql).Tables[0]; if (dt.Rows.Count > 0) { this.ddlProjectID.DataSource = dt; this.ddlProjectID.DataTextField = "NAMES"; this.ddlProjectID.DataValueField = "ID"; this.ddlProjectID.DataBind(); } }
protected void Calendar1_SelectionChanged(object sender, EventArgs e) { //获得传进来的用户ID string strId = Session["User_users"].ToString(); DataTable dt = new DataTable(); //获得选中的时间 string strdateTime = Calendar1.SelectedDate.ToString(); //通过ID获得用户在这个时间内的任务 string strsql = "select top 5 * from Personal_plan where '" + strdateTime + "' between StartTime and endTime and delflag ='0' and Status <> 2 and UserId = '" + strId + "' order by StartTime asc "; dt = pageControl.doSql(strsql).Tables[0]; GridView_PresonProject.DataSource = dt; GridView_PresonProject.DataBind(); }