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)); }