SQLServerDAL/SortAd.cs

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

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

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

using WMPT.Model;

using WMPT.DBUtility;

namespace WMPT.SQLServerDAL
{
    /// <summary>
    /// 分类对应的文字广告
    /// </summary>
    public class SortAd
    {
        /// <summary>
        /// 增加一条数据
        /// </summary>
        public int Add(SortAdInfo model)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("insert into SortAd(");
            strSql.Append("Picture,Link,Introduce,state,title,Width,Height,isLink,stype,sortid,Servicefee,AdStartDate,AdEndDate,defautpic,cityid)");
            strSql.Append(" values (");
            strSql.Append("@Picture,@Link,@Introduce,@state,@title,@Width,@Height,@isLink,@stype,@sortid,@Servicefee,@AdStartDate,@AdEndDate,@defautpic,@cityid)");
            strSql.Append(";select @@IDENTITY");
            SqlParameter[] parameters = 
            {
				new SqlParameter("@Picture", SqlDbType.VarChar,256),
				new SqlParameter("@Link", SqlDbType.VarChar,256),
				new SqlParameter("@Introduce", SqlDbType.VarChar,4096),
				new SqlParameter("@state", SqlDbType.VarChar,256),
				new SqlParameter("@title", SqlDbType.VarChar,256),
				new SqlParameter("@Width", SqlDbType.Int,4),
				new SqlParameter("@Height", SqlDbType.Int,4),
                new SqlParameter("@isLink",SqlDbType.Int,4),
                new SqlParameter("@stype", SqlDbType.Int,4),
				new SqlParameter("@sortid", SqlDbType.Int,4),
				new SqlParameter("@Servicefee", SqlDbType.Decimal,5),
				new SqlParameter("@AdStartDate", SqlDbType.DateTime),
				new SqlParameter("@AdEndDate", SqlDbType.DateTime),
				new SqlParameter("@defautpic", SqlDbType.VarChar,256),
                new SqlParameter("@cityid",SqlDbType.Int)
            };
            parameters[0].Value = model.Picture;
            parameters[1].Value = model.Link;
            parameters[2].Value = model.Introduce;
            parameters[3].Value = model.state;
            parameters[4].Value = model.title;
            parameters[5].Value = 0;
            parameters[6].Value = 0;
            parameters[7].Value = model.isLink;
            parameters[8].Value = 0;
            parameters[9].Value = model.sortid;
            parameters[10].Value = model.Servicefee;
            parameters[11].Value = model.AdStartDate;
            parameters[12].Value = model.AdEndDate;