insertintosp.cs

网上购物中介

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

namespace _3DLib
{
	/// <summary>
	/// InsertIntoSp 的摘要说明。
	/// </summary>
	public class InsertIntoSp
	{
		public InsertIntoSp()
		{
		}
		public static int insertInto(int m,string insert)
		{
			int i=0;
			string table=null;
			if(m==0)
			{
				table="展出商品";
			}
			else if(m==1)
			{
				table="出售商品";
			}
			else if(m==2)
			{
				table="提供商";
			}
			OleDbConnection con=DataBaseCon.GetCon();
			System.Data.OleDb.OleDbCommand cmd=new System.Data.OleDb.OleDbCommand();
			cmd.Connection=con;
			cmd.CommandText="insert into "+table+" values("+insert+")";
			con.Open();
			if(cmd.ExecuteNonQuery()==1)
			{
                i=1;
			}
			else i=2;
			con.Close();
			return i;
		}
		public static int checkOnlyOne(int i,string primarykey)
		{
			int k=0;
			string table=null;
			if(i==0)
			{
				table="展出商品";
			}
			else if(i==1)
			{
				table="出售商品";
			}
			OleDbConnection con=DataBaseCon.GetCon();
			System.Data.OleDb.OleDbCommand cmd=new System.Data.OleDb.OleDbCommand();
			cmd.Connection=con;
			cmd.CommandText="select * from "+table+" where ID='"+primarykey+"'";
			con.Open();
			if(cmd.ExecuteReader().HasRows)
			{
				k=1;
			}
            else k=2;
			con.Close();
			return k;
		}
		public static string insertIntoNews(string newstring,string link)
		{
			int i=0;string returnString=null;
			OleDbConnection con=DataBaseCon.GetCon();
			System.Data.OleDb.OleDbCommand cmd=new System.Data.OleDb.OleDbCommand();
			cmd.Connection=con;
		    con.Open();
			try
			{
				cmd.CommandText="insert into news(新闻描述,链接地址) values('"+newstring+"','"+link+"')";
				i=cmd.ExecuteNonQuery();
			}
			catch(Exception ee)
			{
				returnString=ee.Message;
			}
			if(i==1)
				returnString="OK";
			return returnString;
		}
		public static string insertIntoTips(string newString,string link)
		{
			int i=0;string returnString=null;
			OleDbConnection con=DataBaseCon.GetCon();
			System.Data.OleDb.OleDbCommand cmd=new System.Data.OleDb.OleDbCommand();
			cmd.Connection=con;
			con.Open();
			try
			{
				cmd.CommandText="insert into tips(信息头,链接地址) values('"+newString+"','"+link+"')";
				i=cmd.ExecuteNonQuery();
			}
			catch(Exception ee)
			{
				returnString=ee.Message;
			}
			if(i==1)
				returnString="OK";
			return returnString;
		}
	}
}