public SqlDataReader QuerySystemParam ()
		{
			SqlDataReader dtRdWarrtCdt;

			//調(diào)用SqlHelper.ExecuteReader方法，并使用usps_proSelectSystemParam存儲過程，并將SqlDataReader賦給dtRdWarrtCdt;
			dtRdWarrtCdt = SqlHelper.ExecuteReader(m_Connection_String,CommandType.StoredProcedure,"usps_proSelectSystemParam");
			if (dtRdWarrtCdt.Read())
			{
				return dtRdWarrtCdt;
			}
			return null;
		}	
		
		#endregion

		#region 更新憑證表中的信息
		/// <summary>
		/// 更新憑證表中的信息
		/// </summary>
		/// <param name="AbstractLayer.baseWarrant">objWarrant</param>
		/// <returns></returns>
		
		public void Update(AbstractLayer.baseWarrant objWarrant)
		{
			//			實例化事務(wù)
			SqlTransaction objTrans=null;
			//				實例化鏈接字符串
			SqlConnection myConnection =  new SqlConnection(m_Connection_String);

													
			try
			{		
												
				//		打開數(shù)據(jù)庫連接
				myConnection.Open();
				//		開始事務(wù)
				objTrans= myConnection.BeginTransaction();
				//		定義SqlParameter數(shù)組,其大小為10,數(shù)組名為prAccountParms
				SqlParameter [] prAccountParms=new SqlParameter[10];
				//		給prAccountParms參數(shù)賦值(參考SqlDataAccess類)
				prAccountParms[0]=new SqlParameter("@warNum",objWarrant.warNum);					
				prAccountParms[1]=new SqlParameter("@accPer",objWarrant.accPer);
				prAccountParms[2]=new SqlParameter("@warChar", objWarrant.warChar); 
				prAccountParms[3]=new SqlParameter("@data",objWarrant.data);
				prAccountParms[4]=new SqlParameter("@addBill",objWarrant.addBill);
				prAccountParms[5]=new SqlParameter("@makeBill", objWarrant.makeBill); 
				prAccountParms[6]=new SqlParameter("@debtorAll",objWarrant.debtorAll);
				prAccountParms[7]=new SqlParameter("@lenderAll",objWarrant.lenderAll);
				prAccountParms[8]=new SqlParameter("@tranaccSta",objWarrant.tranaccSta);
				prAccountParms[9]=new SqlParameter("@warSta",objWarrant.warSta);
			
				//pass connection string, storedprocedure name and parameter array
				//調(diào)用SqlHelper.ExecuteNonQuery方法，并使用usps_proUpdateWarrant存儲過程
				SqlHelper.ExecuteNonQuery(m_Connection_String,CommandType.StoredProcedure,"usps_proUpdateWarrant",prAccountParms);

			}
			catch(Exception Ex)
			{
				//					回滾事務(wù)
				objTrans.Rollback();
				throw;
			}
			finally
			{
				myConnection.Close();
			}
		}

		#endregion

		#region 刪除憑證表和分錄表中的信息
		/// <summary>
		/// 刪除憑證表和分錄表中的信息
		/// </summary>
		/// <param name="AbstractLayer.baseWarrant"></param>
		/// <returns></returns>
		public void dltWarrtSubRec(string cnd)
		{
			SqlParameter [] arrParam=new SqlParameter[1];
			//		給arrParam參數(shù)賦值(參考SqlDataAccess類)
			arrParam[0]=new SqlParameter("@WarrentCode",cnd);	
			using (SqlConnection conn = new SqlConnection(m_Connection_String)) 
			{
				conn.Open();//打開連接
				using (SqlTransaction trans = conn.BeginTransaction()) //開始事務(wù)
				{
					try 
					{
						
						SqlHelper.ExecuteNonQuery(trans, CommandType.StoredProcedure, "usps_proDeletWarrSubRec",arrParam);
						trans.Commit();//提交事務(wù)
					
					}
					catch 
					{
						trans.Rollback();//發(fā)生異常，則回滾。
						throw;
					}
				}
			}
		}
		#endregion

		#region 試算平衡
		///待調(diào)整
		public DataSet CalTrailBalance (int _isNewAccount)
		{
			DataSet dtStTrailBalance;
			//			調(diào)用SqlHelper.ExecuteDataset方法，并使用usps_proSelectWarrant003存儲過程，并將數(shù)據(jù)集賦給dtStWarrant;
			SqlParameter [] arrParam=new SqlParameter[1];
			//		給arrParam參數(shù)賦值(參考SqlDataAccess類)
			arrParam[0]=new SqlParameter("@isNewAccout ",_isNewAccount);	
			dtStTrailBalance = SqlHelper.ExecuteDataset(m_Connection_String,CommandType.StoredProcedure,"usps_proSelectTrailBalance",arrParam);
			return dtStTrailBalance;
		}
		#endregion
		
		#region 顯示資產(chǎn)負(fù)債表中的所有信息
		///usps_proSelectAssertDebt
		/// <summary>
		/// 顯示資產(chǎn)負(fù)債表中的所有信息
		/// </summary>
		/// <param name=""></param>
		/// <returns>資產(chǎn)負(fù)債表中所有信息的數(shù)據(jù)集</returns>
		
		public DataSet ListAssertDebt ()
		{
			DataSet dtStAssertDebt;
			//			調(diào)用SqlHelper.ExecuteDataset方法，并使用usps_proSelectAssertDebt存儲過程，并將數(shù)據(jù)集賦給dtStAssertDebt;
			
			dtStAssertDebt = SqlHelper.ExecuteDataset(m_Connection_String,CommandType.StoredProcedure,"usps_proSelectAssertDebt");
			return dtStAssertDebt;
		}	
		#endregion

		#region 顯示總分類賬表中的所有信息
		///usps_proSelectTotalBooks
		/// <summary>
		/// 顯示總分類賬表中的所有信息
		/// </summary>
		/// <param name=""></param>
		/// <returns>顯示總分類賬表中的所有信息</returns>
		public DataSet ListTotalBooks ()
		{
			DataSet dtStTotalBooks;
			//調(diào)用SqlHelper.ExecuteDataset方法，并使用usps_proSelectTotalBooks存儲過程，并將數(shù)據(jù)集賦給dtStTotalBooks;
			
			dtStTotalBooks = SqlHelper.ExecuteDataset(m_Connection_String,CommandType.StoredProcedure,"usps_proSelectTotalBooks");
			return dtStTotalBooks;
		}
		#endregion

		#region 根據(jù)科目代碼顯示總分類賬表中的所有信息
		///usps_proSelectTotalBooks001
		/// <summary>
		/// 根據(jù)科目代碼顯示總分類賬表中的所有信息
		/// </summary>
		/// <param name=""></param>
		/// <returns>根據(jù)科目代碼顯示總分類賬表中的所有信息</returns>
		public DataSet ListTotalBooksCnd (string subjectID)
		{
			DataSet dtStTotalBooks;
			SqlParameter [] arrParam=new SqlParameter[1];
			//		給arrParam參數(shù)賦值(參考SqlDataAccess類)
			arrParam[0]=new SqlParameter("@subjectID",subjectID);
			//調(diào)用SqlHelper.ExecuteDataset方法，并使用usps_proSelectTotalBooks001存儲過程，并將數(shù)據(jù)集賦給dtStTotalBooks;
			dtStTotalBooks = SqlHelper.ExecuteDataset(m_Connection_String,CommandType.StoredProcedure,"usps_proSelectTotalBooks001",arrParam);
			return dtStTotalBooks;
		}
		#endregion

		#region 顯示日記賬表中的所有信息
		/// <summary>
		/// 顯示日記賬表中的所有信息
		/// </summary>
		/// <param name=""></param>
		/// <returns>日記賬表中的所有信息的數(shù)據(jù)集</returns>
		public DataSet ListDiary ()
		{
			DataSet dtStDiary;
			//調(diào)用SqlHelper.ExecuteDataset方法，并使用usps_proSelectDirayQuery存儲過程，并將數(shù)據(jù)集賦給dtStDiary;
			
			dtStDiary = SqlHelper.ExecuteDataset(m_Connection_String,CommandType.StoredProcedure,"usps_proSelectDirayQuery");
			return dtStDiary;
		}
		#endregion

		#region 根據(jù)科目代碼顯示日記賬表中的信息
		/// <summary>
		/// 根據(jù)科目代碼顯示日記賬表中的信息
		/// </summary>
		/// <param name=""></param>
		/// <returns>明細(xì)賬表中信息的數(shù)據(jù)集</returns>
		public DataSet ListDiaryCnd (string subjectID)
		{
			DataSet dtStDiaryCnd;
			SqlParameter [] arrParam=new SqlParameter[1];
			//		給arrParam參數(shù)賦值(參考SqlDataAccess類)
			arrParam[0]=new SqlParameter("@subjectID",subjectID);
			//調(diào)用SqlHelper.ExecuteDataset方法，并使用usps_proSelectDirayQuery001存儲過程，并將數(shù)據(jù)集賦給dtStDiaryCnd;
			dtStDiaryCnd = SqlHelper.ExecuteDataset(m_Connection_String,CommandType.StoredProcedure,"usps_proSelectDirayQuery001",arrParam);
			return dtStDiaryCnd;
		}
		#endregion
	}
}