📄 transact.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>
/// transact 的摘要说明。
/// </summary>
public class transact : OI.PageBase
{
protected System.Web.UI.WebControls.RequiredFieldValidator RequiredFieldValidator1;
protected System.Web.UI.WebControls.TextBox txtIdea;
//protected OI.UserControls .transactDetail transdetail;
protected System.Web.UI.WebControls.Label Label5;
protected System.Web.UI.WebControls.Label SendDepartment;
protected System.Web.UI.WebControls.Label ReceiveFileNumber;
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 Receivedeclare;
protected System.Web.UI.WebControls.Label Ldyj;
protected System.Web.UI.WebControls.RequiredFieldValidator Requiredfieldvalidator2;
protected System.Web.UI.WebControls.TextBox txtIdea1;
protected System.Web.UI.WebControls.Label ExigenceDegreeID;
protected System.Web.UI.WebControls.ImageButton imgbtnSubmit;
protected System.Web.UI.WebControls.ImageButton imggaizhang;
protected System.Web.UI.WebControls.Panel panel1;
protected System.Web.UI.WebControls.Panel Panel2;
protected System.Web.UI.WebControls.Panel Panel3;
protected System.Web.UI.WebControls.DropDownList dst_usualS;
protected System.Web.UI.WebControls.DropDownList dst_usualST;
OI.DatabaseOper .DatabaseConnect Dbc=new OI.DatabaseOper.DatabaseConnect ();
private void Page_Load(object sender, System.EventArgs e)
{
// 在此处放置用户代码以初始化页面
if (Session["userid"]==null)
{
Response.Write ("<script>alert('超时,请重新登录');top.location.href='../userpass.aspx';</script>");
return ;
}
// dst_usualS.Attributes ["onchange"]="dst_usualS_change() ";
// dst_usualST.Attributes ["onchange"]="dst_usualST_change() ";
if (!Page.IsPostBack )
{
try
{
ViewState["transactid"]=int .Parse (Request.Params ["id"].ToString ()).ToString ();
}
catch
{
return ;
}
Display();
}
else
{
CreateTransmas();
}
//transdetail.ReDocumentID =int.Parse (ViewState["reDocumentID"].ToString ());
//transdetail.IsView =false;
}
/// <summary>
/// 显示初始化值.
/// </summary>
private void Display( )
{
string 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 ();
// str +=" and userid="+Session["userid"].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 ();
ReceiveDate.Text = System.DateTime .Parse (ds.Tables[0].Rows[0]["ReceiveDate"].ToString ()).ToShortDateString();
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();
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"];
DataSet ds1=Dbc.getBinding(sql1,"t1");
//DataTable dt=ds1.Tables [0];
CreateTransmas();
int countt=System.Convert.ToInt32(Dbc.GetValueBySql(sql1));
if(countt!=0)
{
try
{
if( System.Convert.ToBoolean(Session["IsldID"]))
{
dst_usualS_bind();
Requiredfieldvalidator2.Visible=false;
txtIdea1.Visible=false;
Panel3.Visible =false;
}
else
{
dst_usualST_bind();
txtIdea.Visible=false;
panel1.Visible=false;
}
}
catch(Exception ess)
{
Response.Write(ess.Message);
Response.Write(Session["IsldID"]);
Response.End();
}
foreach(DataRow dr in ds1.Tables["t1"].Rows)
{
if(Convert.ToBoolean(dr["Istransact"].ToString()))
{
if(Convert.ToBoolean(dr["IsldID"].ToString()))
{
//string idea= dr["Idea"].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> ";//意见
}
}
}
}
}
#region Web 窗体设计器生成的代码
override protected void OnInit(EventArgs e)
{
//
// CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。
//
InitializeComponent();
base.OnInit(e);
}
/// <summary>
/// 设计器支持所需的方法 - 不要使用代码编辑器修改
/// 此方法的内容。
/// </summary>
private void InitializeComponent()
{
this.dst_usualS.SelectedIndexChanged += new System.EventHandler(this.dst_usualS_SelectedIndexChanged);
this.dst_usualST.SelectedIndexChanged += new System.EventHandler(this.dst_usualST_SelectedIndexChanged);
this.imgbtnSubmit.Click += new System.Web.UI.ImageClickEventHandler(this.imgbtnSubmit_Click);
this.Load += new System.EventHandler(this.Page_Load);
}
#endregion
private void imgbtnSubmit_Click(object sender, System.Web.UI.ImageClickEventArgs e)
{
string Idea;
if( System.Convert.ToBoolean(Session["IsldID"]))
{
Idea=txtIdea.Text .Replace ("'","''");
if(System.Convert.ToInt32(Session["gaizhang"])!=1)
{
Page.RegisterStartupScript("","<script>alert('请加盖私章！');</script>");
return;
}
}
else
{
Idea=txtIdea1.Text .Replace ("'","''");
}
Session["gaizhang"]=0;
string str= "update documentmittransaction set idea='"+ Idea+"' ,istransact=1 ,TransactDate='"+System.DateTime.Now +"'";
str +=" where transactid="+ ViewState["transactid"].ToString ();
str +=" and userid=" +Session["userid"].ToString ();
try
{
//得到收文人员的用户ID
Dbc.ExecuteSQL (str);
cs.Message message =new OI.cs.Message ();
message.finishOprate (int.Parse (Session["userid"].ToString ()),int.Parse (ViewState["reDocumentID"].ToString ()),"末阅办");
BackMessageString();
Response.Redirect ("transactno.aspx");
}
catch(System.Exception err)
{
Response.Write(err.ToString());
}
Display();
}
/// <summary>
/// 返回向收文人员发送消息的字符串
/// </summary>
/// <returns></returns>
private void BackMessageString()
{
string sql=" select count(*) from documentMitTransaction where Istransact =0 and ReDocumentID="+ViewState["reDocumentID"] ;
int count= int.Parse (Dbc.GetObjectBySql (sql).ToString ());
if (count >0) //不是最后一个处理人
{
return ;
}
else //最后一个处理人，应当向收文用户发送消息小精灵。
{
sql ="select d.userid,a.username,dp.departmentname from documentMitTransaction d, accounts_users a ,departments dp ";
sql +=" where d.userid=a.userid and a.departmentid=dp.departmentid ";
sql +=" and d.senddate=(select senddate from documentMitTransaction where transactid="+ViewState["transactid"]+")";
DataTable TransactMans=Dbc.getBinding(sql,"t").Tables[0];
string mans="";
foreach ( DataRow dr in TransactMans.Rows )
{
mans+=dr["username"].ToString ();
mans+="(所属部门:"+dr["departmentname"].ToString ()+"),";
}
mans=mans.Substring (0,mans.Length -1);//得到处理人的列表
//得到收文人员的ＩＤ
sql=" select r.userid from ReceiveDocument r,documentmittransaction dt ";
sql+=" where dt.redocumentid=r.redocumentid and dt.transactid="+ViewState["transactid"].ToString ();
string ReceiveUserid =Dbc.GetObjectBySql(sql).ToString ();
//得到该文档的标题。
sql=" select DocumentTitle from ReceiveDocument r,documentmittransaction dt ";
sql+=" where dt.redocumentid=r.redocumentid and dt.transactid="+ViewState["transactid"].ToString ();
string DocumentTitle=Dbc.GetObjectBySql(sql).ToString ();
//给收文人员发送短消息。
//string backstr=" insert into message (Senduserid,ReceiveUserId,messageContent,FileTable) values (" +Session["userid"] +","+ReceiveUserid +",'" +mans+"己完成 《"+ DocumentTitle+"》的处理，请你继续处理！','RecordFile')";
cs.Message message =new OI.cs.Message ();
message.MessageContent =mans+"己完成 《"+ DocumentTitle+"》的处理，请你继续处理！";
message.ModeName ="正在传阅";
message.SendUserID =int.Parse (Session["userid"] .ToString ());
message.ReceiveUserID =int.Parse (ReceiveUserid);
message.ID =int.Parse (ViewState["reDocumentID"].ToString ());
message.SendTime =System.DateTime .Now ;
message.Title=DocumentTitle;
message.DocumentPath ="../receivdocument/transmited.aspx";
message.ADD ();
}
}
private DataTable normalSententce()
{
string sqlcontent= "select * from personcontent where userid="+Session["userid"].ToString ();
DataTable dt=Dbc.getBinding (sqlcontent,"t").Tables [0];
return dt ;
}
private void dst_usualS_bind()
{
DataTable dt=normalSententce();
dst_usualS.DataSource =dt ;
dst_usualS.DataTextField =dt.Columns["personcontent"].ToString ();
dst_usualS.DataValueField =dt.Columns["personcontent"].ToString ();
dst_usualS.DataBind ();
dst_usualS.Items .Insert (0,"无");
dst_usualS.SelectedItem.Selected =false;
dst_usualS.Items .FindByText ("无").Selected =true;
}
private void dst_usualST_bind()
{
DataTable dt=normalSententce();
dst_usualST.DataSource =dt ;
dst_usualST.DataTextField =dt.Columns["personcontent"].ToString ();
dst_usualST.DataValueField =dt.Columns["personcontent"].ToString ();
dst_usualST.DataBind ();
dst_usualST.Items .Insert (0,"无");
dst_usualST.SelectedItem.Selected =false;
dst_usualST.Items .FindByText ("无").Selected =true;
}
private void dst_usualS_SelectedIndexChanged(object sender, System.EventArgs e)
{
string text=dst_usualS.SelectedItem .Text ;
if (text !="无")
{
txtIdea.Text +="\r\n"+text;
}
}
private void dst_usualST_SelectedIndexChanged(object sender, System.EventArgs e)
{
string text=dst_usualST.SelectedItem .Text ;
if (text !="无")
{
txtIdea1.Text +="\r\n"+text;
}
}
private void CreateTransmas()
{
string sql1="select d.*,a.username,a.userid from documentMitTransaction d,accounts_users a where d.userid=a.userid 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);
Panel2.Controls .Add (tab);
}
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -