SQLServerDAL/orders.cs

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

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

using System;
using System.Data;
using System.Text;
using System.Data.SqlClient;
using CAI.SHOP.IDAL;
using Maticsoft.DBUtility;//请先添加引用
namespace CAI.SHOP.SQLServerDAL
{
	/// <summary>
	/// 数据访问类orders。
	/// </summary>
	public class orders:Iorders
	{
		public orders()
		{}
		#region  成员方法

		/// <summary>
		/// 是否存在该记录
		/// </summary>
		public bool Exists(int oid)
		{
			StringBuilder strSql=new StringBuilder();
			strSql.Append("select count(1) from orders");
			strSql.Append(" where oid=@oid ");
			SqlParameter[] parameters = {
					new SqlParameter("@oid", SqlDbType.Int,4)};
			parameters[0].Value = oid;

			return DbHelperSQL.Exists(strSql.ToString(),parameters);
		}

        public void Getoid()
        {

            StringBuilder strSql = new StringBuilder();
            strSql.Append("SELECT @@IDENTITY AS 'Identity'");
             DbHelperSQL.Query(strSql.ToString());
        }

		/// <summary>
		/// 增加一条数据
		/// </summary>
		public int Add(CAI.SHOP.Model.orders model)
		{
			StringBuilder strSql=new StringBuilder();
			strSql.Append("insert into orders(");
			strSql.Append("orderid,username,userid,shouhuoname,address,postcode,telephone,songhuofs,fukuanfs,dingdanshijian,dingdantotal,beizhu,djifen)");
			strSql.Append(" values (");
			strSql.Append("@orderid,@username,@userid,@shouhuoname,@address,@postcode,@telephone,@songhuofs,@fukuanfs,@dingdanshijian,@dingdantotal,@beizhu,@djifen)");
            strSql.Append(";SELECT @@IDENTITY AS 'Identity'");
			SqlParameter[] parameters = {
					new SqlParameter("@orderid", SqlDbType.VarChar,50),
					new SqlParameter("@username", SqlDbType.VarChar,50),
					new SqlParameter("@userid", SqlDbType.Int,4),
					new SqlParameter("@shouhuoname", SqlDbType.VarChar,50),
					new SqlParameter("@address", SqlDbType.NVarChar,200),
					new SqlParameter("@postcode", SqlDbType.NVarChar,50),
					new SqlParameter("@telephone", SqlDbType.NVarChar,50),
					new SqlParameter("@songhuofs", SqlDbType.NVarChar,50),