Beispiel #1
0
        public QPS.NEW.Model.Trends GetModel(int Id)
        {
            QPS.NEW.Model.Trends trends = null;

            DataTable dt = sqlHelper_.GetDataTable(
                "select * from Trends where Id=@id",
                CommandType.Text,
                new System.Data.SqlClient.SqlParameter[]
            {
                new System.Data.SqlClient.SqlParameter("@id", Id)
            }
                );

            if (dt != null && dt.Rows.Count > 0)
            {
                trends = new Model.Trends();

                trends.Id      = Convert.ToInt32(dt.Rows[0]["Id"]);
                trends.Title   = dt.Rows[0]["Title"].ToString();
                trends.Content = dt.Rows[0]["Content"].ToString();
                trends.Time    = dt.Rows[0]["Time"].ToString();
            }

            return(trends);
        }
Beispiel #2
0
        public QPS.NEW.Model.Trends GetModel(int Id)
        {
            QPS.NEW.Model.Trends trends = null;

            DataTable dt = sqlHelper_.GetDataTable(
                "select * from Trends where Id=@id",
                CommandType.Text,
                new System.Data.SqlClient.SqlParameter[]
                {
                    new System.Data.SqlClient.SqlParameter("@id",Id)
                }
                );

            if (dt != null && dt.Rows.Count > 0)
            {
                trends = new Model.Trends();

                trends.Id = Convert.ToInt32(dt.Rows[0]["Id"]);
                trends.Title = dt.Rows[0]["Title"].ToString();
                trends.Content = dt.Rows[0]["Content"].ToString();
                trends.Time = dt.Rows[0]["Time"].ToString();
               
            }

            return trends;
        }