g.hnyhua.cn/Mtxfw.DAL/Link.cs

using System;
using System.Data;
using System.Text;
using System.Data.SqlClient;
using Wuqi.Webdiyer;

namespace Mtxfw.DAL
{
	/// <summary>
	/// 数据访问类:Link
	/// </summary>
    public partial class Link : Mtxfw.Utility.Myabstract
	{
        public Link() : base("Link") { }

		/// <summary>
		/// 增加一条数据
		/// </summary>
		public int Add(Mtxfw.Model.Link model)
		{
			StringBuilder strSql=new StringBuilder();
			strSql.Append("insert into Link(");
			strSql.Append("LinkName,LinkUrl,LinkImg)");
			strSql.Append(" values (");
			strSql.Append("@LinkName,@LinkUrl,@LinkImg)");
			strSql.Append(";select SCOPE_IDENTITY()");
			SqlParameter[] parameters = {
					new SqlParameter("@LinkName", SqlDbType.NVarChar,80),
					new SqlParameter("@LinkUrl", SqlDbType.NVarChar,120),
					new SqlParameter("@LinkImg", SqlDbType.NVarChar,200)};
			parameters[0].Value = model.LinkName;
			parameters[1].Value = model.LinkUrl;
			parameters[2].Value = model.LinkImg;

            return  Mtxfw.Utility.SqlDbHelper_U.ExecuteCmd(strSql.ToString(), parameters);
		}
		/// <summary>
		/// 更新一条数据
		/// </summary>
		public int Update(Mtxfw.Model.Link model)
		{
			StringBuilder strSql=new StringBuilder();
			strSql.Append("update Link set ");
			strSql.Append("LinkName=@LinkName,");
			strSql.Append("LinkUrl=@LinkUrl,");
			strSql.Append("LinkImg=@LinkImg");
			strSql.Append(" where ID=@ID");
			SqlParameter[] parameters = {
					new SqlParameter("@LinkName", SqlDbType.NVarChar,80),
					new SqlParameter("@LinkUrl", SqlDbType.NVarChar,120),
					new SqlParameter("@LinkImg", SqlDbType.NVarChar,200),
					new SqlParameter("@ID", SqlDbType.Int,4)};
			parameters[0].Value = model.LinkName;
			parameters[1].Value = model.LinkUrl;
			parameters[2].Value = model.LinkImg;
			parameters[3].Value = model.ID;

			return Mtxfw.Utility.SqlDbHelper_U.ExecuteCmd(strSql.ToString(),parameters);
		}

		/// <summary>
		/// 删除一条数据
		/// </summary>
		public bool Delete(int ID)
		{
			
			StringBuilder strSql=new StringBuilder();
			strSql.Append("delete from Link ");
			strSql.Append(" where ID=@ID");
			SqlParameter[] parameters = {
					new SqlParameter("@ID", SqlDbType.Int,4)
            };
			parameters[0].Value = ID;

            int rows = Mtxfw.Utility.SqlDbHelper_U.ExecuteCmd(strSql.ToString(), parameters);
			if (rows > 0)
			{
				return true;
			}
			else
			{
				return false;
			}
		}
		/// <summary>
		/// 删除一条数据
		/// </summary>
		public bool DeleteList(string IDlist )
		{
			StringBuilder strSql=new StringBuilder();
			strSql.Append("delete from Link ");
			strSql.Append(" where ID in ("+IDlist + ")  ");
			int rows=Mtxfw.Utility.SqlDbHelper_U.ExecuteCmd(strSql.ToString());
			if (rows > 0)
			{
				return true;
			}
			else
			{
				return false;
			}
		}


		/// <summary>
		/// 得到一个对象实体
		/// </summary>
        public Mtxfw.Model.Link GetModel(int ID)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("select  top 1 ID,LinkName,LinkUrl,LinkImg,CreateTime from Link ");
            strSql.Append(" where ID=@ID");
            SqlParameter[] parameters = {
					new SqlParameter("@ID", SqlDbType.Int,4)
            };
            parameters[0].Value = ID;

            Mtxfw.Model.Link model = new Mtxfw.Model.Link();
            DataSet ds = Mtxfw.Utility.SqlDbHelper_U.GetDataSet(strSql.ToString(), parameters);
            if (ds.Tables[0].Rows.Count > 0)
            {
                if (ds.Tables[0].Rows[0]["ID"].ToString() != "")
                {
                    model.ID = int.Parse(ds.Tables[0].Rows[0]["ID"].ToString());
                }
                model.LinkName = ds.Tables[0].Rows[0]["LinkName"].ToString();
                model.LinkUrl = ds.Tables[0].Rows[0]["LinkUrl"].ToString();
                model.LinkImg = ds.Tables[0].Rows[0]["LinkImg"].ToString();
                if (ds.Tables[0].Rows[0]["CreateTime"].ToString() != "")
                {
                    model.CreateTime = DateTime.Parse(ds.Tables[0].Rows[0]["CreateTime"].ToString());
                }
                return model;
            }
            else
            {
                return null;
            }
        }

		/// <summary>
		/// 获得数据列表
		/// </summary>
		public DataSet GetList(string strWhere)
		{
			StringBuilder strSql=new StringBuilder();
			strSql.Append("select ID,LinkName,LinkUrl,LinkImg,CreateTime ");
			strSql.Append(" FROM Link ");
			if(strWhere.Trim()!="")
			{
				strSql.Append(" where "+strWhere);
			}
            return Mtxfw.Utility.SqlDbHelper_U.GetDataSet(strSql.ToString());
		}

		/// <summary>
		/// 获得前几行数据
		/// </summary>
		public DataSet GetList(int Top,string strWhere,string filedOrder)
		{
			StringBuilder strSql=new StringBuilder();
			strSql.Append("select ");
			if(Top>0)
			{
				strSql.Append(" top "+Top.ToString());
			}
			strSql.Append(" ID,LinkName,LinkUrl,LinkImg,CreateTime ");
			strSql.Append(" FROM Link ");
			if(strWhere.Trim()!="")
			{
				strSql.Append(" where "+strWhere);
			}
			strSql.Append(" order by " + filedOrder);
			return Mtxfw.Utility.SqlDbHelper_U.GetDataSet(strSql.ToString());
		}
	}
}