110,539
社区成员
发帖
与我相关
我的任务
分享
using System;
using System.Collections.Generic;
using System.Text;
using DAL.IDAL;
using DBProcess;
using System.Data;
using System.Data.SqlClient;
namespace DAL.SqlServerDAL
{
/// <summary>
/// 数据库数据处理
/// 编码 : Walker
/// 时间 : 2008-04-02
/// </summary>
public class PhoneInfo : IPhoneInfo
{ /// <summary>
/// 插入新的商品信息
/// </summary>
/// <param name="phoneInfo">商品信息</param>
public void InsertPhoneInfo(Model.PhoneInfo phoneInfo)
{
//插入商品的Sql命令
string insertSql = "insert into ProductsInfo values(@PhoneID,@PhoneName,@PhoneType,@PhoneUnit,@PhoneColor,@PhonePrice,@PhoneSize,@PhoneStyle,@PhoneOS,@ProvideID,@StoreAmount,@StoreID)";
//设置参数
SqlParameter[] parasInsert = new SqlParameter[]{
new SqlParameter("@PhoneID",SqlDbType.Char),
new SqlParameter("@PhoneName",SqlDbType.VarChar),
new SqlParameter("@PhoneType",SqlDbType.VarChar),
new SqlParameter("@PhoneUnit",SqlDbType.Char),
new SqlParameter("@PhoneColor",SqlDbType.Char),
new SqlParameter("@PhonePrice",SqlDbType.Money),
new SqlParameter("@PhoneSize",SqlDbType.VarChar),
new SqlParameter("@PhoneStyle",SqlDbType.VarChar),
new SqlParameter("@PhoneOS",SqlDbType.VarChar),
new SqlParameter("@ProvideID",SqlDbType.Int),
new SqlParameter("@StoreAmount",SqlDbType.Int),
new SqlParameter("@StoreID",SqlDbType.Int)
};
//为参数赋值
parasInsert[0].Value = phoneInfo.PhoneID;
parasInsert[1].Value = phoneInfo.PhoneName;
parasInsert[2].Value = phoneInfo.PhoneType;
parasInsert[3].Value = phoneInfo.PhoneUnit;
parasInsert[4].Value = phoneInfo.PhoneColor;
parasInsert[5].Value = phoneInfo.PhonePrice;
parasInsert[6].Value = phoneInfo.PhoneSize;
parasInsert[7].Value = phoneInfo.PhoneStyle;
parasInsert[8].Value = phoneInfo.PhoneOS;
parasInsert[9].Value = phoneInfo.ProvideID;
parasInsert[10].Value = phoneInfo.StoreAmount;
parasInsert[11].Value = phoneInfo.StoreID;
//执行插入
SqlHelper.ExecuteSqlCommond(insertSql , parasInsert);
}
/// <summary>
/// 更新商品信息的方法
/// </summary>
/// <param name="phoneInfo">商品信息</param>
public void UpdatePhoneInfo(Model.PhoneInfo phoneInfo)
{
//更新商品信息的Sql命令
string updateSql = "update ProductsInfo set PhoneName=@PhoneName,PhoneType=@PhoneType,PhoneUnit=@PhoneUnit,PhoneColor=@PhoneColor,PhonePrice=@PhonePrice,PhoneSize=@PhoneSize,PhoneStyle=@PhoneStyle,PhoneOS=@PhoneOS,ProvideID=@ProvideID,StoreAmount=@StoreAmount,StoreID=@StoreID where PhoneID = @PhoneID";
//设置参数
SqlParameter[] updateParas = new SqlParameter[]{
new SqlParameter("@PhoneName",SqlDbType.VarChar),
new SqlParameter("@PhoneType",SqlDbType.VarChar),
new SqlParameter("@PhoneUnit",SqlDbType.Char),
new SqlParameter("@PhoneColor",SqlDbType.Char),
new SqlParameter("@PhonePrice",SqlDbType.Money),
new SqlParameter("@PhoneSize",SqlDbType.VarChar),
new SqlParameter("@PhoneStyle",SqlDbType.VarChar),
new SqlParameter("@PhoneOS",SqlDbType.VarChar),
new SqlParameter("@ProvideID",SqlDbType.Int),
new SqlParameter("@StoreAmount",SqlDbType.Int),
new SqlParameter("@StoreID",SqlDbType.Int),
new SqlParameter("@PhoneID",SqlDbType.Char)
};
//为参数赋值
updateParas[0].Value = phoneInfo.PhoneName;
updateParas[1].Value = phoneInfo.PhoneType;
updateParas[2].Value = phoneInfo.PhoneUnit;
updateParas[3].Value = phoneInfo.PhoneColor;
updateParas[4].Value = phoneInfo.PhonePrice;
updateParas[5].Value = phoneInfo.PhoneSize;
updateParas[6].Value = phoneInfo.PhoneStyle;
updateParas[7].Value = phoneInfo.PhoneOS;
updateParas[8].Value = phoneInfo.ProvideID;
updateParas[9].Value = phoneInfo.StoreAmount;
updateParas[10].Value = phoneInfo.StoreID;
updateParas[11].Value = phoneInfo.PhoneID;
//执行更新
SqlHelper.ExecuteSqlCommond(updateSql , updateParas);
}
/// <summary>
/// 删除商品信息
/// </summary>
/// <param name="PhoneID">商品编号</param>
public void DeletePhoneInfo(string PhoneID)
{
//删除商品信息的Sql命令
string deleteSql = "delete from ProductsInfo where PhoneID=" + "'" + PhoneID + "'";
//执行删除
SqlHelper.ExecuteSqlCommond(deleteSql);
}
}
}