📄 selectpersonst.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 ;
using System.Text .RegularExpressions ;
namespace OI.ReceivDocument
{
/// <summary>
/// selectPersonsT 的摘要说明。
/// </summary>
public class selectPersonsT : OI.PageBase
{
protected System.Web.UI.WebControls.ImageButton imgbtnisend;
protected System.Web.UI.WebControls.ImageButton imgbtncy;
protected System.Web.UI.WebControls.ImageButton ldps;
protected System.Web.UI.WebControls.Label SendDepartment;
protected System.Web.UI.WebControls.Label ReceiveFileNumber;
protected System.Web.UI.WebControls.Label ExigenceDegreeID;
protected System.Web.UI.WebControls.Label SecretGreadID;
protected System.Web.UI.WebControls.Label ReceiveDate;
protected System.Web.UI.WebControls.Label DocumentTitle;
protected System.Web.UI.WebControls.Label Ldyj;
protected System.Web.UI.WebControls.Label Label5;
protected System.Web.UI.WebControls.Label Receivedeclare;
protected System.Web.UI.WebControls.Panel Panel1;
protected OI.DatabaseOper .DatabaseConnect Dbc=new OI.DatabaseOper.DatabaseConnect ();
private void Page_Load(object sender, System.EventArgs e)
{
// 在此处放置用户代码以初始化页面
imgbtnisend.Attributes["onclick"] ="return confirm('你确定将此文档办结?');";
if (Session["userid"]==null)
{
Response.Write ("<script>alert('超时,请重新登录');top.location.href='../userpass.aspx';</script>");
return ;
}
if (!Page.IsPostBack )
{
try
{
ViewState["ReDocumentID"]=int .Parse (Request.Params ["id"].ToString ()).ToString ();
}
catch
{
return ;
}
}
//transdetail.ReDocumentID =int.Parse (ViewState["ReDocumentID"].ToString ());
Display();
}
#region Web 窗体设计器生成的代码
override protected void OnInit(EventArgs e)
{
//
// CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。
//
InitializeComponent();
base.OnInit(e);
}
/// <summary>
/// 设计器支持所需的方法 - 不要使用代码编辑器修改
/// 此方法的内容。
/// </summary>
private void InitializeComponent()
{
this.ldps.Click += new System.Web.UI.ImageClickEventHandler(this.ldps_Click);
this.imgbtncy.Click += new System.Web.UI.ImageClickEventHandler(this.imgbtncy_Click);
this.imgbtnisend.Click += new System.Web.UI.ImageClickEventHandler(this.imgbtnisend_Click);
this.Load += new System.EventHandler(this.Page_Load);
}
#endregion
private void imgbtnisend_Click(object sender, System.Web.UI.ImageClickEventArgs e)
{
string str="update ReceiveDocument set IsComplete=1 where ReDocumentID="+ViewState["ReDocumentID"].ToString ();
try
{
Dbc.ExecuteSQL (str);
cs.Message message=new OI.cs.Message ();
message.finishOprate (int.Parse (Session["userid"].ToString ()),int.Parse (ViewState["ReDocumentID"].ToString ()),"正在传阅");
}
catch (Exception er)
{
Response.Write (er.Message );
Response.End ();
}
Response.Redirect ("isComplete.aspx");
}
private void imgbtncy_Click(object sender, System.Web.UI.ImageClickEventArgs e)
{
Session["ldpsidbj"]=0;
Response.Redirect ("selectPersons.aspx?ReDocumentID="+ViewState["ReDocumentID"].ToString ());
}
private void Display( )
{
//string str=" select r.documentTitle,r.ReDocumentID from documentMitTransaction d,accounts_users a, ReceiveDocument r ";
//str +=" where d.userid=a.userid and d.ReDocumentID=r.ReDocumentID and d.transactid= "+ViewState["transactid"].ToString ();
string str="";
if (ViewState["transactid"] !=null)
{
str=" select r.*,a.username,s.SecretGreadName,e.ExigenceDegreeName from documentMitTransaction d,accounts_users a, ReceiveDocument r,secretgread s,exigencedegree e";
str +=" where r.SecretGreadID=s.SecretGreadID and r.ExigenceDegreeID=e.ExigenceDegreeID and d.userid=a.userid and d.ReDocumentID=r.ReDocumentID and d.transactid= "+ViewState["transactid"].ToString ();
}
if (ViewState["ReDocumentID"] !=null)
{
str="select * from ReceiveDocument r,secretgread s,exigencedegree e where r.ExigenceDegreeID=e.ExigenceDegreeID and r.SecretGreadID=s.SecretGreadID and ReDocumentID="+ViewState["ReDocumentID"].ToString ();
}
try
{
DataSet ds= new DataSet ();
ds= Dbc.getBinding (str,"t");
if (ds.Tables[0].Rows.Count >0)
{
SendDepartment.Text=ds.Tables[0].Rows[0]["SendDepartment"].ToString ();
DocumentTitle.Text=ds.Tables[0].Rows[0]["DocumentTitle"].ToString ();
ReceiveFileNumber.Text=ds.Tables[0].Rows[0]["ReceiveFileNumber"].ToString ();
SecretGreadID.Text=ds.Tables[0].Rows[0]["SecretGreadName"].ToString ();
ReceiveDate.Text=ds.Tables[0].Rows[0]["ReceiveDate"].ToString ();
// Receivedeclare.Text=ds.Tables[0].Rows[0]["Receivedeclare"].ToString();
Receivedeclare.Text=Server.HtmlEncode (ds.Tables[0].Rows[0]["Receivedeclare"].ToString()).Replace ("\r\n","<br/>").Replace (" " ," ");
ExigenceDegreeID.Text=ds.Tables[0].Rows[0]["ExigenceDegreeName"].ToString();
//lbl_title.Text =ds.Tables[0].Rows[0]["documentTitle"].ToString ();
ViewState["reDocumentID"]=ds.Tables[0].Rows[0]["ReDocumentID"].ToString ();
}
}
catch(Exception er)
{
Response.Write (er.Message );
Response.End ();
}
string sql2="select * from documentmittransaction where redocumentid="+ViewState["reDocumentID"]+" order by transactid desc";
try
{
DataSet ds2=Dbc.getBinding(sql2,"tt1");
if(ds2.Tables["tt1"].Rows.Count>0)
{
Session["IsldID"]=ds2.Tables["tt1"].Rows[0]["IsldID"].ToString();
}
}
catch(Exception ere)
{
Response.Write (ere.Message );
Response.End ();
}
OI.SendMessage.printTransactPaper pT=new OI.SendMessage.printTransactPaper();
string sql1="select d.*,a.username,a.userid from documentMitTransaction d,accounts_users a where d.userid=a.userid and ReDocumentID="+ ViewState["reDocumentID"];
//else
//{
// sql1="select d.*,a.username from documentMitTransaction d,accounts_users a where d.userid=a.userid and IsldID=1 and ReDocumentID="+ ViewState["reDocumentID"];
//}
DataSet ds1=Dbc.getBinding(sql1,"t1");
DataTable dt=ds1.Tables [0];
printTransactMans print=new printTransactMans ();
Table tab=print. CreatePrintTable(dt,6);
Panel1.Controls .Add (tab);
int countt=System.Convert.ToInt32(Dbc.GetValueBySql(sql1));
if(countt!=0)
{
foreach(DataRow dr in ds1.Tables["t1"].Rows)
{
if(Convert.ToBoolean(dr["Istransact"].ToString()))
{
if(Convert.ToBoolean(dr["IsldID"].ToString()))
{
//Ldyj.Text+=Server.HtmlEncode (dr["Idea"].ToString()).Replace ("\r\n","<br/>").Replace (" " ," ")+" "+pT.getPersonSign(dr["userid"].ToString())+"<br> ";//领导签字
string idea=dr["Idea"].ToString().Replace ("-","－—");
idea=idea.Replace ("\r\n","－");
Regex reg=new Regex (@"[－]*$");
idea=reg.Replace (idea,"");
string []contents= idea.Split (char.Parse ("－"));
if (contents.Length >1)
{
Ldyj.Text +=Server.HtmlEncode (idea).Replace ("－","<br/>").Replace (" " ," ");
Ldyj.Text +="<br>";
for(int i=0;i<contents[contents.Length-1 ].Length ;i++)
{
Ldyj.Text +=" ";
}
Ldyj.Text +=pT.getPersonSign(dr["userid"].ToString())+"<br>";
}
else
{
Ldyj.Text +=Server.HtmlEncode (idea).Replace ("－","<br/>").Replace (" " ," ");
Ldyj.Text +="<br>";
for(int i=0;i<idea.Length+1 ;i++)
{
Ldyj.Text +=" ";
}
Ldyj.Text +=pT.getPersonSign(dr["userid"].ToString())+"<br>";
}
}
else
{
Label5.Text+=Server.HtmlEncode (dr["Idea"].ToString()).Replace ("\r\n","<br/>").Replace (" " ," ")+" "+pT.getPersonSign(dr["userid"].ToString())+"<br> ";//意见
}
}
//Label6.Text+="<td>"+dr["username"].ToString()+"</td>";
//Label7.Text+="<td>"+dr["SendDate"].ToString()+"</td>";
//if(dr["TransactDate"].ToString().Trim()=="")
//{
// Label8.Text+="<td>还没有退件</td>";
// }
// else
// {
// Label8.Text+="<td>"+dr["TransactDate"].ToString()+"</td>";
// }
}
}
}
private void ldps_Click(object sender, System.Web.UI.ImageClickEventArgs e)
{
Session["ldpsidbj"]=1;
Response.Redirect ("selectPersons.aspx?ReDocumentID="+ViewState["ReDocumentID"].ToString ());
}
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -