trailbalance.cs

财务管理电子化网络化：操作简单；稳定安全；高度控制

using System;
using System.Data;
using System.Data.SqlClient;

namespace Mvc.Model
{
	/// <summary>
	/// TrailBalance 的摘要说明。
	/// </summary>
	public class TrailBalance
	{
		//--------------------成员声明------------------------
		private BusinessLayer.Warrant objWarrant;
		private DataSet dtSt;
		public TrailBalance()
		{
			//
			// TODO: 在此处添加构造函数逻辑
			//
		}

		public string confirmTrailBalance()
		{
			//期初借方
			Decimal iniDebit = 0;
			//期初贷方
			Decimal iniLoan = 0;
			//本期发生借方
			Decimal thisDebit = 0;
			//本期发生贷方
			Decimal thisLoan = 0;
			//期末借方
			Decimal finDebit = 0;
			//期末贷方
			Decimal finLoan = 0;
			//试算平衡
			string isBalance = "试算平衡";
			objWarrant = new BusinessLayer.Warrant();
			int _isNewAccount = 1;
			this.dtSt = objWarrant.CalTrailBalance(_isNewAccount);

			for(int i = 0;i < this.dtSt.Tables["Table"].Rows.Count;i++)
			 {
				 iniDebit = iniDebit + Decimal.Parse(this.dtSt.Tables["Table"].Rows[i].ItemArray[2].ToString().Trim());
				 iniLoan = iniLoan + Decimal.Parse(this.dtSt.Tables["Table"].Rows[i].ItemArray[3].ToString().Trim());
				 thisDebit = thisDebit + Decimal.Parse(this.dtSt.Tables["Table"].Rows[i].ItemArray[4].ToString().Trim());
				 thisLoan = thisLoan + Decimal.Parse(this.dtSt.Tables["Table"].Rows[i].ItemArray[5].ToString().Trim());
				 finDebit = finDebit + Decimal.Parse(this.dtSt.Tables["Table"].Rows[i].ItemArray[6].ToString().Trim());
				 finLoan = finLoan + Decimal.Parse(this.dtSt.Tables["Table"].Rows[i].ItemArray[7].ToString().Trim());
			 }
			 if(iniDebit != iniLoan || thisDebit != thisLoan || finDebit != finLoan)
			 {
				 isBalance = "试算不平衡";
			 }
			return isBalance;
		}
	}
}