readcardfacade.cs

会员管理系统

using System;
using System.Data;
using com.sungoal.MemberManage.Common;
using com.sungoal.MemberManage.DataAccess;

namespace com.sungoal.MemberManage.BusinessFacade
{
	/// <summary>
	/// Summary description for ReadCardFacade.
	/// </summary>
	public class ReadCardFacade
	{
		public ReadCardFacade()
		{
			//
			// TODO: Add constructor logic here
			//
		}

		/// <summary>
		/// 生成阅读卡
		/// </summary>
		/// <param name="adminID">管理员ID，从SESSION中获取</param>
		/// <param name="number">阅读卡张数</param>
		/// <param name="money">阅读卡金额</param>
		/// <param name="validDate">有效期</param>
		/// <param name="remark">备注</param>
		/// <returns>成功返回 1</returns>
		public int Add(string adminID, int number, int money, DateTime validDate, string remark)
		{
			// 1。检查管理员ID是不是管理员
			// 2。在阅读卡信息表中插入记录
			ReadCardDAL readCardDAL = new ReadCardDAL();
			UserDAL userDAL = new UserDAL();

			int check = userDAL.IsAdmin(adminID);

			if (check == 1)
			{
				string[] newID = new string[number];
				string[] password = new string[number];

				newID = readCardDAL.CreateNewID(number);
				password = readCardDAL.CreateNewID(number);

				ReadCardData.ReadCardInfoDataTable table = new ReadCardData().ReadCardInfo;
				for (int i = 0; i < number; i ++)
				{
					ReadCardData.ReadCardInfoRow row = (ReadCardData.ReadCardInfoRow)table.NewReadCardInfoRow();
					row.CardID = newID[i];
					row.Cash = money;
					row.GenDate = DateTime.Now;
					row.Password = password[i];
					row.Remark = remark;
					row.Status = "1";
					row.ValidDate = validDate;
					table.Rows.Add(row);
				}

				string[] insert = OleDBHelper.GetInsertSql(table, "ReadCardInfo");
				check = new OleDBHelper().ExecuteSQL(insert);
			}

			return check;
		}

		/// <summary>
		/// 获取阅读卡信息列表
		/// </summary>
		/// <param name="adminID">管理员ID，从SESSION中获取</param>
		/// <param name="table">用来接收数据的数据表</param>
		/// <returns>
		/// 1：操作成功
		/// 其他：操作失败
		/// </returns>
		public int GetReadCardList(string adminID, ref DataTable table)
		{
			// 1。检查管理员ID是不是管理员
			// 2。从阅读卡信息表中获取相应列表
			ReadCardDAL readCardDAL = new ReadCardDAL();
			UserDAL userDAL = new UserDAL();

			int check = userDAL.IsAdmin(adminID);

			if (check == 1)
			{
				table = readCardDAL.GetReadCardList();
			}

			return check;
		}

		/// <summary>
		/// 获取阅读卡信息
		/// </summary>
		/// <param name="adminID">管理员ID，从SESSION中获取</param>
		/// <param name="cardID">阅读卡ID</param>
		/// <param name="table">用来接收数据的数据表</param>
		/// <returns>
		/// 1：操作成功
		/// 其他：操作失败
		/// </returns>
		public int GetReadCardInfo(string adminID, string cardID, ref DataTable table)
		{
			// 1。检查管理员ID是不是管理员
			// 2。从阅读卡信息表中获取相应记录
			ReadCardDAL readCardDAL = new ReadCardDAL();
			UserDAL userDAL = new UserDAL();

			int check = userDAL.IsAdmin(adminID);

			if (check == 1)
			{
				table = readCardDAL.GetReadCardListByCardID(cardID);
			}

			return check;
		}
	}
}