protected void BindDataReader(Model.Security.IpAccessControlModel model, SqlDataReader dr)
{
model.Id = DbTool.ConvertObject <System.Int32>(dr["Id"]);
model.LogType = DbTool.ConvertObject <System.String>(dr["LogType"]);
model.IpAddress = DbTool.ConvertObject <System.String>(dr["IpAddress"]);
model.AccessCount = DbTool.ConvertObject <System.Int32>(dr["AccessCount"]);
model.Islocked = DbTool.ConvertObject <System.Boolean>(dr["Islocked"]);
model.FistDateTime = DbTool.ConvertObject <System.DateTime>(dr["FistDateTime"]);
model.UpdateDate = DbTool.ConvertObject <System.DateTime>(dr["UpdateDate"]);
}
public Model.Security.IpAccessControlModel GetModelByAddressId(string addressId, string logtype)
{
string sql = "select top 1 * from IpAccessControl where IpAddress ='" + addressId + "' and logtype='" + logtype + "'";
Model.Security.IpAccessControlModel model = new Model.Security.IpAccessControlModel();
SqlDataReader dr = SqlHelper.ExecuteReader(conn, CommandType.Text, sql.ToString());
if (dr.Read())
{
BindDataReader(model, dr);
}
dr.Close();
return(model);
}
public List <Model.Security.IpAccessControlModel> GetModelList()
{
List <Model.Security.IpAccessControlModel> result = new List <Model.Security.IpAccessControlModel>();
string sql = "select * from IpAccessControl where 1=1";
Model.Security.IpAccessControlModel model = new Model.Security.IpAccessControlModel();
SqlDataReader dr = SqlHelper.ExecuteReader(conn, CommandType.Text, sql.ToString());
while (dr.Read())
{
model = new Model.Security.IpAccessControlModel();
BindDataReader(model, dr);
result.Add(model);
}
dr.Close();
return(result);
}
public int Add(Model.Security.IpAccessControlModel model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into [IpAccessControl]");
strSql.Append("(LogType,IpAddress,AccessCount,Islocked,FistDateTime,UpdateDate)");
strSql.Append(" values (@LogType,@IpAddress,@AccessCount,@Islocked,@FistDateTime,@UpdateDate)");
strSql.Append(";select SCOPE_IDENTITY()");
SqlParameter[] parameters =
{
new SqlParameter("@LogType", DbTool.FixSqlParameter(model.LogType))
, new SqlParameter("@IpAddress", DbTool.FixSqlParameter(model.IpAddress))
, new SqlParameter("@AccessCount", DbTool.FixSqlParameter(model.AccessCount))
, new SqlParameter("@Islocked", DbTool.FixSqlParameter(model.Islocked))
, new SqlParameter("@FistDateTime", DbTool.FixSqlParameter(model.FistDateTime))
, new SqlParameter("@UpdateDate", DbTool.FixSqlParameter(model.UpdateDate))
};
return(DbTool.ConvertObject <int>(SqlHelper.ExecuteScalar(conn, CommandType.Text, strSql.ToString(), parameters), 0));
}
public int Update(Model.Security.IpAccessControlModel model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update IpAccessControl set ");
strSql.Append("LogType=@LogType,IpAddress=@IpAddress,AccessCount=@AccessCount,Islocked=@Islocked,FistDateTime=@FistDateTime,UpdateDate=@UpdateDate ");
strSql.Append(" where Id=@Id ");
SqlParameter[] parameters =
{
new SqlParameter("@LogType", DbTool.FixSqlParameter(model.LogType))
, new SqlParameter("@IpAddress", DbTool.FixSqlParameter(model.IpAddress))
, new SqlParameter("@AccessCount", DbTool.FixSqlParameter(model.AccessCount))
, new SqlParameter("@Islocked", DbTool.FixSqlParameter(model.Islocked))
, new SqlParameter("@FistDateTime", DbTool.FixSqlParameter(model.FistDateTime))
, new SqlParameter("@UpdateDate", DbTool.FixSqlParameter(model.UpdateDate))
, new SqlParameter("@Id", model.Id)
};
return(SqlHelper.ExecuteNonQuery(conn, CommandType.Text, strSql.ToString(), parameters));
}
