SQLServerDAL/GPS_Records.cs

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

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

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

using WMPT.Model;
using WMPT.DBUtility;

namespace WMPT.SQLServerDAL
{
	/// <summary>
	/// 类GPS_Records。
	/// </summary>
	public class GPS_Records
	{
		/// <summary>
		/// 增加一条数据
		/// </summary>
		public int Add(GPS_RecordsInfo model)
		{
			StringBuilder strSql=new StringBuilder();
			strSql.Append("insert into GPS_Records(");
			strSql.Append("JH1,JH2,JH3,JH4,JH5,AddTime,AddName,UpTime,Remark,Del,ihangjing)");
			strSql.Append(" values (");
			strSql.Append("@JH1,@JH2,@JH3,@JH4,@JH5,@AddTime,@AddName,@UpTime,@Remark,@Del,@ihangjing)");
			strSql.Append(";select @@IDENTITY");
			SqlParameter[] parameters = 
            {
				new SqlParameter("@JH1", SqlDbType.VarChar,20),
				new SqlParameter("@JH2", SqlDbType.VarChar,20),
				new SqlParameter("@JH3", SqlDbType.VarChar,20),
				new SqlParameter("@JH4", SqlDbType.VarChar,20),
				new SqlParameter("@JH5", SqlDbType.VarChar,20),
				new SqlParameter("@AddTime", SqlDbType.DateTime),
				new SqlParameter("@AddName", SqlDbType.VarChar,50),
				new SqlParameter("@UpTime", SqlDbType.DateTime),
				new SqlParameter("@Remark", SqlDbType.Text),
				new SqlParameter("@Del", SqlDbType.Int,4),
				new SqlParameter("@ihangjing", SqlDbType.Int,4)
            };
            parameters[0].Value = model.JH1;
            parameters[1].Value = model.JH2;
            parameters[2].Value = model.JH3;
            parameters[3].Value = model.JH4;
            parameters[4].Value = model.JH5;
            parameters[5].Value = model.AddTime;
            parameters[6].Value = model.AddName;
            parameters[7].Value = model.UpTime;
            parameters[8].Value = model.Remark;
            parameters[9].Value = model.Del;
            parameters[10].Value = model.WMPT;

			return SQLHelper.ExecuteNonQuery(CommandType.Text, strSql.ToString(), parameters);
		}

		/// <summary>
		/// 更新一条数据
		/// </summary>
        public int Update(GPS_RecordsInfo mode)