ÕâÖÖд·¨ÊDz»ÊÇÎÞ·¨±ÜÃâsql×¢È룿

C# code:

using System;
using System.Collections;
using System.Text;
using System.Data;
using Microsoft.ApplicationBlocks.Data;
using System.Data.SqlClient;

namespace ClothingCode
{
/// <summary>
/// ¹ÜÀíÔ±ºǫ́¶ÔÍøÕ¾¹ã¸æµÄÌí¼ÓºÍɾ³ý
/// </summary>
public class AD
{
/// <summary>
/// Ìí¼Ó¹ã¸æ
/// </summary>
/// <param name="c_AD">¹ã¸æʵÌå</param>
public void InsertAD(ClothingCode.ADEntity c_AD)
{
string sqlString = "insert into [C_AD](ADTitle,ADContent,ADType,ADPhoto,ADUrl)" +
"values(N'" + c_AD.ADTitle + "',N'" + c_AD.ADContent + "'," + c_AD.ADType + ",N'" + c_AD.ADPhoto + "',N'" + c_AD.ADUrl + "')";
object obj = SqlHelper.ExecuteNonQuery(ClothingCode.ClothingSystem.ConnString, CommandType.Text, sqlString);
}

/// <summary>
/// ɾ³ý¹ã¸æ
/// </summary>
/// <param name="c_AD">¹ã¸æʵÌå</param>
public void DeleteADAdmin(ClothingCode.ADEntity c_AD)
{
string sqlString = "delete from C_AD where ADID=" + c_AD.ADID + "";
SqlHelper.ExecuteNonQuery(ClothingCode.Clothi