delete.cs

网上购物中介

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

namespace _3DLib
{
	/// <summary>
	/// Delete 的摘要说明。
	/// </summary>
	public class Delete
	{
		public Delete()
		{
			//
			// TODO: 在此处添加构造函数逻辑
			//
		}
		public static string deleteInfo(string table,string value1,string value2)
		{
			string returnString=null;
		    string tj=null;
			if(value1.Equals(""))
			{
				tj="名称='"+value2+"'";
			}
			else if(value2.Equals(""))
			{
				tj="ID='"+value1+"'";
			}
			OleDbConnection con=DataBaseCon.GetCon();
			System.Data.OleDb.OleDbCommand cmd=new System.Data.OleDb.OleDbCommand();
			cmd.Connection=con;
			cmd.CommandText="delete from "+table+" where "+tj;
            con.Open();
			if(cmd.ExecuteNonQuery()==1)
			{
				returnString="OK";
			}
			else
				returnString="!OK";
			con.Close();
			return returnString;
		}
		public static string deleteNew(string news)
		{
			OleDbConnection con=DataBaseCon.GetCon();
			System.Data.OleDb.OleDbCommand cmd=new System.Data.OleDb.OleDbCommand();
			cmd.Connection=con;
			cmd.CommandText="delete from news where 新闻描述='"+news+"'";
			con.Open();
			int i=cmd.ExecuteNonQuery();
			if(i==1)
				return "OK";
			else return "!OK";
		}
	}
}