accountbookmanager.cs

《C#和.NET第一步》中的财务系统 利用三层结构做的

using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using Common;
namespace Business
{
	public class AccountBookManager
	{
		public DataSet GetAccountBooks(string uid)
		{
			string sql = string.Format("SELECT * FROM T_AccountBook WHERE AUID='{0}'", uid);
			return new DataAccess.AccountBooks().GetAccountBooks(sql);
		}
	public bool Insert(AccountBook t)
	{
		return new DataAccess.AccountBooks().Insert(t);
	}

	public DataSet GetDailyAccountBooks(string uid)
	{
		string sql = string.Format("SELECT 名称=AName,类型=AType,币种=AMoneyType,说明=ARemarks,余额=(SELECT sum(BDINMoney)-sum(BDOUTMoney) FROM dbo.T_BillDaily WHERE BAID=AID) FROM T_AccountBook  WHERE AUID='{0}' AND AType='{1}'", uid, BillType.Daily);
		
		DataSet ds = new DataAccess.AccountBooks().GetAccountBooks(sql);

		return ds;
	}
	public DataSet GetInvestAccountBooks(string uid)
	{
		string sql ="SELECT 帐薄名称=AName,类型=AType,币种=AMoneyType,说明=ARemarks,余额=";
		sql +="( (SELECT SUM(BICopys*BIPrice) FROM dbo.T_BillInvest WHERE BIType='卖出' AND BIAID=AID)";
		sql +="-(SELECT SUM(BICopys*BIPrice) FROM dbo.T_BillInvest WHERE BIType='买入' AND BIAID=AID) ) ";
		sql += string.Format("FROM T_AccountBook WHERE AUID='{0}' AND AType='{1}'", uid, BillType.Invest);

		DataSet ds = new DataAccess.AccountBooks().GetAccountBooks(sql);
		return ds;
	}	
	}
}