product.cs

来自「本论文叙述了联机考试系统的现状以及C#语言的概况。重点介绍了联机考试系统的实现过」· CS 代码 · 共 39 行

using System;
using System.Data;
using System.Data.OleDb;

namespace SupermarketProject
{
	/// <summary>
	/// Summary description for Product.
	/// </summary>
	public class Product
	{
		public Product()
		{
			
		}

		public void AddProduct(DataRow drPrd)
		{

		string str="Insert into Products values('"+
		drPrd["ProductId"]+"','"+drPrd["ProductName"]+"','"+drPrd["ProductNo"]+"','"+drPrd["ProductDesc"]+"',"+drPrd["QOH"]+",'"+drPrd["Units"]+"','"+drPrd["CatCode"]+"');";
		Console.WriteLine(str);
		DataConnection.commnd.CommandText=str;
		DataConnection.commnd.ExecuteNonQuery ();
		Console.WriteLine("added");

		}

		public void ModifyProduct(DataRow drPrd)
	{
			string str="Update Products set ProductName='"+drPrd["ProductName"]+"', ProductNo='"+drPrd["ProductNo"]+"', ProductDesc='"+drPrd["ProductDesc"]+"',QOH="+drPrd["QOH"]+",Units='"+drPrd["Units"]+"' where ProductId='"+drPrd["ProductId"]+"';";			

            DataConnection.commnd.CommandText = str;
			DataConnection.commnd.ExecuteNonQuery(); 

		}
	}
}