protected void BindDataReader(Model.Login_LogModel model, SqlDataReader dr)
{
model.LogId = DbTool.ConvertObject <System.Int32>(dr["LogId"]);
model.LoginTime = DbTool.ConvertObject <System.DateTime>(dr["LoginTime"]);
model.LoginIp = DbTool.ConvertObject <System.String>(dr["LoginIp"]);
model.UserName = DbTool.ConvertObject <System.String>(dr["UserName"]);
}
public Model.Login_LogModel GetModel(int Id)
{
string sql = "select top 1 * from Login_Log where LogId =" + Id;
Model.Login_LogModel model = new Model.Login_LogModel();
SqlDataReader dr = SqlHelper.ExecuteReader(conn, CommandType.Text, sql.ToString());
if (dr.Read())
{
//var fields = DbTool.GetReaderFieldNames(dr);
//model = AutoBindDataReader(dr, fields);
BindDataReader(model, dr);
}
dr.Close();
return(model);
}
public int Update(Model.Login_LogModel model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update Login_Log set ");
strSql.Append("LoginTime=@LoginTime,LoginIp=@LoginIp,UserName=@UserName ");
strSql.Append(" where LogId=@LogId ");
SqlParameter[] parameters =
{
new SqlParameter("@LoginTime", DbTool.FixSqlParameter(model.LoginTime))
, new SqlParameter("@LoginIp", DbTool.FixSqlParameter(model.LoginIp))
, new SqlParameter("@UserName", DbTool.FixSqlParameter(model.UserName))
, new SqlParameter("@LogId", model.LogId)
};
return(SqlHelper.ExecuteNonQuery(conn, CommandType.Text, strSql.ToString(), parameters));
}
public int Add(Model.Login_LogModel model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into [Login_Log]");
strSql.Append("(LoginTime,LoginIp,UserName,Notes)");
strSql.Append(" values (@LoginTime,@LoginIp,@UserName,@Notes)");
strSql.Append(";select SCOPE_IDENTITY()");
SqlParameter[] parameters =
{
new SqlParameter("@LoginTime", DbTool.FixSqlParameter(model.LoginTime))
, new SqlParameter("@LoginIp", DbTool.FixSqlParameter(model.LoginIp))
, new SqlParameter("@UserName", DbTool.FixSqlParameter(model.UserName))
, new SqlParameter("@Notes", DbTool.FixSqlParameter(model.Notes))
};
return(DbTool.ConvertObject <int>(SqlHelper.ExecuteScalar(conn, CommandType.Text, strSql.ToString(), parameters), 0));
}
public List <Model.Login_LogModel> GetModelList()
{
List <Model.Login_LogModel> result = new List <Model.Login_LogModel>();
string sql = "select * from Login_Log where 1=1";
Model.Login_LogModel model = new Model.Login_LogModel();
SqlDataReader dr = SqlHelper.ExecuteReader(conn, CommandType.Text, sql.ToString());
//var fields = DbTool.GetReaderFieldNames(dr);
while (dr.Read())
{
//model = AutoBindDataReader(dr, fields);
model = new Model.Login_LogModel();
BindDataReader(model, dr);
result.Add(model);
}
dr.Close();
return(result);
}
protected Model.Login_LogModel AutoBindDataReader(SqlDataReader dr, params string[] fields)
{
var model = new Model.Login_LogModel();
if (DbTool.HasFields("LogId", fields))
{
model.LogId = DbTool.ConvertObject <System.Int32>(dr["LogId"]);
}
if (DbTool.HasFields("LoginTime", fields))
{
model.LoginTime = DbTool.ConvertObject <System.DateTime>(dr["LoginTime"]);
}
if (DbTool.HasFields("LoginIp", fields))
{
model.LoginIp = DbTool.ConvertObject <System.String>(dr["LoginIp"]);
}
if (DbTool.HasFields("UserName", fields))
{
model.UserName = DbTool.ConvertObject <System.String>(dr["UserName"]);
}
return(model);
}
