deldatum.cs

很不错的公文流转系统

using System;

namespace OI.PersonSend
{
	/// <summary>
	/// delDatum 的摘要说明。
	/// </summary>
	
	public class delDatum:System.Web .UI .Page 
	{
		protected OI.DatabaseOper.DatabaseConnect Dbc=new OI.DatabaseOper.DatabaseConnect ();
		public delDatum()
		{
			//
			// TODO: 在此处添加构造函数逻辑

			//
		}
		/// <summary>
		/// 删除己发资料
		/// </summary>
		/// <param name="DatumID"></param>
		public void sendDatumDel(int DatumID) 
		{
			
			try
			{
			
					string str=" update datumPersonSend set isdel=1 where DatumID ="+DatumID.ToString ();
		            Dbc.ExecuteSQL (str);
                    dels(DatumID);
			}
			catch(Exception er)
			{
				throw new AppException (er.Message );
			}
		}
		public void acceptDatumDel(int ID)
		{
		    string str   =" select ds.datumid  from datumPersonSend ds ,datumPersonAccept da ";
                   str +=" where ds.datumid=da.datumid  and da.id="+ID.ToString ();
			try
			{
				int number= int.Parse (Dbc.GetValueBySql (str)) ;
				str=" update datumPersonAccept set isdel=1 where ID ="+ID.ToString ();
				Dbc.ExecuteSQL (str);
				dels(number);
			}
			catch(Exception er)
			{
				throw new AppException (er.Message );
			}
		}
		public void dels(int DatumID)
		{
			try
			{
				string strA="select count(*) from  datumPersonSend ds ,datumPersonAccept da where ds.DatumID=da.DatumID and  da.isdel=0 and ds.DatumID= "+DatumID.ToString ();
				string strS="select count(*) from datumPersonSend where isdel=0 and DatumID="+DatumID;
				int numberS= int.Parse (Dbc.GetValueBySql (strS)) ;
				int numberA= int.Parse (Dbc.GetValueBySql (strA));

				if (numberS ==0  && numberA ==0 ) 
				{
					if(!upFileDel(DatumID)) 
					{
						throw new AppException ("删除附件失败...</br>请联系系统管理员");
					}
					else
					{
						string str=" delete from datumPersonSend  where DatumID ="+DatumID.ToString ();
						Dbc.ExecuteSQL (str);
					}
				}
				
			}
			catch(Exception er)
			{
				throw new AppException (er.Message );
			}
		}
		public bool upFileDel(int DatumID)
		{
			string str=  " select FileName  from datumPersonSend where datumid=" +DatumID.ToString ();
			object o= Dbc.GetObjectBySql(str);
			if (o ==null) return true;
			else
			{
				string strURL=Server.MapPath (OI.Modules .Config .GetSetting ("documents").ToString ())+"\\"+o.ToString ();
				if (System.IO.File .Exists (strURL))
				{
					try
					{
						System.IO.File.Delete (strURL);
					}
					catch 
					{
//						throw new Exception ("删除附件失败...</br>请联系系统管理员");
						return false;
					}
				}
			 	
			}
			return true;
		}
	}
}