using System;
using System.Data;
using System.Text;
using System.Data.SqlClient;

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

        /// <summary>
        /// 增加一条数据
        /// </summary>
        public int Add(Mtxfw.Model.Article model)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("insert into Article(");
            strSql.Append("senderid,receiverid,Title,AddTime,Author,Content,Content2,CategoryId,ParentID,Paths,Paths2,KeyWords,media_id,thumb_media_id,wtype,wtype2,LinkID,Seef,gtype)");
            strSql.Append(" values (");
            strSql.Append("@senderid,@receiverid,@Title,@AddTime,@Author,@Content,@Content2,@CategoryId,@ParentID,@Paths,@Paths2,@KeyWords,@media_id,@thumb_media_id,@wtype,@wtype2,@LinkID,@Seef,@gtype)");
            strSql.Append(";select SCOPE_IDENTITY()");
            SqlParameter[] parameters = {
                    new SqlParameter("@senderid", SqlDbType.Int),
                    new SqlParameter("@receiverid", SqlDbType.Int),
					new SqlParameter("@Title", SqlDbType.VarChar,200),
					new SqlParameter("@AddTime", SqlDbType.DateTime),
					new SqlParameter("@Author", SqlDbType.VarChar,250),
					new SqlParameter("@Content", SqlDbType.Text),
                    new SqlParameter("@Content2", SqlDbType.Text),
					new SqlParameter("@CategoryId", SqlDbType.VarChar,50),
					new SqlParameter("@ParentID", SqlDbType.Int,4),
                    new SqlParameter("@Paths", SqlDbType.VarChar,8000),
                    new SqlParameter("@Paths2", SqlDbType.VarChar,250),
                    new SqlParameter("@KeyWords", SqlDbType.VarChar,250),
                    new SqlParameter("@media_id", SqlDbType.VarChar,250),
                    new SqlParameter("@thumb_media_id", SqlDbType.VarChar,250),
                    new SqlParameter("@wtype", SqlDbType.Int,4),
                    new SqlParameter("@wtype2", SqlDbType.Int,4),
                    new SqlParameter("@LinkID", SqlDbType.Int,4),
                    new SqlParameter("@Seef", SqlDbType.Int,4),
                    new SqlParameter("@gtype", SqlDbType.Int)};
            parameters[0].Value = model.senderid;
            parameters[1].Value = model.receiverid;
            parameters[2].Value = model.Title;
            parameters[3].Value = model.AddTime;
            parameters[4].Value = model.Author;
            parameters[5].Value = model.Content;
            parameters[6].Value = model.Content2;
            parameters[7].Value = model.CategoryId;
            parameters[8].Value = model.ParentID;
            parameters[9].Value = model.Paths;
            parameters[10].Value = model.Paths2;
            parameters[11].Value = model.KeyWords;
            parameters[12].Value = model.media_id;
            parameters[13].Value = model.thumb_media_id;
            parameters[14].Value = model.wtype;
            parameters[15].Value = model.wtype2;
            parameters[16].Value = model.LinkID;
            parameters[17].Value = model.Seef;
            parameters[18].Value = model.gtype;
            string obj = Mtxfw.Utility.SqlDbHelper_U.GetObject(strSql.ToString(), parameters).ToString();
            if (obj == "")
            {
                return 0;
            }
            else
            {
                return Convert.ToInt32(obj);
            }
        }
        /// <summary>
        /// 更新一条数据
        /// </summary>
        public void Update(Mtxfw.Model.Article model)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("update Article set ");
            strSql.Append("senderid=@senderid,");
            strSql.Append("receiverid=@receiverid,");
            strSql.Append("Title=@Title,");
            strSql.Append("AddTime=@AddTime,");
            strSql.Append("Author=@Author,");
            strSql.Append("Content=@Content,");
            strSql.Append("Content2=@Content2,");
            strSql.Append("CategoryId=@CategoryId,");
            strSql.Append("ParentID=@ParentID,");
            strSql.Append("Paths=@Paths,");
            strSql.Append("Paths2=@Paths2,");
            strSql.Append("KeyWords=@KeyWords,");
            strSql.Append("media_id=@media_id,");
            strSql.Append("thumb_media_id=@thumb_media_id,");
            strSql.Append("jlsecond=@jlsecond,");
            strSql.Append("xfjmoney=@xfjmoney,");
            strSql.Append("tfllmoney=@tfllmoney,");
            strSql.Append("zscs=@zscs,");
            strSql.Append("gxzmoney=@gxzmoney,");
            strSql.Append("ltype=@ltype,");
            strSql.Append("csday=@csday,");
            strSql.Append("latitude=@latitude,");
            strSql.Append("longitude=@longitude,");
            strSql.Append("wtype=@wtype,");
            strSql.Append("wtype2=@wtype2,");
            strSql.Append("LinkID=@LinkID,");
            strSql.Append("Seef=@Seef");
            strSql.Append(" where id=@id");
            SqlParameter[] parameters = {
                    new SqlParameter("@senderid", SqlDbType.Int),
                    new SqlParameter("@receiverid", SqlDbType.Int),
                    new SqlParameter("@Title", SqlDbType.VarChar,200),
					new SqlParameter("@AddTime", SqlDbType.DateTime),
					new SqlParameter("@Author", SqlDbType.VarChar,250),
					new SqlParameter("@Content", SqlDbType.Text),
                    new SqlParameter("@Content2", SqlDbType.Text),
					new SqlParameter("@CategoryId", SqlDbType.VarChar,50),
					new SqlParameter("@ParentID", SqlDbType.Int,4),
                    new SqlParameter("@Paths", SqlDbType.VarChar,8000),
                    new SqlParameter("@Paths2", SqlDbType.VarChar,250),
                    new SqlParameter("@KeyWords", SqlDbType.VarChar,250),
                    new SqlParameter("@media_id", SqlDbType.VarChar,250),
                    new SqlParameter("@thumb_media_id", SqlDbType.VarChar,250),
                    new SqlParameter("@jlsecond", SqlDbType.Int,4),
                    new SqlParameter("@xfjmoney", SqlDbType.Money),
                    new SqlParameter("@tfllmoney", SqlDbType.Money),
                    new SqlParameter("@zscs", SqlDbType.Int,4),
                    new SqlParameter("@gxzmoney", SqlDbType.Money),
                    new SqlParameter("@ltype", SqlDbType.Int,4),
                    new SqlParameter("@csday", SqlDbType.Int,4),
                    new SqlParameter("@latitude", SqlDbType.Decimal),
                    new SqlParameter("@longitude", SqlDbType.Decimal),
                    new SqlParameter("@wtype", SqlDbType.Int,4),
                    new SqlParameter("@wtype2", SqlDbType.Int,4),
                    new SqlParameter("@Seef", SqlDbType.Int,4),
                    new SqlParameter("@LinkID", SqlDbType.Int,4),
					new SqlParameter("@id", SqlDbType.Int,4)};
            parameters[0].Value = model.senderid;
            parameters[1].Value = model.receiverid;
            parameters[2].Value = model.Title;
            parameters[3].Value = model.AddTime;
            parameters[4].Value = model.Author;
            parameters[5].Value = model.Content;
            parameters[6].Value = model.Content2;
            parameters[7].Value = model.CategoryId;
            parameters[8].Value = model.ParentID;
            parameters[9].Value = model.Paths;
            parameters[10].Value = model.Paths2;
            parameters[11].Value = model.KeyWords;
            parameters[12].Value = model.media_id;
            parameters[13].Value = model.thumb_media_id;
            parameters[14].Value = model.jlsecond;
            parameters[15].Value = model.xfjmoney;
            parameters[16].Value = model.tfllmoney;
            parameters[17].Value = model.zscs;
            parameters[18].Value = model.gxzmoney;
            parameters[19].Value = model.ltype;
            parameters[20].Value = model.csday;
            parameters[21].Value = model.latitude;
            parameters[22].Value = model.longitude;
            parameters[23].Value = model.wtype;
            parameters[24].Value = model.wtype2;
            parameters[25].Value = model.Seef;
            parameters[26].Value = model.LinkID;
            parameters[27].Value = model.id;

            Mtxfw.Utility.SqlDbHelper_U.ExecuteCmd(strSql.ToString(), parameters);
        }
        /// <summary>
        /// 更新一条数据
        /// </summary>
        public bool UpdateuSel(string Sel, int SelValue, int Id)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("update Article set ");
            strSql.Append(Sel + "=@SelValue");
            strSql.Append(" where Id=@Id");
            SqlParameter[] parameters = {
                    new SqlParameter("@SelValue", SqlDbType.Int),
					new SqlParameter("@Id", SqlDbType.Int)};
            parameters[0].Value = SelValue;
            parameters[1].Value = Id;
            int rows = Mtxfw.Utility.SqlDbHelper_U.ExecuteCmd(strSql.ToString(), parameters);
            if (rows > 0)
            {
                return true;
            }
            else
            {
                return false;
            }
        }
        /// <summary>
        /// 更新一条数据
        /// </summary>
        public bool UpdateuSel(string Sel, int SelValue, string where)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("update Article set ");
            strSql.Append(Sel + "=@SelValue");
            strSql.Append(" where " + where);
            SqlParameter[] parameters = {
                    new SqlParameter("@SelValue", SqlDbType.Int)};
            parameters[0].Value = SelValue;
            int rows = Mtxfw.Utility.SqlDbHelper_U.ExecuteCmd(strSql.ToString(), parameters);
            if (rows > 0)
            {
                return true;
            }
            else
            {
                return false;
            }
        }
        /// <summary>
        /// 更新一条数据
        /// </summary>
        public bool UpdateuSel0(string Sel, int SelValue, int Id)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("update Article set ");
            strSql.Append(Sel + "=" + Sel + "+@SelValue");
            strSql.Append(" where Id=@Id");
            SqlParameter[] parameters = {
                    new SqlParameter("@SelValue", SqlDbType.Int),
                    new SqlParameter("@Id", SqlDbType.Int)};
            parameters[0].Value = SelValue;
            parameters[1].Value = Id;
            int rows = Mtxfw.Utility.SqlDbHelper_U.ExecuteCmd(strSql.ToString(), parameters);
            if (rows > 0)
            {
                return true;
            }
            else
            {
                return false;
            }
        }
        /// <summary>
        /// 更新一条数据
        /// </summary>
        public bool Updatecategoryid(string categoryid)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("update Article set ");
            strSql.Append("categoryid=@categoryid");
            strSql.Append(" where parentid=16 And categoryid='0'");
            SqlParameter[] parameters = {
                    new SqlParameter("@categoryid", SqlDbType.VarChar,50)};
            parameters[0].Value = categoryid;
            int rows = Mtxfw.Utility.SqlDbHelper_U.ExecuteCmd(strSql.ToString(), parameters);
            if (rows > 0)
            {
                return true;
            }
            else
            {
                return false;
            }
        }
        /// <summary>
        /// 更新一条数据
        /// </summary>
        public bool UpdateuSel(string Sel, int SelValue, int parentid, int UserId, int Id)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("update Article set ");
            strSql.Append(Sel + "=@SelValue");
            strSql.Append(" where parentid=@parentid And UserId=@UserId And Id=@Id");
            SqlParameter[] parameters = {
                    new SqlParameter("@SelValue", SqlDbType.Int),
                    new SqlParameter("@parentid", SqlDbType.Int),
                    new SqlParameter("@UserId", SqlDbType.Int),
					new SqlParameter("@Id", SqlDbType.Int)};
            parameters[0].Value = SelValue;
            parameters[1].Value = parentid;
            parameters[2].Value = UserId;
            parameters[3].Value = Id;
            int rows = Mtxfw.Utility.SqlDbHelper_U.ExecuteCmd(strSql.ToString(), parameters);
            if (rows > 0)
            {
                return true;
            }
            else
            {
                return false;
            }
        }
        /// <summary>
        /// 更新一条数据
        /// </summary>
        public bool UpdateuSeef()
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("update Article set ");
            strSql.Append("Seef=0");
            strSql.Append(" where (ParentID=18 Or ParentID=19) And Seef=1");
            int rows = Mtxfw.Utility.SqlDbHelper_U.ExecuteCmd(strSql.ToString());
            if (rows > 0)
            {
                return true;
            }
            else
            {
                return false;
            }
        }
        /// <summary>
        /// 删除一条数据
        /// </summary>
        public bool Delete2(int id)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("delete from Article ");
            strSql.Append(" where (parentid=22 And (id=@id or CategoryId=@id)) Or (parentid=23 And CategoryId=@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 Delete(int id)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("delete from Article ");
            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 Mtxfw.Model.Article GetModel(int id)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("select  top 1 * from Article ");
            strSql.Append(" where id=@id");
            SqlParameter[] parameters = {
					new SqlParameter("@id", SqlDbType.Int,4)
            };
            parameters[0].Value = id;

            Mtxfw.Model.Article model = new Mtxfw.Model.Article();
            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());
                }
                if (ds.Tables[0].Rows[0]["senderid"].ToString() != "")
                {
                    model.senderid = int.Parse(ds.Tables[0].Rows[0]["senderid"].ToString());
                }
                if (ds.Tables[0].Rows[0]["receiverid"].ToString() != "")
                {
                    model.receiverid = int.Parse(ds.Tables[0].Rows[0]["receiverid"].ToString());
                }
                model.Title = ds.Tables[0].Rows[0]["Title"].ToString();
                if (ds.Tables[0].Rows[0]["AddTime"].ToString() != "")
                {
                    model.AddTime = DateTime.Parse(ds.Tables[0].Rows[0]["AddTime"].ToString());
                }
                model.Author = ds.Tables[0].Rows[0]["Author"].ToString();
                model.Content = ds.Tables[0].Rows[0]["Content"].ToString();
                model.Content2 = ds.Tables[0].Rows[0]["Content2"].ToString();
                model.CategoryId = ds.Tables[0].Rows[0]["CategoryId"].ToString();
                if (ds.Tables[0].Rows[0]["ParentID"].ToString() != "")
                {
                    model.ParentID = int.Parse(ds.Tables[0].Rows[0]["ParentID"].ToString());
                }
                model.hasRead = int.Parse(ds.Tables[0].Rows[0]["hasRead"].ToString());
                if (ds.Tables[0].Rows[0]["Seef"].ToString() != "")
                {
                    model.Seef = int.Parse(ds.Tables[0].Rows[0]["Seef"].ToString());
                }
                if (ds.Tables[0].Rows[0]["LinkID"].ToString() != "")
                {
                    model.LinkID = int.Parse(ds.Tables[0].Rows[0]["LinkID"].ToString());
                }
                model.Paths = ds.Tables[0].Rows[0]["Paths"].ToString();
                model.Paths2 = ds.Tables[0].Rows[0]["Paths2"].ToString();
                model.KeyWords = ds.Tables[0].Rows[0]["KeyWords"].ToString();
                model.media_id = ds.Tables[0].Rows[0]["media_id"].ToString();
                model.thumb_media_id = ds.Tables[0].Rows[0]["thumb_media_id"].ToString();
                model.jlsecond = Convert.ToInt32(ds.Tables[0].Rows[0]["jlsecond"].ToString());
                model.xfjmoney = Convert.ToDouble(ds.Tables[0].Rows[0]["xfjmoney"].ToString());
                model.tfllmoney = Convert.ToDouble(ds.Tables[0].Rows[0]["tfllmoney"].ToString());
                model.zscs = Convert.ToInt32(ds.Tables[0].Rows[0]["zscs"].ToString());
                model.gxzmoney = Convert.ToDouble(ds.Tables[0].Rows[0]["gxzmoney"].ToString());
                model.ltype = Convert.ToInt32(ds.Tables[0].Rows[0]["ltype"].ToString());
                model.csday = Convert.ToInt32(ds.Tables[0].Rows[0]["csday"].ToString());
                model.latitude = Convert.ToDecimal(ds.Tables[0].Rows[0]["latitude"].ToString());
                model.longitude = Convert.ToDecimal(ds.Tables[0].Rows[0]["longitude"].ToString());
                if (ds.Tables[0].Rows[0]["wtype"].ToString() != "")
                {
                    model.wtype = int.Parse(ds.Tables[0].Rows[0]["wtype"].ToString());
                }
                if (ds.Tables[0].Rows[0]["wtype2"].ToString() != "")
                {
                    model.wtype2 = int.Parse(ds.Tables[0].Rows[0]["wtype2"].ToString());
                }
                model.IFTJ = Convert.ToInt32(ds.Tables[0].Rows[0]["IFTJ"].ToString());
                model.IFTop = Convert.ToInt32(ds.Tables[0].Rows[0]["IFTop"].ToString());
                model.gtype = int.Parse(ds.Tables[0].Rows[0]["gtype"].ToString());
                return model;
            }
            else
            {
                return null;
            }
        }

        /// <summary>
        /// 获取上一条记录
        /// </summary>
        public Mtxfw.Model.Article GetMinModel(int gtype, int id, int ParentID)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("select  top 1 * from Article ");
            strSql.Append(" where gtype=@gtype and id>@id and ParentID=@ParentID order by id desc");
            SqlParameter[] parameters = { new SqlParameter("@gtype", SqlDbType.Int, 4),
                                          new SqlParameter("@id", SqlDbType.Int, 4), 
                                          new SqlParameter("@ParentID", SqlDbType.Int, 4) };
            parameters[0].Value = gtype;
            parameters[1].Value = id;
            parameters[2].Value = ParentID;
            Mtxfw.Model.Article model = new Mtxfw.Model.Article();
            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());
                }
                if (ds.Tables[0].Rows[0]["senderid"].ToString() != "")
                {
                    model.senderid = int.Parse(ds.Tables[0].Rows[0]["senderid"].ToString());
                }
                if (ds.Tables[0].Rows[0]["receiverid"].ToString() != "")
                {
                    model.receiverid = int.Parse(ds.Tables[0].Rows[0]["receiverid"].ToString());
                }
                model.Title = ds.Tables[0].Rows[0]["Title"].ToString();
                if (ds.Tables[0].Rows[0]["AddTime"].ToString() != "")
                {
                    model.AddTime = DateTime.Parse(ds.Tables[0].Rows[0]["AddTime"].ToString());
                }
                model.Author = ds.Tables[0].Rows[0]["Author"].ToString();
                model.Content = ds.Tables[0].Rows[0]["Content"].ToString();
                model.CategoryId = ds.Tables[0].Rows[0]["CategoryId"].ToString();
                if (ds.Tables[0].Rows[0]["ParentID"].ToString() != "")
                {
                    model.ParentID = int.Parse(ds.Tables[0].Rows[0]["ParentID"].ToString());
                }
                model.hasRead = int.Parse(ds.Tables[0].Rows[0]["hasRead"].ToString());
                if (ds.Tables[0].Rows[0]["Seef"].ToString() != "")
                {
                    model.Seef = int.Parse(ds.Tables[0].Rows[0]["Seef"].ToString());
                }
                model.gtype = int.Parse(ds.Tables[0].Rows[0]["gtype"].ToString());
                return model;
            }
            else
            {
                return null;
            }
        }

        /// <summary>
        /// 获取下一条记录
        /// </summary>
        public Mtxfw.Model.Article GetMaxModel(int gtype, int id, int ParentID)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("select top 1 * from Article ");
            strSql.Append(" where gtype=@gtype and id<@id and ParentID=@ParentID order by id asc");
            SqlParameter[] parameters = { new SqlParameter("@gtype", SqlDbType.Int, 4),
                                          new SqlParameter("@id", SqlDbType.Int, 4),
                                          new SqlParameter("@ParentID", SqlDbType.Int, 4) };
            parameters[0].Value = gtype;
            parameters[1].Value = id;
            parameters[2].Value = ParentID;
            Mtxfw.Model.Article model = new Mtxfw.Model.Article();
            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());
                }
                if (ds.Tables[0].Rows[0]["senderid"].ToString() != "")
                {
                    model.senderid = int.Parse(ds.Tables[0].Rows[0]["senderid"].ToString());
                }
                if (ds.Tables[0].Rows[0]["receiverid"].ToString() != "")
                {
                    model.receiverid = int.Parse(ds.Tables[0].Rows[0]["receiverid"].ToString());
                }
                model.Title = ds.Tables[0].Rows[0]["Title"].ToString();
                if (ds.Tables[0].Rows[0]["AddTime"].ToString() != "")
                {
                    model.AddTime = DateTime.Parse(ds.Tables[0].Rows[0]["AddTime"].ToString());
                }
                model.Author = ds.Tables[0].Rows[0]["Author"].ToString();
                model.Content = ds.Tables[0].Rows[0]["Content"].ToString();
                model.CategoryId = ds.Tables[0].Rows[0]["CategoryId"].ToString();
                if (ds.Tables[0].Rows[0]["ParentID"].ToString() != "")
                {
                    model.ParentID = int.Parse(ds.Tables[0].Rows[0]["ParentID"].ToString());
                }
                model.hasRead = int.Parse(ds.Tables[0].Rows[0]["hasRead"].ToString());
                if (ds.Tables[0].Rows[0]["Seef"].ToString() != "")
                {
                    model.Seef = int.Parse(ds.Tables[0].Rows[0]["Seef"].ToString());
                }
                model.gtype = int.Parse(ds.Tables[0].Rows[0]["gtype"].ToString());
                return model;
            }
            else
            {
                return null;
            }
        }

        /// <summary>
        /// 获得数据列表
        /// </summary>
        public DataSet GetList(string strWhere)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("select * ");
            strSql.Append(" FROM Article ");
            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(" * ");
            strSql.Append(" FROM Article ");
            if (strWhere.Trim() != "")
            {
                strSql.Append(" where " + strWhere);
            }
            strSql.Append(" order by " + filedOrder);
            return Mtxfw.Utility.SqlDbHelper_U.GetDataSet(strSql.ToString());
        }
    }
}