/// <summary>
/// 根据传入Model更新数据并返回更新后的Model
/// </summary>
public int Update(RetrievePasswordLog retrievePasswordLog)
{
string sql =
"UPDATE tblRetrievePasswordLog " +
"SET " +
" UserInfoID = @UserInfoID"
+ ", LogStatus = @LogStatus"
+ ", Token = @Token"
+ ", CreateTime = @CreateTime"
+ ", LastTime = @LastTime"
+ " WHERE RetrievePasswordLogID = @RetrievePasswordLogID";
MySqlParameter[] para = new MySqlParameter[]
{
new MySqlParameter("@RetrievePasswordLogID", retrievePasswordLog.RetrievePasswordLogID)
, new MySqlParameter("@UserInfoID", ToDBValue(retrievePasswordLog.UserInfoID))
, new MySqlParameter("@LogStatus", ToDBValue(retrievePasswordLog.LogStatus))
, new MySqlParameter("@Token", ToDBValue(retrievePasswordLog.Token))
, new MySqlParameter("@CreateTime", ToDBValue(retrievePasswordLog.CreateTime))
, new MySqlParameter("@LastTime", ToDBValue(retrievePasswordLog.LastTime))
};
return(MyDBHelper.ExecuteNonQuery(sql, para));
}
public BizRetrievePasswordLog(RetrievePasswordLog dataInfo)
{
RetrievePasswordLogID = dataInfo.RetrievePasswordLogID;
UserInfoID = dataInfo.UserInfoID;
LogStatus = dataInfo.LogStatus;
Token = dataInfo.Token;
CreateTime = dataInfo.CreateTime;
LastTime = dataInfo.LastTime;
}
/// <summary>
/// 把DataRow转换成Model
/// </summary>
public RetrievePasswordLog ToModel(MySqlDataReader dr)
{
RetrievePasswordLog retrievePasswordLog = new RetrievePasswordLog();
retrievePasswordLog.RetrievePasswordLogID = (long)ToModelValue(dr, "RetrievePasswordLogID");
retrievePasswordLog.UserInfoID = (long)ToModelValue(dr, "UserInfoID");
retrievePasswordLog.LogStatus = (int)ToModelValue(dr, "LogStatus");
retrievePasswordLog.Token = (string)ToModelValue(dr, "Token");
retrievePasswordLog.CreateTime = (DateTime)ToModelValue(dr, "CreateTime");
retrievePasswordLog.LastTime = (DateTime)ToModelValue(dr, "LastTime");
return(retrievePasswordLog);
}
/// <summary>
/// 根据传入Model，并返回Model
/// </summary>
public bool Add(RetrievePasswordLog retrievePasswordLog)
{
string sql = "INSERT INTO tblRetrievePasswordLog (RetrievePasswordLogID, UserInfoID, LogStatus, Token, CreateTime, LastTime) VALUES (@RetrievePasswordLogID, @UserInfoID, @LogStatus, @Token, @CreateTime, @LastTime)";
MySqlParameter[] para = new MySqlParameter[]
{
new MySqlParameter("@RetrievePasswordLogID", ToDBValue(retrievePasswordLog.RetrievePasswordLogID)),
new MySqlParameter("@UserInfoID", ToDBValue(retrievePasswordLog.UserInfoID)),
new MySqlParameter("@LogStatus", ToDBValue(retrievePasswordLog.LogStatus)),
new MySqlParameter("@Token", ToDBValue(retrievePasswordLog.Token)),
new MySqlParameter("@CreateTime", ToDBValue(retrievePasswordLog.CreateTime)),
new MySqlParameter("@LastTime", ToDBValue(retrievePasswordLog.LastTime)),
};
int AddId = (int)MyDBHelper.ExecuteNonQuery(sql, para);
if (AddId > 1)
{
return(true);
}
else
{
return(false);
}
}
public int Update(RetrievePasswordLog retrievePasswordLog)
{
return(new RetrievePasswordLogDAL().Update(retrievePasswordLog));
}
public bool RetrievePasswordLogAdd(RetrievePasswordLog retrievePasswordLog)
{
return(new RetrievePasswordLogDAL().Add(retrievePasswordLog));
}