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: 在此處添加構(gòu)造函數(shù)邏輯
			//
		}

		public string confirmTrailBalance()
		{
			//期初借方
			Decimal iniDebit = 0;
			//期初貸方
			Decimal iniLoan = 0;
			//本期發(fā)生借方
			Decimal thisDebit = 0;
			//本期發(fā)生貸方
			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;
		}
	}
}