DraftOut/streamSuperviseT.aspx.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

using System; 
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
using ZHENGYI;
using System.Data .SqlClient ;
namespace OI.DraftOut
{
	/// <summary>
	/// streamSuperviseT 的摘要说明。
	/// </summary>
	public partial class streamSuperviseT : OI.PageBase
	{
		DataSet ds=new DataSet ();
		OI.cs.readStream Rs=new OI.cs.readStream ();
		
		protected OI.DatabaseOper.DatabaseConnect Dbc=new OI.DatabaseOper.DatabaseConnect ();
		protected DataGridNavigation  divepage ;
		protected void Page_Load(object sender, System.EventArgs e)
		{
			// 在此处放置用户代码以初始化页面
			if (Session["userid"]==null)
			{
				Response.Write ("<script>alert('超时,请重新登录');top.location.href='../userpass.aspx';</script>");
				return ;
			}
			SetDivePage();
			if(!Page.IsPostBack )
			{
				ViewState["documentid"]=Request.Params["id"].ToString ();

				Lbl_Title.Text =Dbc.GetObjectBySql("select title from document where documentid="+ViewState["documentid"]).ToString (); 
			 dataBind();
			}

		}
		private void CreateDataSource()
		{
			string sql="(select d.documentid, dt.stepid, '己处理'as 'istransact',dt.userid,au.username, d.title,dt.idea,dt.transtype,dt.transactdate,dt.transactlimitdate  ";
                   sql +=" from document d,documenttransact dt  ,accounts_users au";
                   sql +=" where d.documentid=dt.documentid and d.documentid="+ViewState["documentid"] ;
//                   sql +=" and dt.backstate=(select max(backstate) from documentTransact where documentid=d.documentid) ";
                   sql +=" and dt.userid=au.userid) union  ";
				   sql +="  (select d.documentid,ts.stepid,  '<font color=red>未处理</red>'as 'istransact',ts.userid ,au.username ,'' ,'' ,'','9999-12-12',null  ";
			       sql +=" from document d, transactusers ts,accounts_users au";
			       sql +=" where d.documentid=ts.documentid ";
			       sql +=" and d.documentid="+ViewState["documentid"] ;
			       sql +=" and d.CurrentStepID=ts.stepID ";
			       sql +=" and ts.userid=au.userid )";
//			       sql +=" and ts.userid not in (select  userid from documenttransact where documentid=d.documentid and stepid=ts.stepid and backstate=(select max(backstate) from documentTransact where documentid=d.documentid )) )" ;
		           sql +=" union (select d.documentid, 3, '末处理'as 'istransact',au.userid,au.username, ";
                   sql +=" d.title,'','回退起草'as transtype ,'9999-12-12',null ";
                   sql +=" from document d,accounts_users au where  d.UserID=au.userid and d.documentid="+ ViewState["documentid"] +" and d.CurrentStepID=0) ";