DAL/DD_Bulletin.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.Collections;
using System.Collections.ObjectModel;
using System.Data;
using System.Data.SqlClient;
using System.Text;
using Model;
using DBUtility;

namespace DAL
{
    public class DD_Bulletin
    {
        public DD_Bulletin() { }
        public Int32 Insert(D_BulletinInfo bulletinInfo)
        {
            StringBuilder sqlStr = new StringBuilder();

            SqlParameter[] Para = new SqlParameter[5];
            Para[0] = new SqlParameter("@BulletinTitle", bulletinInfo.BulletinTitle);
            Para[1] = new SqlParameter("@BulletinContent", bulletinInfo.BulletinContent);
            Para[2] = new SqlParameter("@IsPost", bulletinInfo.IsPost);
            Para[3] = new SqlParameter("@OrderNum", bulletinInfo.OrderNum);
            Para[4] = new SqlParameter("@PostTime", bulletinInfo.PostTime);

            sqlStr.Append("Insert into Bulletin(");
            sqlStr.Append("[BulletinTitle],[BulletinContent],[IsPost],[OrderNum],[PostTime])");
            sqlStr.Append(" Values(");
            sqlStr.Append("@BulletinTitle,@BulletinContent,@IsPost,@OrderNum,@PostTime)");

            return SqlHelper.ExecuteNonQuery(CommandType.Text, sqlStr.ToString(), Para);
        }

        public int Update_Bulletin(D_BulletinInfo bulletinInfo)
        {
            StringBuilder sqlStr = new StringBuilder();

            SqlParameter[] Para = new SqlParameter[6];

            Para[0] = new SqlParameter("@BulletinTitle", bulletinInfo.BulletinTitle);
            Para[1] = new SqlParameter("@BulletinContent", bulletinInfo.BulletinContent);
            Para[2] = new SqlParameter("@IsPost", bulletinInfo.IsPost);
            Para[3] = new SqlParameter("@OrderNum", bulletinInfo.OrderNum);
            Para[4] = new SqlParameter("@PostTime", bulletinInfo.PostTime);
            Para[5] = new SqlParameter("@Id", bulletinInfo.Id);

            sqlStr.Append("Update Bulletin Set ");
            sqlStr.Append("[BulletinTitle]=@BulletinTitle,[BulletinContent]=@BulletinContent,[OrderNum]=@OrderNum,[PostTime]=@PostTime");
            sqlStr.Append(" Where Id=@Id");

            return SqlHelper.ExecuteNonQuery(CommandType.Text, sqlStr.ToString(), Para);
        }

        public D_BulletinInfo GetBulletinInfo(Int32 Id,Int16 InfoType)
        {
            D_BulletinInfo bulletininfo = null;
            string sqlStr;
            SqlParameter[] Para = new SqlParameter[1];
            Para[0] = new SqlParameter("@Id", Id);