📄 desktop.aspx.cs
字号:
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 System.Data .SqlClient ;
namespace OI
{
/// <summary>
/// desktop 的摘要说明。
/// </summary>
public class desktopW : OI.PageBase
{
protected OI.UserControls .DisaplyMessage todayArrange;
protected System.Web.UI.WebControls.Table TableWilldo;
protected OI.UserControls .DisaplyMessage tomorrowArrange;
private OI.DatabaseOper .DatabaseConnect dc;
private void Page_Load(object sender, System.EventArgs e)
{
// 在此处放置用户代码以初始化页面
if (Session["userid"]==null)
{
Response.Write ("<script>alert('超时,请重新登录');top.location.href='../userpass.aspx';</script>");
Response.End ();
}
if(!this.IsPostBack )
{
// this.BindData ();
// this.BindTableWill ();
CreateDataSource();
}
}
private void CreateDataSource()
{
OI.cs.Message message=new OI.cs.Message ();
int userid =int.Parse (Session["userid"].ToString ());
DataTable dt=message.deskGetAllNoTransact (userid);
foreach (DataRow dr in dt.Rows )
{
TableRow tr=new TableRow ();
TableCell ctitle=new TableCell ();
string Stitle=dr["Title"].ToString ();
string title=Stitle;
if (Stitle.Length >20)
{
title=title.Substring (0,20)+"...";
}
ctitle.Text ="<a href=\""+dr["Documentpath"].ToString ()+"\" title=\""+Stitle+"\" >"+title+"</a>";
TableCell cmodename=new TableCell ();
cmodename.Text ="["+dr["modename"].ToString ();
TableCell cSendUsername=new TableCell ();
cSendUsername.Text ="<font color=\"#FF9900\">|</font> "+ dr["username"].ToString ();
TableCell cdepartment=new TableCell ();
cdepartment.Text ="<font color=\"#FF9900\">|</font> "+ dr["departmentname"].ToString ()+" ]";
tr.Cells .Add (ctitle);
tr.Cells .Add (cmodename);
tr.Cells .Add (cSendUsername);
tr.Cells .Add (cdepartment);
TableWilldo.Rows .Add (tr);
}
}
private void BindData()
{
//newMessage.Url ="../Messagemanage/View_MessageManage.aspx?id=";
string strSql="select planid,title from SelfPlan where userid='"+Session["userid"].ToString ()+"' and BeginDate<='"+DateTime.Today +"'"+
" AND EndDate>'"+DateTime.Today +"'";
todayArrange.Sql =strSql;
todayArrange.Title ="title";
todayArrange.KeyID ="planid";
todayArrange.Url="../IndividualArrange/dispOne.aspx?id=";
strSql="select planid,title from SelfPlan where userid='"+Session["userid"].ToString ()+"' and BeginDate='"+DateTime.Today.AddDays (1) +"'";
tomorrowArrange.Sql =strSql;
tomorrowArrange.Title ="title";
tomorrowArrange.KeyID ="planid";
tomorrowArrange.Url="../IndividualArrange/dispOne.aspx?id=";
}
#region Web 窗体设计器生成的代码
override protected void OnInit(EventArgs e)
{
//
// CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。
//
InitializeComponent();
base.OnInit(e);
}
/// <summary>
/// 设计器支持所需的方法 - 不要使用代码编辑器修改
/// 此方法的内容。
/// </summary>
private void InitializeComponent()
{
this.Load += new System.EventHandler(this.Page_Load);
}
#endregion
private void BindTableWill()
{
//remarked by lb at 2004.2.2
if(Session["userid"]==null)
{
Response.Write ("登录超时，请重新登录");
return;
}
// 1.未校核：http://pc4/OI/Document/dispTransact.aspx?documentid=197
// 2.未签发：http://pc4/OI/document/dispTransact.aspx?documentid=208
// 3.待核发公文：http://pc4/OI/SendMessage/SendFileList.aspx
// 4.回退公文（起草）：http://pc4/OI/draftout/draftstart.aspx?documentid=207
// 5.收文办理：http://pc4/OI/ReFileOperate/FileReseive.aspx
//
// 1.公文起草
// 2.公文校核
// 3.公文签发
// 4.发文办理
// 5.收文办理
dc=new OI.DatabaseOper.DatabaseConnect ();
OI.cs.readStream rs =new OI.cs.readStream ();
string strReWrite="../draftout/draftstart.aspx?documentid=";//回退公文
string strCollate="../Document/dispTransact.aspx?documentid=";//公文校核
string strIdiograph="../document/dispTransact.aspx?documentid=";//公文签发
string strSend="../SendMessage/SendFileList.aspx";//发文办理
string strRecorder="../ReFileOperate/FileReseive.aspx";//收文办理
string strRecordFile="../PersonSend/RecorderFile.aspx";//个人资料交换，接收资料 04-2-11
string strReadDo="../ReceivDocument/transactNo.aspx";//接收资料 未阅办 04-2-11
string strReceive ="../ReceivDocument/receiveDocumentN0.aspx" ;//末收文
string strLinkHead="<a href=";
string strLinkTail="</a>";
//回退公文
string sql="select title,documentid from document where currentstepid=0 and completeSign=0 and userid="+Session["userid"].ToString ();
ArrayList al=dc.getData (sql);
TableRow tabelR;
TableCell tableC;
string tempStr="";
for(int i=0;i<al.Count ;i++)
{
if(i%2==0)
{
tempStr=al[i].ToString ();
}
else
{
tabelR=new TableRow ();
tableC=new TableCell ();
if (tempStr.Length >20)
{
tableC.Controls.Add (new LiteralControl("·"+strLinkHead+strReWrite+al[i].ToString ()+" title=\""+tempStr+"\" >"+tempStr.Substring (0,20)+"..."+strLinkTail));
}
else
{
tableC.Controls.Add (new LiteralControl("·"+strLinkHead+strReWrite+al[i].ToString ()+" title=\""+tempStr+"\">"+tempStr+strLinkTail));
}
tabelR.Cells .Add (tableC);
tableC=new TableCell ();
tableC.Controls.Add (new LiteralControl("<font color=\"#990000\">回退公文</font>"));
tabelR.Cells .Add (tableC);
TableWilldo.Rows .Add (tabelR);
}
}
sql="SELECT dbo.datumPersonSend.Title "+ //接收资料 04-2-11
"FROM dbo.datumPersonAccept,dbo.datumPersonSend "+
"WHERE dbo.datumPersonAccept.DatumID = dbo.datumPersonSend.DatumID and "+
"dbo.datumPersonAccept.isAccept=0 and "+
"dbo.datumPersonAccept.UserID='"+Session["userid"].ToString ()+"'";
ArrayList alNew=dc.getData (sql);
for(int x=0;x<alNew.Count ;x++)
{
tabelR=new TableRow ();
tableC=new TableCell ();
if (alNew[x].ToString().Length >20 )
{
tableC.Controls.Add (new LiteralControl("·"+strLinkHead+strRecordFile+" title=\""+alNew[x].ToString ()+"\" >"+alNew[x].ToString ().Substring(0,20)+"..."+strLinkTail));
}
else
{
tableC.Controls.Add (new LiteralControl("·"+strLinkHead+strRecordFile+" title=\""+alNew[x].ToString ()+"\" >"+alNew[x].ToString ()+strLinkTail));
}
tabelR.Cells .Add (tableC);
tableC=new TableCell ();
tableC.Controls.Add (new LiteralControl("<font color=\"#990000\">接收资料</font>"));
tabelR.Cells .Add (tableC);
TableWilldo.Rows .Add (tabelR);
}
//收文办理 未阅办 04-2-20
sql =" select rd.documentTitle ";
sql +="from documentMitTransaction dmt, ReceiveDocument rd ";
sql +=" where dmt.Istransact=0 and dmt.RedocumentID =rd.RedocumentID and dmt.userid ="+Session["userid"].ToString ();
alNew.Clear ();
alNew=dc.getData (sql);
for(int x=0;x<alNew.Count ;x++)
{
tabelR=new TableRow ();
tableC=new TableCell ();
if (alNew[x].ToString().Length >20 )
{
tableC.Controls.Add (new LiteralControl("·"+strLinkHead+strReadDo+" title=\""+alNew[x].ToString ()+"\" >"+alNew[x].ToString ().Substring(0,20)+"..." +strLinkTail));
}
else
{
tableC.Controls.Add (new LiteralControl("·"+strLinkHead+strReadDo+" title=\""+alNew[x].ToString ()+"\" >"+alNew[x].ToString () +strLinkTail));
}
tabelR.Cells .Add (tableC);
tableC=new TableCell ();
tableC.Controls.Add (new LiteralControl("<font color=\"#990000\">未阅办</font>"));
tabelR.Cells .Add (tableC);
TableWilldo.Rows .Add (tabelR);
}
//末收文
//strReceive ="../ReceivDocument/receiveDocumentN0.aspx" ;
string username= Session["UserName"].ToString ();
if (username.IndexOf ("收文人员") >0)
{
string str="select distinct dsr.documenttitle ";
str +=" from receiveWait rw,documentSendR dsr ,Departments d ,ExigenceDegree e ";
str +=" where rw.RegisterID=dsr.RegisterID and dsr.departmentid=d.departmentid ";
str +=" and dsr.ExigenceDegreeID=e.ExigenceDegreeID" ;
str +=" and (rw.ReseverDepartmentZ= ";
str +=" (select d2.departmentname from departments d2 ,accounts_users au where au.departmentid=d2.departmentid and au.userid=" + Session["userid"] + " ) ";
str +=" or rw.ReseverDepartmentc = ";
str +=" (select d2.departmentname from departments d2 ,accounts_users au where au.departmentid=d2.departmentid and au.userid=" + Session["userid"] + " ) ";
str +=" )" ;
str +=" and not exists (select rdt.waitid from receivedocument rdt where rdt.waitid=rw.waitid ) ";
DataTable td=dc.getBinding (str,"t").Tables[0];
for (int x=0 ;x<td.Rows .Count ;x++)
{
tabelR=new TableRow ();
tableC=new TableCell ();
if (td.Rows [x]["documenttitle"].ToString().Length >20)
{
tableC.Controls.Add (new LiteralControl("·"+strLinkHead+strReceive+" title=\""+td.Rows [x]["documenttitle"].ToString()+"\">"+td.Rows [x]["documenttitle"].ToString ().Substring (0,20)+"..."+strLinkTail));
}
else
{
tableC.Controls.Add (new LiteralControl("·"+strLinkHead+strReceive+" title=\""+td.Rows [x]["documenttitle"].ToString()+"\">"+td.Rows [x]["documenttitle"].ToString ()+strLinkTail));
}
tabelR.Cells .Add (tableC);
tableC=new TableCell ();
tableC.Controls.Add (new LiteralControl("<font color=\"#990000\">未收文</font>"));
tabelR.Cells .Add (tableC);
TableWilldo.Rows .Add (tabelR);
}
}
//
sql="select * from ViewDocumentno where CompleteSign=0 and currentstepid != 2 ";
DataSet ds=dc.getBinding(sql,"t");
foreach (DataRow dr in ds.Tables[0].Rows )
{
rs.doucmentID =int.Parse (dr["documentid"].ToString ());
//如果当前用户没在当前节点中,则应当删除.
// if (!rs.IsUserInCurrrentNode (Session["userid"].ToString (),dr["CurrentStepID"].ToString ()))
// {
// dr.Delete ();
// }
if (dc.GetValueBySql ("select count(*) from TransactUsers where documentid="+dr["documentid"] +" and stepID="+dr["CurrentStepID"].ToString () +" and userid="+Session["userid"].ToString () ).ToString ()=="0")
{
dr.Delete ();
}
else
{ //用户存在当前节点中。
// sql="select count(*) from DocumentTransact where documentid="+dr["documentid"].ToString () +" and " ;
// sql += " StepID=" + dr["CurrentStepID"].ToString () + " and userid="+Session["userid"].ToString ();
sql="select count(*) from DocumentTransact where documentid="+dr["documentid"].ToString () +" and " ;
sql += " StepID=" + dr["CurrentStepID"].ToString () + " and userid="+Session["userid"].ToString ();
sql +=" and BackState=(select max(BackState) from DocumentTransact where documentid= "+dr["documentid"].ToString () +")";
if (int.Parse (dc.GetValueBySql(sql)) >0) //如果当前用户,当前节点在处理表中存在,那么删除.
{
dr.Delete ();
}
else
{
tabelR=new TableRow ();
tableC=new TableCell ();
string title=dr["title"].ToString ();
if (title.Length >20)
{
title=title.Substring (0,20)+"...";
}
string URL="";
string CurrentOprateType=rs.GetCurrentOprateTypeByNodeID (dr["CurrentStepID"].ToString ());
string strType="";
if(CurrentOprateType=="公文校核")
{
URL="·"+strLinkHead+strCollate+dr["documentid"].ToString ()+" title=\""+dr["title"].ToString ()+"\">"+title+strLinkTail;
strType="<font color=\"#990000\">公文校核</font>";
}
else if(CurrentOprateType=="公文签发")
{
//URL="·"+strLinkHead+strIdiograph+dr["documentid"].ToString ()+">"+dr["title"].ToString ()+strLinkTail;
URL="·"+strLinkHead+strIdiograph+dr["documentid"].ToString ()+" title=\""+dr["title"].ToString ()+"\">"+title+strLinkTail;
strType="<font color=\"#990000\">公文签发</font>";
}
else if(CurrentOprateType=="发文办理")
{
strType="<font color=\"#990000\">发文办理</font>";
// URL="·"+strLinkHead+strSend+">"+dr["title"].ToString ()+strLinkTail;
URL="·"+strLinkHead+strSend+" title=\""+dr["title"].ToString ()+"\">"+title+strLinkTail;
}
else if(CurrentOprateType=="收文办理")
{
strType="<font color=\"#990000\">收文办理</font>";
//URL="·"+strLinkHead+strRecorder+">"+dr["title"].ToString ()+strLinkTail;
URL="·"+strLinkHead+strRecorder+ " title=\""+dr["title"].ToString ()+"\">"+title+strLinkTail;
}
else
continue;
tableC.Controls .Add (new LiteralControl (URL));
tabelR.Cells .Add (tableC);
tableC=new TableCell ();
tableC.Controls .Add (new LiteralControl (strType));
tabelR.Cells .Add (tableC);
TableWilldo.Rows .Add (tabelR);
//dr.Delete ();
}
}
}
// 处理人员回传给收文人员列表
ReceiveMan();
//ds.Tables [0].AcceptChanges ();
}
private void ReceiveMan()
{
string sql="select r.documenttitle from Receivedocument r ,documentMitTransaction dt" ;
sql +=" where r.redocumentid=r.redocumentid and r.IsComplete=0 and dt.istransact =1 and r.userid="+Session["userid"].ToString ();
sql +=" and dt.transactid= ";
sql +=" (select top 1 transactid from documentMitTransaction where redocumentid=r.redocumentid order by senddate desc ) ";
ArrayList al=dc.getData (sql);
TableRow tabelR;
TableCell tableC;
string tempStr="";
string receiveManLink="<a href='../receivdocument/transmited.aspx' ";
for(int i=0;i<al.Count ;i++)
{
tempStr=al[i].ToString ();
tabelR=new TableRow ();
tableC=new TableCell ();
if (tempStr.Length >20)
{
tableC.Controls.Add (new LiteralControl("·"+receiveManLink+al[i].ToString ()+" title=\""+tempStr+"\" >"+tempStr.Substring (0,20)+"...</a>"));
}
else
{
tableC.Controls.Add (new LiteralControl("·"+receiveManLink+al[i].ToString ()+" title=\""+tempStr+"\">"+tempStr+"</a>"));
}
tabelR.Cells .Add (tableC);
tableC=new TableCell ();
tableC.Controls.Add (new LiteralControl("<font color=\"#990000\">正在传阅</font>"));
tabelR.Cells .Add (tableC);
TableWilldo.Rows .Add (tabelR);
}
}
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -