📄 draftstart.aspx.cs
字号:
/******************************************************************
* OI INC. *
* Copyright (c) 2003 OI INC. *
* *
* All rights reserved. No part of this program or publication *
* may be reproduced, transmitted, transcribed, stored in a *
* retrieval system,or translated into any language or computer *
* language, in any form or by any means, electronic, mechanical, *
* magnetic, optical, chemical,biological, or otherwise, without *
* the prior written permission. *
* *
******************************************************************/
/******************************************************************
* Source File Name : DraftStart.cs *
* Project Name: OI.csproj *
* Engineer: 黎斌 *
* Date Generated: 2003/12/9 *
* Last Revision Date : *
* Brief Description : 文档起草页面类 *
******************************************************************/
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.DraftOut
{
/// <summary>
/// DraftStart 的摘要说明。
/// </summary>
public class DraftStart :OI.PageBase
{
protected System.Web.UI.WebControls.LinkButton Bt_NextStep;
protected System.Web.UI.WebControls.TextBox TBTitle;
protected System.Web.UI.WebControls.DropDownList DDLUrgency;
protected System.Web.UI.WebControls.TextBox TBWriter;
protected System.Web.UI.WebControls.DropDownList DDLSecrecy;
protected System.Web.UI.WebControls.DropDownList DDLTemplate;
OI.DatabaseOper.DatabaseConnect oConn = new OI.DatabaseOper.DatabaseConnect();
private static DateTime oDateTime;
private static string szUserID;
protected System.Web.UI.WebControls.TextBox TBTopic;
private string EditType="";
protected System.Web.UI.WebControls.DropDownList DDLType;
protected System.Web.UI.WebControls.DropDownList DDLTypeDetail;
protected System.Web.UI.WebControls.DropDownList DDLStream;
protected System.Web.UI.WebControls.ImageButton ImageButtonView;
public string userName;
private void Page_Load(object sender, System.EventArgs e)
{
// 在此处放置用户代码以初始化页面
if (Session["userid"]==null)
{
Response.Write ("<script>alert('超时,请重新登录');top.location.href='../userpass.aspx';</script>");
return ;
}
if(Session["UserName"]==null)
{
Response.Write ("<script>Top.location.href='../userpass.aspx'</script>");
return;
}
if(!NullDepartment())
{
Response.Write ("<script>alert('你无权起草公文');</script>");
Response.End();
}
// if(!Page.IsPostBack)
// {
// DDLStream_Bind();
// }
if (IsPostBack)
return;
if (Request.QueryString["EditType"] != null)
{
EditType = Request.QueryString["EditType"].ToString();
ViewState["EditType"]=EditType;
}
if (Request.QueryString["DocumentID"] == null)
{
//只读
szUserID = Session["userID"].ToString();
userName=Session["UserName"].ToString();
BindDDL(false);
}
else
{
//编辑
BindDDL(true);
}
}
/// <summary>
/// 判断起草人员是否属于删除部门
/// </summary>
/// <returns></returns>
private bool NullDepartment()
{
string sql="select departmentname from departments where departmentid="+Convert.ToInt32(Session["departmentid"]);
if(oConn.GetObjectBySql(sql).ToString()=="不确定")
return false;
else
return true;
}
private void BindDDL(bool Edit)
{
DataSet dsType = new DataSet();
DataSet dsSecret = new DataSet();
DataSet dsExigence = new DataSet();
DataSet dsStream = new DataSet();
//OI.cs.readStream oReadStream = new OI.cs.readStream();
ArrayList arraylist;
ArrayList alist;
string szSql;
int nDocumentID=0;
if (Request.QueryString["DocumentID"] != null)
nDocumentID = Convert.ToInt32(Request.QueryString["DocumentID"]);
szSql = "select * from Document where DocumentID = " + nDocumentID.ToString();
arraylist = oConn.getData(szSql);
if (Edit)
{
TBTitle.Text = arraylist[24].ToString();
TBTopic.Text = arraylist[11].ToString();
TBWriter.Text = arraylist[32].ToString();
//TBWriter
Session["RecordID"] = arraylist[22].ToString();//设置与之关联的文档记录ID
}
else
{
TBWriter.Text = userName;
Session["RecordID"] = null;
}
TBWriter.Enabled = true;
if (Edit)
{
szSql = "select * from VIEW_DocumentType where DocumentTypeID="+arraylist[2].ToString();
alist = oConn.getData(szSql);
ListItem list = new ListItem(alist[2].ToString(),alist[3].ToString());
DDLType.Items.Insert(0,list);
DDLType.Enabled = false;
list = new ListItem(alist[1].ToString(),alist[0].ToString());
DDLTypeDetail.Items.Insert(0,list);
DDLTypeDetail.Enabled = false;
szSql = "select RecordID,substring(filename,0,len(filename)-3) filename from Template where DocumentTypeID = " + arraylist[2].ToString();
alist = oConn.getData(szSql);
if (alist.Count != 0)
{
list = new ListItem(alist[1].ToString(),alist[0].ToString());
DDLTemplate.Items.Insert(0,list);
}
DDLTemplate.Enabled = false;
Bt_NextStep.Enabled = true;
// Bt_Submit.Enabled = true;
}
else
{
szSql = "select DocumentTypeDescription,PrimaryType from VIEW_DocumentType group by PrimaryType,DocumentTypeDescription";
dsType = oConn.getBinding(szSql,"Temp");
DDLType.DataSource = dsType.Tables["Temp"];
DDLType.DataTextField = dsType.Tables["Temp"].Columns["DocumentTypeDescription"].ToString();
DDLType.DataValueField = dsType.Tables["Temp"].Columns["PrimaryType"].ToString();
DDLType.DataBind();
ListItem li=new ListItem("请选择","000");
DDLType.Items.Insert (0,li);
}
szSql = "select * from SecretGread order by secretGreadID desc";
dsSecret = oConn.getBinding(szSql,"Temp");
DDLSecrecy.DataSource = dsSecret.Tables["Temp"];
DDLSecrecy.DataTextField = dsSecret.Tables["Temp"].Columns["SecretGreadName"].ToString();
DDLSecrecy.DataValueField = dsSecret.Tables["Temp"].Columns["SecretGreadID"].ToString();
DDLSecrecy.DataBind();
DDLSecrecy.Items .FindByText (DDLSecrecy.SelectedItem.Text).Selected =false;
DDLSecrecy.Items .FindByText ("普通").Selected =true;
if (Edit)
DDLSecrecy.SelectedValue = arraylist[1].ToString();
szSql = "select * from ExigenceDegree order by ExigenceDegreeID desc";
dsExigence = oConn.getBinding(szSql,"Temp");
DDLUrgency.DataSource = dsExigence.Tables["Temp"];
DDLUrgency.DataTextField = dsExigence.Tables["Temp"].Columns["ExigenceDegreeName"].ToString();
DDLUrgency.DataValueField = dsExigence.Tables["Temp"].Columns["ExigenceDegreeID"].ToString();
DDLUrgency.DataBind();
DDLUrgency.Items .FindByText (DDLUrgency.SelectedItem.Text).Selected =false;
DDLUrgency.Items .FindByText ("一般").Selected =true;
if (Edit)
DDLUrgency.SelectedValue = arraylist[3].ToString();
DDLStream_Bind();
// szSql = "select * from Stream";
// dsStream = oConn.getBinding(szSql,"Temp");
// foreach(DataRow dr in dsStream.Tables["Temp"].Rows)
// {
// oReadStream.StreamID = Convert.ToInt32(dr[0]);
// if (oReadStream.GetNodeIdByType("公文起草") == null)
// dr.Delete();//若流中无公文起草结点则删除该行
// }
//
// DDLStream.DataSource = dsStream.Tables["Temp"];
// DDLStream.DataTextField = dsStream.Tables["Temp"].Columns["StreamName"].ToString();
// DDLStream.DataValueField = dsStream.Tables["Temp"].Columns["StreamID"].ToString();
// DDLStream.DataBind();
if (Edit)
{
//DDLStream.Items .FindByValue (DDLStream.SelectedValue ).Selected =false;
//DDLStream.Items .FindByValue (arraylist[19].ToString() ).Selected =true;
DDLStream_Bind();
DDLStream.SelectedValue = arraylist[19].ToString();
}
}
#region Web 窗体设计器生成的代码
override protected void OnInit(EventArgs e)
{
//
// CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。
//
InitializeComponent();
base.OnInit(e);
}
/// <summary>
/// 设计器支持所需的方法 - 不要使用代码编辑器修改
/// 此方法的内容。
/// </summary>
private void InitializeComponent()
{
this.DDLType.SelectedIndexChanged += new System.EventHandler(this.DDLType_SelectedIndexChanged);
this.DDLTypeDetail.SelectedIndexChanged += new System.EventHandler(this.DDLTypeDetail_SelectedIndexChanged);
this.ImageButtonView.Click += new System.Web.UI.ImageClickEventHandler(this.ImageButtonView_Click);
this.Bt_NextStep.Click += new System.EventHandler(this.Bt_NextStep_Click);
this.Load += new System.EventHandler(this.Page_Load);
}
#endregion
private void Bt_NextStep_Click(object sender, System.EventArgs e)
{
if (!CheckInput())
return;
//试用版提示
string sqlw="select count(documentid) from document";
OI.DatabaseOper .DatabaseConnect dcw=new OI.DatabaseOper.DatabaseConnect ();
ArrayList alw=dcw.getData (sqlw);
int nCount=int.Parse (alw[0].ToString ().Trim ());
if(nCount>500)
{
Page.RegisterStartupScript ("","<script>alert(\"起草失败\")");
return;
}
saveInfo(false);
if (ViewState["EditType"] != null)
Response.Redirect("DraftEdit.aspx?EditType="+ViewState["EditType"].ToString(),true);
else
Response.Redirect("DraftEdit.aspx",true);
}
private bool CheckInput()
{
if(DDLStream.Items.Count==0)
{
Page.RegisterStartupScript("","<script>alert('请添加工作流程');</script>");
return false;
}
if (TBTitle.Text.Trim() == "")
{
Response.Write("<script>alert('请输入主题！');Form1.TBTitle.focus();</script>");
return false;
}
if (DDLType.SelectedValue == "000")
{
Page.RegisterStartupScript("","<script>alert('请选择文档主类别!');Form1.DDLType.focus();</script>");
return false;
}
if (DDLTypeDetail.SelectedValue == "000")
{
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -