Backup/DAL/ordersMore.cs

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

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

using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using SL.Model;
using SL.DbUtility;
using System.Data.SqlClient;

namespace  SL.DAL
{
    /// <summary>
    /// [ordersMore] 数据操作类
    /// </summary>
    public class ordersMore
    {
        public ordersMore(){}
        
        /// <summary>
        /// 增加一条数据
        /// </summary>
        /// <param name="model">对象实体</param>
        public bool Insert(SL.Model.ordersMore model)
        {
            string strSql=String.Format(@"Insert Into ordersMore(pid,oid,price,quantity) 
                                        values({0},'{1}',{2},{3})",
                                        model.pid,model.oid,model.price,model.quantity);

            return AosySql.ExecuteforBool(strSql);
        }
        

        
        /// <summary>
        /// 更新一条数据
        /// </summary>
        /// <param name="model">对象实体</param>
        public bool Update(SL.Model.ordersMore model)
        {
            string strSql=String.Format(@"Update ordersMore Set 
            pid={0},oid='{1}',price={2},quantity={3} 
            Where id={4}",
            model.pid,model.oid,model.price,model.quantity,model.id);
            return AosySql.ExecuteforBool(strSql);
        }
        

        
        /// <summary>
        ///  删除一条数据
        /// </summary>
        /// <parame name="id">id</param>
        public bool Delete(int id)
        {
            string strSql=String.Format("Delete From ordersMore Where id={0}",id);
            return AosySql.ExecuteforBool(strSql);
        }
        


        /// <summary>