SQLServerDAL/deliver_country.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>
	/// 数据访问类deliver_country。
	/// </summary>
	public class deliver_country:Ideliver_country
	{
		public deliver_country()
		{}
		#region  成员方法



		/// <summary>
		/// 增加一条数据
		/// </summary>
		public void Add(CAI.SHOP.Model.deliver_country model)
		{
			StringBuilder strSql=new StringBuilder();
			strSql.Append("insert into deliver_country(");
			strSql.Append("deliver_country_id,deliver_country_name,zone_id)");
			strSql.Append(" values (");
			strSql.Append("@deliver_country_id,@deliver_country_name,@zone_id)");
			SqlParameter[] parameters = {
					new SqlParameter("@deliver_country_id", SqlDbType.Int,4),
					new SqlParameter("@deliver_country_name", SqlDbType.NVarChar,1000),
					new SqlParameter("@zone_id", SqlDbType.Int,4)};
			parameters[0].Value = model.deliver_country_id;
			parameters[1].Value = model.deliver_country_name;
			parameters[2].Value = model.zone_id;

			DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
		}
		/// <summary>
		/// 更新一条数据
		/// </summary>
		public void Update(CAI.SHOP.Model.deliver_country model)
		{
			StringBuilder strSql=new StringBuilder();
			strSql.Append("update deliver_country set ");
			strSql.Append("deliver_country_id=@deliver_country_id,");
			strSql.Append("deliver_country_name=@deliver_country_name,");
			strSql.Append("zone_id=@zone_id");
			strSql.Append(" where ");
			SqlParameter[] parameters = {
					new SqlParameter("@deliver_country_id", SqlDbType.Int,4),
					new SqlParameter("@deliver_country_name", SqlDbType.NVarChar,1000),
					new SqlParameter("@zone_id", SqlDbType.Int,4)};
			parameters[0].Value = model.deliver_country_id;
			parameters[1].Value = model.deliver_country_name;
			parameters[2].Value = model.zone_id;

			DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
		}