Project.Dal/ArticleDal.cs

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

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

using System;
using System.Text;
using System.Collections.Generic;
using System.Data;
using System.Data.Common;
using System.Data.SqlClient;
using Project.Model;
using System.Data;
using Project.Common;

///========================================================================
/// Project: 权限系统	
/// Copyright: Copyright (c) 2007
/// Company: 
///========================================================================

namespace Project.Dal
{

	/// <summary>
	///Title: Article类
	///Description: Article表SQLServer数据库操作实现代码
	///@author xu
	///@version 1.0.0.0
	///@date 2012-9-21
	///@modify 
	///@date 
	/// </summary>
	public class ArticleDal
	{		
		#region 数据库基本操作方法
		

		/// <summary>
		/// 在dbo.Article中新增一条记录,支持数据库事务
		/// </summary>
		/// <param name="model">包含被插入数据的实体对象</param>
		/// <param name="trans">事务参数</param>
		/// <returns>影响行数</returns>
		public int Insert(Article model,SqlTransaction trans)
		{
			const string sql = "INSERT INTO Article (TypeId,Title,Author,FromWhere,ZhaiYao,ImageUrl,ContentInfo,IsTop,IsCommed,AddTime,MetaKeys,MetaDes) VALUES (@TypeId,@Title,@Author,@FromWhere,@ZhaiYao,@ImageUrl,@ContentInfo,@IsTop,@IsCommed,@AddTime,@MetaKeys,@MetaDes)";
			
			SqlParameter[]parms = GetParms(model);
			
			int n = 0;
            try
            {
                if (trans == null)
                    n = SQLHelper.ExecuteNonQuery(SQLHelper.ConnectionString, CommandType.Text, sql, parms);
                else
                    n = SQLHelper.ExecuteNonQuery(trans, CommandType.Text, sql, parms);
            }
            catch (Exception ex)
            {
                //Common.Log4NET.Log4Net.Error(ex.ToString(), ex);
            }
            return n;
		}