picnews.cs

烟草公司应用网站

using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.Data.Sql;
using System.Data.SqlClient;

namespace BLL
{
    public class PicNews
    {
        public static void Insert(string InsertCon, Model.PicNews myNews)
        {
            //SqlParameter[] ps=new SqlParameter[]
            //{
            //    new SqlParameter(),
            //    new SqlParameter(),
            //    new SqlParameter(),
            //    new SqlParameter(),
            //    new SqlParameter()
            //};
            //ps[0].Value =;
            //ps[1].Value =;
            //ps[2].Value =;
            //ps[3].Value =;
            //ps[4].Value =;
            //DbHelper.ExecuteNonQuery(,CommandType.StoredProcedure ,"",ps);
            SqlParameter[] ps = new SqlParameter[]
            {
                  new SqlParameter("@PicUrl",SqlDbType.VarChar ,100),
                new SqlParameter("@PicCommente",SqlDbType.VarChar ,2000),
                new SqlParameter("@ReleaseTimet",SqlDbType.DateTime),
                new SqlParameter("@Author",SqlDbType.VarChar ,100),
            };
            ps[0].Value = myNews.PicUrl;
            ps[1].Value = myNews.PicComment;
            ps[2].Value = myNews.ReleaseTime;
            ps[3].Value = myNews.Author;
            DbHelper.ExecuteNonQuery(InsertCon, CommandType.StoredProcedure, "PicNewsInsert", ps);
        }
        public static void Update(string UpdateCon, Model.PicNews myNews)
        {
            SqlParameter[] ps = new SqlParameter[]
            {
                new SqlParameter("@NewsID",SqlDbType.Int),
                new SqlParameter("@PicUrl",SqlDbType.VarChar ,100),
                new SqlParameter("@PicCommente",SqlDbType.VarChar ,2000),
                new SqlParameter("@ReleaseTimet",SqlDbType.DateTime),
                new SqlParameter("@Author",SqlDbType.VarChar ,100),
               
            };
            ps[0].Value = myNews.NewsID;
            ps[1].Value = myNews.PicUrl;
            ps[2].Value = myNews.PicComment;
            ps[3].Value = myNews.ReleaseTime;
            ps[4].Value = myNews.Author;
            DbHelper.ExecuteNonQuery(UpdateCon, CommandType.StoredProcedure, "PicNewsUpdate", ps);
        }
        public static void Delete(string DeleteCon, string ID)
        {
            SqlParameter[] ps = new SqlParameter[]
            {
                new SqlParameter("@NewsID",SqlDbType.Int),
            };
            ps[0].Value = Convert.ToInt32(ID);
            DbHelper.ExecuteNonQuery(DeleteCon, CommandType.StoredProcedure, "PicNewsDelete", ps);
        }
        public static DataSet Select(string SelectCon)
        {
            return DbHelper.ExecuteDataset(SelectCon, CommandType.StoredProcedure, "PicNewsSelect");
        }
        public static DataSet SelectSingle(string SelectCon, string ID)
        {
            SqlParameter[] ps = new SqlParameter[]
            {
                new SqlParameter("@NewsID",SqlDbType.Int),
            };
            ps[0].Value = Convert.ToInt32(ID);
            return DbHelper.ExecuteDataset(SelectCon, CommandType.StoredProcedure, "PicNewsSelectSingle", ps);
        }
    }
}