Smokewinetea.DAL/turnDAL.cs

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

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

namespace Smokewinetea.DAL
{
   public class turnDAL
    {
       public static int insertturn(turnModels turn)
       {
           StringBuilder sql = new StringBuilder();
           sql.Append("insert into Turn values( @TurnName,@TurnTime,@TurnNames)");
           SqlParameter[] param = {
                                      new SqlParameter("TurnName",SqlDbType.VarChar,20),
                                      new SqlParameter("TurnTime",SqlDbType.DateTime),
                                      new SqlParameter("TurnNames",SqlDbType.VarChar,20)
                                  };
           param[0].Value = turn.TurnName;
           param[1].Value = turn.TurnTime;
           param[2].Value = turn.TurnNames;

           int H = DbHelper.ExecuteNonQuery(sql.ToString(),param);
           return H;

       }
    }
}