Backup/CreateSQLSentence/ProductClassSentence.cs

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

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.Collections.Generic;
using System.Text;
using System.Configuration;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using Model;
using IDAL;
using DAL;
using System.Data;

namespace CreateSQLSentence
{
    public class ProductClassSentence : I_ProductClassManage
    {
        SQLAccess sqlManager = new SQLAccess();
        #region I_ProductClassManage 成员
        /// <summary>
        ///  产品类别添加
        /// </summary>
        /// <param name="newProductClass">新产品类别对象</param>
        /// <returns>是否添加成功</returns>
        public int ProductClassAdd(ProductClass newProductClass)
        {
            StringBuilder sql_sentence = new StringBuilder();
            sql_sentence.AppendFormat("insert into Tab_ProductClass(ProductClassName,ProductParentID,ProductClassContent) values('{0}','{1}','{2}')", newProductClass.ProductClassName1,newProductClass.ProductParentID1,newProductClass.ProductClassContent1);
            return sqlManager.ExecuteNonQuery(sql_sentence.ToString());
        }
        /// <summary>
        /// 产品类别删除
        /// </summary>
        /// <param name="De_ProductClassID">需要删除的产品类别ID</param>
        /// <returns>是否删除成功</returns>
        public int ProductClassDelete(int De_ProductClassID)
        {
            throw new Exception("The method or operation is not implemented.");
        }
        /// <summary>
        /// 产品类别查询
        /// </summary>
        /// <param name="where">查询条件</param>
        /// <returns>表类型的信息</returns>
        public DataSet ProductClassSelect(string sql_sentence_where)
        {
            StringBuilder sql_sentence = new StringBuilder();
            sql_sentence.Append("select * from Tab_ProductClass ");
            if (sql_sentence_where.Length > 0)
                sql_sentence.AppendFormat(" where {0}", sql_sentence_where);
            return sqlManager.ExecuteDataSet(sql_sentence.ToString());
        }
        /// <summary>
        /// 首页产品类别查询
        /// </summary>
        /// <returns>表类型的信息</returns>
        public DataSet ProductClassSelect()
        {
            StringBuilder sql_sentence = new StringBuilder();