Sp_log.cs

using System;
using System.Text;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;

///

/// 类Sp_log。
///

public class Sp_log
{
public Sp_log()
{ }
#region Model
private int _id;
private string _loger;
private string _idname;
private DateTime _dtt;
///

///
///

public int id
{
set { _id = value; }
get { return _id; }
}
///

///
///

public string loger
{
set { _loger = value; }
get { return _loger; }
}
///

///
///

public string idname
{
set { _idname = value; }
get { return _idname; }
}
///

///
///

public DateTime dtt
{
set { _dtt = value; }
get { return _dtt; }
}
#endregion Model


#region 成员方法

///

/// 增加一条数据
///

public int Add()
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into Sp_log(");
strSql.Append("loger,idname,dtt)");
strSql.Append(" values (");
strSql.Append("@loger,@idname,@dtt)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@loger", SqlDbType.Text),
new SqlParameter("@idname", SqlDbType.VarChar,50),
new SqlParameter("@dtt", SqlDbType.DateTime)};
parameters[0].Value = loger;
parameters[1].Value = idname;
parameters[2].Value = dtt;

object obj = Sp.SQLServerDAL.DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return 1;
}
else
{
return Convert.ToInt32(obj);
}
}
#endregion 成员方法
}