addbooks.cs

.NET编写的小型图书管理系统,里面有详细说明,源码,发布软件包和数据库文件,本人本科时设计编写

using System.Data;
using bookShop.classLib.dbLib;

namespace bookShop.classLib.dataLayer
{
	/// <summary>
	/// AddBooks 的摘要说明。
	/// </summary>
	public class AddBooks
	{
		public AddBooks(string bookNo,string bookName,string author,string publishingHouse,string derivePrice,string retailPrice,string wholePrice,int count)
		{
			DataSetDBConnect dsc=new DataSetDBConnect("Book1");
			dsc.StrSQL="select * from Book where BookNo='"+bookNo+"'";
			dsc.Do();	
			DataRow rowTemp=null;
			if(dsc.ObjDataSet.Tables["Book1"].Rows.Count==0)
			{
				rowTemp=dsc.ObjDataSet.Tables["Book1"].NewRow();
				rowTemp["BookNo"]=bookNo;
				rowTemp["BookName"]=bookName;
				rowTemp["Author"]=author;
				rowTemp["PublishingHouse"]=publishingHouse;
				rowTemp["DerivePrice"]=derivePrice;
				rowTemp["RetailPrice"]=retailPrice;
				rowTemp["WholePrice"]=wholePrice;
				rowTemp["Stocks"]=count;
				rowTemp["SaledNo"]=0;
				dsc.ObjDataSet.Tables["Book1"].Rows.Add(rowTemp);
			}
			else
			{
				int sum=(int)dsc.ObjDataSet.Tables["Book1"].Rows[0]["Stocks"]+count;
				rowTemp=dsc.ObjDataSet.Tables["Book1"].Rows[0];
				rowTemp["Stocks"]=sum;
				rowTemp["BookName"]=bookName;
				rowTemp["Author"]=author;
				rowTemp["PublishingHouse"]=publishingHouse;
				rowTemp["DerivePrice"]=derivePrice;
				rowTemp["RetailPrice"]=retailPrice;
				rowTemp["WholePrice"]=wholePrice;
			}
			dsc.WriteBack();
			dsc.Close();
		}
	}
}