/// <summary> /// 得到一个对象实体 /// </summary> public Gymnasium_APP.Model.SystemLoginLogModel DataRowToModel(DataRow row) { Gymnasium_APP.Model.SystemLoginLogModel model=new Gymnasium_APP.Model.SystemLoginLogModel(); if (row != null) { if(row["LoginLogId"]!=null && row["LoginLogId"].ToString()!="") { model.LoginLogId=int.Parse(row["LoginLogId"].ToString()); } if(row["UserId"]!=null && row["UserId"].ToString()!="") { model.UserId=int.Parse(row["UserId"].ToString()); } if(row["LoginIP"]!=null) { model.LoginIP=row["LoginIP"].ToString(); } if(row["LoginAddress"]!=null) { model.LoginAddress=row["LoginAddress"].ToString(); } if(row["LoginDate"]!=null) { model.LoginDate=row["LoginDate"].ToString(); } if(row["LoginType"]!=null) { model.LoginType=row["LoginType"].ToString(); } if(row["LoginCont"]!=null) { model.LoginCont=row["LoginCont"].ToString(); } } return model; }
/// <summary> /// 得到一个对象实体 /// </summary> public Gymnasium_APP.Model.SystemLoginLogModel GetModel(int LoginLogId) { StringBuilder strSql=new StringBuilder(); strSql.Append("select top 1 LoginLogId,UserId,LoginIP,LoginAddress,LoginDate,LoginType,LoginCont from SystemLoginLog "); strSql.Append(" where LoginLogId=@LoginLogId "); SqlParameter[] parameters = { new SqlParameter("@LoginLogId", SqlDbType.Int,4) }; parameters[0].Value = LoginLogId; Gymnasium_APP.Model.SystemLoginLogModel model=new Gymnasium_APP.Model.SystemLoginLogModel(); DataSet ds=DbHelperSQL.Query(strSql.ToString(),parameters); if(ds.Tables[0].Rows.Count>0) { return DataRowToModel(ds.Tables[0].Rows[0]); } else { return null; } }