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