draftstart.aspx.cs

很不错的公文流转系统

				Page.RegisterStartupScript("","<script>alert('请选择文档子类别!');Form1.DDLTypeDetail.focus();</script>");
				return false;
			}
			//			if (TBWriter.Text.Trim() == "")
			//			{
			//				Page.RegisterStartupScript("","<script>alert('请输入作者名!');Form1.TBWriter.focus();</script>");
			//				return false;
			//			}

			return true;
		}

		/// <summary>
		/// 
		/// </summary>
		/// <param name="finished">文档起草是否完成</param>
		private void saveInfo(bool finished)
		{	
			
			//			
			//			if (CheckInput())
			//			{
			//是否暂存
			if (finished)
			{		
				string szSql;
				int nDocumentID;

				if (Request.QueryString["DocumentID"] == null)
				{
					nDocumentID = -1;
				}
				else
				{
					nDocumentID = Convert.ToInt32(Request.QueryString["DocumentID"]);
				}
				szSql = "SELECT RecordID from  Document Where DocumentID = " + nDocumentID;
				DataSet ds = new DataSet();
				ds = oConn.getBinding(szSql,"Temp");
				int nRow = ds.Tables["Temp"].Rows.Count;

				if (nRow > 0)
				{
					szSql = "update Document set Title='" + TBTitle.Text.Trim() + "',"
						+ "Subject='" + TBTitle.Text.Trim() + "',"
						+ "TopicWord='" + TBTopic.Text.Trim() + "',"
						+ "SecretGreadID=" + DDLSecrecy.SelectedValue + ","
						+ "ExigenceDegreeID=" + DDLUrgency.SelectedValue + ","
						+ "StreamID=" + DDLStream.SelectedValue 
						+ " where DocumentID = " + Request.QueryString["DocumentID"].ToString();					
				}
				else
				{					
					oDateTime = DateTime.Now;			
					//公文起草阶段，流状态为0
					szSql = "insert into Document (Title,Subject,TopicWord,DocumentTypeID,Author,DrawMan,UserID,SecretGreadID,ExigenceDegreeID,Template,";
					szSql +="StreamID,FileDate,Content,RecordID)" ;
					szSql += "values( '" + TBTitle.Text.Trim() + "',";
					szSql += "'" + TBTitle.Text.Trim() + "',";
					szSql += "'" + TBTopic.Text.Trim() + "',";
					szSql += DDLType.SelectedValue  + ",";
					szSql += "'" + Session["Author"].ToString ()+ "',"; //作者|录入人员
					szSql +="'"+Session["DrawMan"].ToString ()+"',"; //起草人
					szSql += szUserID + ",";
					szSql += DDLSecrecy.SelectedValue + ",";
					szSql += DDLUrgency.SelectedValue + ",";
					szSql += "'" + DDLTemplate.SelectedValue + "',";
					szSql += DDLStream.SelectedValue + ",";
					szSql += "'" + oDateTime + "',";
					szSql += "'',";
					szSql += "'" +oDateTime.ToString("yyyyMMddhhmmss") + "')";
				}

				try
				{
					oConn.ExecuteSQL(szSql);
				}
				catch(System.Data.SqlClient.SqlException e)
				{				
					throw new AppException("执行下列语句出错：\n\r"+szSql,e);
				}
			}
			else
			{
				Session["Title"] = TBTitle.Text.Trim();
				Session["Subject"] = TBTitle.Text.Trim();
				Session["DocumentTypeID"] = DDLTypeDetail.SelectedValue;//*****
				Session["DrawMan"] = TBWriter.Text.Trim();
				Session["Author"]=Session["username"];
				Session["SecretGreadID"] = DDLSecrecy.SelectedValue;
				Session["ExigenceDegreeID"] = DDLUrgency.SelectedValue;
				//					Session["Template"] = DDLTemplate.SelectedValue;
				Session["StreamID"] = DDLStream.SelectedValue;
				Session["TopicWord"] = TBTopic.Text.Trim();
				if (DDLTemplate.SelectedValue == "000"||DDLTemplate.SelectedValue == "001")//是否选择空模板
				{
					if(DDLTemplate.SelectedValue == "000")
					{
						Session["FileType"] = ".doc";
						Session["Template"] = "";
					}
					if(DDLTemplate.SelectedValue == "001")
					{
						Session["FileType"] = ".xls";
						Session["Template"] = "";
					}

				}
				else
				{
					string szSql = "select FileType from Template where RecordID = '" + DDLTemplate.SelectedValue + "'";					
					Session["FileType"] = oConn.GetValueBySql(szSql);
					Session["Template"] = DDLTemplate.SelectedValue;
				}
			}
			//			}
		}

		private void Bt_Submit_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(\"该版本为试用版,请使用正版\n暂存失败\")");
				return;
			}

			saveInfo(true);
			Response.Redirect("DraftTemporary.aspx",true);
		}

		private void DDLType_SelectedIndexChanged(object sender, System.EventArgs e)
		{
			if (DDLType.SelectedValue != "000")
			{
				string szSql = "select * from VIEW_DocumentType where PrimaryType=" + DDLType.SelectedValue;
				DataSet dsTemp = oConn.getBinding(szSql,"Temp");

				DDLTypeDetail.DataSource = dsTemp.Tables["Temp"];
				DDLTypeDetail.DataTextField = "DocumentTypeName";
				DDLTypeDetail.DataValueField = "DocumentTypeID";
				DDLTypeDetail.DataBind();
				ListItem li = new ListItem("请选择","000");
				DDLTypeDetail.Items.Insert(0,li);

				DDLTypeDetail.Enabled = true;					
			}
			else
			{
				DDLTypeDetail.Enabled = false;
				DDLTemplate.Enabled = false;
				Bt_NextStep.Enabled = false;
				//				Bt_Submit.Enabled = false;
			}

		}

		private void DDLTypeDetail_SelectedIndexChanged(object sender, System.EventArgs e)
		{
			DataSet dsTemplate = new DataSet();
			string szSql;

			szSql = "select RecordID,substring(filename,0,len(filename)-3) filename from Template where DocumentTypeID = " + DDLTypeDetail.SelectedValue+" and departmentid in (0,"+Session["departmentid"]+")";
			//			szSql = "select RecordID,substring(filename,0,len(filename)-3) filename from Template where FileType='.doc'";
			dsTemplate = oConn.getBinding(szSql,"Temp");
			DDLTemplate.DataSource = dsTemplate.Tables["Temp"];
			DDLTemplate.DataTextField = dsTemplate.Tables["Temp"].Columns["filename"].ToString();
			DDLTemplate.DataValueField = dsTemplate.Tables["Temp"].Columns["RecordID"].ToString();
			DDLTemplate.DataBind();
			ListItem li = new ListItem("空模板word","000");
			DDLTemplate.Items.Insert(0,li);
//			ListItem li1 = new ListItem("空模板excel","001");
//			DDLTemplate.Items.Insert(1,li1);
			DDLTemplate.Enabled = true;
			Bt_NextStep.Enabled = true;
			//			Bt_Submit.Enabled = true;
		}

		private void DDLUrgency_SelectedIndexChanged(object sender, System.EventArgs e)
		{
		
		}

		private void ImageButtonView_Click(object sender, System.Web.UI.ImageClickEventArgs e)
		{
			if(DDLStream.SelectedItem==null)
				return;
			else
			
				Response.Redirect("../desktop/StreamDetail.aspx?streamID="+DDLStream.SelectedItem.Value);
		}

		private void DDLTemplate_SelectedIndexChanged(object sender, System.EventArgs e)
		{
		
		}

		private void Dstclass_SelectedIndexChanged(object sender, System.EventArgs e)
		{
			DDLStream_Bind();
		}
		
		private ArrayList al=new ArrayList();//保存部门节点的和其子节点的所有departmentid值
		
		private void SelectDepartmentID(string parentid)
		{
			
			string sql="select departmentid from departments where parentdepartmentid='"+parentid+"'";
			ArrayList aldepartmentid=oConn.getData(sql);
			for(int i=0;i<aldepartmentid.Count;i++)
			{  
				al.Add(aldepartmentid[i].ToString());
				SelectDepartmentID(aldepartmentid[i].ToString());
			}
			
		}

		
		private void  DDLStream_Bind()
		{
//
//			OI.cs.readStream oReadStream = new OI.cs.readStream();
//			al.Add(Session["departmentid"].ToString());
//			SelectDepartmentID(Session["departmentid"].ToString());//获得部门节点的和其子节点的所有departmentid值
//			string str="(";
//			for(int i=0;i<al.Count;i++)
//			{
//				if(i!=al.Count-1)
//					str+=al[i].ToString()+",";
//				else
//					str+=al[i].ToString();
//
//			}
//			str+=")";
					
			//string sql="select streamid,streamname from stream where departmentid in"+str;	
			string sql="select streamid,streamname from stream where departmentid in (0,"+Session["departmentid"].ToString()+")";
			DataSet ds=oConn.getBinding(sql,"t");
//			for (int i=0;i <ds.Tables[0].Rows.Count;i++)
//			{
//				oReadStream.StreamID = Convert.ToInt32(ds.Tables[0].Rows[i][0]);
//				if (oReadStream.GetNodeIdByType("公文起草") == null)
//					ds.Tables[0].Rows[i].Delete();//若流中无公文起草结点则删除该行
//			}
			ds.Tables[0].AcceptChanges();
                
			DDLStream.DataSource = ds.Tables[0].DefaultView;
				
			DDLStream.DataTextField =ds.Tables[0].Columns["streamname"].ToString(); 
			DDLStream.DataValueField =ds.Tables[0].Columns["streamid"].ToString();
			DDLStream.DataBind();
			

		}

		private void DDLStream_SelectedIndexChanged(object sender, System.EventArgs e)
		{
		
		}

		private void TBWriter_TextChanged(object sender, System.EventArgs e)
		{
		
		}
	
		private void  DDLStream_Bind(bool edit)
		{
			if (edit)
			{
				OI.cs.readStream oReadStream = new OI.cs.readStream();
				string szSql = "select * from Stream " ;
				DataSet dsStream =new DataSet ();
				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();
			}

		}
	}
}