ordermanager.cs

本系统主要针对物流供应链中的库存管理环节

using System;
using System.Data;
using System.Collections;
using SQLHolderLib;
using sql=System.Data.SqlClient;
using System.Data.SqlClient;
namespace mmcBMS_online.ClassLib
{
	/// <summary>
	/// Order 的摘要说明。
	/// </summary>
	public class OrderManager
	{
		private SQLHolder holder=new SQLHolder();
		public OrderManager()
		{
		}
		public SqlDataReader GetOrderList(string orderName,string teachManager ,string bookName,
			bool bOrderName,bool bTeachManager,bool bBookName)
		{
			sql.SqlParameter[] parms=new SqlParameter[]{
															holder.CreateInParam("@orderName",SqlDbType.VarChar,10,orderName)
														   ,holder.CreateInParam("@teachManager",SqlDbType.VarChar,10,teachManager)
														   ,holder.CreateInParam("@bookName",SqlDbType.VarChar,50,bookName)
														   ,holder.CreateInParam("@bOrderName",SqlDbType.Bit,1,bOrderName)
														   ,holder.CreateInParam("@bTeachManager",SqlDbType.Bit,1,bTeachManager)
														   ,holder.CreateInParam("@bBookName",SqlDbType.Bit,1,bBookName)
													   };
			return holder.GetDataByProc("mmcjck_online_Order_Select",parms);
		}
		public SqlDataReader GetClassUseList(string orderID)
		{
			long id;
			try
			{
				id=Convert.ToInt64(orderID);
			}
			catch
			{
				return null;
			}
			sql.SqlParameter[] parms=new SqlParameter[]{
															holder.CreateInParam("@orderID",SqlDbType.BigInt,8,id)
													   };
			return holder.GetDataByProc("mmcjck_sp_ClassUseInfo_Select",parms);
		}
		public SqlDataReader GetClass(string className)
		{
			sql.SqlParameter[] parms=new SqlParameter[]{
														   holder.CreateInParam("@className",SqlDbType.VarChar,40,className)
													   };
			return holder.GetDataByProc("mmcjck_online_Class_Select",parms);
		}
		public SqlDataReader GetBookList(string bookName)
		{
			sql.SqlParameter[] parms=new SqlParameter[]{
														   holder.CreateInParam("@BookName",SqlDbType.VarChar,50,bookName)
													   };
			return holder.GetDataByProc("mmcjck_online_Book_Select",parms);
		}
		public DataSet GetBookConcern()
		{
			return holder.GetDataByProc("mmcjck_sp_BookConcern_Select","BookConcern");
		}
		#region AddBookOrder
		public void AddBookOrder(BookOrder bookOrder,DateTime orderDate)
		{
			if(bookOrder.Book_.BookID<0)
			{
				this.AddBookOrderAll(bookOrder,orderDate);
			}
			else
			{
				this.AddBookOrderHalf(bookOrder,orderDate);
			}
		}
		private void AddBookOrderAll(BookOrder bookOrder,DateTime orderDate)
		{
			SqlParameter[] prams=new SqlParameter[]{
														   holder.CreateInParam("@ISBN",SqlDbType.VarChar,30,bookOrder.Book_.BookISBN)
														   ,holder.CreateInParam("@bookName",SqlDbType.VarChar,50,bookOrder.Book_.BookName)
														   ,holder.CreateInParam("@author",SqlDbType.VarChar,50,bookOrder.Book_.BookAuthor)
														   ,holder.CreateInParam("@bookConcernID",SqlDbType.BigInt,8,bookOrder.Book_.BookConcern_.ID)
														   ,holder.CreateInParam("@edition",SqlDbType.VarChar,10,bookOrder.Book_.BookEdition)														   
														   ,holder.CreateInParam("@price",SqlDbType.Money,8,bookOrder.Book_.BookPrice)  
														   ,holder.CreateInParam("@explain",SqlDbType.VarChar,50,bookOrder.Book_.BookExplain)
														   ,holder.CreateInParam("@need",SqlDbType.Int,4,bookOrder.Need)
														   ,holder.CreateInParam("@orderDate",SqlDbType.DateTime,
														   8,orderDate)
														   ,holder.CreateInParam("@orderName",SqlDbType.VarChar,
														   10,bookOrder.OrderName)
														   ,holder.CreateInParam("@stuNeed",SqlDbType.Int,
														   4,bookOrder.StudentNeed)
														   ,holder.CreateInParam("@teachNeed",SqlDbType.Int,
														   4,bookOrder.TeacherNeed)
														   ,holder.CreateInParam("@srManager",SqlDbType.VarChar,
														   10,bookOrder.SrManager)
														   ,holder.CreateInParam("@acaManager",SqlDbType.VarChar,
														   10,bookOrder.AcaManager)
														   ,holder.CreateInParam("@teach",SqlDbType.VarChar,
														   30,bookOrder.Teach)
														   ,holder.CreateOutParam("@orderID",SqlDbType.BigInt,8)
													   };
			int i=holder.RunProc("mmcjck_sp_BookOrder_Add_Q",prams);
			if(i==2)
			{
				bookOrder.OrderID=(long)prams[15].Value;
				this.AddClassUseInfo(bookOrder.GetUseClasses(),bookOrder.OrderID);
			}
			else
			{
				throw new ApplicationException("订单提交失败，请跟管理员联系！");
			}
		
		}
		private void AddBookOrderHalf(BookOrder bookOrder,DateTime orderDate)
		{
			SqlParameter[] prams=new SqlParameter[]{
														   holder.CreateInParam("@storeID",SqlDbType.BigInt,
														   8,bookOrder.Book_.BookID)
														   ,holder.CreateInParam("@need",SqlDbType.Int,
														   4,bookOrder.Need)
														   ,holder.CreateInParam("@orderDate",SqlDbType.DateTime,
														   8,orderDate)
														   ,holder.CreateInParam("@orderName",SqlDbType.VarChar,
														   10,bookOrder.OrderName)
														   ,holder.CreateInParam("@stuNeed",SqlDbType.Int,
														   4,bookOrder.StudentNeed)
														   ,holder.CreateInParam("@teachNeed",SqlDbType.Int,
														   4,bookOrder.TeacherNeed)
														   ,holder.CreateInParam("@srManager",SqlDbType.VarChar,
														   10,bookOrder.SrManager)
														   ,holder.CreateInParam("@acaManager",SqlDbType.VarChar,
														   10,bookOrder.AcaManager)
														   ,holder.CreateInParam("@teach",SqlDbType.VarChar,
														   30,bookOrder.Teach)
														   ,holder.CreateOutParam("@orderID",SqlDbType.BigInt,8)
													   };
			int i=holder.RunProc("mmcjck_sp_BookOrder_Add",prams);
			if(i==2)
			{
				bookOrder.OrderID=(long)prams[9].Value;
				this.AddClassUseInfo(bookOrder.GetUseClasses(),bookOrder.OrderID);
			}
			else
			{
				throw new ApplicationException("订单提交失败，请跟管理员联系！");
			}
		}
		private void AddClassUseInfo(Hashtable classUseInfos,long orderID)
		{
			if(classUseInfos!=null)
			{
				foreach(object obj in classUseInfos.Values)
				{
					UseClass classUseInfo=obj as UseClass;
					SqlParameter[] prams=new SqlParameter[]{
																   holder.CreateInParam("@bjdm",SqlDbType.BigInt,
																   8,classUseInfo.ClassID)
																   ,holder.CreateInParam("@orderID",SqlDbType.BigInt,
																   8,orderID)
																   ,holder.CreateInParam("@courseName",SqlDbType.VarChar,
																   50,classUseInfo.CourseName)
																   ,holder.CreateInParam("@useTime",SqlDbType.VarChar,
																   10,classUseInfo.UseYear)

															   };
					int i=holder.RunProc("mmcjck_sp_ClassUseInfo_Add",prams);
					if(i==0)
					{
						throw new ApplicationException ("用书班级添加有误，请跟管理员联系！");
					}
				}
			}

		}
		#endregion
		public string AddBookConcern(string bookConcernName)
		{
			sql.SqlParameter[] parms=new SqlParameter[]{
														   holder.CreateInParam("@BookConcernName",SqlDbType.VarChar,30,bookConcernName)
													   };
			int i= holder.RunProc("mmcjck_sp_BookConcern_Add",parms);
			if(i<=0)
			{
				return "出版社添加失败，或者该出版社已经存在！";
			}
			else
			{
				return "出版社添加成功！请按“返回”";
			}
		}
	}
}