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