sqlwarrtaccess.cs

使用工具为.net2003

		
		public SqlDataReader QuerySystemParam ()
		{
			SqlDataReader dtRdWarrtCdt;

			//调用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)
		{
			//			实例化事务
			SqlTransaction objTrans=null;
			//				实例化链接字符串
			SqlConnection myConnection =  new SqlConnection(m_Connection_String);

													
			try
			{		
												
				//		打开数据库连接
				myConnection.Open();
				//		开始事务
				objTrans= myConnection.BeginTransaction();
				//		定义SqlParameter数组,其大小为10,数组名为prAccountParms
				SqlParameter [] prAccountParms=new SqlParameter[10];
				//		给prAccountParms参数赋值(参考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
				//调用SqlHelper.ExecuteNonQuery方法，并使用usps_proUpdateWarrant存储过程
				SqlHelper.ExecuteNonQuery(m_Connection_String,CommandType.StoredProcedure,"usps_proUpdateWarrant",prAccountParms);

			}
			catch(Exception Ex)
			{
				//					回滚事务
				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参数赋值(参考SqlDataAccess类)
			arrParam[0]=new SqlParameter("@WarrentCode",cnd);	
			using (SqlConnection conn = new SqlConnection(m_Connection_String)) 
			{
				conn.Open();//打开连接
				using (SqlTransaction trans = conn.BeginTransaction()) //开始事务
				{
					try 
					{
						
						SqlHelper.ExecuteNonQuery(trans, CommandType.StoredProcedure, "usps_proDeletWarrSubRec",arrParam);
						trans.Commit();//提交事务
					
					}
					catch 
					{
						trans.Rollback();//发生异常，则回滚。
						throw;
					}
				}
			}
		}
		#endregion

		#region 试算平衡
		///待调整
		public DataSet CalTrailBalance (int _isNewAccount)
		{
			DataSet dtStTrailBalance;
			//			调用SqlHelper.ExecuteDataset方法，并使用usps_proSelectWarrant003存储过程，并将数据集赋给dtStWarrant;
			SqlParameter [] arrParam=new SqlParameter[1];
			//		给arrParam参数赋值(参考SqlDataAccess类)
			arrParam[0]=new SqlParameter("@isNewAccout ",_isNewAccount);	
			dtStTrailBalance = SqlHelper.ExecuteDataset(m_Connection_String,CommandType.StoredProcedure,"usps_proSelectTrailBalance",arrParam);
			return dtStTrailBalance;
		}
		#endregion
		
		#region 显示资产负债表中的所有信息
		///usps_proSelectAssertDebt
		/// <summary>
		/// 显示资产负债表中的所有信息
		/// </summary>
		/// <param name=""></param>
		/// <returns>资产负债表中所有信息的数据集</returns>
		
		public DataSet ListAssertDebt ()
		{
			DataSet dtStAssertDebt;
			//			调用SqlHelper.ExecuteDataset方法，并使用usps_proSelectAssertDebt存储过程，并将数据集赋给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;
			//调用SqlHelper.ExecuteDataset方法，并使用usps_proSelectTotalBooks存储过程，并将数据集赋给dtStTotalBooks;
			
			dtStTotalBooks = SqlHelper.ExecuteDataset(m_Connection_String,CommandType.StoredProcedure,"usps_proSelectTotalBooks");
			return dtStTotalBooks;
		}
		#endregion

		#region 根据科目代码显示总分类账表中的所有信息
		///usps_proSelectTotalBooks001
		/// <summary>
		/// 根据科目代码显示总分类账表中的所有信息
		/// </summary>
		/// <param name=""></param>
		/// <returns>根据科目代码显示总分类账表中的所有信息</returns>
		public DataSet ListTotalBooksCnd (string subjectID)
		{
			DataSet dtStTotalBooks;
			SqlParameter [] arrParam=new SqlParameter[1];
			//		给arrParam参数赋值(参考SqlDataAccess类)
			arrParam[0]=new SqlParameter("@subjectID",subjectID);
			//调用SqlHelper.ExecuteDataset方法，并使用usps_proSelectTotalBooks001存储过程，并将数据集赋给dtStTotalBooks;
			dtStTotalBooks = SqlHelper.ExecuteDataset(m_Connection_String,CommandType.StoredProcedure,"usps_proSelectTotalBooks001",arrParam);
			return dtStTotalBooks;
		}
		#endregion

		#region 显示日记账表中的所有信息
		/// <summary>
		/// 显示日记账表中的所有信息
		/// </summary>
		/// <param name=""></param>
		/// <returns>日记账表中的所有信息的数据集</returns>
		public DataSet ListDiary ()
		{
			DataSet dtStDiary;
			//调用SqlHelper.ExecuteDataset方法，并使用usps_proSelectDirayQuery存储过程，并将数据集赋给dtStDiary;
			
			dtStDiary = SqlHelper.ExecuteDataset(m_Connection_String,CommandType.StoredProcedure,"usps_proSelectDirayQuery");
			return dtStDiary;
		}
		#endregion

		#region 根据科目代码显示日记账表中的信息
		/// <summary>
		/// 根据科目代码显示日记账表中的信息
		/// </summary>
		/// <param name=""></param>
		/// <returns>明细账表中信息的数据集</returns>
		public DataSet ListDiaryCnd (string subjectID)
		{
			DataSet dtStDiaryCnd;
			SqlParameter [] arrParam=new SqlParameter[1];
			//		给arrParam参数赋值(参考SqlDataAccess类)
			arrParam[0]=new SqlParameter("@subjectID",subjectID);
			//调用SqlHelper.ExecuteDataset方法，并使用usps_proSelectDirayQuery001存储过程，并将数据集赋给dtStDiaryCnd;
			dtStDiaryCnd = SqlHelper.ExecuteDataset(m_Connection_String,CommandType.StoredProcedure,"usps_proSelectDirayQuery001",arrParam);
			return dtStDiaryCnd;
		}
		#endregion
	}
}