OleDbDAL/product.cs

（开头部分） 20KB

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.Data.OleDb;
using ClothesShop.DBUtility;

namespace ClothesShop.OleDbDAL
{
    public class product : ClothesShop.IDAL.Iproduct
    {
        /// <summary>
        /// 创建一个商品
        /// </summary>
        /// <param name="productname">商品名称</param>
        /// <param name="typeid_1">商品一级分类</param>
        /// <param name="typeid_2">商品二级分类</param>
        /// <param name="recommended">是否推荐</param>
        /// <param name="specials">是否特价</param>
        /// <param name="price">商品原价</param>
        /// <param name="userprice">会员价格</param>
        /// <param name="specialsprice">推荐价格</param>
        /// <param name="pointcount">点击数量</param>
        /// <param name="imagepath">图片路径</param>
        /// <param name="count">商品库存数量</param>
        /// <param name="count">销售数量</param>
        /// <param name="description">商品描述</param>
        /// <returns></returns>
        public int createproduct(string productname, int typeid_1, int typeid_2, bool recommended, bool specials, double price,
            double userprice, double specialsprice, int pointcount, string imagepath, int count, int sellcount, string description)
        {
            StringBuilder sb = new StringBuilder();
            sb.Append("insert into products (productname,typeid_1,typeid_2,recommended,specials,price,");
            sb.Append("userprice,specialsprice,pointcount,imagepath,[count],[sellcount],[description]) values (");
            sb.Append("@productname,@typeid_1,@typeid_2,@recommended,@specials,@price,@userprice,");
            sb.Append("@specialsprice,@pointcount,@imagepath,@count,@sellcount,@description)");
            OleDbParameter[] param = 
                                    {
                                        OleDbHelper.GetParameter("@productname",OleDbType.Char,50,"productname",productname),
                                        OleDbHelper.GetParameter("@typeid_1",OleDbType.Integer,4,"typeid_1",typeid_1),
                                        OleDbHelper.GetParameter("@typeid_2",OleDbType.Integer,4,"typeid_2",typeid_2),
                                        OleDbHelper.GetParameter("@recommended",OleDbType.Boolean,recommended),
                                        OleDbHelper.GetParameter("@specials",OleDbType.Boolean,specials),
                                        OleDbHelper.GetParameter("@price",OleDbType.Double,8,"price",price),
                                        OleDbHelper.GetParameter("@userprice",OleDbType.Double,8,"userprice",userprice),
                                        OleDbHelper.GetParameter("@specialsprice",OleDbType.Double,8,"specialsprice",specialsprice),
                                        OleDbHelper.GetParameter("@pointcount",OleDbType.Integer,4,"pointcount",pointcount),
                                        OleDbHelper.GetParameter("@imagepath",OleDbType.Char,100,"imagepath",imagepath),
                                        OleDbHelper.GetParameter("@count",OleDbType.Integer,4,"[count]",count),
                                        OleDbHelper.GetParameter("@sellcount",OleDbType.Integer,4,"[sellcount]",sellcount),
                                        OleDbHelper.GetParameter("@description",OleDbType.Char,description)
                                    };
            return OleDbHelper.ExecuteSql(sb.ToString(), param);
        }

        /// <summary>
        /// 删除一个商品
        /// </summary>
        /// <param name="productid"></param>
        /// <returns></returns>
后面还有 319 行代码，购买后查看完整代码

24 小时内免费解锁 3 个项目，之后 1 算力/个。 规则说明

AI 解读 AI

登录后可用，每次 10 算力，解读结果公开显示在下面。

还没有人解读过这个文件。