download.cs

烟草公司应用网站

using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.Data.SqlClient;
using System.Data.Sql;
namespace BLL
{
    public class DownLoad
    {
        public static void Insert(string InsertCon, Model.DownLoad myFile)
        { 
            //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("@FileTitle",SqlDbType.VarChar ,50),
                new SqlParameter("@FilePath",SqlDbType.VarChar ,200),
                new SqlParameter("@UpLoadtime",SqlDbType.DateTime)
            };
            ps[0].Value =myFile.FileTitle;
            ps[1].Value =myFile .FilePath;
            ps[2].Value =myFile .UpLoadTime;
            DbHelper.ExecuteNonQuery(InsertCon, CommandType.StoredProcedure, "FileInsert", ps);
        }
        public static void Update(string UpdateCon,Model .DownLoad myFile)
        {
            SqlParameter[] ps=new SqlParameter[]
            {
                new SqlParameter("@FileID",SqlDbType.Int),
                new SqlParameter("@FileTitle",SqlDbType.VarChar,50)
            };
            ps[0].Value =myFile .FileID;
            ps[1].Value = myFile.FileTitle;
            DbHelper.ExecuteNonQuery(UpdateCon,CommandType.StoredProcedure ,"FileUpdate",ps);
        }
        public static void Delete(string DeleteCon, string ID)
        {
            SqlParameter[] ps = new SqlParameter[]
            {
                new SqlParameter("@FileID",SqlDbType.Int)
            };
            ps[0].Value = Convert.ToInt32(ID);
            DbHelper.ExecuteNonQuery(DeleteCon, CommandType.StoredProcedure, "FileDelete", ps);
        }
        public static DataSet SelectSingle(string SelectCon, string ID)
        {
            SqlParameter[] ps = new SqlParameter[]
            {
                new SqlParameter("@FileID",SqlDbType.Int)
            };
            ps[0].Value = Convert.ToInt32(ID);
           return DbHelper.ExecuteDataset(SelectCon,CommandType.StoredProcedure, "FileSelectSingle", ps);
        }
        public static DataSet SelectAll(string SelectCon)
        {
            return DbHelper.ExecuteDataset(SelectCon, CommandType.StoredProcedure, "FileSelectAll");
        }
    }
}