private static EasyOne.Model.UserManage.UserValidLogInfo UserValidLogInfo(NullableDataReader rdr) { EasyOne.Model.UserManage.UserValidLogInfo info = new EasyOne.Model.UserManage.UserValidLogInfo(); info.LogId = rdr.GetInt32("LogID"); info.UserName = rdr.GetString("UserName"); info.ValidNum = rdr.GetInt32("ValidNum"); info.LogTime = rdr.GetDateTime("LogTime"); info.IncomePayout = rdr.GetInt32("IncomePayout"); info.Remark = rdr.GetString("Remark"); info.IP = rdr.GetString("IP"); info.Inputer = rdr.GetString("Inputer"); return(info); }
public EasyOne.Model.UserManage.UserValidLogInfo GetValidLogById(int logId) { using (NullableDataReader reader = DBHelper.ExecuteReaderSql("SELECT * FROM PE_ValidLog WHERE LogID = @LogID", new Parameters("@LogID", DbType.String, logId))) { if (reader.Read()) { EasyOne.Model.UserManage.UserValidLogInfo info = UserValidLogInfo(reader); info.Memo = reader.GetString("Memo"); return(info); } return(new EasyOne.Model.UserManage.UserValidLogInfo(true)); } }
public bool Add(EasyOne.Model.UserManage.UserValidLogInfo userValidLogInfo) { Parameters cmdParams = new Parameters(); cmdParams.AddInParameter("@LogID", DbType.Int32, userValidLogInfo.LogId); cmdParams.AddInParameter("@UserName", DbType.String, userValidLogInfo.UserName); cmdParams.AddInParameter("@ValidNum", DbType.Int32, userValidLogInfo.ValidNum); cmdParams.AddInParameter("@IncomePayout", DbType.Int32, userValidLogInfo.IncomePayout); cmdParams.AddInParameter("@LogTime", DbType.DateTime, userValidLogInfo.LogTime); cmdParams.AddInParameter("@Remark", DbType.String, userValidLogInfo.Remark); cmdParams.AddInParameter("@IP", DbType.String, userValidLogInfo.IP); cmdParams.AddInParameter("@Inputer", DbType.String, userValidLogInfo.Inputer); cmdParams.AddInParameter("@Memo", DbType.String, userValidLogInfo.Memo); return(DBHelper.ExecuteProc("PR_UserManage_UserValidLog_Add", cmdParams)); }
public EasyOne.Model.UserManage.UserValidLogInfo GetValidLogByIdAndUserName(int logId, string userName) { string strSql = "SELECT * FROM PE_ValidLog WHERE LogID = @LogID AND UserName = @UserName"; Parameters cmdParams = new Parameters("@LogID", DbType.Int32, logId); cmdParams.AddInParameter("@UserName", DbType.String, userName); using (NullableDataReader reader = DBHelper.ExecuteReaderSql(strSql, cmdParams)) { if (reader.Read()) { EasyOne.Model.UserManage.UserValidLogInfo info = UserValidLogInfo(reader); info.Memo = reader.GetString("Memo"); return(info); } return(new EasyOne.Model.UserManage.UserValidLogInfo(true)); } }